public function runUpdate()
{
if (Capsule::schema()->hasTable('settings')) {
$updateVersion = SettingModel::where('name', 'update_version')->first();
if ($updateVersion && $updateVersion->value == $this->app['version']) {
return $this->app->redirect('/');
}
}
$s = new Seeder($this->app, $this->app['projects.creator']);
$s->seedTemplates();
$s->seedLibraries();
if (SettingModel::where('name', 'update_version')->first()) {
SettingModel::where('name', 'update_version')->update(array('value' => $this->app['version']));
} else {
SettingModel::insert(array('name' => 'update_version', 'value' => $this->app['version']));
}
return $this->app->redirect('/');
}
/**
* Reset database by truncating tables and re-seeding.
*
* @return Response
*/
public function reset()
{
if ($_SERVER['REMOTE_ADDR'] !== $_SERVER['SERVER_ADDR']) {
return new Response('You don\'t have permissions to do that.', 403);
}
DB::table('folders')->truncate();
DB::table('groups')->truncate();
DB::table('images')->truncate();
DB::table('images_folders')->truncate();
DB::table('libraries')->truncate();
DB::table('pages')->truncate();
DB::table('pages_libraries')->truncate();
DB::table('projects')->truncate();
DB::table('templates')->truncate();
DB::table('themes')->truncate();
DB::table('users_projects')->truncate();
$this->emptyFolders();
$this->seeder->seed();
$this->seeder->seedDemoProjects();
file_put_contents($this->lastResetPath, '<?php return ' . Carbon::now()->timestamp . ';');
return new Response('Reset database successfully.', 200);
}