41 lines
1.1 KiB
PHP
41 lines
1.1 KiB
PHP
<?php
|
|
|
|
use Illuminate\Database\Migrations\Migration;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
return new class extends Migration
|
|
{
|
|
/**
|
|
* Run the migrations.
|
|
*/
|
|
public function up(): void
|
|
{
|
|
// This updates the 'type' field for images, uploaded as shelf cover images,
|
|
// to be cover_bookshelf instead of cover_book.
|
|
// This does not fix their paths, since fixing that requires a more complicated operation,
|
|
// but their path does not affect functionality at time of this fix.
|
|
|
|
$shelfImageIds = DB::table('bookshelves')
|
|
->whereNotNull('image_id')
|
|
->pluck('image_id')
|
|
->values()->all();
|
|
|
|
if (count($shelfImageIds) > 0) {
|
|
DB::table('images')
|
|
->where('type', '=', 'cover_book')
|
|
->whereIn('id', $shelfImageIds)
|
|
->update(['type' => 'cover_bookshelf']);
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Reverse the migrations.
|
|
*/
|
|
public function down(): void
|
|
{
|
|
DB::table('images')
|
|
->where('type', '=', 'cover_bookshelf')
|
|
->update(['type' => 'cover_book']);
|
|
}
|
|
};
|