1:   2:   3:   4:   5:   6:   7:   8:   9:  10:  11:  12:  13:  14:  15:  16:  17:  18:  19:  20:  21:  22:  23:  24:  25:  26:  27:  28:  29:  30:  31:  32:  33:  34:  35:  36:  37:  38:  39:  40:  41:  42:  43:  44:  45:  46:  47:  48:  49:  50:  51:  52:  53:  54:  55:  56:  57:  58:  59:  60:  61:  62:  63:  64:  65:  66:  67:  68:  69:  70:  71:  72:  73:  74:  75:  76:  77:  78:  79:  80:  81:  82:  83:  84:  85:  86:  87:  88:  89:  90:  91:  92:  93:  94:  95:  96:  97:  98:  99: 100: 

<?php

    namespace Inlm\SchemaGenerator\Dumpers;

    use CzProject\SqlGenerator;
    use CzProject\SqlSchema;
    use Inlm\SchemaGenerator\Diffs;
    use Inlm\SchemaGenerator\IDumper;
    use Nette\Utils\Strings;


    class SqlDumper extends AbstractSqlDumper
    {
        const FLAT = 0;
        const YEAR = 1;
        const YEAR_MONTH = 2;

        /** @var string */
        private $directory;

        /** @var int */
        private $outputStructure = self::FLAT;


        /**
         * @param  string
         */
        public function __construct($directory)
        {
            $this->directory = $directory;
        }


        /**
         * @param  int
         * @return static
         */
        public function setOutputStructure($outputStructure)
        {
            $this->outputStructure = $outputStructure;
            return $this;
        }


        /**
         * @return static
         * @deprecated
         */
        public function setDeepStructure()
        {
            $this->outputStructure = self::YEAR_MONTH;
            return $this;
        }


        /**
         * @return void
         */
        public function end()
        {
            $this->checkIfStarted();

            if (!$this->sqlDocument->isEmpty()) {
                $driver = $this->prepareDriver($this->databaseType);
                $directory = $this->directory;

                if ($this->outputStructure === self::YEAR_MONTH) {
                    $directory .= '/' . date('Y/m');

                } elseif ($this->outputStructure === self::YEAR) {
                    $directory .= '/' . date('Y');

                } elseif ($this->outputStructure !== self::FLAT) {
                    throw new \Inlm\SchemaGenerator\InvalidArgumentException("Invalid output structure '{$this->outputStructure}'.");
                }

                $description = '';

                if (isset($this->description)) {
                    $description = Strings::webalize($this->description);

                    if ($description !== '') {
                        $description = '-' . $description;
                    }
                }

                $path = $directory . '/' . date('Y-m-d-His') . $description . '.sql';

                if (file_exists($path)) {
                    throw new \Inlm\SchemaGenerator\FileSystemException("File '$path' already exists.");
                }

                @mkdir($directory, 0777, TRUE);
                file_put_contents($path, $this->getHeaderBlock() . $this->sqlDocument->toSql($driver));
            }

            $this->stop();
        }
    }