2018_08_15_103716_move_photos.php

<?php

use App\Facades\Helpers;
use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\Storage;
use function Safe\date;
use Safe\Exceptions\DatetimeException;
use Safe\Exceptions\ImageException;
use function Safe\getimagesize;

require_once 'TemporaryModels/MovePhotos_Photo.php';

return new class() extends Migration {
	/**
	 * Run the migrations.
	 */
	public function up(): void
	{
		// only do if photos is empty and
		// if there is a table to import from
		if (
			MovePhotos_Photo::count() === 0 &&
			Schema::hasTable(env('DB_OLD_LYCHEE_PREFIX', '') . 'lychee_photos')
		) {
			$results = DB::table(env('DB_OLD_LYCHEE_PREFIX', '') . 'lychee_photos')->select('*')->orderBy('id', 'asc')->orderBy('album', 'asc')->get();
			$id = 0;
			foreach ($results as $result) {
				$photoAttributes = [];
				$id = Helpers::trancateIf32($result->id, (int) $id);
				$photoAttributes['id'] = $id;
				if ($result->album === 0) {
					$photoAttributes['album_id'] = null;
				} else {
					$albumID = Helpers::trancateIf32($result->album, 0);
					$exists = DB::table('albums')->select('id')->where('id', '=', $albumID)->count() > 0;
					$photoAttributes['album_id'] = $exists ? $albumID : null;
				}
				$photoAttributes['title'] = $result->title;
				$photoAttributes['description'] = $result->description;
				$photoAttributes['url'] = $result->url;
				$photoAttributes['tags'] = $result->tags;
				$photoAttributes['public'] = $result->public;
				$photoAttributes['type'] = $result->type;
				$photoAttributes['width'] = $result->width;
				$photoAttributes['height'] = $result->height;
				$photoAttributes['size'] = $result->size;
				$photoAttributes['iso'] = $result->iso;
				$photoAttributes['aperture'] = $result->aperture;
				$photoAttributes['make'] = $result->make;
				$photoAttributes['lens'] = $result->lens ?? '';
				$photoAttributes['model'] = $result->model;
				$photoAttributes['shutter'] = $result->shutter;
				$photoAttributes['focal'] = $result->focal;
				try {
					$date = date('Y-m-d H:i:s', $result->takestamp);
				} catch (DatetimeException) {
					$date = null;
				}
				$photoAttributes['takestamp'] = ($result->takestamp === 0 || $result->takestamp === null) ? null : $date;
				$photoAttributes['star'] = $result->star;
				$photoAttributes['thumbUrl'] = $result->thumbUrl;
				$thumbUrl2x = explode('.', $result->thumbUrl);
				if (count($thumbUrl2x) < 2) {
					$photoAttributes['thumb2x'] = 0;
				} else {
					/** @var string $thumbUrl2x */
					$thumbUrl2x = $thumbUrl2x[0] . '@2x.' . $thumbUrl2x[1];
					if (!Storage::exists('thumb/' . $thumbUrl2x)) {
						$photoAttributes['thumb2x'] = 0;
					} else {
						$photoAttributes['thumb2x'] = 1;
					}
				}
				$photoAttributes['checksum'] = $result->checksum;
				if (Storage::exists('medium/' . $photoAttributes['url'])) {
					try {
						list($width, $height) = getimagesize(Storage::path('medium/' . $photoAttributes['url']));
						$photoAttributes['medium'] = $width . 'x' . $height;
					} catch (ImageException) {
						$photoAttributes['medium'] = '';
					}
				} else {
					$photoAttributes['medium'] = '';
				}
				if (Storage::exists('small/' . $photoAttributes['url'])) {
					try {
						list($width, $height) = getimagesize(Storage::path('small/' . $photoAttributes['url']));
						$photoAttributes['small'] = $width . 'x' . $height;
					} catch (ImageException) {
						$photoAttributes['small'] = '';
					}
				} else {
					$photoAttributes['small'] = '';
				}
				$photoAttributes['license'] = $result->license ?? 'none';

				$photoModel = new MovePhotos_Photo();
				$photoModel->setRawAttributes($photoAttributes);
				$photoModel->save();
			}
		}
	}

	/**
	 * Reverse the migrations.
	 */
	public function down(): void
	{
		if (Schema::hasTable('lychee_photos')) {
			MovePhotos_Photo::query()->truncate();
		}
	}
};