zDbAccess Class Reference
[Custom Database Access without Magic Methods]

Inheritance diagram for zDbAccess:

[legend]

Collaboration diagram for zDbAccess:

[legend]

Public Member Functions
	zDbAccess ($connAlias, $tableName)
	__construct ($connAlias, $tableName)
	Constructs Table level Objects.
Private Member Functions
	colList ($conAlias, $driver)
	Bind's Proper driver, and connects through it.

---

Detailed Description

dbAccess Class builds a table Object dynamically. without using static ORM Maps. it uses teh real column names as the column alias name. and as there is no orm map assiciated wit it it doesn't uses any validation filters. you need to load dbAccess module to use it.
You cant use any magic method that comes from zOrm_magic like findCol() or findColByOp() etc.. However yo can use all non-magic methods that comes from zOrm_nomagic and its parents.
you need to pass a table name with which you want to connect and pass the connection name e.g. Connection file name by using that it will connect.
you can even create dynamic Connection files on the fly. take a look at the zCDE Class/Module. If you need magic-method support use zDynOrm Class Instead.

Show Source

  $this->load->module('dbAccess');
  //code this in your Controller to load the module
  //You can also code load_module('dbAccess');
  $stdObj = new zDbAccess('conAliasName', 'student');
  //$stdObj = new zDbAccess('conAliasName', 'tableName');
  $stdObj->find('std_name');//$stdObj->find('col_name');

Definition at line 65 of file dbaccess.php.

---

Constructor & Destructor Documentation

zDbAccess::__construct( string $connAlias, string $tableName )

Constructs Table level Objects.

Parameters:

	$connAlias	Connection file name
	$tableName	Table name to which to connect.

Definition at line 75 of file dbaccess.php.

References zOrm_core::$connAlias, colList(), zOrm_core::init(), and perror().

Show Source

                                              {
    $path = ZIGROOT.DRS.Z_DIR_PROJECTS.DRS.Z_PROJECT_DIR.DRS.ZIGSETTINGSDIR.DRS.Z_DIR_ETC_CONF.DRS.$connAlias.".con.ini.php";
    if(!file_exists($path)){
      perror('<code>zigmoyd.dynamicOrm.init</code><br />Failed to parse the connection file '.$connAlias.' as  the file doesn\'t exist');
      exit;
    }
    if(!defined('ZIGORM_Q_SELECT')){define('ZIGORM_Q_SELECT', 's');}
    if(!defined('ZIGORM_Q_INSERT')){define('ZIGORM_Q_INSERT', 'i');}
    if(!defined('ZIGORM_Q_UPDATE')){define('ZIGORM_Q_UPDATE', 'u');}
    if(!defined('ZIGORM_Q_REMOVE')){define('ZIGORM_Q_REMOVE', 'r');}
    if(!defined('ZIGORM_Q_SQL')){define('ZIGORM_Q_SQL', 'q');}
    if(!defined('ZIGORM_Q_TRUNCATE')){define('ZIGORM_Q_TRUNCATE', 't');}
    if(!defined('ZIGORM_NO_FLUSH')){define('ZIGORM_NO_FLUSH', false);}
    if(!defined('ZIGORM_FLUSH')){define('ZIGORM_FLUSH', true);}
    if(!defined('ZIGORM_NO_QUOTE'))define('ZIGORM_NO_QUOTE', false);
    if(!defined('ZIGORM_QUOTE'))define('ZIGORM_QUOTE', true);
    if(!defined('ZIGORM_Q_JOIN')){define('ZIGORM_Q_JOIN', 'j');}
    if(!defined('ZIGORM_Q_AUTOJOIN')){define('ZIGORM_Q_AUTOJOIN', 'aj');}
    if(!defined('ZIGORM_JOIN_CROSS'))define('ZIGORM_JOIN_CROSS', 'jc');
    if(!defined('ZIGORM_JOIN_LEFT'))define('ZIGORM_JOIN_LEFT', 'jl');
    if(!defined('ZIGORM_JOIN_RIGHT'))define('ZIGORM_JOIN_RIGHT', 'jr');
    if(!defined('ZIGORM_JOIN_FULL'))define('ZIGORM_JOIN_FULL', 'jf');
    if(!defined('ZIGORM_JOIN_INNER'))define('ZIGORM_JOIN_INNER', 'ji');
    if(!defined('ZIGORM_JOIN_NATURAL'))define('ZIGORM_JOIN_NATURAL', 'jn');
    if(!defined('ZIGORM_OP_EQUALS'))define('ZIGORM_OP_EQUALS', '=');
    if(!defined('ZIGORM_OP_GREATER'))define('ZIGORM_OP_GREATER', '>');
    if(!defined('ZIGORM_OP_LESS'))define('ZIGORM_OP_LESS', '<');
    if(!defined('ZIGORM_OP_GREATER_EQUALS'))define('ZIGORM_OP_GREATER_EQUALS', '>=');
    if(!defined('ZIGORM_OP_LESS_EQUALS'))define('ZIGORM_OP_LESS_EQUALS', '<=');
    if(!defined('ZIGORM_OP_NOT_EQUALS'))define('ZIGORM_OP_NOT_EQUALS', '<>');
    $conData = parse_ini_file($path);
    $this->realTableName = $tableName;
    $this->tableAlias = $tableName;
    $this->connAlias = $connAlias;
    $this->__struct = new stdClass();
    $this->__struct->alias = $tableName;
    $this->__struct->Attributes = array();
    foreach($this->colList($connAlias, $conData['driver']) as $colName){
      $this->__struct->Attributes[$colName] = new stdClass();
      $this->__struct->Attributes[$colName]->alias = $colName;
      $this->__struct->Attributes[$colName]->permission = 'writable';
    }
    $this->init();
  }

Here is the call graph for this function:

Top 

---

Member Function Documentation

zDbAccess::zDbAccess( string $connAlias, string $tableName )

Definition at line 66 of file dbaccess.php.

References zOrm_core::$connAlias, and zCore::__construct().

Show Source

                                            {
    $this->__construct($connAlias, $tableName);
  }

Here is the call graph for this function:

Top 

zDbAccess::colList( string $conAlias, string $driver ) [private]

Bind's Proper driver, and connects through it.

For internal use only.

Definition at line 124 of file dbaccess.php.

References $__ZigOrm, zOrm_core::$driver, $GLOBALS, connections, zLogger::debug(), zLogger::error(), and perror().

Referenced by __construct().

Show Source

                                      {
    switch(trim($driver)){
      case 'mysql':
          zLogger::debug("Using Orm driver mysql", 'orm.'.$this->realTableName);
          include_once(ZIGROOT.DRS.MOD_KEY_NAME_EXPLICIT.DRS.'orm'.DRS.'driver'.DRS.'mysql.php');
          $GLOBALS['__zigmoyd__Orm_drv'] = new OrmDriver_mysql();
          $GLOBALS['__zigmoyd__Orm_drv']->connAlias($conAlias);
          if(!$GLOBALS['__zigmoyd__Orm_drv']->connect()){
            perror("<code>zigmoyd.dynamicOrm.core.execute</code><br />Failed To Connect $this->connAlias");
            return false;
          }
          return $GLOBALS['__zigmoyd__Orm_drv']->listCols($this->realTableName);
        break;
      default:
        zLogger::error("Using Invalid Driver ".$__ZigOrm->connections[$this->conn_alias]->driver, 'orm.'.$this->__table_name);
        perror('Invalid Driver '.$__ZigOrm->connections[$this->conn_alias]->driver." seleced");
    }
  }

Here is the call graph for this function:

Top 

---

The documentation for this class was generated from the following file:

• dbaccess.php