/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$subdomains = json_decode(file_get_contents(stryve_path() . '/Database/SeedData/reserved_subdomains.json'));
$subdomains_array = [];
foreach ($subdomains as $subdomain) {
$subdomain = lowertrim($subdomain);
if (isValidSubdomain($subdomain)) {
$subdomains_array[] = ['subdomain' => $subdomain, 'created_at' => \Carbon\Carbon::now(), 'updated_at' => \Carbon\Carbon::now()];
}
}
$this->reserved_subdomain->insert($subdomains_array);
}
/**
* Create a new account
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request, ReservedSubdomain $reserved_subdomain)
{
// [
// "full_name" => "Nick Law"
// "organisation" => "Stryve Technologies"
// "subdomain" => "stryve-tech-123"
// "phone" => "0423 640 190"
// "email" => "*****@*****.**"
// ]
// sanitize passed params and get geo data
$request = $this->account->sanitizeAndExpandRegistrationRequest($request);
dd($request);
// Check email address id valid
if (!isValidEmailAddress($request->email)) {
throw new HttpBadRequestException('Invalid email address.', 4002);
}
// check subdomain meets length and regex specifications
if (!$this->account->isValidSubdomain($request->subdomain)) {
throw new HttpBadRequestException('Invalid subdomain.', 4003);
}
// check subdomain is not already taken or reserved
if ($this->account->exists($request->subdomain) || $reserved_subdomain->isReserved($request->subdomain)) {
throw new HttpConflictException('Account already exists.', 4091);
}
// begin database transactions
DB::transaction(function () {
// create new user
// create new account
// create account email addresses
});
// set the connection options
$options = ['database' => $database, 'prefix' => $database_prefix];
// get the default connection detail so we can revert back
$defaultConnection = getDefaultDatabaseConnetion();
// set the new connection
setDatabaseConnetion($database, $options);
// create the new tenants database
$this->tenant->createNewTenantDatabase($database);
// run the new tenant migration
$this->tenant->runNewTenantMigration($database);
// \DB::disconnect($request->database);
// dd(\DB::connection('svr1'));
// run new tenant seeder
$this->tenant->runNewTenantTableSeeder($database);
// reset the default database connection
// setDatabaseConnetion($defaultConnection['connection'], $defaultConnection['options']);
// $default = \Config::get('database.default');
// dd(\Config::get('database.connections.' . $default));
exit('done');
// \DB::statement(\DB::raw('CREATE DATABASE ' . $request->database));
// \Artisan::call('migrate', [
// '--database' => $request->database,
// '--path' => 'app/Stryve/Database/Migrations/Tenant'
// ]);
//
/***/
// // Will contain the array of connections that appear in our database config file.
// $connections = \Config::get('database.connections');
// // This line pulls out the default connection by key (by default it's `mysql`)
// $defaultConnection = $connections[\Config::get('database.default')];
// // Now we simply copy the default connection information to our new connection.
// $newConnection = $defaultConnection;
// $options = [
// 'database' => $request->database,
// 'prefix' => $request->database_prefix
// ];
// // Override the database name.
// foreach($newConnection as $item => $value)
// $newConnection[$item] = isset($options[$item]) ? $options[$item] : $newConnection[$item];
// // dd($newConnection);
// // $newConnection['database'] = $request->database;
// // This will add our new connection to the run-time configuration for the duration of the request.
// \Config::set('database.connections.'.$request->database, $newConnection);
/***/
// count number of table from each database server
// select database server with the least number of databases
// // set the default connections options so we can revert back
// $conn_name = \Config::get('database.default');
// $defaultOptions = \Config::get('database.connections.'.$conn_name);
// // clone the default options
// $default = $defaultOptions;
// // the new conneciton options
// $options = [
// 'database' => $request->database,
// 'prefix' => $request->database_prefix
// ];
// // replace default options
// foreach($default as $item => $value)
// $default[$item] = isset($options[$item]) ? $options[$item] : $default[$item];
// // set the new connection
// \Config::set('database.connections.'.$conn_name, $default);
// try inserting new tenant DB
\DB::statement(\DB::raw('CREATE DATABASE ' . $request->database));
// dd(\Config::get('database.connections.db_svr_0'));
// $this->tenant->runNewTenantMigration($request->database);
// run new tenant migration
\Artisan::call('migrate', ['--database' => $conn->getConnectionName(), '--path' => 'app/Stryve/Database/Migrations/Tenant']);
// \Config::set('database.connections.'.\Config::get('database.default'), $defaultConnection);
// dd(\Config::get('database.connections.'.\Config::get('database.default')));
exit('done');
// set the connection to insert the new tenant database
// $connection = new ConnectOTF($options); // $this->tenant->setNewDbConnection($request);
// dd($connection->getDefaultOptions());
// create new tenant database
// $connection->createDatabase($request->database);
// dd(\Config::get('database.connections.'.$connection->getConnectionName()));
// perform initaial database table migration
// perform initial database seed
// reset the connection bac to its default
// $connection->getConnection()->resetDefaultConnection();
// add request data to stryve_admin database
// \Artisan::call('migrate:rollback');
}
