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



                    "updated_at"   => $row->letzte_Aenderung_am,
                ] );
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    directory_medien

                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateItems()
        {

                $item->updated_by = $bearbeiter;
                $item->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );
            $sql = "
                SELECT
                    p.*
                FROM

                    "updated_at"  => $price->geaendert_am
                ] );
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    artikel_medien

                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        private function migrateActions()
        {

                $actionDB->updated_by = "WebanOS Laravel Upgrade";
                $actionDB->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    aktionen_medien

            {
                $medium = new ActionMedium();
                $medium->action_id = $row->aktionen_id;
                $medium->medium_id = $row->medien_id;
                $medium->rank = $row->rang;
 
 
                $medium->created_by = "WebanOS Laravel Upgrade";
                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
        }

 
        public function migrateMedia()
        {

                $mediumDB->updated_by = $bearbeiter;
                $mediumDB->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $progressbar->clear();
        }
    }

Revision 301	Revision 302
Zeile 84...	Zeile 84...
84	`"updated_at" => $row->letzte_Aenderung_am,`	84	`"updated_at" => $row->letzte_Aenderung_am,`
85	`] );`	85	`] );`
86	`$progressbar->advance();`	86	`$progressbar->advance();`
87	`}`	87	`}`
88	`$progressbar->finish();`	88	`$progressbar->finish();`
-		89	`$progressbar->clear();`
89	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );`	90	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );`
90	`$sql = "SELECT`	91	`$sql = "SELECT`
91	`*`	92	`*`
92	`FROM`	93	`FROM`
93	`directory_medien`	94	`directory_medien`
Zeile 108...	Zeile 109...
108	`$medium->updated_by = "WebanOS Laravel Upgrade";`	109	`$medium->updated_by = "WebanOS Laravel Upgrade";`
109	`$medium->save();`	110	`$medium->save();`
110	`$progressbar->advance();`	111	`$progressbar->advance();`
111	`}`	112	`}`
112	`$progressbar->finish();`	113	`$progressbar->finish();`
-		114	`$progressbar->clear();`
113	`}`	115	`}`
Zeile 114...	Zeile 116...
114		116
115	`private function migrateItems()`	117	`private function migrateItems()`
116	`{`	118	`{`
Zeile 151...	Zeile 153...
151	`$item->updated_by = $bearbeiter;`	153	`$item->updated_by = $bearbeiter;`
152	`$item->save();`	154	`$item->save();`
153	`$progressbar->advance();`	155	`$progressbar->advance();`
154	`}`	156	`}`
155	`$progressbar->finish();`	157	`$progressbar->finish();`
-		158	`$progressbar->clear();`
156	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );`	159	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );`
157	`$sql = "`	160	`$sql = "`
158	`SELECT`	161	`SELECT`
159	`p.*`	162	`p.*`
160	`FROM`	163	`FROM`
Zeile 182...	Zeile 185...
182	`"updated_at" => $price->geaendert_am`	185	`"updated_at" => $price->geaendert_am`
183	`] );`	186	`] );`
184	`$progressbar->advance();`	187	`$progressbar->advance();`
185	`}`	188	`}`
186	`$progressbar->finish();`	189	`$progressbar->finish();`
-		190	`$progressbar->clear();`
187	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );`	191	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );`
188	`$sql = "SELECT`	192	`$sql = "SELECT`
189	`*`	193	`*`
190	`FROM`	194	`FROM`
191	`artikel_medien`	195	`artikel_medien`
Zeile 206...	Zeile 210...
206	`$medium->updated_by = "WebanOS Laravel Upgrade";`	210	`$medium->updated_by = "WebanOS Laravel Upgrade";`
207	`$medium->save();`	211	`$medium->save();`
208	`$progressbar->advance();`	212	`$progressbar->advance();`
209	`}`	213	`}`
210	`$progressbar->finish();`	214	`$progressbar->finish();`
-		215	`$progressbar->clear();`
211	`}`	216	`}`
Zeile 212...	Zeile 217...
212		217
213	`private function migrateActions()`	218	`private function migrateActions()`
214	`{`	219	`{`
Zeile 238...	Zeile 243...
238	`$actionDB->updated_by = "WebanOS Laravel Upgrade";`	243	`$actionDB->updated_by = "WebanOS Laravel Upgrade";`
239	`$actionDB->save();`	244	`$actionDB->save();`
240	`$progressbar->advance();`	245	`$progressbar->advance();`
241	`}`	246	`}`
242	`$progressbar->finish();`	247	`$progressbar->finish();`
-		248	`$progressbar->clear();`
243	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );`	249	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );`
244	`$sql = "SELECT`	250	`$sql = "SELECT`
245	`*`	251	`*`
246	`FROM`	252	`FROM`
247	`aktionen_medien`	253	`aktionen_medien`
Zeile 253...	Zeile 259...
253	`{`	259	`{`
254	`$medium = new ActionMedium();`	260	`$medium = new ActionMedium();`
255	`$medium->action_id = $row->aktionen_id;`	261	`$medium->action_id = $row->aktionen_id;`
256	`$medium->medium_id = $row->medien_id;`	262	`$medium->medium_id = $row->medien_id;`
257	`$medium->rank = $row->rang;`	263	`$medium->rank = $row->rang;`
258	`$medium->created_at = $row->zugeordnet_am;`	-
259	`$medium->updated_at = $row->zugeordnet_am;`	-
260	`$medium->created_by = "WebanOS Laravel Upgrade";`	264	`$medium->created_by = "WebanOS Laravel Upgrade";`
261	`$medium->updated_by = "WebanOS Laravel Upgrade";`	265	`$medium->updated_by = "WebanOS Laravel Upgrade";`
262	`$medium->save();`	266	`$medium->save();`
263	`$progressbar->advance();`	267	`$progressbar->advance();`
264	`}`	268	`}`
265	`$progressbar->finish();`	269	`$progressbar->finish();`
-		270	`$progressbar->clear();`
266	`}`	271	`}`
Zeile 267...	Zeile 272...
267		272
268	`public function migrateMedia()`	273	`public function migrateMedia()`
269	`{`	274	`{`
Zeile 303...	Zeile 308...
303	`$mediumDB->updated_by = $bearbeiter;`	308	`$mediumDB->updated_by = $bearbeiter;`
304	`$mediumDB->save();`	309	`$mediumDB->save();`
305	`$progressbar->advance();`	310	`$progressbar->advance();`
306	`}`	311	`}`
307	`$progressbar->finish();`	312	`$progressbar->finish();`
-		313	`$progressbar->clear();`
308	`}`	314	`}`
309	`}`	315	`}`

Subversion-Projekte lars-tiefland.laravel_shop

(root)/trunk/app/Console/Commands/convertDB.php – Revision 301 → 302