public function testCreateTable()
{
$db = $this->getDb();
$adapter = new SqliteTypeAdapter($db);
$db->expects($this->exactly(3))->method('execute')->withConsecutive([$this->equalTo('CREATE TABLE "foo_bar" (' . 'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ' . 'foo TEXT(255) NOT NULL DEFAULT "bar")')], [$this->equalTo('CREATE INDEX "foo_bar_foo_id" ON "foo_bar" (foo, id)')], [$this->equalTo('CREATE UNIQUE INDEX "foo_bar_foo" ON "foo_bar" (foo)')]);
$def = new \Jivoo\Data\DefinitionBuilder();
$def->addAutoIncrementId();
$def->foo = DataType::string(255, false, "bar");
$def->addKey(['foo', 'id']);
$def->addUnique('foo');
$adapter->createTable('FooBar', $def);
}
public function testCreateTable()
{
$db = $this->getDb();
$adapter = new PostgresqlTypeAdapter($db);
$db->expects($this->exactly(3))->method('execute')->withConsecutive([$this->equalTo('CREATE TABLE {FooBar} (' . 'id serial NOT NULL, ' . 'foo varchar(255) NOT NULL DEFAULT "bar", ' . 'CONSTRAINT "foo_bar_PRIMARY" PRIMARY KEY (id))')], [$this->equalTo('CREATE INDEX "foo_bar_foo_id" ON {FooBar} (foo, id)')], [$this->equalTo('CREATE UNIQUE INDEX "foo_bar_foo" ON {FooBar} (foo)')]);
$def = new \Jivoo\Data\DefinitionBuilder();
$def->addAutoIncrementId();
$def->foo = DataType::string(255, false, "bar");
$def->addKey(['foo', 'id']);
$def->addUnique('foo');
$adapter->createTable('FooBar', $def);
}
public function testCreateTable()
{
$db = $this->getDb();
$adapter = new MysqlTypeAdapter($db);
$db->expects($this->once())->method('execute')->with($this->equalTo('CREATE TABLE `foo_bar` (' . 'id INT UNSIGNED NOT NULL AUTO_INCREMENT, ' . 'foo VARCHAR(255) NOT NULL DEFAULT "bar", ' . 'PRIMARY KEY (id), ' . 'INDEX (foo, id), ' . 'UNIQUE (foo)' . ') CHARACTER SET utf8'));
$def = new \Jivoo\Data\DefinitionBuilder();
$def->addAutoIncrementId();
$def->foo = DataType::string(255, false, "bar");
$def->addKey(['foo', 'id']);
$def->addUnique('foo');
$adapter->createTable('FooBar', $def);
}