public function deleteAction()
{
$request = $this->get('request');
// Get the input
$id = $request->postVar('id');
// Get the message
$message = DataModel::repo(self::DATA_TYPE)->find($id);
if ($message) {
// Remove the message
$message->remove();
// Return a successful response
return $this->json(array('success' => true));
}
// Return an error response
return $this->json(array('success' => false));
}
public function validateDb()
{
$errors = array('message' => 'Database structure is invalid');
try {
$db = $this->get('db');
// Reconnect in case the database was created just now
$db->reconnect();
$tables = $db->getTables();
$expectedTables = array(UserModel::repo()->getTableName(), MessageModel::repo()->getTableName(), DataModel::repo('')->getTableName());
} catch (Exception $ex) {
$errors['message'] = 'Database exception: ' . $ex->getMessage();
return $errors;
}
if (count(array_diff($expectedTables, $tables)) !== 0) {
$errors['message'] = 'Invalid table structure, actual tables: ' . join(', ', $tables) . ', expected tables: ' . join(', ', $expectedTables);
return $errors;
}
return array();
}
