Subversion-Projekte lars-tiefland.laravel_shop

Revision

Revision 482 | Revision 487 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 482 Revision 486
Zeile 106... Zeile 106...
106 
        }
 106 
        }
Zeile 107... Zeile 107...
107 
 
 107 
 
108 
        public function migrateMedia()
 108 
        public function migrateMedia()
109 
        {
 109 
        {
- 
 
 110 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
- 
 
 111 
            $start = 0;
- 
 
 112 
            $sql = "SELECT
- 
 
 113 
                    MAX(id) AS start
- 
 
 114 
                FROM
- 
 
 115 
                    media
- 
 
 116 
            ";
- 
 
 117 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 118 
            if ( $row[0]->start )
- 
 
 119 
            {
- 
 
 120 
                $start = $row[0]->start;
110 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Medien" );
 121 
            }
111 
            $sql = "
 122 
            $sql = "
112 
                SELECT
 123 
                SELECT
113 
                    *
 124 
                    *
114 
                FROM
 125 
                FROM
- 
 
 126 
                    medien
- 
 
 127 
                WHERE
115 
                    medien
 128 
                    id>" . $start . "
116 
            ";
 129 
            ";
117 
            $media = DB::connection( 'old' )->select( $sql );
 130 
            $media = DB::connection( 'old' )->select( $sql );
118 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 131 
            $progressbar = $this->output->createProgressBar( count( $media ) );
119 
            $progressbar->start();
 132 
            $progressbar->start();
Zeile 149... Zeile 162...
149 
        }
 162 
        }
Zeile 150... Zeile 163...
150 
 
 163 
 
151 
        private function migrateDirs()
 164 
        private function migrateDirs()
152 
        {
 165 
        {
- 
 
 166 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
- 
 
 167 
            $start = 0;
- 
 
 168 
            $sql = "SELECT
- 
 
 169 
                    MAX(id) AS start
- 
 
 170 
                FROM
- 
 
 171 
                    directories
- 
 
 172 
            ";
- 
 
 173 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 174 
            if ( $row[0]->start )
- 
 
 175 
            {
- 
 
 176 
                $start = $row[0]->start;
153 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorien" );
 177 
            }
154 
            $sql = '
 178 
            $sql = '
155 
                SELECT
179 
                SELECT
156 
                    *
 180 
                    *
157 
                FROM
 181 
                FROM
- 
 
 182 
                    directory
158 
                    directory
 183 
                WHERE id>' . $start . '
159 
            ';
 184 
            ';
160 
            $dirs = DB::connection( 'old' )->select( $sql );
 185 
            $dirs = DB::connection( 'old' )->select( $sql );
161 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
 186 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
162 
            $progressbar->start();
 187 
            $progressbar->start();
Zeile 194... Zeile 219...
194 
        }
 219 
        }
Zeile 195... Zeile 220...
195 
 
 220 
 
196 
        public function migrateDirMedia()
 221 
        public function migrateDirMedia()
197 
        {
 222 
        {
- 
 
 223 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
- 
 
 224 
            $start = 0;
- 
 
 225 
            $sql = "SELECT
- 
 
 226 
                    MAX(medium_id) AS start
- 
 
 227 
                FROM
- 
 
 228 
                    directory_media
- 
 
 229 
            ";
- 
 
 230 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 231 
            if ( $row[0]->start )
- 
 
 232 
            {
- 
 
 233 
                $start = $row[0]->start;
198 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Kategorie-Bilder" );
 234 
            }
199 
            $sql = "SELECT
 235 
            $sql = "SELECT
200 
                    *
 236 
                    *
201 
                FROM
 237 
                FROM
- 
 
 238 
                    directory_medien
- 
 
 239 
                WHERE
202 
                    directory_medien
 240 
                    mediuen_id>" . $start . "
203 
            ";
 241 
            ";
204 
            $media = DB::connection( 'old' )->select( $sql );
 242 
            $media = DB::connection( 'old' )->select( $sql );
205 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 243 
            $progressbar = $this->output->createProgressBar( count( $media ) );
206 
            $progressbar->start();
 244 
            $progressbar->start();
Zeile 223... Zeile 261...
223 
        }
 261 
        }
Zeile 224... Zeile 262...
224 
 
 262 
 
225 
        private function migrateItems()
 263 
        private function migrateItems()
226 
        {
 264 
        {
- 
 
 265 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
- 
 
 266 
            $start = 0;
- 
 
 267 
            $sql = "SELECT
- 
 
 268 
                    MAX(id) AS start
- 
 
 269 
                FROM
- 
 
 270 
                    items
- 
 
 271 
            ";
- 
 
 272 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 273 
            if ( $row[0]->start )
- 
 
 274 
            {
- 
 
 275 
                $start = $row[0]->start;
227 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel" );
 276 
            }
228 
            $sql = '
 277 
            $sql = '
229 
                SELECT
278 
                SELECT
230 
                    *
 279 
                    *
231 
                FROM
 280 
                FROM
232 
                    artikel
 281 
                    artikel
233 
                WHERE
 282 
                WHERE
- 
 
 283 
                    father > -1
- 
 
 284 
                AND
234 
                    father>=-1
 285 
                    id>=' . $start . '
235 
            ';
 286 
            ';
236 
            $dirs = DB::connection( 'old' )->select( $sql );
 287 
            $dirs = DB::connection( 'old' )->select( $sql );
237 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
 288 
            $progressbar = $this->output->createProgressBar( count( $dirs ) );
238 
            $progressbar->start();
 289 
            $progressbar->start();
Zeile 299... Zeile 350...
299 
        }
 350 
        }
Zeile 300... Zeile 351...
300 
 
 351 
 
301 
        public function migrateItemMedia()
 352 
        public function migrateItemMedia()
302 
        {
 353 
        {
- 
 
 354 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
- 
 
 355 
            $start = 0;
- 
 
 356 
            $sql = "SELECT
- 
 
 357 
                    MAX(medium_id) AS start
- 
 
 358 
                FROM
- 
 
 359 
                    users
- 
 
 360 
            ";
- 
 
 361 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 362 
            if ( $row[0]->start )
- 
 
 363 
            {
- 
 
 364 
                $start = $row[0]->start;
303 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Artikel-Bilder" );
 365 
            }
304 
            $sql = "SELECT
 366 
            $sql = "SELECT
305 
                    *
 367 
                    *
306 
                FROM
 368 
                FROM
- 
 
 369 
                    artikel_medien
- 
 
 370 
                WHERE
307 
                    artikel_medien
 371 
                    medien_id>" . $start . "
308 
            ";
 372 
            ";
309 
            $media = DB::connection( 'old' )->select( $sql );
 373 
            $media = DB::connection( 'old' )->select( $sql );
310 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 374 
            $progressbar = $this->output->createProgressBar( count( $media ) );
311 
            $progressbar->start();
 375 
            $progressbar->start();
Zeile 328... Zeile 392...
328 
        }
 392 
        }
Zeile 329... Zeile 393...
329 
 
 393 
 
330 
        private function migrateActions()
 394 
        private function migrateActions()
331 
        {
 395 
        {
- 
 
 396 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
- 
 
 397 
            $start = 0;
- 
 
 398 
            $sql = "SELECT
- 
 
 399 
                    MAX(id) AS start
- 
 
 400 
                FROM
- 
 
 401 
                    actions
- 
 
 402 
            ";
- 
 
 403 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 404 
            if ( $row[0]->start )
- 
 
 405 
            {
- 
 
 406 
                $start = $row[0]->start;
332 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktionen" );
 407 
            }
333 
            $sql = "
 408 
            $sql = "
334 
                SELECT
 409 
                SELECT
335 
                    *
 410 
                    *
336 
                FROM
 411 
                FROM
- 
 
 412 
                    Aktionen
- 
 
 413 
                WHERE
337 
                    Aktionen
 414 
                    id>" . $start . "
338 
            ";
 415 
            ";
339 
            $actions = DB::connection( 'old' )->select( $sql );
 416 
            $actions = DB::connection( 'old' )->select( $sql );
340 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
 417 
            $progressbar = $this->output->createProgressBar( count( $actions ) );
341 
            $progressbar->start();
 418 
            $progressbar->start();
Zeile 361... Zeile 438...
361 
        }
 438 
        }
Zeile 362... Zeile 439...
362 
 
 439 
 
363 
        public function migrateActionMedia()
 440 
        public function migrateActionMedia()
364 
        {
 441 
        {
- 
 
 442 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
- 
 
 443 
            $start = 0;
- 
 
 444 
            $sql = "SELECT
- 
 
 445 
                    MAX(id) AS start
- 
 
 446 
                FROM
- 
 
 447 
                    action_media
- 
 
 448 
            ";
- 
 
 449 
            $row = DB::connection( "mysql" )->select( $sql );
- 
 
 450 
            if ( $row[0]->start )
- 
 
 451 
            {
- 
 
 452 
                $start = $row[0]->start;
365 
            $this->info( date( "d.m.Y H:i:s" ) . ": Migriere Aktions-Bilder" );
 453 
            }
366 
            $sql = "SELECT
 454 
            $sql = "SELECT
367 
                    *
 455 
                    *
368 
                FROM
 456 
                FROM
- 
 
 457 
                    aktionen_medien
- 
 
 458 
                WHERE
369 
                    aktionen_medien
 459 
                    id>" . $start . "
370 
            ";
 460 
            ";
371 
            $media = DB::connection( 'old' )->select( $sql );
 461 
            $media = DB::connection( 'old' )->select( $sql );
372 
            $progressbar = $this->output->createProgressBar( count( $media ) );
 462 
            $progressbar = $this->output->createProgressBar( count( $media ) );
373 
            $progressbar->start();
 463 
            $progressbar->start();