public static function setUpBeforeClass()
{
self::$module = new \Codeception\Module\Db(make_container());
self::$module->_setConfig(self::$config);
self::$module->_initialize();
$sqlite = self::$module->driver;
$sqlite->cleanup();
$sql = file_get_contents(\Codeception\Configuration::dataDir() . '/dumps/sqlite.sql');
$sql = preg_replace('%/\\*(?:(?!\\*/).)*\\*/%s', "", $sql);
$sql = explode("\n", $sql);
$sqlite->load($sql);
}
public function setUp()
{
self::$database = ':memory:';
db::connect(array('database' => self::$database, 'type' => 'sqlite'));
// create a dummy user table, which we can use for our tests
db::query('
CREATE TABLE "users" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE,
"username" TEXT UNIQUE ON CONFLICT FAIL NOT NULL,
"fname" TEXT,
"lname" TEXT,
"password" TEXT NOT NULL,
"email" TEXT NOT NULL
);
');
// insert some silly dummy data
db::insert('users', array('username' => 'john', 'fname' => 'John', 'lname' => 'Lennon', 'email' => '*****@*****.**', 'password' => 'beatles'));
db::insert('users', array('username' => 'paul', 'fname' => 'Paul', 'lname' => 'McCartney', 'email' => '*****@*****.**', 'password' => 'beatles'));
db::insert('users', array('username' => 'george', 'fname' => 'George', 'lname' => 'Harrison', 'email' => '*****@*****.**', 'password' => 'beatles'));
}
public function dbTest()
{
$test = new DbTest(Application::param('package_name'));
$test->run();
return $test->passed();
}
