<?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:----h4trEwmQMDp9Upj3GAo5iT7YkmWALpZnAQ9GoQEea+XrXEkJnghdfATn/zLiELvGBGg3f2T/9Ge0qrbN1R8lQaS+v0XjaQgMSUgcbNLpzb3zaUfS6GElfuT3Vrb19u4AK1gnUVcYCcw0VZyazH8bVPGy7/VlkZ8+GqYtjcxxumLEwsPtPgwLr/aVh0cPe4oIh/pzb/EuTZqrx/O/nfrfFDlMdd/CJMZX2bEDoxKIU47ahNmOrnyBVnAOJKFrpMBSa5gWPo+ZfUxw7DUYUJFLKwdW43bgbe8jJFQyiswOSNxALci0e7zJl5EVrJ4nvAKtvs1O+dbyiXAp1IOp4d9K6lYBzhzX2/0u/tXZQygRQlXrperxyReOBfwRkedK1epDmnnFyVziowmoZ9drKPHWBADPMkFNTJRWFoCPgi70+AtFkxzTNAhRVBow086uihzugFpMF9qJ61YmK5bh7Rnre4/9Db8n/8lK1gM35LWVMTH9TWLrQ+9sDtIcZF78QPExfsCzz6Sk2YmS9qzjUy2i8ueQo8W8jVsPM0Imb1zwvqJXRMA28vd4LhD5v/RMzYIxevcf6NyqozrDjH67tptKN0wU6YlII1n+72PqM1dmUFXPnFvpOFMws+bbfUKztaJ9LZL64FWAm8JvNGLaVLXPLGv1RpGnUPHj6pwn5SQmitk=----ATTACHMENT:----NzkwNzQyMzk0MzE5OTEyMSAyOTY0NDIwMzU4MTQ5NjE2IDE0MTI4MDI5MTkzMDE0NzQ=