} // 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