public function loadBackup()
{
ini_set("max_execution_time", 0);
\DB::Connection('mysql2')->statement('CREATE DATABASE IF NOT EXISTS pmportal');
\DB::unprepared(file_get_contents('C:\\xampp\\htdocs\\PMPortal\\storage\\app\\backups\\dump.sql'));
flash()->success('Database backup has been successfully loaded');
return redirect()->action('ProjectsController@index');
}
/**
* Remove the specified resource from storage.
*
* @param Request $request
* @param int $id
* @return \Illuminate\Http\Response
* @throws \Exception
*/
public function destroy(Request $request, $id)
{
$this->authorize('litteraturkritikk');
if (!$request->get('confirm-deleteperson')) {
return redirect()->back()->with('status', 'Manglet bekreftelse');
}
$person = Person::findOrFail($id);
$person->records()->detach();
$person->delete();
\DB::unprepared('REFRESH MATERIALIZED VIEW litteraturkritikk_records_search');
return redirect()->action('LitteraturkritikkPersonController@show', $id)->with('status', 'Personen ble slettet');
}