Files
yii2/tests/framework/db/mysql/QueryBuilderTest.php
Carsten Brandt 8ba032d147 refactored database tests
- changed test class naming for easier copying and searching of classes
- made base tests abstract and made MySQL an equal citisen in the test
  hierarchie
- added missing db specific test classes
2016-06-20 19:26:43 +02:00

60 lines
1.9 KiB
PHP

<?php
namespace yiiunit\framework\db\mysql;
use yii\db\Schema;
/**
* @group db
* @group mysql
*/
class QueryBuilderTest extends \yiiunit\framework\db\QueryBuilderTest
{
protected $driverName = 'mysql';
/**
* this is not used as a dataprovider for testGetColumnType to speed up the test
* when used as dataprovider every single line will cause a reconnect with the database which is not needed here
*/
public function columnTypes()
{
return array_merge(parent::columnTypes(), [
[
Schema::TYPE_PK . ' AFTER `col_before`',
$this->primaryKey()->after('col_before'),
'int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY AFTER `col_before`'
],
[
Schema::TYPE_PK . ' FIRST',
$this->primaryKey()->first(),
'int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST'
],
[
Schema::TYPE_PK . ' FIRST',
$this->primaryKey()->first()->after('col_before'),
'int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST'
],
[
Schema::TYPE_PK . '(8) AFTER `col_before`',
$this->primaryKey(8)->after('col_before'),
'int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY AFTER `col_before`'
],
[
Schema::TYPE_PK . '(8) FIRST',
$this->primaryKey(8)->first(),
'int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST'
],
[
Schema::TYPE_PK . '(8) FIRST',
$this->primaryKey(8)->first()->after('col_before'),
'int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST'
],
[
Schema::TYPE_PK . " COMMENT 'test' AFTER `col_before`",
$this->primaryKey()->comment('test')->after('col_before'),
"int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'test' AFTER `col_before`"
],
]);
}
}