we have noticed a problem in the describetable and zend_db_table about primary keys. I'll try to address the problem as soon as possible.

Thanks for understanding :)

-D

hello David Coallier, i've tested your work with the new zend frmk rc2 but it doesn't work, because zend_loader and other mod...
Do you plan to make a new version for the new zend frmk ?

Everything has been fixed in SVN in order to work with RC2 and we are building tests. As soon as those are done, I'll release :)

Thanks for your interest.

this is a fix I have come up with that will allow fetchAll to correctly join dependant parent tables, so that fetchAll in fact bring back all related parent tables as it would in a normal LEFT JOIN query - the ZPDataJoiner can obviously be refined a lot more.

How to: create a class file from the below and include it in your table model class file, then instead of extending your table class with Zend_Db_Table_Abstract extend it with ZPDataJoiner, this will override the fetchAll() of Zend_Db_Table_Abstract.

require_once 'Zend/Db/Table/Abstract.php';

class ZPDataJoiner extends Zend_Db_Table_Abstract{

public function fetchAll($where = null, $order = null, $count = null, $offset = null) {

$select = $this->_db->select();

$select ->from(array('thistable' => $this->_name))
->order($order)
->limit($offset, $count);

if (!is_null($where)) {
$select->where($where);
}

if (!empty($this->_referenceMap)) {


foreach($this->_referenceMap as $ruleName => $specs) {

if (isset($specs['columns']) && isset($specs['refColumns']) && isset($specs['refTableClass'])) {


if(isset($this->parentTables[$specs['refTableClass']])){
// echo $specs['columns'].'<hr>';
$parTable = $this->parentTables[$specs['refTableClass']];
$parAlias = $ruleName;

$select->joinLeft(array($parAlias => $parTable),
'thistable.'.$specs['columns'].' = '.$parAlias.'.'.$specs['refColumns'],array('*'));


}

}

}

}

//$select->toString(); return false;
$stmt = $select->query();


$data = array(
'table' => $this,
'data' => $stmt->fetchAll(Zend_Db::FETCH_ASSOC),
'rowClass' => $this->_rowClass,
'stored' => true
);
//print_r($data['data']);
Zend_Loader::loadClass($this->_rowsetClass);
return new $this->_rowsetClass($data);


}
}

//example model class

class Cities extends ZPDataJoiner{
protected $_primary = array('city_id');
protected $_name = 'cities';
protected $_dependentTables = array('departments','staff');

/*the $parentTables is important array(tableclass=>actual_table_name)
it is used by ZPDataJoiner to resolve relationships
and I was to lazy to write a lookup that could use only the
$_referenceMap
*/
protected $parentTables = array('Countries'=>'countries');

protected $_referenceMap = array(
'CitiesToCountries' => array(
'columns' => 'country_id',
'refTableClass' => 'Countries',
'refColumns' => 'country_id',
'onDelete' => '',
'onUpdate ' => ''
));

}

Link to release: http://dev.agoraproduction.com/zend/releases/Php-0.3.0.tar.gz

As I see you just forgot add function

public function getQuoteIdentifierSymbol()
{
return '`';
}

to php/Mysql.php file.

By default I we got a ".

Anyway thank you, with this fix all works super!! cool!

OK, that was fun - heh.

I've managed to (so far) get simple "fetchAll" working with Zend 1.6.1.

Here's what I had to do:

All changes within db.php

Replace:
/**
* Zend
*/
require_once 'Zend.php';

/**
* Zend_Db_Exception
*/
require_once 'Zend/Db/Exception.php';

With:
/**
* @see Zend_Loader
*/
require_once 'Zend/Loader.php';


Add:
/**
* Use the INT_TYPE, BIGINT_TYPE, and FLOAT_TYPE with the quote() method.
*/
const INT_TYPE = 0;
const BIGINT_TYPE = 1;
const FLOAT_TYPE = 2;

... to the top of the Zend_Db declaration.

Replace:
Zend::loadClass($adapterName);

With:
@Zend_Loader::loadClass($adapterName);


Now I've only been working with this for about 30 minutes, I'm going against MySQL, so I have no idea if there are other gotchas waiting.

But at least I can now have Zend DB in an environment where MySQLi and PDO are not enabled. Thanks! (I hope you confirm/update the code soon.)

Dear David!

Your link http://dev.agoraproduction.com/zend/ isn't opening, can You or someone who downloaded that PHP adapters put it to mirror?

Thank You!