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';
                        $attributes[arFieldList::IS_UNIQUE] = '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 $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;
        }
}
 
?>