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



                    MAX(id) AS start
                FROM
                    media
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "
                SELECT
                    *
                FROM

                    MAX(id) AS start
                FROM
                    directories
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = '
                SELECT 
                    *
                FROM

                    MAX(medium_id) AS start
                FROM
                    directory_media
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    directory_medien

                    MAX(id) AS start
                FROM
                    items
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = '
                SELECT 
                    *
                FROM

                    MAX(id) AS start
                FROM
                    prices
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "
                SELECT
                    p.*
                FROM

                    MAX(medium_id) AS start
                FROM
                    item_media
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    artikel_medien

                    MAX(id) AS start
                FROM
                    actions
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "
                SELECT
                    *
                FROM

                    MAX(id) AS start
                FROM
                    action_media
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    aktionen_medien

                    MAX(id) AS start
                FROM
                    users
            ";
            $row = DB::connection( "order" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    Logins

                    MAX(id) AS start
                FROM
                    " . $table . "
            ";
            $row = DB::connection( "order" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    " . $oldTable . "

                    MAX(id) AS start
                FROM
                    orders
            ";
            $row = DB::connection( "order" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    Bestellung

                    MAX(id) AS start
                FROM
                    order_items
            ";
            $row = DB::connection( "order" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    artikel_to_Bestellung

                    MAX(id) AS start
                FROM
                    shops
            ";
            $row = DB::connection( 'mysql' )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    shops

 

        }
 
        private function migratePaymentMethods()
        {
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );
            $start = 0;
            $sql = "SELECT
                    MAX(id) AS start
                FROM
                    media
            ";
            $row = DB::connection( "mysql" )->select( $sql );
            if ( $row[ 0 ]->start )
            {
                $start = $row[ 0 ]->start;
            }
            $sql = "SELECT
                    *
                FROM
                    zahlungsarten
                WHERE
                    id>" . $start . "
            ";
            $methods = DB::connection( 'old' )->select( $sql );
            foreach ( $methods as $method )

Revision 496	Revision 498
Zeile 104...	Zeile 104...
104	`MAX(id) AS start`	104	`MAX(id) AS start`
105	`FROM`	105	`FROM`
106	`media`	106	`media`
107	`";`	107	`";`
108	`$row = DB::connection( "mysql" )->select( $sql );`	108	`$row = DB::connection( "mysql" )->select( $sql );`
109	`if ( $row[0]->start )`	109	`if ( $row[ 0 ]->start )`
110	`{`	110	`{`
111	`$start = $row[0]->start;`	111	`$start = $row[ 0 ]->start;`
112	`}`	112	`}`
113	`$sql = "`	113	`$sql = "`
114	`SELECT`	114	`SELECT`
115	`*`	115	`*`
116	`FROM`	116	`FROM`
Zeile 160...	Zeile 160...
160	`MAX(id) AS start`	160	`MAX(id) AS start`
161	`FROM`	161	`FROM`
162	`directories`	162	`directories`
163	`";`	163	`";`
164	`$row = DB::connection( "mysql" )->select( $sql );`	164	`$row = DB::connection( "mysql" )->select( $sql );`
165	`if ( $row[0]->start )`	165	`if ( $row[ 0 ]->start )`
166	`{`	166	`{`
167	`$start = $row[0]->start;`	167	`$start = $row[ 0 ]->start;`
168	`}`	168	`}`
169	`$sql = '`	169	`$sql = '`
170	`SELECT`	170	`SELECT`
171	`*`	171	`*`
172	`FROM`	172	`FROM`
Zeile 217...	Zeile 217...
217	`MAX(medium_id) AS start`	217	`MAX(medium_id) AS start`
218	`FROM`	218	`FROM`
219	`directory_media`	219	`directory_media`
220	`";`	220	`";`
221	`$row = DB::connection( "mysql" )->select( $sql );`	221	`$row = DB::connection( "mysql" )->select( $sql );`
222	`if ( $row[0]->start )`	222	`if ( $row[ 0 ]->start )`
223	`{`	223	`{`
224	`$start = $row[0]->start;`	224	`$start = $row[ 0 ]->start;`
225	`}`	225	`}`
226	`$sql = "SELECT`	226	`$sql = "SELECT`
227	`*`	227	`*`
228	`FROM`	228	`FROM`
229	`directory_medien`	229	`directory_medien`
Zeile 259...	Zeile 259...
259	`MAX(id) AS start`	259	`MAX(id) AS start`
260	`FROM`	260	`FROM`
261	`items`	261	`items`
262	`";`	262	`";`
263	`$row = DB::connection( "mysql" )->select( $sql );`	263	`$row = DB::connection( "mysql" )->select( $sql );`
264	`if ( $row[0]->start )`	264	`if ( $row[ 0 ]->start )`
265	`{`	265	`{`
266	`$start = $row[0]->start;`	266	`$start = $row[ 0 ]->start;`
267	`}`	267	`}`
268	`$sql = '`	268	`$sql = '`
269	`SELECT`	269	`SELECT`
270	`*`	270	`*`
271	`FROM`	271	`FROM`
Zeile 312...	Zeile 312...
312	`MAX(id) AS start`	312	`MAX(id) AS start`
313	`FROM`	313	`FROM`
314	`prices`	314	`prices`
315	`";`	315	`";`
316	`$row = DB::connection( "mysql" )->select( $sql );`	316	`$row = DB::connection( "mysql" )->select( $sql );`
317	`if ( $row[0]->start )`	317	`if ( $row[ 0 ]->start )`
318	`{`	318	`{`
319	`$start = $row[0]->start;`	319	`$start = $row[ 0 ]->start;`
320	`}`	320	`}`
321	`$sql = "`	321	`$sql = "`
322	`SELECT`	322	`SELECT`
323	`p.*`	323	`p.*`
324	`FROM`	324	`FROM`
Zeile 362...	Zeile 362...
362	`MAX(medium_id) AS start`	362	`MAX(medium_id) AS start`
363	`FROM`	363	`FROM`
364	`item_media`	364	`item_media`
365	`";`	365	`";`
366	`$row = DB::connection( "mysql" )->select( $sql );`	366	`$row = DB::connection( "mysql" )->select( $sql );`
367	`if ( $row[0]->start )`	367	`if ( $row[ 0 ]->start )`
368	`{`	368	`{`
369	`$start = $row[0]->start;`	369	`$start = $row[ 0 ]->start;`
370	`}`	370	`}`
371	`$sql = "SELECT`	371	`$sql = "SELECT`
372	`*`	372	`*`
373	`FROM`	373	`FROM`
374	`artikel_medien`	374	`artikel_medien`
Zeile 404...	Zeile 404...
404	`MAX(id) AS start`	404	`MAX(id) AS start`
405	`FROM`	405	`FROM`
406	`actions`	406	`actions`
407	`";`	407	`";`
408	`$row = DB::connection( "mysql" )->select( $sql );`	408	`$row = DB::connection( "mysql" )->select( $sql );`
409	`if ( $row[0]->start )`	409	`if ( $row[ 0 ]->start )`
410	`{`	410	`{`
411	`$start = $row[0]->start;`	411	`$start = $row[ 0 ]->start;`
412	`}`	412	`}`
413	`$sql = "`	413	`$sql = "`
414	`SELECT`	414	`SELECT`
415	`*`	415	`*`
416	`FROM`	416	`FROM`
Zeile 450...	Zeile 450...
450	`MAX(id) AS start`	450	`MAX(id) AS start`
451	`FROM`	451	`FROM`
452	`action_media`	452	`action_media`
453	`";`	453	`";`
454	`$row = DB::connection( "mysql" )->select( $sql );`	454	`$row = DB::connection( "mysql" )->select( $sql );`
455	`if ( $row[0]->start )`	455	`if ( $row[ 0 ]->start )`
456	`{`	456	`{`
457	`$start = $row[0]->start;`	457	`$start = $row[ 0 ]->start;`
458	`}`	458	`}`
459	`$sql = "SELECT`	459	`$sql = "SELECT`
460	`*`	460	`*`
461	`FROM`	461	`FROM`
462	`aktionen_medien`	462	`aktionen_medien`
Zeile 489...	Zeile 489...
489	`MAX(id) AS start`	489	`MAX(id) AS start`
490	`FROM`	490	`FROM`
491	`users`	491	`users`
492	`";`	492	`";`
493	`$row = DB::connection( "order" )->select( $sql );`	493	`$row = DB::connection( "order" )->select( $sql );`
494	`if ( $row[0]->start )`	494	`if ( $row[ 0 ]->start )`
495	`{`	495	`{`
496	`$start = $row[0]->start;`	496	`$start = $row[ 0 ]->start;`
497	`}`	497	`}`
498	`$sql = "SELECT`	498	`$sql = "SELECT`
499	`*`	499	`*`
500	`FROM`	500	`FROM`
501	`Logins`	501	`Logins`
Zeile 548...	Zeile 548...
548	`MAX(id) AS start`	548	`MAX(id) AS start`
549	`FROM`	549	`FROM`
550	`" . $table . "`	550	`" . $table . "`
551	`";`	551	`";`
552	`$row = DB::connection( "order" )->select( $sql );`	552	`$row = DB::connection( "order" )->select( $sql );`
553	`if ( $row[0]->start )`	553	`if ( $row[ 0 ]->start )`
554	`{`	554	`{`
555	`$start = $row[0]->start;`	555	`$start = $row[ 0 ]->start;`
556	`}`	556	`}`
557	`$sql = "SELECT`	557	`$sql = "SELECT`
558	`*`	558	`*`
559	`FROM`	559	`FROM`
560	`" . $oldTable . "`	560	`" . $oldTable . "`
Zeile 624...	Zeile 624...
624	`MAX(id) AS start`	624	`MAX(id) AS start`
625	`FROM`	625	`FROM`
626	`orders`	626	`orders`
627	`";`	627	`";`
628	`$row = DB::connection( "order" )->select( $sql );`	628	`$row = DB::connection( "order" )->select( $sql );`
629	`if ( $row[0]->start )`	629	`if ( $row[ 0 ]->start )`
630	`{`	630	`{`
631	`$start = $row[0]->start;`	631	`$start = $row[ 0 ]->start;`
632	`}`	632	`}`
633	`$sql = "SELECT`	633	`$sql = "SELECT`
634	`*`	634	`*`
635	`FROM`	635	`FROM`
636	`Bestellung`	636	`Bestellung`
Zeile 686...	Zeile 686...
686	`MAX(id) AS start`	686	`MAX(id) AS start`
687	`FROM`	687	`FROM`
688	`order_items`	688	`order_items`
689	`";`	689	`";`
690	`$row = DB::connection( "order" )->select( $sql );`	690	`$row = DB::connection( "order" )->select( $sql );`
691	`if ( $row[0]->start )`	691	`if ( $row[ 0 ]->start )`
692	`{`	692	`{`
693	`$start = $row[0]->start;`	693	`$start = $row[ 0 ]->start;`
694	`}`	694	`}`
695	`$sql = "SELECT`	695	`$sql = "SELECT`
696	`*`	696	`*`
697	`FROM`	697	`FROM`
698	`artikel_to_Bestellung`	698	`artikel_to_Bestellung`
Zeile 719...	Zeile 719...
719	`MAX(id) AS start`	719	`MAX(id) AS start`
720	`FROM`	720	`FROM`
721	`shops`	721	`shops`
722	`";`	722	`";`
723	`$row = DB::connection( 'mysql' )->select( $sql );`	723	`$row = DB::connection( 'mysql' )->select( $sql );`
724	`if ( $row[0]->start )`	724	`if ( $row[ 0 ]->start )`
725	`{`	725	`{`
726	`$start = $row[0]->start;`	726	`$start = $row[ 0 ]->start;`
727	`}`	727	`}`
728	`$sql = "SELECT`	728	`$sql = "SELECT`
729	`*`	729	`*`
730	`FROM`	730	`FROM`
731	`shops`	731	`shops`
Zeile 774...	Zeile 774...
774		774
Zeile 775...	Zeile 775...
775	`}`	775	`}`
776		776
-		777	`private function migratePaymentMethods()`
-		778	`{`
-		779	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Zahlungsmethoden" );`
-		780	`$start = 0;`
-		781	`$sql = "SELECT`
-		782	`MAX(id) AS start`
-		783	`FROM`
-		784	`media`
-		785	`";`
-		786	`$row = DB::connection( "mysql" )->select( $sql );`
-		787	`if ( $row[ 0 ]->start )`
-		788	`{`
777	`private function migratePaymentMethods()`	789	`$start = $row[ 0 ]->start;`
778	`{`	790	`}`
779	`$sql = "SELECT`	791	`$sql = "SELECT`
780	`*`	792	`*`
-		793	`FROM`
-		794	`zahlungsarten`
781	`FROM`	795	`WHERE`
782	`zahlungsarten`	796	`id>" . $start . "`
783	`";`	797	`";`
784	`$methods = DB::connection( 'old' )->select( $sql );`	798	`$methods = DB::connection( 'old' )->select( $sql );`
785	`foreach ( $methods as $method )`	799	`foreach ( $methods as $method )`

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Console/Commands/convertDB.php – Revision 496 → 498