/** * 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); }
/** * 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; } }
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 }
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; }