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



            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );
            $start = 0;
            $sql = "SELECT
                    MAX(id) AS start
                FROM
                    users
            ";
            $row = DB::connection( "order" )->select( $sql );
            if ( $row )
            {
                $start = $row[0]["start"];
            }
            $sql = "SELECT
                    *
                FROM
                    Logins
                WHERE
                    id>" . $start . "
            ";
            $orders = DB::connection( "orderOld" )->select( $sql );
            foreach ( $orders as $oldOrder )

Revision 433	Revision 434
Zeile 380...	Zeile 380...
380	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );`	380	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere User" );`
381	`$start = 0;`	381	`$start = 0;`
382	`$sql = "SELECT`	382	`$sql = "SELECT`
383	`MAX(id) AS start`	383	`MAX(id) AS start`
384	`FROM`	384	`FROM`
385	`orders`	385	`users`
386	`";`	386	`";`
387	`$row = DB::connection( "order" )->select( $sql );`	387	`$row = DB::connection( "order" )->select( $sql );`
388	`if ( $row )`	388	`if ( $row )`
389	`{`	389	`{`
390	`$start = $row[0]["start"];`	390	`$start = $row[0]["start"];`
391	`}`	391	`}`
392	`$sql = "SELECT`	392	`$sql = "SELECT`
393	`*`	393	`*`
394	`FROM`	394	`FROM`
395	`Bestellungen`	395	`Logins`
396	`WHERE`	396	`WHERE`
397	`id>" . $start . "`	397	`id>" . $start . "`
398	`";`	398	`";`
399	`$orders = DB::connection( "orderOld" )->select( $sql );`	399	`$orders = DB::connection( "orderOld" )->select( $sql );`
400	`foreach ( $orders as $oldOrder )`	400	`foreach ( $orders as $oldOrder )`

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Console/Commands/convertDB.php – Revision 433 → 434