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');