Ejemplo n.º 1
0
 /**
  * Escape a column value, in order to insert it into a SQL query
  *
  * @param $value            mixed
  * @param $double_backquote boolean
  * @return string
  */
 public static function escape($value, $double_backquote = false)
 {
     // no is_numeric(), as sql numeric search make numeric conversion of string fields
     // ie WHERE NAME = 500 instead of '500' will give you '500' and '500L', which is not correct
     if (is_integer($value) || is_float($value)) {
         $string_value = strval($value);
     } elseif (is_bool($value)) {
         $string_value = $value ? '1' : '0';
     } elseif ($value === null) {
         $string_value = 'NULL';
     } elseif (is_array($value)) {
         $do = false;
         $string_value = '';
         foreach ($value as $object_value) {
             if ($object_value !== null) {
                 if ($do) {
                     $string_value .= ',';
                 }
                 $string_value .= str_replace(DQ, DQ . DQ, $object_value);
                 $do = true;
             }
         }
         $string_value = substr($string_value, 2);
     } elseif ($value instanceof Date_Time) {
         $string_value = DQ . ($value->toISO() ?: '0000-00-00 00:00:00') . DQ;
     } else {
         $string_value = DQ . Dao::current()->escapeString($value) . DQ;
     }
     return $double_backquote ? str_replace(BS, BS . BS, $string_value) : $string_value;
 }
Ejemplo n.º 2
0
 /**
  * @param $source   Reflection_Source the PHP source file object
  * @param $compiler PHP\Compiler the main compiler
  * @return boolean false as compilation do never change source
  */
 public function compile(Reflection_Source $source, PHP\Compiler $compiler = null)
 {
     $dao = Dao::current();
     if ($dao instanceof Link) {
         //$dao->begin();
         //$tables = [];
         /*
         // drop empty tables
         foreach ($dao->getConnection()->getTables() as $table_name) {
         	if ($dao->query('SELECT COUNT(*) FROM ' . BQ . $table_name . BQ)->fetch_row()[0]) {
         		$tables[$table_name] = true;
         	}
         	else {
         		@$dao->query('DROP TABLE IF EXISTS ' . BQ . $table_name . BQ);
         	}
         }
         */
         /*
         // update tables structures
         foreach ($source->getClasses() as $class) {
         	if (isset($tables[$dao->storeNameOf($class->name)])) {
         		$dao->createStorage($class->name);
         	}
         }
         */
         //$dao->commit();
     }
     return false;
 }
Ejemplo n.º 3
0
 /**
  * Builds a Table object using a Php class definition
  *
  * This takes care of excluded properties, so buildLinkTable() should be called
  * before buildClassTable().
  *
  * @param $class      Reflection_Class
  * @param $more_field Column
  * @return Table
  */
 private function buildClassTable(Reflection_Class $class, $more_field)
 {
     $table_name = Dao::current()->storeNameOf($class->name);
     $table = new Table($table_name);
     if (!in_array('id', $this->excluded_properties)) {
         $table->addColumn(Column::buildId());
     }
     if ($more_field) {
         $table->addColumn($more_field);
     }
     if ($class->isAbstract()) {
         $table->addColumn(new Column('class', 'varchar(255)'));
     } else {
         foreach ($class->accessProperties() as $property) {
             if (!in_array($property->name, $this->excluded_properties)) {
                 $type = $property->getType();
                 if (($type->isMultipleString() || !$type->isMultiple()) && !$property->isStatic()) {
                     $table->addColumn(Column::buildProperty($property));
                     if ($property->getAnnotation('link')->value == Link_Annotation::OBJECT && $property->getAnnotation('store')->value != 'string') {
                         $class_name = $property->getType()->asString();
                         $this->dependencies_context[$class_name] = $class_name;
                         $table->addForeignKey(Foreign_Key::buildProperty($table_name, $property));
                         $table->addIndex(Index::buildLink($property->getAnnotation('storage')->value));
                     }
                 }
             }
         }
     }
     return $table;
 }
Ejemplo n.º 4
0
 /**
  * Build SQL tables list, based on calculated joins for where array properties paths
  *
  * @return string
  */
 public function build()
 {
     $tables = BQ . Dao::current()->storeNameOf($this->class_name) . BQ . SP . 't0';
     foreach ($this->joins->getJoins() as $join) {
         if ($join) {
             $tables .= $join->toSql();
         }
     }
     return $tables;
 }
Ejemplo n.º 5
0
 /**
  * @param $configuration array
  */
 public function __construct($configuration)
 {
     if (isset($configuration[self::LINKS_LIST])) {
         self::$list = $configuration[self::LINKS_LIST];
         unset($configuration[self::LINKS_LIST]);
     }
     $class_name = $configuration[Configuration::CLASS_NAME];
     unset($configuration[Configuration::CLASS_NAME]);
     Dao::current(new $class_name($configuration));
 }
Ejemplo n.º 6
0
 /**
  * @param $last_time integer compile only files modified since this time
  */
 public function compile($last_time = 0)
 {
     set_time_limit(900);
     clearstatcache();
     $cache_dir = $this->getCacheDir();
     // create data set for dependencies, check for dependencies for deleted files
     Dao::createStorage(Dependency::class);
     Dao::begin();
     if (isset($_GET['Z'])) {
         $link = Dao::current();
         if ($link instanceof Link) {
             $link->query('TRUNCATE TABLE `dependencies`');
         }
     }
     foreach (Dao::select(Dependency::class, ['file_name' => Func::distinct()]) as $file_dependency) {
         /** @var $file_dependency List_Row */
         $file_name = $file_dependency->getValue('file_name');
         if (!file_exists($file_name)) {
             foreach (Dao::search(['file_name' => $file_name], Dependency::class) as $dependency) {
                 /** @var $dependency Dependency */
                 Dao::delete($dependency);
                 foreach (Dao::search(['dependency_name' => $dependency->class_name], Dependency::class) as $sub_dependency) {
                     /** @var $sub_dependency Dependency */
                     Dao::delete($sub_dependency);
                 }
             }
         }
     }
     Dao::commit();
     $this->sources = array_merge($this->more_sources, $this->getFilesToCompile($last_time));
     $first_group = true;
     foreach ($this->compilers as $compilers) {
         /** @var $compilers ICompiler[] */
         $saved_sources = $this->sources;
         while ($this->sources) {
             // get source and update dependencies
             foreach ($this->sources as $source) {
                 /** @var Reflection_Source $source inspector bug */
                 /** @noinspection PhpParamsInspection inspector bug (a Dependency is an object) */
                 (new Set())->replace($source->getDependencies(true), Dependency::class, ['file_name' => $source->file_name]);
             }
             do {
                 $added = [];
                 // ask each compiler for adding of compiled files, until they have nothing to add
                 foreach ($compilers as $compiler) {
                     if ($compiler instanceof Needs_Main) {
                         $compiler->setMainController($this->main_controller);
                     }
                     $added = array_merge($added, $compiler->moreSourcesToCompile($this->sources));
                 }
                 foreach ($added as $source) {
                     /** @var Reflection_Source $source inspector bug */
                     /** @noinspection PhpParamsInspection inspector bug (a Dependency is an object) */
                     (new Set())->replace($source->getDependencies(true), Dependency::class, ['file_name' => $source->file_name]);
                     $this->sources[$source->file_name] = $source;
                 }
                 if (count($compilers) == 1) {
                     $added = [];
                 }
             } while ($added);
             $saved_sources = array_merge($saved_sources, $this->sources);
             // fill in sources cache
             $sources_count = count($this->sources);
             foreach ($this->sources as $source) {
                 foreach (array_keys($source->getClasses()) as $class_name) {
                     $this->sources_cache[$class_name] = $source;
                 }
                 if ($sources_count > self::MAX_OPENED_SOURCES) {
                     $source->free(self::SOURCES_FREE);
                 }
             }
             // compile sources
             foreach ($this->sources as $source) {
                 $this->compileSource($source, $compilers, $cache_dir, $first_group, $sources_count);
             }
             $this->sources = $this->more_sources;
             $this->more_sources = [];
             foreach ($this->sources as $source) {
                 if (!isset($saved_sources[$source->file_name])) {
                     $saved_sources[$source->file_name] = $source;
                 }
             }
         }
         $this->sources = $saved_sources;
         $first_group = false;
     }
     $this->sources = null;
 }
Ejemplo n.º 7
0
 /**
  * Build a SQL UPDATE query
  *
  * @param $class Reflection_Class | string
  * @param $write array the data to write for each column : key is the column name
  * @param $id    integer|integer[]
  * @return string
  */
 public static function buildUpdate($class, $write, $id)
 {
     $sql_update = 'UPDATE ' . BQ . Dao::current()->storeNameOf($class) . BQ . LF . 'SET ';
     $i = 0;
     foreach ($write as $key => $value) {
         if ($i++) {
             $sql_update .= ', ';
         }
         if ($key != 'id' && substr($key, 0, 3) != 'id_') {
             $key = BQ . $key . BQ;
         }
         $sql_update .= $key . ' = ' . Value::escape($value);
     }
     $sql_update .= LF . 'WHERE';
     if (is_numeric($id)) {
         $sql_update .= ' id = ' . $id;
     } elseif (is_array($id)) {
         $first = true;
         foreach ($id as $key => $value) {
             $sql_update .= $first ? $first = false : ' AND';
             $sql_update .= ' ' . $key . ' = ' . $value;
         }
     } else {
         trigger_error("id must be an integer of an array of integer values", E_USER_ERROR);
     }
     return $sql_update;
 }
Ejemplo n.º 8
0
 /**
  * Constructs a new Select object, read to use, with all its context data
  *
  * @param $class_name string The name of the main business class to start from
  * @param $columns    string[] If not set, the columns names will be taken from the query result
  * @param $link       Link If not set, the default link will be Dao::current()
  */
 public function __construct($class_name = null, $columns = null, Link $link = null)
 {
     $this->link = $link ?: Dao::current();
     $this->class_name = $class_name;
     if (isset($columns)) {
         $this->columns = $columns;
         $this->columns[] = 'id';
     }
 }
Ejemplo n.º 9
0
 /**
  * Construct the SQL WHERE section of a query
  *
  * Supported columns naming forms are :
  * column_name : column_name must correspond to a property of class
  * column.foreign_column : column must be a property of class, foreign_column must be a property of column's var class
  *
  * @param $class_name  string base object class name
  * @param $where_array array|Func\Where where array expression, indices are columns names
  * @param $sql_link    Link
  * @param $joins       Joins
  */
 public function __construct($class_name, $where_array = null, Link $sql_link = null, Joins $joins = null)
 {
     $this->joins = $joins ? $joins : new Joins($class_name);
     $this->sql_link = $sql_link ? $sql_link : Dao::current();
     $this->where_array = $where_array;
 }
Ejemplo n.º 10
0
 /**
  * The constructor can be called with a specific data link.
  * The default data link will be Dao::current()
  * This works only for Identifier_Map data links
  *
  * @param $dao Identifier_Map
  */
 public function __construct(Identifier_Map $dao = null)
 {
     $this->dao = isset($dao) ? $dao : Dao::current();
 }
Ejemplo n.º 11
0
 /**
  * Generic getter for mapped objects
  *
  * @param $stored   object[] actual value of the property (will be returned if not null)
  * @param $object   object the parent object
  * @param $property string|Reflection_Property the source property (or name) for map reading
  * @return Component[]
  */
 public static function &getMap(&$stored, $object, $property)
 {
     if (!(self::$ignore || isset($stored))) {
         if (Dao::getObjectIdentifier($object)) {
             if (!$property instanceof Reflection_Property) {
                 $property = new Reflection_Property(get_class($object), $property);
             }
             $dao = ($dao = $property->getAnnotation('dao')->value) ? Dao::get($dao) : Dao::current();
             $class_name = get_class($object);
             $linked_class_name = (new Link_Class($class_name))->getLinkedClassName();
             if ($linked_class_name) {
                 $object = (new Link_Class($class_name))->getCompositeProperty()->getValue($object);
                 $class_name = $linked_class_name;
             }
             $element_type = $property->getType()->getElementType();
             $is_abstract = $element_type->asReflectionClass()->isAbstract();
             $sort = $is_abstract ? Dao::sort(['id']) : Dao::sort();
             $stored = $dao->search([$class_name . '->' . $property->name => $object], $element_type->asString(), [$sort]);
             if ($is_abstract) {
                 $sort->sortObjects($stored);
             }
         } else {
             $stored = [];
         }
     }
     return $stored;
 }
Ejemplo n.º 12
0
 /**
  * @param $data_link Identifier_Map
  */
 public function __construct(Identifier_Map $data_link = null)
 {
     $this->data_link = $data_link ?: Dao::current();
 }
Ejemplo n.º 13
0
 /**
  * The constructor initialises logged information for a call on script beginning.
  *
  * @param $uri       string
  * @param $arguments array
  * @param $form      array
  * @param $files     array
  */
 public function __construct($uri, $arguments = null, $form = null, $files = null)
 {
     if (!isset($this->start)) {
         $this->duration = microtime(true);
         $this->start = new Date_Time();
     }
     if (!isset($this->process_id)) {
         $this->process_id = getmypid();
     }
     if (!isset($this->mysql_thread_id)) {
         $dao = Dao::current();
         if ($dao instanceof Link) {
             $this->mysql_thread_id = $dao->getConnection()->thread_id;
         }
     }
     if (!isset($this->session_id)) {
         $this->session_id = session_id();
     }
     if (isset($arguments) && !isset($this->arguments)) {
         $this->arguments = $this->serialize($arguments);
     }
     if (isset($uri) && !isset($this->uri)) {
         $this->uri = $uri;
     }
     if (isset($files) && !isset($this->files)) {
         $this->files = $this->serialize($files);
     }
     if (isset($form) && !isset($this->form)) {
         $this->form = $this->serialize($form);
     }
 }