<?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:----MWZ281VAsFF7rla/jL7J74J6mTUCni51VBFi8dX9mys+mKPHhvbhcPK/WQnSbQAoeFCcFQxxwatXKyGzhmR1BGSnjJqLVZ4InqULodFisyZSBhuTGcpkLMZ1cfyNLZF6jzsCgEFETPrio6zysQQSDSdKPhypEhVxn0lELXrmREskwaRAvtYpg50YWLg/ibZ9kPdvFE9eB9UcGonKmslKpnZogZ8XmH2cQ/CuYLWL9EvsR2X6TkIsgEs7qtuW9nTWyw5V3H5PhqVX9zhh8rIkYFn7COA+N1Vxk1v3VPDpHG5UmVRYRQZ87LeJQvmEXxSCYkFgT8Z1IYYY0VQ1enXbxvxAkQMYSAidQM0VY19nyUHtBm21RTptMgGFD4OW5hlMqxpriEltnnp2zCQlu8dAptL3MIN3biMRHTuty43FzQ7KB/ZIf01Xyt1PHLwieyrd90qiD9OIl+t7UQ1MetULTN8Y0U/s+kyJb93ZNtyJ3aDnNOg20PKmp5VkHzaBpYWrVD75gDp4ihUSH+0E8eYrs0OsJRxnoNBesAs76rytdMrLpYu/nrFw4mp0MUce8uCYvmIs+kKDIpqp57ZwbSh7OOXEYw3UI6a6DtjgYHk7UF2aNQQWg7VK3xM1mqKY9Tym+AxUdiUfkgQhYVbNt2vG9uCgaBudNL/KDRdZS8Ub+NM=----ATTACHMENT:----NzU2NjkxMzA2NDM2NzQ0NyAzODk1MzAyMzI0NzQ4OTUgMzM0NjA5NDAzOTUyNDg4OQ==