PHP MatchaModel::tableIdProperties方法代码示例

 /**
  * function SenchaModel($fileModel):
  * This method will create the table and fields if does not exist in the database
  * also this is the brain of the micro ORM.
  *
  * This method needs rework, this method has to be the brain!
  *
  * @param string $fileModel 'App.model.Example'
  * @param bool $force for to read the sencha model file (skip the MatchaMemory)
  * @return bool success
  *
  */
 public static function __SenchaModel($fileModel, $force = false)
 {
     try {
         self::$fileModel = $fileModel;
         // skip this entire routine if freeze option is true
         if (self::$__freeze) {
             self::$__senchaModel = self::__getSenchaModel($fileModel);
             return true;
         }
         self::$__senchaModel = array();
         // check the difference in dates of the Sencha model file and the stored Sencha model on the server memory,
         // if there are equal go ahead and load the model from memory and quit the procedure
         if (!$force && self::__getFileModifyDate($fileModel) == MatchaMemory::__getSenchaModelLastChange($fileModel)) {
             self::$__senchaModel = MatchaMemory::__getModelFromMemory($fileModel);
             return true;
         }
         // get the model of the table from the sencha .js file
         self::$__senchaModel = self::__getSenchaModel($fileModel);
         if (!self::$__senchaModel['fields']) {
             return false;
         }
         // get model fields
         $modelFields = (array) self::$__senchaModel['fields'];
         // Copy the table ID from the idProperty if the idProperty is undefined use "id" instead.
         self::$tableId = isset(self::$__senchaModel['idProperty']) ? self::$__senchaModel['idProperty'] : 'id';
         //id properties
         $tableIdIndex = MatchaUtils::__recursiveArraySearch(self::$tableId, $modelFields);
         self::$tableIdProperties = $modelFields[$tableIdIndex];
         // check if the table property is an array, if not return the array is a table string.
         $table = (string) (is_array(self::$__senchaModel['table']) ? self::$__senchaModel['table']['name'] : self::$__senchaModel['table']);
         // verify the existence of the table if it does not exist create it
         $recordSet = self::$__conn->query("SHOW TABLES LIKE '" . $table . "';");
         if (isset($recordSet)) {
             self::__createTable($table);
         }
         // if id property is not set in sencha model look for propertyId.
         if ($modelFields[$tableIdIndex] === false) {
             unset($modelFields[$tableIdIndex]);
         }
         // unset the fields that will noe be store int the database
         foreach ($modelFields as $key => $field) {
             if (isset($field['store']) && $field['store'] === false || isset($field['persist']) && $field['persist'] === false) {
                 unset($modelFields[$key]);
             }
         }
         // get the table column information and remove the id column
         $tableColumns = self::$__conn->query("SHOW FULL COLUMNS IN " . $table . ";")->fetchAll(PDO::FETCH_ASSOC);
         unset($tableColumns[MatchaUtils::__recursiveArraySearch(self::$tableId, $tableColumns)]);
         $columnsTableNames = array();
         $columnsSenchaNames = array();
         // get all the column names of each model (Sencha and Database-table)
         foreach ($tableColumns as $column) {
             $columnsTableNames[] = $column['Field'];
         }
         foreach ($modelFields as $column) {
             $columnsSenchaNames[] = isset($column['mapping']) ? $column['mapping'] : $column['name'];
         }
         // get all the column that are not present in the database-table
         $differentCreateColumns = array_diff($columnsSenchaNames, $columnsTableNames);
         $differentDropColumns = array_diff($columnsTableNames, $columnsSenchaNames);
         // unset the id field from both arrays
         unset($differentCreateColumns[MatchaUtils::__recursiveArraySearch('id', $differentCreateColumns)]);
         unset($modelFields[MatchaUtils::__recursiveArraySearch('id', $modelFields)]);
         // deal with the sencha triggers
         self::__diffTriggers(self::$__senchaModel);
         $indexArray = self::__getIndexFields(self::$__senchaModel);
         // check if the table has columns, if not create them.
         if (count($tableColumns) <= 1) {
             self::__createAllColumns($modelFields);
             // add data - if the model has data defined.
             if (isset(self::$__senchaModel['table']['data'])) {
                 $rec = self::$__conn->prepare('SELECT * FROM ' . $table);
                 $rec->execute();
                 if ($rec->rowCount() <= 0) {
                     MatchaModel::__setSenchaModelData(MatchaModel::$__senchaModel['table']['data']);
                 }
             }
             return true;
         } elseif (count($differentCreateColumns) || count($differentDropColumns)) {
             // add columns to the table
             foreach ($differentCreateColumns as $column) {
                 self::__createColumn($modelFields[MatchaUtils::__recursiveArraySearch($column, $modelFields)], $table, in_array($column, $indexArray));
             }
             // remove columns from the table
             foreach ($differentDropColumns as $column) {
                 self::__dropColumn($column);
             }
         } else {
//.........这里部分代码省略.........