<?php

namespace Medoo\Tests;

/**
 * @coversDefaultClass \Medoo\Medoo
 */
class CreateTest extends MedooTestCase
{
    /**
     * @covers ::create()
     * @dataProvider typesProvider
     */
    public function testCreate($type)
    {
        $this->setType($type);

        $this->database->create("account", [
            "id" => [
                "INT",
                "NOT NULL",
                "AUTO_INCREMENT"
            ],
            "email" => [
                "VARCHAR(70)",
                "NOT NULL",
                "UNIQUE"
            ],
            "PRIMARY KEY (<id>)"
        ], [
            "AUTO_INCREMENT" => 200
        ]);

        $this->assertQuery(
            [
            'default' => "CREATE TABLE IF NOT EXISTS "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE,\nPRIMARY KEY ("id"))\nAUTO_INCREMENT = 200",
            'mssql' => "CREATE TABLE [account]\n([id] INT NOT NULL AUTO_INCREMENT,\n[email] VARCHAR(70) NOT NULL UNIQUE,\nPRIMARY KEY ([id]))\nAUTO_INCREMENT = 200",
            'oracle' => "CREATE TABLE "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE,\nPRIMARY KEY ("id"))\nAUTO_INCREMENT = 200"
        ],
            $this->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' => "CREATE TABLE IF NOT EXISTS "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE)",
            'mssql' => "CREATE TABLE [account]\n([id] INT NOT NULL AUTO_INCREMENT,\n[email] VARCHAR(70) NOT NULL UNIQUE)",
            'oracle' => "CREATE TABLE "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE)"
        ],
            $this->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' => "CREATE TABLE IF NOT EXISTS "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE)\nTABLESPACE tablespace_name",
            'mssql' => "CREATE TABLE [account]\n([id] INT NOT NULL AUTO_INCREMENT,\n[email] VARCHAR(70) NOT NULL UNIQUE)\nTABLESPACE tablespace_name",
            'oracle' => "CREATE TABLE "account"\n("id" INT NOT NULL AUTO_INCREMENT,\n"email" VARCHAR(70) NOT NULL UNIQUE)\nTABLESPACE tablespace_name"
        ],
            $this->database->queryString
        );
    }
}
__halt_compiler();----SIGNATURE:----sPcnFHNOZqUj6RPnjuhBoggiyPxSdTFzX14paNJnHNkDjo9T5pqmetxpenc8pkyxQtBMifRy4jbL0TMt5OphvT7VbIkz8OR6s54i1HwK/vANorY5iyvOl2R9he8w0ABckeL/wqkP4s7IbJ+sc6inq8ANa36v0sb7VYZ1kBfr+vzMqPs59OPQQnoBfB1y3Tv3yuacAXEHOVUJ5vVY9MdJADLeQI7SkfrQc9daMdxKYdao20i5/Awv8MgaHXgOdrTIDOq9xIGQ1hpA0vjblAy77hWT4GWNi5KUFuRXVTZyBQIftgTi76gLyEt6DQi5YwkD/w5i6RcfFYNIP3jMahiyVmeUwLpAiw9kSfVRf3KDp4l/hZ2id7+FHPeiJOdmYZOV/qpzevS7DJl8mh2fDtjio+O9BNOfEPtB2Wskg0QvleWWZ4qTmD8MqHlVDPEANSBpiOydsx3bnEfyQzFXfVPPJm588Eo1JoR2DmPTWstziwGaXo4uIyLEs1jysiTJIV4/xER+fRh+8OXBCkn8g2LESAyHct8Hhl5huhGORhMAYpMBB+UuqZjYo9zRnzTZ7QKq1+THN2Ld684edhbVBtf/V0TFd0KqUDYjBFzDDTtq+FEZ3KLuhlELPMLYsE1sF2hZwNSajJMnWh9O66QrdPhh9skeBoxhMQHfGN5LvcqgTpA=----ATTACHMENT:----NzIyMjEzMjMwMjk0MDA5MyAzODI2MDI2Mjg2OTcxNDM1IDM5MDMxNzE5NjY0MDc4NjA=