}
// Columns
$FirstUser = $Database->where('id', 1)->getOne('users', 'id, name');
checkQuery('SELECT id, name FROM users WHERE "id" = 1 LIMIT 1', 'GETONE_QUERY_COLUMN_MISMATCH');
if ($FirstUser['id'] != 1) {
fail('GETONE_RETURNING_COLUMN_WRONG_DATA');
}
if (!is_int($FirstUser['id'])) {
fail('GETONE_RETURNING_WRONG_DATA_TYPE_INT');
}
if (!is_string($FirstUser['name'])) {
fail('GETONE_RETURNING_WRONG_DATA_TYPE_STRING');
}
# orderBy() Checks
// Generic call
$LastUser = $Database->orderBy('id', 'DESC')->getOne('users');
checkQuery('SELECT * FROM users ORDER BY id DESC LIMIT 1', 'ORDERBY_QUERY_MISMATCH');
if (!isset($LastUser['id'])) {
fail('ORDERBY_RETURNING_WRONG_DATA');
}
if ($LastUser['id'] != 3) {
fail('ORDERBY_RETURNING_WRONG_DATA');
}
if (!is_int($LastUser['id'])) {
fail('ORDERBY_RETURNING_WRONG_DATA_TYPE_INT');
}
if (!is_string($LastUser['name'])) {
fail('ORDERBY_RETURNING_WRONG_DATA_TYPE_STRING');
}
# rawQuery() Checks
// No bound parameteres
