/**
* Executes an insert query against the database and returns the auto-increment id
*
* @param SqlCommand $command
* @return long last id inserted for this connection
*/
public function ExecuteInsert(ISqlCommand $command)
{
$this->Connection->Connect();
//Log::Debug('Database::ExecuteInsert %s', $command->GetQuery());
$this->Connection->Execute($command);
$insertedId = $this->Connection->GetLastInsertId();
$this->Connection->Disconnect();
return $insertedId;
}
/**
* @param IDbConnection $connection
* @throws \OC\DatabaseSetupException
*/
private function createDBUser($connection)
{
$name = $this->dbUser;
$password = $this->dbPassword;
// we need to create 2 accounts, one for global use and one for local user. if we don't specify the local one,
// the anonymous user would take precedence when there is one.
$query = "CREATE USER '{$name}'@'localhost' IDENTIFIED BY '{$password}'";
$connection->executeUpdate($query);
$query = "CREATE USER '{$name}'@'%' IDENTIFIED BY '{$password}'";
$connection->executeUpdate($query);
}
