/**
* createTable(argument) Execute the CREATE query
*
* @return bool
*/
public function createTable($tablename, $connection = NULL)
{
$connection = DatabaseQuery::connect();
try {
$sqlQuery = self::sanitizeQuery($tablename);
$query = $connection->prepare($sqlQuery);
if ($query->execute()) {
return true;
}
} catch (PDOException $e) {
return $e->getMessage();
}
}
/**
* destroy($value)
* Delete data from database
*
* @return bool
*/
public function destroy($value, $dbConnection = NULL)
{
$connection = DatabaseQuery::checkConnection($dbConnection);
$query = $connection->prepare('DELETE FROM ' . self::getTableName($connection) . ' WHERE id = ' . $value);
$query->execute();
$check = $query->rowCount();
if ($check) {
return true;
}
throw new DataNotFoundException();
}
/**
* getTableName()
*
* @return string
*/
protected function getTableName($connection)
{
return DatabaseQuery::checkTableName($this->getClassName(), $connection);
}