setType($type); $this->database->create("account", [ "id" => [ "INT", "NOT NULL", "AUTO_INCREMENT" ], "email" => [ "VARCHAR(70)", "NOT NULL", "UNIQUE" ], "PRIMARY KEY ()" ], [ "AUTO_INCREMENT" => 200 ]); $this->assertQuery( [ 'default' => << << <<database->queryString ); } /** * @covers ::create() * @dataProvider typesProvider */ public function testCreateWithStringDefinition($type) { $this->setType($type); $this->database->create("account", [ "id" => "INT NOT NULL AUTO_INCREMENT", "email" => "VARCHAR(70) NOT NULL UNIQUE" ]); $this->assertQuery( [ 'default' => << << <<database->queryString ); } /** * @covers ::create() * @dataProvider typesProvider */ public function testCreateWithSingleOption($type) { $this->setType($type); $this->database->create("account", [ "id" => [ "INT", "NOT NULL", "AUTO_INCREMENT" ], "email" => [ "VARCHAR(70)", "NOT NULL", "UNIQUE" ] ], "TABLESPACE tablespace_name"); $this->assertQuery( [ 'default' => << << <<database->queryString ); } }