/**
* Load configuration from a file and set it to the EZPDO manager.
*
* If config file is not specified, it tries to load config.xml first.
* Then config.ini if config.xml not found from the current directory.
*
* @param string $file
* @return bool
*/
function epLoadConfig($file = false)
{
// use default config file?
if (!$file) {
// try config.ini first
if (file_exists($file = 'config.ini')) {
$file = 'config.ini';
} else {
if (file_exists('config.xml')) {
$file = 'config.xml';
} else {
return false;
}
}
} else {
// check if the specified config file exists
if (!file_exists($file)) {
return false;
}
}
// load the config file
include_once EP_SRC_BASE . '/epConfig.php';
if (!($cfg =& epConfig::load($file))) {
return false;
}
// set config to the EZPDO manager
return epManager::instance()->setConfig($cfg);
}
function initPersistance()
{
$m = epManager::instance();
$m->setConfigOption("compiled_dir", "" . $this->config['Paths']['cache'] . $this->config['Models']['cached']);
$m->setConfigOption("source_dirs", "" . $this->config['Models']['folder']);
$m->setConfigOption("log_file", "" . $this->config['Paths']['logs'] . "ezpdo.log");
foreach ($this->config['Persistance'] as $k => $v) {
$m->setConfigOption($k, $v);
}
$this->db = $m;
}
/**
* Dump queries
* @return void
*/
function dumpQueries()
{
$m = epManager::instance();
$db_queries = $m->getQueries();
foreach ($db_queries as $db => $queries) {
echo "*** database: {$db} (" . count($queries) . ")***\n";
if ($queries) {
// remove "\n"
$s = '';
foreach ($queries as &$q) {
$q = str_replace("\n", '', $q);
$s .= $q . "\n";
}
echo $s;
}
}
}
/**
* Returns one or more EnumeratedValue instances as a multi-valued array.
* If the $enumType parameter is given, the result set will be limited
* to the named scope. If the $enumValue parameter is given, only matching
* instance(s) will be returned.
*
* @param string enumType The enum type (e.g. PublicationState, EventStatus, ProgramType, ResourceType)
* @param string value A specific enum value
* @return Zero or more EnumeratedValues as an array keyed by enum type
*/
function fetch($enumType = null, $enumValue = null)
{
global $logger;
$logger->debug(get_class($this) . "::fetch({$enumType}, {$enumValue})");
$pdo = epManager::instance();
$result = array();
if ($enumType == null) {
$enumeratedValues = $pdo->find('from EnumeratedValue order by oid');
} else {
$enumeratedValues = $pdo->find('from EnumeratedValue where scope = ? order by oid', $enumType);
}
foreach ($enumeratedValues as $value) {
if ($enumValue == null || $enumValue == $value->getValue()) {
$result[$value->getScope()][] = $value;
}
}
return $result;
}
/**
* Initialize categories
*/
function initCategories()
{
// define initial setup values
$categories = array("Genre" => array(array("name" => "Theater", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Readings and Talks", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Cinema's Legacy", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Film", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Comedy", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Food", "subtitle" => "", "description" => "", "pubState" => "Published")), "Audience" => array(array("name" => "Family", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Teen", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Toddler", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Public", "subtitle" => "", "description" => "", "pubState" => "Published")), "Series" => array(array("name" => "Sunset Concerts", "subtitle" => "", "description" => "", "pubState" => "Published"), array("name" => "Cinema Z", "subtitle" => "", "description" => "", "pubState" => "Published")));
$pdo = epManager::instance();
// cleanup/setup enumerations
foreach ($categories as $class => $elements) {
$filter = $pdo->create($class);
$values = $pdo->find($filter);
foreach ($values as $item) {
$pdo->delete($item);
}
for ($index = 0; $index < count($elements); $index++) {
$category = $pdo->create($class);
$category->setName($elements[$index]["name"]);
$category->setSubtitle($elements[$index]["subtitle"]);
$category->setDescription($elements[$index]["description"]);
$category->setPubState($elements[$index]["pubState"]);
$pdo->commit($category);
}
}
}
function setUp()
{
$this->pdo = epManager::instance();
}
/**
* Constructor
* @param string|epCache & $cache The cache to be plugged in
* @param array|epConfig $config The configuration
*/
public function __construct($cache, $config = null)
{
// call parent to set configuration
parent::__construct($config);
// is input a string?
if (is_string($cache)) {
$this->cache =& $this->_cache();
} else {
if ($cache instanceof epCache) {
$this->cache =& $cache;
} else {
throw new epExceptionCacheObject("Unrecognized parameter");
}
}
// get the runtime manager
self::$em = epManager::instance();
}
/**
* Constructor
* @param $name
* @param epQueryAliasManager &$am
*/
public function __construct($name)
{
// call parent to set name and child key ('Name')
parent::__construct($name, 'Name');
// set up the EZPDO runtime manager if not already
if (!self::$em) {
self::$em =& epManager::instance();
}
// initialize class2alias lookup array
$this->class2alias = array();
}
/**
* Implement {@link epSingleton} interface
* Forcefully destroy old instance (only used for tests).
* After reset(), {@link instance()} returns a new instance.
*/
public static function destroy()
{
self::$instance = null;
}
/**
* Return the PublicationState PDO for the given value
* @access private
* @param string The PublicationSatte value
* @return PublicationState PDO
*/
private function fetchPubState($value)
{
global $logger;
$logger->debug(get_class($this) . "::fetchPubState({$value})");
if (is_string($value)) {
$pdo = epManager::instance();
$template = $pdo->create('PublicationState');
$template->setValue($value);
$pubStates = $pdo->find($template);
if (count($pubStates) > 0) {
return $pubStates[0];
} else {
$logger->debug("No PublicationStates matched value: {$value}");
return false;
}
}
}
/**
* Implements magic method __wakeup()
* Recovers cached manager and class map
*/
public function __wakeup()
{
// recover manager when waking up
$this->ep_m = epManager::instance();
// recover class map
$this->ep_cm = $this->ep_m->getMap(get_class($this->ep_object));
// cache this object in manager (important for flush)
$this->ep_m->cache($this, true);
// true: force replace
}
<?php
require_once dirname(__FILE__) . '/../../library/ezpdo/ezpdo_runtime.php';
require_once dirname(__FILE__) . '/../_orm/orm.inc.php';
epLoadConfig(dirname(__FILE__) . '/config.ini');
try {
$myManager = epManager::instance();
} catch (PDOException $e) {
echo $e->getMessage();
}
*
* @author Oak Nauhygon <*****@*****.**>
* @version $Revision: 991 $ $Date: 2006-05-31 15:24:19 -0400 (Wed, 31 May 2006) $
* @package ezpdo_ex
* @subpackage ezpdo_ex.bookstore
*/
/**
* Need EZPDO runtime API
*/
include_once dirname(__FILE__) . '/../../ezpdo_runtime.php';
/**
* This script prints out all authors and books stored in database
* and can be called by other scripts to print all records.
*/
// get the persistence manager
$m = epManager::instance();
// get all authors
$authors = $m->get('Author');
// print all authors
if ($authors) {
foreach ($authors as $a) {
//echo $a->toString() . "\n";
echo $a;
echo "\n";
}
} else {
echo "No author is found.\n";
}
// get all books
$books = $m->get('Book');
// print all books
/**
* Returns the timestamp for the first scheduled start time
*
* @access private
* @return int Timestamp of first scheduled startTime (min)
*/
private function getFirstScheduled()
{
global $logger;
$logger->debug(get_class($this) . "::getFirstScheduled()");
$epm = epManager::instance();
$first = $epm->find("min(startTime) from Schedule where startTime > 0");
$logger->debug("First scheduled timestamp: " . $first);
return $first;
}
/**
* Converts the last record set into epObject object(s) with class map
* @param epClassMap $cm the class map for the conversion
* @param array (of integers) object ids to be excluded
* @return false|array (of epObject)
* @throws epExceptionDbObject
*/
protected function _rs2obj($cm, $oids_ex = null)
{
// !!!important!!! with a large db, the list of oid to be excluded
// $oids_ex can grown really large and can significantly slow down
// queries. so it is suppressed in the select statement and moved
// to this method to process.
// get epManager instance and cache it
if (!$this->ep_m) {
$this->ep_m =& epManager::instance();
}
// get the class name
$class = $cm->getName();
// get all mapped vars
if (!($fms = $cm->getAllFields())) {
return self::$false;
}
// reset counter and return value
$ret = array();
// go through reach record
$okay = $this->db->rsRestart();
while ($okay) {
// get oid column
$oid = $this->db->rsGetCol($cn = $cm->getOidColumn(), $class . '.' . $cn);
// exclude it?
if ($oids_ex && in_array($oid, $oids_ex)) {
// next row
$okay = $this->db->rsNext();
// exclude it
continue;
}
// call epManager to create an instance (false: no caching; false: no event dispatching)
if (!($o =& $this->ep_m->_create($class, false, false))) {
// next row
$okay = $this->db->rsNext();
continue;
}
// go through each field
foreach ($fms as $fname => $fm) {
// skip non-primivite field
if (!$fm->isPrimitive()) {
continue;
}
// get var value and set to object
$val = $this->db->rsGetCol($cn = $fm->getColumnName(), $class . '.' . $cn);
// set value to var (true: no dirty flag change)
$o->epSet($fm->getName(), $this->_castType($val, $fm->getType()), true);
}
// set oid
$o->epSetObjectId($oid);
// collect return result
$ret[] = $o;
// next row
$okay = $this->db->rsNext();
}
return $ret;
}
/**
* Copies the updated values of the bean to the pdo
* object, then commits the pdo object to update the
* address.
*
* @access private
* @param bean Address Bean
* @return pdo updated Address PDO
*/
private function updateAddress($bean)
{
global $logger;
$logger->debug(get_class($this) . "::updateAddress({$bean})");
$logger->debug("Address is of class: " . get_class($bean));
$logger->debug("Before update the address id: " . $bean->getOid());
$epm = epManager::instance();
$pdo = null;
if ($bean->getOid() > 0) {
$pdo = $this->fetchAddressById($bean->getOid());
$logger->debug("Oid > 0: " . $pdo->getOid());
} else {
if (trim($bean->getStreet()) != NULL) {
$pdo = $epm->create('Address');
$logger->debug("No oid, but valid street: " . $bean->getStreet());
} else {
return null;
// This is not a valid address
}
}
$pdo = BeanUtil::copyBean($bean, $pdo);
$pdo = $epm->commit($pdo);
$logger->debug("After update the address id: " . $pdo->getOid());
return $pdo;
}
/**
* Returns the PDO object for the given scope.
*/
private function fetch($scope)
{
global $logger;
$logger->debug(get_class($this) . "::fetch({$scope})");
$epm = epManager::instance();
$pdos = $epm->find('from Announcement where scope = ?', $scope);
return $pdos[0];
}
function _testQuery56()
{
$this->assertTrue($m = epManager::instance());
$this->assertTrue($os = $m->query("from eptAuthor as a where a.name in (?) order by name", array('Richard Helm', 'Erich Gamma')));
$this->assertTrue(count($os) == 2);
$this->assertTrue($os[0]->name == 'Erich Gamma');
$this->assertTrue($os[1]->name == 'Richard Helm');
return true;
}
/**
* Returns a PDO instance for the target Category. Currently
* all subclasses of Category are managed in the same PDO table.
* Therefore, the scope is not actually needed. Adding it to the
* API however will allow for the separation of these subsclasses
* if required in the future.
*
* @param string scope The category type (e.g. Audience, Genre)
* @param int $oid The oid of the target category
* @return pdo The Category PDO
*/
private function fetchCategoryById($scope, $oid)
{
$pdo = epManager::instance();
$cat = $pdo->get('Category', $oid);
if ($cat === FALSE) {
trigger_error("Invalid Category: {$oid} not found", E_USER_ERROR);
return;
}
if (is_array($cat)) {
trigger_error("Invalid Category: ambiguous results for {$oid}", E_USER_ERROR);
return;
}
return $cat;
}
/**
* Constructor
* @param epQueryNode $root the root node of the syntax tree
* @param string &$query the query string
* @param array $args the arguments for the query
* @param boolean whether to print out debugging info
* @throws epExceptionQueryBuilder
*/
public function __construct(epQueryNode &$root, &$query = '', $args = array(), $verbose = false)
{
// get runtime manager
$this->em = epManager::instance();
// get root and arguments for the query
$this->root =& $root;
$this->args =& $args;
$this->query =& $query;
$this->verbose = $verbose;
}
/**
* setup before each test
* @param string $dbal (adodb or peardb)
* @param string $db (mysql, pgsql, or sqlite)
*/
function _setUp($dbal, $db)
{
// destroy singletons
$this->_destroy();
// load config.xml for compiler
include_once EP_SRC_BASE . '/epConfig.php';
$cfg =& epConfig::load(dirname(__FILE__) . "/config.xml");
$this->assertTrue(!empty($cfg));
// set dblib
$cfg->set('db_lib', $dbal);
// make input/output path absolute (fixed)
$source_dirs = EP_TESTS . '/classes/';
$cfg->set('source_dirs', $source_dirs);
// set compiled dir
switch ($db) {
case 'mysql':
$compiled_file = $cfg->get('test/compiled_file/mysql');
$default_dsn = $cfg->get('test/default_dsn/mysql');
break;
case 'pgsql':
$compiled_file = $cfg->get('test/compiled_file/pgsql');
$default_dsn = $cfg->get('test/default_dsn/pgsql');
$cfg->set('default_oid_column', 'eoid');
// oid is special in pgsql
break;
case 'sqlite':
$compiled_file = $cfg->get('test/compiled_file/sqlite/' . $dbal);
$default_dsn = $cfg->get('test/default_dsn/sqlite/' . $dbal);
break;
}
$cfg->set('compiled_file', $compiled_file);
$cfg->set('default_dsn', $default_dsn);
// force compile so default_dsn gets into class map
$cfg->set('force_compile', true);
// get epManager instance
include_once EP_SRC_RUNTIME . '/epManager.php';
$this->m = null;
// force a new instance
$this->m =& epManager::instance();
$this->assertTrue($this->m);
// set config to manager
$this->assertTrue($this->m->setConfig($cfg));
// assert source_dirs is correct
$this->assertTrue($this->m->getConfigOption('source_dirs') === $source_dirs);
// assert source_dirs is correct
$this->assertTrue($this->m->getConfigOption('compiled_file') === $compiled_file);
// assert default_dsn is correct
$this->assertTrue($this->m->getConfigOption('default_dsn') === $default_dsn);
}
/**
* Check if the object is valid
*
* Implements the {@link epValidateable} interface
* @param bool $recursive (ignored)
* @return true|string (error msg)
*/
public function isValid($recursive)
{
// array to hold errors
$errors = array();
// get the manager
if (!($m = epManager::instance())) {
$errors[] = 'cannot get manager';
return $errors;
}
//
// check object a
//
if (!$this->class_a) {
$errors[] = 'class_a is empty';
}
if (!$this->oid_a) {
$errors[] = 'oid_a is zero (invalid oid) or empty';
}
if (!$this->var_a) {
$errors[] = 'var_a is empty';
}
// check if object a
if ($this->class_a) {
// check if class a exists
if (!($cm = $m->getClassMap($this->class_a))) {
$errors[] = 'class_a [' . $this->class_a . '] no longer exists';
} else {
// check if var_a exists
if ($this->var_a) {
if (!$cm->getField($this->var_a)) {
$errors[] = 'var_a [' . $this->var_a . '] no longer exists in class_a [' . $this->class_a . ']';
}
}
// check if object_a exists
if (!($obj_a = $m->get($this->class_a, $this->oid_a))) {
$errors[] = 'object of class_a [' . $this->class_a . '] with oid [' . $this->oid_a . '] no longer exists';
}
}
}
//
// check object b
//
if (!$this->base_b) {
$errors[] = 'base_b is empty';
} else {
// check if base_b exists
if (!($cm = $m->getClassMap($this->base_b))) {
$errors[] = 'base_b [' . $this->base_b . '] no longer exists';
}
}
if (!$this->class_b) {
$errors[] = 'class_b is empty';
}
if (!$this->oid_b) {
$errors[] = 'oid_b is zero (invalid oid) or empty';
}
// check if object b
if ($this->class_b) {
// check if class b exists
if (!($cm = $m->getClassMap($this->class_b))) {
$errors[] = 'class_b [' . $this->class_b . '] no longer exists';
} else {
// check if object_b exists
if (!($obj_b = $m->get($this->class_b, $this->oid_b))) {
$errors[] = 'object of class_b [' . $this->class_b . '] with oid [' . $this->oid_b . '] no longer exists';
}
}
}
// either return array of errors or true
return $errors ? $errors : true;
}
