PHP Helpers::get_type_size方法代码示例

 /**
  * Parse values in map and add to corresponding table array.
  *
  * @return bool
  * @uses DatabaseMap::$map
  * @uses DatabaseMap::$table_separator
  * @uses DatabaseMap::$from_tables
  * @uses DatabaseMap::$to_tables
  */
 private function getTables()
 {
     $this->Log->write(__METHOD__, Log::LOG_LEVEL_SYSTEM_INFORMATION);
     // input validation
     if (empty($this->map)) {
         $this->Log->write('map is empty', Log::LOG_LEVEL_WARNING);
         return false;
     }
     $this->Log->write('looping through $this->map', Log::LOG_LEVEL_USER, $this->map);
     foreach ($this->map as $from => $to) {
         $this->Log->write('from', Log::LOG_LEVEL_USER, $from);
         $this->Log->write('to', Log::LOG_LEVEL_USER, $to);
         if ($to === 'skip') {
             $this->Log->write('skipping this one', Log::LOG_LEVEL_USER);
             continue;
         } elseif ($to === null || is_null($to) || !Helpers::is_string_ne($to)) {
             $this->Log->write('this is not a field to use', Log::LOG_LEVEL_WARNING, $from . ' => to ' . Helpers::get_type_size($to));
             continue;
         }
         list($from_table, $from_field) = explode($this->table_separator, $from);
         if (Helpers::is_string_ne($from_table)) {
             if (!array_key_exists($from_table, $this->from_tables)) {
                 $this->from_tables[$from_table] = array();
             }
             if (Helpers::is_string_ne($from_field) && !array_search($from_field, $this->from_tables[$from_table])) {
                 $this->from_tables[$from_table][] = $from_field;
             }
         }
         // populate is a value that is used to indicate the value is needed, but the field is not needed
         if ($to !== 'populate' && strstr($to, $this->table_separator)) {
             list($to_table, $to_field) = explode($this->table_separator, $to);
             if (Helpers::is_string_ne($to_table)) {
                 if (!array_key_exists($to_table, $this->to_tables)) {
                     $this->to_tables[$to_table] = array();
                 }
                 if (Helpers::is_string_ne($to_field) && !array_search($to_field, $this->to_tables[$to_table])) {
                     $this->to_tables[$to_table][] = $to_field;
                 }
             }
         }
     }
     $this->Log->write('finished looping through $this->map', Log::LOG_LEVEL_USER);
     return true;
 }

 /**
  * Import a file to MySQL through command line.
  *
  * @param string $file
  * @return bool
  * @todo Make this available for other SQL variants.
  */
 public function importFile($file = '')
 {
     $this->Log->write(__METHOD__, Log::LOG_LEVEL_SYSTEM_INFORMATION);
     // input validation
     if (!Helpers::is_string_ne($file)) {
         $this->Log->write('no file provided', Log::LOG_LEVEL_WARNING, Helpers::get_type_size($file));
         return false;
     }
     if (!is_file($file)) {
         $this->Log->write('file does not exist', Log::LOG_LEVEL_WARNING, $file);
         return false;
     }
     $ext = substr($file, -3);
     if (strtolower($ext) !== 'sql') {
         $this->Log->write('file extension must be sql', Log::LOG_LEVEL_WARNING, $ext);
         return false;
     }
     $command = MYSQL_BIN . 'mysql --verbose -h ' . $this->host . ' -u' . $this->user;
     if (Helpers::is_string_ne($this->pass)) {
         $command .= ' -p\'' . trim($this->pass) . '\'';
     }
     $command .= ' ' . $this->dbname . ' < ' . $file;
     $output = array();
     exec($command, $output, $return_var);
     if ($return_var != 0) {
         $this->Log->write($return_var . ': Failed to import from file', Log::LOG_LEVEL_WARNING, $output);
         return false;
     }
     return true;
 }

 /**
  * Generate PHP string for this table and field.
  *
  * @param array $array Row of results from constant list
  * @return bool|int
  * @uses Db::query()
  * @uses Db::quote()
  */
 protected function generate($array = array())
 {
     $this->Log->write(__METHOD__, Log::LOG_LEVEL_SYSTEM_INFORMATION);
     // input validation
     if (!Helpers::is_array_ne($array)) {
         $this->Log->write('array is invalid', Log::LOG_LEVEL_WARNING, Helpers::get_call_string());
         return false;
     }
     // these fields need to be present in the array
     $fields = array('table_name', 'name_field', 'value_field', 'type');
     $valid = true;
     // check for the existence of each field in the array and break if one of them does not exist
     foreach ($fields as $field) {
         if (!array_key_exists($field, $array)) {
             $valid = false;
             break;
         }
     }
     if (!$valid) {
         $this->Log->write('input invalid', Log::LOG_LEVEL_WARNING);
         return false;
     }
     // assign parameters to variables
     $table = $array['table_name'];
     $field = $array['name_field'];
     $value_field = $array['value_field'];
     $type = $array['type'];
     $prefix = array_key_exists('prefix', $array) ? $array['prefix'] : $table;
     // build SELECT query for field and value
     $sql = 'SELECT ' . $field . ', ' . $value_field . PHP_EOL;
     $sql .= '  FROM ' . $table . PHP_EOL;
     $this->Log->write('generate SQL', Log::LOG_LEVEL_USER, $sql);
     // get rows from table
     $rows = $this->query($sql, array(), 'iterator');
     if (!$rows instanceof DbIterator) {
         $this->Log->write('could not find rows from query', Log::LOG_LEVEL_WARNING);
         return false;
     }
     $this->Log->write('found rows for generate query', Log::LOG_LEVEL_USER);
     // build PHP string with comments to indicate table and field used in generation
     $php = PHP_EOL . '/**' . PHP_EOL;
     $php .= ' * ' . $table . '.' . $field . PHP_EOL;
     $php .= ' */' . PHP_EOL;
     foreach ($rows as $row) {
         if ($row === null || !array_key_exists($field, $row)) {
             continue;
         }
         // prepare constant name (upper case, underscores instead of spaces, no multiple underscores together)
         $val = strtoupper(Helpers::space_to_underscore($prefix . '_' . $row[$field]));
         // add define statement to string
         $php .= 'define(\'' . $val . '\', ' . $this->quote($row[$value_field], $type) . ');' . PHP_EOL;
     }
     $php .= '// END ' . $table . '.' . $field . PHP_EOL . PHP_EOL;
     $this->Log->write('built PHP string with ' . strlen($php) . ' characters', Log::LOG_LEVEL_USER);
     if (!Helpers::is_string_ne($php)) {
         $this->Log->write('There was an issue building the PHP.', Log::LOG_LEVEL_WARNING, Helpers::get_type_size($php));
         return false;
     }
     // append string to global string
     $this->php .= $php;
     return strlen($php);
 }