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



                    *
                FROM
                    directory
            ';
            $dirs = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
            $progressbar->start();
            foreach ( $dirs as $row )
            {
                $ersteller = $row->erstellt_von;
                if ( !$ersteller )
                {

                    "created_at"   => $row->erstellt_am,
                    "created_by"   => $ersteller,
                    "updated_by"   => $bearbeiter,
                    "updated_at"   => $row->letzte_Aenderung_am,
                ] );
                $progressbar->advance();
            }
            $progressbar->finish();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    directory_medien
            ";
            $media = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $media ) );
            $progressbar->start();
            foreach ( $media as $row )
            {
                $medium = new DirectoryMedium();
                $medium->directory_id = $row->directory_id;
                $medium->medium_id = $row->medien_id;

                $medium->created_at = $row->zugeordnet_am;
                $medium->updated_at = $row->zugeordnet_am;
                $medium->created_by = "WebanOS Laravel Upgrade";
                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
        }

 
        private function migrateItems()
        {

                    artikel
                WHERE
                    father>=-1
            ';
            $dirs = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
            $progressbar->start();
            foreach ( $dirs as $row )
            {
                $item = new Item();
                $item->id = $row->ID;
                $item->directory_id = $row->Father;

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

                    a.id=p.artikel_id
                WHERE
                    a.father >=-1
            ";
            $prices = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $prices ) );
            $progressbar->start();
            foreach ( $prices as $price )
            {
                Price::factory()->createQuietly( [
                    "item_id"     => $price->artikel_id,
                    "preis_index" => $price->preis_index,

                    "created_at"  => $price->geaendert_am,
                    "created_by"  => $price->geaendert_von,
                    "updated_by"  => $price->geaendert_von,
                    "updated_at"  => $price->geaendert_am
                ] );
                $progressbar->advance();
            }
            $progressbar->finish();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    artikel_medien
            ";
            $media = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $media ) );
            $progressbar->start();
            foreach ( $media as $row )
            {
                $medium = new ItemMedium();
                $medium->item_id = $row->artikel_id;
                $medium->medium_id = $row->medien_id;

                $medium->created_at = $row->zugeordnet_am;
                $medium->updated_at = $row->zugeordnet_am;
                $medium->created_by = "WebanOS Laravel Upgrade";
                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
        }

 
        private function migrateActions()
        {

                    *
                FROM
                    Aktionen
            ";
            $actions = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $actions ) );
            $progressbar->start();
            foreach ( $actions as $action )
            {
                $actionDB = new Action();
                $actionDB->id = $action->ID;
                $actionDB->headline = $action->headline;

                $actionDB->valid_from = $action->von;
                $actionDB->valid_to = $action->bis;
                $actionDB->created_by = "WebanOS Laravel Upgrade";
                $actionDB->updated_by = "WebanOS Laravel Upgrade";
                $actionDB->save();
                $progressbar->advance();
            }
            $progressbar->finish();
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
            $sql = "SELECT
                    *
                FROM
                    aktionen_medien
            ";
            $media = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $media ) );
            $progressbar->start();
            foreach ( $media as $row )
            {
                $medium = new ActionMedium();
                $medium->action_id = $row->aktionen_id;
                $medium->medium_id = $row->medien_id;

                $medium->created_at = $row->zugeordnet_am;
                $medium->updated_at = $row->zugeordnet_am;
                $medium->created_by = "WebanOS Laravel Upgrade";
                $medium->updated_by = "WebanOS Laravel Upgrade";
                $medium->save();
                $progressbar->advance();
            }
            $progressbar->finish();
        }

 
        public function migrateMedia()
        {

                    *
                FROM
                    medien
            ";
            $media = DB::connection( 'old' )->select( $sql );
            $progressbar = $this->output->createProgressBar( count( $media ) );
            $progressbar->start();
            foreach ( $media as $medium )
            {
                $mediumDB = new Medium();
                $mediumDB->id = $medium->id;
                $mediumDB->name = $medium->name;

                    $bearbeiter = "WebanOS Laravel Upgrade";
                }
                $mediumDB->created_by = $ersteller;
                $mediumDB->updated_by = $bearbeiter;
                $mediumDB->save();
                $progressbar->advance();
            }
            $progressbar->finish();
        }
    }

Revision 300	Revision 301
Zeile 53...	Zeile 53...
53	`*`	53	`*`
54	`FROM`	54	`FROM`
55	`directory`	55	`directory`
56	`';`	56	`';`
57	`$dirs = DB::connection( 'old' )->select( $sql );`	57	`$dirs = DB::connection( 'old' )->select( $sql );`
-		58	`$progressbar = $this->output->createProgressBar( count( $dirs ) );`
-		59	`$progressbar->start();`
58	`foreach ( $dirs as $row )`	60	`foreach ( $dirs as $row )`
59	`{`	61	`{`
60	`$ersteller = $row->erstellt_von;`	62	`$ersteller = $row->erstellt_von;`
61	`if ( !$ersteller )`	63	`if ( !$ersteller )`
62	`{`	64	`{`
Zeile 79...	Zeile 81...
79	`"created_at" => $row->erstellt_am,`	81	`"created_at" => $row->erstellt_am,`
80	`"created_by" => $ersteller,`	82	`"created_by" => $ersteller,`
81	`"updated_by" => $bearbeiter,`	83	`"updated_by" => $bearbeiter,`
82	`"updated_at" => $row->letzte_Aenderung_am,`	84	`"updated_at" => $row->letzte_Aenderung_am,`
83	`] );`	85	`] );`
-		86	`$progressbar->advance();`
84	`}`	87	`}`
-		88	`$progressbar->finish();`
85	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );`	89	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );`
86	`$sql = "SELECT`	90	`$sql = "SELECT`
87	`*`	91	`*`
88	`FROM`	92	`FROM`
89	`directory_medien`	93	`directory_medien`
90	`";`	94	`";`
91	`$media = DB::connection( 'old' )->select( $sql );`	95	`$media = DB::connection( 'old' )->select( $sql );`
-		96	`$progressbar = $this->output->createProgressBar( count( $media ) );`
-		97	`$progressbar->start();`
92	`foreach ( $media as $row )`	98	`foreach ( $media as $row )`
93	`{`	99	`{`
94	`$medium = new DirectoryMedium();`	100	`$medium = new DirectoryMedium();`
95	`$medium->directory_id = $row->directory_id;`	101	`$medium->directory_id = $row->directory_id;`
96	`$medium->medium_id = $row->medien_id;`	102	`$medium->medium_id = $row->medien_id;`
Zeile 99...	Zeile 105...
99	`$medium->created_at = $row->zugeordnet_am;`	105	`$medium->created_at = $row->zugeordnet_am;`
100	`$medium->updated_at = $row->zugeordnet_am;`	106	`$medium->updated_at = $row->zugeordnet_am;`
101	`$medium->created_by = "WebanOS Laravel Upgrade";`	107	`$medium->created_by = "WebanOS Laravel Upgrade";`
102	`$medium->updated_by = "WebanOS Laravel Upgrade";`	108	`$medium->updated_by = "WebanOS Laravel Upgrade";`
103	`$medium->save();`	109	`$medium->save();`
-		110	`$progressbar->advance();`
104	`}`	111	`}`
-		112	`$progressbar->finish();`
105	`}`	113	`}`
Zeile 106...	Zeile 114...
106		114
107	`private function migrateItems()`	115	`private function migrateItems()`
108	`{`	116	`{`
Zeile 114...	Zeile 122...
114	`artikel`	122	`artikel`
115	`WHERE`	123	`WHERE`
116	`father>=-1`	124	`father>=-1`
117	`';`	125	`';`
118	`$dirs = DB::connection( 'old' )->select( $sql );`	126	`$dirs = DB::connection( 'old' )->select( $sql );`
-		127	`$progressbar = $this->output->createProgressBar( count( $dirs ) );`
-		128	`$progressbar->start();`
119	`foreach ( $dirs as $row )`	129	`foreach ( $dirs as $row )`
120	`{`	130	`{`
121	`$item = new Item();`	131	`$item = new Item();`
122	`$item->id = $row->ID;`	132	`$item->id = $row->ID;`
123	`$item->directory_id = $row->Father;`	133	`$item->directory_id = $row->Father;`
Zeile 138...	Zeile 148...
138	`$bearbeiter = "WebanOS Laravel Upgrade";`	148	`$bearbeiter = "WebanOS Laravel Upgrade";`
139	`}`	149	`}`
140	`$item->created_by = $ersteller;`	150	`$item->created_by = $ersteller;`
141	`$item->updated_by = $bearbeiter;`	151	`$item->updated_by = $bearbeiter;`
142	`$item->save();`	152	`$item->save();`
-		153	`$progressbar->advance();`
143	`}`	154	`}`
-		155	`$progressbar->finish();`
144	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );`	156	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Preise" );`
145	`$sql = "`	157	`$sql = "`
146	`SELECT`	158	`SELECT`
147	`p.*`	159	`p.*`
148	`FROM`	160	`FROM`
Zeile 153...	Zeile 165...
153	`a.id=p.artikel_id`	165	`a.id=p.artikel_id`
154	`WHERE`	166	`WHERE`
155	`a.father >=-1`	167	`a.father >=-1`
156	`";`	168	`";`
157	`$prices = DB::connection( 'old' )->select( $sql );`	169	`$prices = DB::connection( 'old' )->select( $sql );`
-		170	`$progressbar = $this->output->createProgressBar( count( $prices ) );`
-		171	`$progressbar->start();`
158	`foreach ( $prices as $price )`	172	`foreach ( $prices as $price )`
159	`{`	173	`{`
160	`Price::factory()->createQuietly( [`	174	`Price::factory()->createQuietly( [`
161	`"item_id" => $price->artikel_id,`	175	`"item_id" => $price->artikel_id,`
162	`"preis_index" => $price->preis_index,`	176	`"preis_index" => $price->preis_index,`
Zeile 165...	Zeile 179...
165	`"created_at" => $price->geaendert_am,`	179	`"created_at" => $price->geaendert_am,`
166	`"created_by" => $price->geaendert_von,`	180	`"created_by" => $price->geaendert_von,`
167	`"updated_by" => $price->geaendert_von,`	181	`"updated_by" => $price->geaendert_von,`
168	`"updated_at" => $price->geaendert_am`	182	`"updated_at" => $price->geaendert_am`
169	`] );`	183	`] );`
-		184	`$progressbar->advance();`
170	`}`	185	`}`
-		186	`$progressbar->finish();`
171	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );`	187	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );`
172	`$sql = "SELECT`	188	`$sql = "SELECT`
173	`*`	189	`*`
174	`FROM`	190	`FROM`
175	`artikel_medien`	191	`artikel_medien`
176	`";`	192	`";`
177	`$media = DB::connection( 'old' )->select( $sql );`	193	`$media = DB::connection( 'old' )->select( $sql );`
-		194	`$progressbar = $this->output->createProgressBar( count( $media ) );`
-		195	`$progressbar->start();`
178	`foreach ( $media as $row )`	196	`foreach ( $media as $row )`
179	`{`	197	`{`
180	`$medium = new ItemMedium();`	198	`$medium = new ItemMedium();`
181	`$medium->item_id = $row->artikel_id;`	199	`$medium->item_id = $row->artikel_id;`
182	`$medium->medium_id = $row->medien_id;`	200	`$medium->medium_id = $row->medien_id;`
Zeile 185...	Zeile 203...
185	`$medium->created_at = $row->zugeordnet_am;`	203	`$medium->created_at = $row->zugeordnet_am;`
186	`$medium->updated_at = $row->zugeordnet_am;`	204	`$medium->updated_at = $row->zugeordnet_am;`
187	`$medium->created_by = "WebanOS Laravel Upgrade";`	205	`$medium->created_by = "WebanOS Laravel Upgrade";`
188	`$medium->updated_by = "WebanOS Laravel Upgrade";`	206	`$medium->updated_by = "WebanOS Laravel Upgrade";`
189	`$medium->save();`	207	`$medium->save();`
-		208	`$progressbar->advance();`
190	`}`	209	`}`
-		210	`$progressbar->finish();`
191	`}`	211	`}`
Zeile 192...	Zeile 212...
192		212
193	`private function migrateActions()`	213	`private function migrateActions()`
194	`{`	214	`{`
Zeile 198...	Zeile 218...
198	`*`	218	`*`
199	`FROM`	219	`FROM`
200	`Aktionen`	220	`Aktionen`
201	`";`	221	`";`
202	`$actions = DB::connection( 'old' )->select( $sql );`	222	`$actions = DB::connection( 'old' )->select( $sql );`
-		223	`$progressbar = $this->output->createProgressBar( count( $actions ) );`
-		224	`$progressbar->start();`
203	`foreach ( $actions as $action )`	225	`foreach ( $actions as $action )`
204	`{`	226	`{`
205	`$actionDB = new Action();`	227	`$actionDB = new Action();`
206	`$actionDB->id = $action->ID;`	228	`$actionDB->id = $action->ID;`
207	`$actionDB->headline = $action->headline;`	229	`$actionDB->headline = $action->headline;`
Zeile 213...	Zeile 235...
213	`$actionDB->valid_from = $action->von;`	235	`$actionDB->valid_from = $action->von;`
214	`$actionDB->valid_to = $action->bis;`	236	`$actionDB->valid_to = $action->bis;`
215	`$actionDB->created_by = "WebanOS Laravel Upgrade";`	237	`$actionDB->created_by = "WebanOS Laravel Upgrade";`
216	`$actionDB->updated_by = "WebanOS Laravel Upgrade";`	238	`$actionDB->updated_by = "WebanOS Laravel Upgrade";`
217	`$actionDB->save();`	239	`$actionDB->save();`
-		240	`$progressbar->advance();`
218	`}`	241	`}`
-		242	`$progressbar->finish();`
219	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );`	243	`$this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );`
220	`$sql = "SELECT`	244	`$sql = "SELECT`
221	`*`	245	`*`
222	`FROM`	246	`FROM`
223	`aktionen_medien`	247	`aktionen_medien`
224	`";`	248	`";`
225	`$media = DB::connection( 'old' )->select( $sql );`	249	`$media = DB::connection( 'old' )->select( $sql );`
-		250	`$progressbar = $this->output->createProgressBar( count( $media ) );`
-		251	`$progressbar->start();`
226	`foreach ( $media as $row )`	252	`foreach ( $media as $row )`
227	`{`	253	`{`
228	`$medium = new ActionMedium();`	254	`$medium = new ActionMedium();`
229	`$medium->action_id = $row->aktionen_id;`	255	`$medium->action_id = $row->aktionen_id;`
230	`$medium->medium_id = $row->medien_id;`	256	`$medium->medium_id = $row->medien_id;`
Zeile 232...	Zeile 258...
232	`$medium->created_at = $row->zugeordnet_am;`	258	`$medium->created_at = $row->zugeordnet_am;`
233	`$medium->updated_at = $row->zugeordnet_am;`	259	`$medium->updated_at = $row->zugeordnet_am;`
234	`$medium->created_by = "WebanOS Laravel Upgrade";`	260	`$medium->created_by = "WebanOS Laravel Upgrade";`
235	`$medium->updated_by = "WebanOS Laravel Upgrade";`	261	`$medium->updated_by = "WebanOS Laravel Upgrade";`
236	`$medium->save();`	262	`$medium->save();`
-		263	`$progressbar->advance();`
237	`}`	264	`}`
-		265	`$progressbar->finish();`
238	`}`	266	`}`
Zeile 239...	Zeile 267...
239		267
240	`public function migrateMedia()`	268	`public function migrateMedia()`
241	`{`	269	`{`
Zeile 245...	Zeile 273...
245	`*`	273	`*`
246	`FROM`	274	`FROM`
247	`medien`	275	`medien`
248	`";`	276	`";`
249	`$media = DB::connection( 'old' )->select( $sql );`	277	`$media = DB::connection( 'old' )->select( $sql );`
-		278	`$progressbar = $this->output->createProgressBar( count( $media ) );`
-		279	`$progressbar->start();`
250	`foreach ( $media as $medium )`	280	`foreach ( $media as $medium )`
251	`{`	281	`{`
252	`$mediumDB = new Medium();`	282	`$mediumDB = new Medium();`
253	`$mediumDB->id = $medium->id;`	283	`$mediumDB->id = $medium->id;`
254	`$mediumDB->name = $medium->name;`	284	`$mediumDB->name = $medium->name;`
Zeile 270...	Zeile 300...
270	`$bearbeiter = "WebanOS Laravel Upgrade";`	300	`$bearbeiter = "WebanOS Laravel Upgrade";`
271	`}`	301	`}`
272	`$mediumDB->created_by = $ersteller;`	302	`$mediumDB->created_by = $ersteller;`
273	`$mediumDB->updated_by = $bearbeiter;`	303	`$mediumDB->updated_by = $bearbeiter;`
274	`$mediumDB->save();`	304	`$mediumDB->save();`
-		305	`$progressbar->advance();`
275	`}`	306	`}`
-		307	`$progressbar->finish();`
276	`}`	308	`}`
277	`}`	309	`}`

Subversion-Projekte lars-tiefland.laravel_shop

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