31 lines
908 B
PHP
31 lines
908 B
PHP
<?php
|
|
require __DIR__.'/../vendor/autoload.php';
|
|
$app = require_once __DIR__.'/../bootstrap/app.php';
|
|
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
|
|
$kernel->bootstrap();
|
|
|
|
use Illuminate\Support\Facades\DB;
|
|
use Illuminate\Support\Facades\Artisan;
|
|
|
|
echo "Wiping database...\n";
|
|
Artisan::call('db:wipe');
|
|
echo Artisan::output();
|
|
|
|
echo "Importing SQL file...\n";
|
|
$sql = file_get_contents(__DIR__.'/../u693027326_seb.sql');
|
|
|
|
// DB::unprepared can fail on very large files due to memory. Let's see if it works.
|
|
DB::unprepared($sql);
|
|
|
|
echo "Import successful.\n";
|
|
|
|
$user = \App\Models\User::where('email', 'mbmirandilla.jmc@gmail.com')->first();
|
|
if ($user) {
|
|
echo "Permissions for " . $user->email . ":\n";
|
|
print_r($user->getAllPermissions()->pluck('name')->toArray());
|
|
echo "\nRoles:\n";
|
|
print_r($user->roles->pluck('name')->toArray());
|
|
} else {
|
|
echo "User not found.\n";
|
|
}
|