try {
if ($Database->tableExists('users') !== false) {
exit($_['TABLEEXISTS_NOT_FALSE']);
}
} catch (Exception $e) {
fail('TESTDB_CONNECTION_ERROR');
}
$Database->rawQuery('CREATE TABLE "users" (id serial NOT NULL, name character varying(10))');
if ($Database->tableExists('users') !== true) {
fail('TABLEEXISTS_NOT_TRUE');
}
// Add PRIMARY KEY constraint
$Database->rawQuery('ALTER TABLE "users" ADD CONSTRAINT "users_id" PRIMARY KEY ("id")');
# get() Checks
// Regular call
$Users = $Database->get('users');
checkQuery('SELECT * FROM users', 'GET_QUERY_MISMATCH');
if (!is_array($Users)) {
var_dump($Users);
fail('GET_RETURNING_WRONG_DATA');
}
// Check get with limit
$Users = $Database->get('users', 1);
checkQuery('SELECT * FROM users LIMIT 1', 'GET_QUERY_LIMIT_MISMATCH');
// Check get with array limit
$Users = $Database->get('users', array(10, 2));
checkQuery('SELECT * FROM users LIMIT 2 OFFSET 10', 'GET_QUERY_ARRAY_LIMIT_MISMATCH');
// Check get with column(s)
$Users = $Database->get('users', null, 'id');
checkQuery('SELECT id FROM users', 'GET_QUERY_COLUMNS_MISMATCH');
# count() Checks
