class.arConverter.php

Go to the documentation of this file.

<?php
require_once(dirname(__FILE__) . '/../class.arFieldList.php');

class arConverter
{
    const REGEX = "/([a-z]*)\\(([0-9]*)\\)/us";
    protected static $field_map = array(
        'varchar' => arField::FIELD_TYPE_TEXT,
        'char' => arField::FIELD_TYPE_TEXT,
        'int' => arField::FIELD_TYPE_INTEGER,
        'tinyint' => arField::FIELD_TYPE_INTEGER,
        'smallint' => arField::FIELD_TYPE_INTEGER,
        'mediumint' => arField::FIELD_TYPE_INTEGER,
        'bigint' => arField::FIELD_TYPE_INTEGER,
    );
    protected static $length_map = array(
        arField::FIELD_TYPE_TEXT => false,
        arField::FIELD_TYPE_DATE => false,
        arField::FIELD_TYPE_TIME => false,
        arField::FIELD_TYPE_TIMESTAMP => false,
        arField::FIELD_TYPE_CLOB => false,
        arField::FIELD_TYPE_FLOAT => false,
        arField::FIELD_TYPE_INTEGER => array(
            11 => 4,
            4 => 1,
        )
    );
    protected $table_name = '';
    protected $class_name = '';
    protected $structure = array();
    protected $ids = array();


    public function __construct($table_name, $class_name)
    {
        $this->setClassName($class_name);
        $this->setTableName($table_name);
        $this->readStructure();
    }


    public function readStructure()
    {
        $sql = 'DESCRIBE ' . $this->getTableName();
        $res = self::getDB()->query($sql);
        while ($data = self::getDB()->fetchObject($res)) {
            $this->addStructure($data);
        }
    }


    public function downloadClassFile()
    {
        $header = "<?php
require_once('./Services/ActiveRecord/class.ActiveRecord.php');

class {CLASS_NAME} extends ActiveRecord {

        static function returnDbTableName() {
                return '{TABLE_NAME}';
        }

        public function getConnectorContainerName() {
                return '{TABLE_NAME}';
        }
";
        $txt = str_replace('{CLASS_NAME}', $this->getClassName(), $header);
        $txt = str_replace('{TABLE_NAME}', $this->getTableName(), $txt);
        $all_members = '';
        foreach ($this->getStructure() as $str) {
            $member = "/**
         * @var {DECLARATION}
         *\n";
            foreach ($this->returnAttributesForField($str) as $name => $value) {
                $member .= '     * @con_' . $name . ' ' . $value . "\n";
            }

            $member .= "*/
        protected \${FIELD_NAME};

        ";

            $member = str_replace('{FIELD_NAME}', $str->Field, $member);
            $member = str_replace('{DECLARATION}', ' ', $member);

            $all_members .= $member;
        }
        $txt = $txt . $all_members . '
}

?>';

        //              echo '<pre>' . print_r(, 1) . '</pre>';

        header('Content-type: application/x-httpd-php');
        header("Content-Disposition: attachment; filename=\"class." . $this->getClassName() . ".php\"");
        echo $txt;
        exit;
    }


    protected function returnAttributesForField(stdClass $field)
    {
        $attributes = array();
        $attributes[arFieldList::HAS_FIELD] = 'true';
        $attributes[arFieldList::FIELDTYPE] = self::lookupFieldType($field->Type);
        $attributes[arFieldList::LENGTH] = self::lookupFieldLength($field->Type);

        if ($field->Null == 'NO') {
            $attributes[arFieldList::IS_NOTNULL] = 'true';
        }

        if ($field->Key == 'PRI') {
            $attributes[arFieldList::IS_PRIMARY] = 'true';
        }

        return $attributes;
    }


    protected static function lookupFieldType($string)
    {
        preg_match(self::REGEX, $string, $matches);

        return self::$field_map[$matches[1]];
    }


    protected static function lookupFieldLength($string)
    {
        $field_type = self::lookupFieldType($string);

        preg_match(self::REGEX, $string, $matches);

        if (self::$length_map[$field_type][$matches[2]]) {
            return self::$length_map[$field_type][$matches[2]];
        } else {
            return $matches[2];
        }
    }


    public static function getDB()
    {
        global $DIC;
        $ilDB = $DIC['ilDB'];

        return $ilDB;
    }


    public function setTableName($table_name)
    {
        $this->table_name = $table_name;
    }


    public function getTableName()
    {
        return $this->table_name;
    }


    public function setStructure($structure)
    {
        $this->structure = $structure;
    }


    public function getStructure()
    {
        return $this->structure;
    }


    public function addStructure(stdClass $structure)
    {
        if (!in_array($structure->Field, $this->ids)) {
            $this->structure[] = $structure;
            $this->ids[] = $structure->Field;
        }
    }


    public function setClassName($class_name)
    {
        $this->class_name = $class_name;
    }


    public function getClassName()
    {
        return $this->class_name;
    }
}