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