public function getDatabaseName()
{
$data = Farmbook::where('id', '=', $this->farmbook)->first();
if (is_null($data)) {
$data = "No database";
} else {
$data = $data->name;
}
return $data;
}
/**
* Show the application dashboard.
*
* @return \Illuminate\Http\Response
*/
public function store(Request $request, $id)
{
// current timestamp
$now = Carbon\Carbon::now('Africa/Cairo')->toDateTimeString();
// get inpute
$id = $request->input('id');
$name = $request->input('name');
$database = $request->input('database');
$suburbs = $request->input('suburbs');
//dd($suburbs);
//$type = $request->input('type');
Farmbook::where('id', $id)->update(array('name' => $name, 'database' => $database, 'updated_at' => $now));
$farmbook = Farmbook::where('id', '=', $id)->first();
// store the deed suburbs
$farmbook->suburbs()->sync($suburbs);
// dd("user controller Store ",$id,,$farmbooks);
Session::flash('flash_message', 'Updated ' . $name . ' at ' . $now);
Session::flash('flash_type', 'alert-success');
return Redirect::back();
}
public function createdatabase(Request $request)
{
$file = storage_path() . '/databases/dummy_database.sql';
$file2 = storage_path() . '/databases/dummy_database.sql';
// check if the file exists
if (file_exists($file)) {
$sqldump = file_get_contents($file);
} else {
$file = "not found";
$message = 'missing dummy_database';
Session::flash('flash_message', $message);
Session::flash('flash_type', 'alert-danger');
return Redirect::back()->with('flash_message', $message);
}
$database = $request->input('database');
$type = $request->input('type');
$database = $database . '_' . $type . '_farmbook2';
//dd($database);
$servername = config('database.connections.mysql.host');
$username = config('database.connections.mysql.username');
$password = config('database.connections.mysql.password');
// dd('make database',$database);
$dbname = 'tmp';
// connect to tmp database
$otf = new \App\Database\OTF(['database' => $dbname]);
$db = DB::connection($dbname);
$sql = "CREATE DATABASE " . $database;
//set created to false
$created = false;
try {
// created database successfully
$db->getpdo()->exec($sql);
$created = true;
} catch (Exception $ex) {
// dd( $ex->getMessage());
// error creating database
$message = $ex->getMessage();
}
// database created success
if ($created == true) {
$Farmbook = Farmbook::where('database', '=', $database);
$normal_name = str_replace('_', ' ', $database);
$normal_name = str_replace('farmbook2', ' ', $normal_name);
if ($Farmbook->count() > 0) {
$Farmbook = Farmbook::where('database', '=', $database)->update(['database' => $database]);
} else {
// add to farmbooks
$Farmbook = new Farmbook();
$Farmbook->name = $normal_name;
$Farmbook->database = $database;
$Farmbook->type = 0;
$Farmbook->save();
}
// connect to the new database
$otf = new \App\Database\OTF(['database' => $database]);
$db = DB::connection($database);
// creates tables with dummy
$db->getpdo()->exec($sqldump);
$message = $database . ' created successfully.';
Session::flash('flash_message', $message);
Session::flash('flash_type', 'alert-success');
} else {
Session::flash('flash_message', $message);
Session::flash('flash_type', 'alert-danger');
}
return Redirect::back()->with('flash_message', $message);
}
