Example #1
0
 /**
  * Constructor.
  *
  * @param string $table
  */
 public function __construct($table)
 {
     //set a table_desc object with the fields for a table
     $rs = SqlTools::sqlQuery("desc {$table}");
     if ($rs) {
         $this->table['name'] = $table;
         while ($field = mysql_fetch_object($rs, 'FieldDesc')) {
             $field->Decorate();
             $this->fields[$field->Field] = $field;
         }
         $this->field_keys = array_keys($this->fields);
         $this->nb_fields = count($this->field_keys);
         self::$tables[$table] = $this;
     } else {
         throw new Exception('Table ' . $table . ' may not exist ' . mysql_error());
     }
 }
Example #2
0
File: Morm.php Project: anicet/morm
 /**
  * getForeignValues 
  *
  * only used by the scaffolding, should probably be removed or extended to 
  * make it more generic 
  * 
  * @throws Exception if field is not a foreign key
  * @param mixed $field 
  * @param array $foreign_fields (can be null))
  * @param mixed $conditions 
  * @return array
  */
 public function getForeignValues($field, $foreign_fields = NULL, $conditions = NULL)
 {
     if ($this->isForeignKey($field)) {
         if (!isset($this->_foreign_values[$field])) {
             $select = is_null($foreign_fields) ? '*' : '`' . implode('`,`', $foreign_fields) . '`';
             $conditions = is_null($conditions) ? '' : $conditions;
             $sql = "select " . $select . " from `" . $this->getForeignTable($field) . "` " . $conditions;
             $rs = SqlTools::sqlQuery($sql);
             $foreign_values = array();
             while ($line = mysql_fetch_assoc($rs)) {
                 $foreign_values[] = $line;
             }
             $this->_foreign_values[$field] = $foreign_values;
         }
         return $this->_foreign_values[$field];
     } else {
         throw new Exception($field . ' is not a foreign key in table ' . $this->_table);
     }
 }
Example #3
0
 /**
  * @todo cache the result
  * @param boolean $with_limit
  * @return integer
  */
 public function get_count($with_limit = false)
 {
     $limit_stmt = $with_limit ? SqlBuilder::order_by($this->order, $this->order_dir) . SqlBuilder::limit($this->offset, $this->limit) : '';
     $rs = SqlTools::sqlQuery("SELECT count(1)\n                        \nFROM " . SqlBuilder::from($this->get_from_tables()) . SqlBuilder::joins($this->joins, $this->getJoinType()) . SqlBuilder::where($this->where, $this->sql_where) . $limit_stmt);
     if ($rs) {
         return (int) mysql_result($rs, 0);
     } else {
         throw new Exception("Fatal error:" . mysql_error());
     }
 }
Example #4
0
 public function delete()
 {
     $position = $this->position;
     if (parent::delete()) {
         $sql = "update `" . $this->_table . "` set position = position - 1 where position > " . $position;
         if (SqlTools::sqlQuery($sql)) {
             return true;
         }
         return false;
     }
 }
Example #5
0
 public function testFormatSqlToolsWithArrayNoFake()
 {
     $result = mysql_fetch_array(SqlTools::sqlQuery('SELECT ? + ?', array(40, 1)));
     $this->assertEqual(41, $result[0]);
 }