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(); }