WebSVN – lars-tiefland.laravel_shop – Diff – /trunk/app/Console/Commands/convertDB.php

                 $progressbar->advance();
+            }
             $progressbar->finish();
             $progressbar->clear();
             $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );
+            $sql = "SELECT
+                    MAX(id) AS start
+                FROM
+                    prices
+            ";
+            $row = DB::connection( "mysql" )->select( $sql );
+            if ( $row[0]->start )
+            {
+                $start = $row[0]->start;
+            }
             $sql = "
                 SELECT
                     p.*
                 FROM
                     preise p
                     artikel a
                 ON
                     a.id=p.artikel_id
                 WHERE
                     a.father >=-1
+                AND
+                    p.id>" . $start . "
             ";
             $prices = DB::connection( 'old' )->select( $sql );
             $progressbar = $this->output->createProgressBar( count( $prices ) );
             $progressbar->start();
             foreach ( $prices as $price )

Subversion-Projekte lars-tiefland.laravel_shop