function checkQuery($expect, $exitkey)
{
global $Database;
if (empty($Database)) {
return false;
}
$LastQuery = $Database->getLastQuery();
if ($expect !== $LastQuery) {
echo "Mismatched query string:\n";
var_dump($LastQuery);
fail($exitkey);
}
}
// Check tableExists & rawQuery
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');
