Ejemplo n.º 1
0
 /**
  * Returns the meta object for this DatabaseObject's class
  *
  * @see DatabaseObjectMeta
  *
  * @return object DatabaseObjectMeta
  */
 public function meta()
 {
     return DatabaseObjectMeta::forClass(get_class($this), $this->_db);
 }
 public function getToMeta()
 {
     return DatabaseObjectMeta::forClass($this->toClass);
 }
Ejemplo n.º 3
0
 /**
  * Used by DatabaseObject::load
  *
  * @param id integer
  * @return CMSNode or null
  */
 public static function factory($id)
 {
     assert(is_int($id));
     $type = null;
     $meta = DatabaseObjectMeta::forClass(__CLASS__);
     $database = $meta->getDatabase();
     $sql = $meta->getSQL('get_type');
     $sth = $database->execute($sql, $id);
     $sth->bindColumn(1, $type);
     $r = $sth->fetch();
     if ($r && isset($type)) {
         $class = self::getTypeClass($type);
         return new $class($type);
     } else {
         return null;
     }
 }
Ejemplo n.º 4
0
 public function testDummy()
 {
     // Test meta object
     $meta = DatabaseObjectMeta::forClass('DBODummy');
     $table = $meta->getTable();
     $key = $meta->getKey();
     $this->assertEqual('DBODummy', $meta->getClass());
     $this->assertEqual('dbodummy', $table);
     $this->assertEqual('dbodummy_id', $key);
     $colMap = $meta->getColumnMap();
     $this->assertEqual($colMap["aDate"], "a_date");
     $this->assertEqual($colMap["aDateTime"], "a_date_time");
     $this->assertEqual($colMap["aTime"], "a_time");
     $this->assertEqual($colMap["mess"], "mess");
     $this->assertEqual($colMap["id"], "dbodummy_id");
     $fieldSet = $meta->getFieldSetSQL();
     $this->assertEqual($fieldSet, implode(', ', array('`a_date`=FROM_UNIXTIME(:a_date)', '`a_date_time`=FROM_UNIXTIME(:a_date_time)', '`a_time`=SEC_TO_TIME(:a_time)', '`mess`=:mess')));
     $pfx = "`{$table}`.";
     $colSQL = $meta->getColumnsSQL();
     $this->assertEqual($colSQL, implode(', ', array("UNIX_TIMESTAMP({$pfx}`a_date`) AS `a_date`", "UNIX_TIMESTAMP({$pfx}`a_date_time`) AS `a_date_time`", "TIME_TO_SEC({$pfx}`a_time`) AS `a_time`", "{$pfx}`mess` AS `mess`")));
     $colSQL = $meta->getColumnsSQL(null, null);
     $this->assertEqual($colSQL, implode(', ', array("UNIX_TIMESTAMP(`a_date`) AS `a_date`", "UNIX_TIMESTAMP(`a_date_time`) AS `a_date_time`", "TIME_TO_SEC(`a_time`) AS `a_time`", "`mess` AS `mess`")));
     $drop = "DROP TABLE IF EXISTS {$table}";
     $create = "CREATE TABLE {$table} (\n  " . implode(",\n  ", DBODummy::$CreateSpec) . "\n)";
     $this->expectExact('perform', $drop);
     $this->expectExact('perform', $create);
     $this->db->perform($drop);
     $this->db->perform($create);
     $dummy = new DBODummy();
     // Create a dummy
     $this->populate($dummy);
     // TODO populate really should be a method on the object or its meta
     $this->expectExact('lock', "LOCK TABLES {$table} WRITE");
     $this->expectExact('prepare', "INSERT INTO `{$table}` SET {$fieldSet}");
     $this->expectExact('execute', json_encode(array(":a_date" => (int) $dummy->aDate, ":a_date_time" => (int) $dummy->aDateTime, ":a_time" => (int) $dummy->aTime, ":mess" => $dummy->mess)));
     $this->expectExact('lastInsertId', 1);
     // The table is virgin
     $this->expectExact('unlock', 'UNLOCK TABLES');
     $dummy->create();
     // Change the dummy and save
     $this->populate($dummy);
     $this->expectExact('prepare', "UPDATE `{$table}` SET {$fieldSet} WHERE `{$key}` = :{$key} LIMIT 1");
     $this->expectExact('execute', json_encode(array(":a_date" => (int) $dummy->aDate, ":a_date_time" => (int) $dummy->aDateTime, ":a_time" => (int) $dummy->aTime, ":mess" => $dummy->mess, ":dbodummy_id" => $dummy->id)));
     $dummy->update();
     // Fetch a dummy
     $dummyId = $dummy->id;
     $dummyData = array($dummy->aDate, $dummy->aDateTime, $dummy->aTime, $dummy->mess);
     $dummy = null;
     $this->expectExact('prepare', "SELECT {$colSQL} FROM `{$table}` WHERE `{$key}` = ? LIMIT 1");
     $this->expectExact('executef', json_encode(array($dummyId)));
     $dummy = DatabaseObject::load('DBODummy', $dummyId);
     $this->assertEqual($dummyId, $dummy->id);
     $this->assertEqual($dummyData[0], $dummy->aDate);
     $this->assertEqual($dummyData[1], $dummy->aDateTime);
     $this->assertEqual($dummyData[2], $dummy->aTime);
     $this->assertEqual($dummyData[3], $dummy->mess);
     // Kill a dummy
     $this->expectExact('prepare', "DELETE FROM `{$table}` WHERE `{$key}` = ?");
     $this->expectExact('executef', json_encode(array($dummyId)));
     $dummy->delete();
     $this->assertEqual(-1, $dummy->id);
     // Delete only clears id
     $this->assertEqual($dummyData[0], $dummy->aDate);
     $this->assertEqual($dummyData[1], $dummy->aDateTime);
     $this->assertEqual($dummyData[2], $dummy->aTime);
     $this->assertEqual($dummyData[3], $dummy->mess);
     // TODO once wipe added, values should be nullifed
     // TODO update a non-existent id should fail
     // TODO fetch non-existent id should fail
 }
Ejemplo n.º 5
0
 public static function loadPath($path)
 {
     $meta = DatabaseObjectMeta::forClass(__CLASS__);
     $database = $meta->getDatabase();
     $sql = $meta->getSQL('id_for_path');
     $sth = $database->execute($sql, $path);
     $r = null;
     if ($sth->rowCount() > 0) {
         $r = $sth->fetch(PDO::FETCH_NUM);
         $r = self::load($r[0]);
     }
     return $r;
 }