public function setUp() { parent::setUp(); // Clean up foreach (array('groups', 'users', 'points') as $table) { $dropQuery = new DropTableQuery($table); $dropQuery->IfExists(); $this->assertQuery($dropQuery); } }
public function tearDown() { parent::tearDown(); $q = new DropTableQuery('products'); $q->IfExists(); $this->assertQuery($q); $q = new DropTableQuery('users'); $q->IfExists(); $this->assertQuery($q); }
public function setUp() { parent::setUp(); $q = new DropTableQuery('users'); $q->ifExists(); $this->assertQuery($q); $q = new CreateTableQuery('users'); $q->column('id')->integer()->primary()->autoIncrement(); $q->column('first_name')->varchar(32); $q->column('last_name')->varchar(16); $q->column('age')->tinyint(3)->unsigned()->null(); $q->column('phone')->varchar(24)->null(); $q->column('email')->varchar(128)->notNull(); $q->column('confirmed')->boolean()->default(false); $q->column('types')->set('student', 'teacher'); $q->column('remark')->text(); $q->index(['first_name', 'last_name'])->name('username_idx'); $this->assertQuery($q); }
public function tearDown() { parent::tearDown(); $this->cleanUpTables(); }