ZF-300: Zend_Db_Table: map SQL datatypes to PHP native datatypes

Issue Type: New Feature Created: 2006-08-02T16:55:18.000+0000 Last Updated: 2012-08-31T09:13:02.000+0000 Status: Postponed Fix version(s): Reporter: Marc Bennewitz (GIATA mbH) (mben) Assignee: Ralph Schindler (ralph) Tags: - Zend_Db_Table

Related issues: - ZF-1457



Tabe definition: id int(10)
name varchar(255) pass varchar(255) pass_hash_id language_id smallint(5)

on use: $this->_data = $this->find($id);

the php data types can be: $this->id : int $this->name : string $this->pass : string $this->pass_hash_id : int $this->language_id : int

But i don't now whether php can ask all databases for the data types



Posted by Bill Karwin (bkarwin) on 2006-11-13T15:22:37.000+0000

Changing fix version to 0.8.0.

Posted by Bill Karwin (bkarwin) on 2007-01-02T19:13:34.000+0000

Hi Marc, I am taking a look at this issue report. I am not understanding what your request is. PHP does not support distinct datatypes corresponding to the different SQL datatypes. What behavior are you asking for, that is different from the behavior today?

Posted by Bill Karwin (bkarwin) on 2007-01-05T17:06:23.000+0000

Recategorize as Zend_Db_Table component.

Posted by Marc Bennewitz (GIATA mbH) (mben) on 2007-01-30T16:10:34.000+0000

Sorry my english is't the best.

If I write a object using Zend_Db_Table i can define which columns have which sql data types. than on get the data from database with e.g. "$this->find($id)" Zend_Db_Table can automatic cast the sql data types to php

e.g. int, smallint ... can cast to integer on php. On now these are string values.

Posted by Bill Karwin (bkarwin) on 2007-02-16T17:41:57.000+0000

Hi Marc, thank you for your explanation. We may have time to implement this in Zend Framework 0.9.

Posted by Wil Sinclair (wil) on 2008-03-25T20:43:54.000+0000

Please categorize/fix as needed.

Posted by Wil Sinclair (wil) on 2008-04-18T13:11:50.000+0000

This doesn't appear to have been fixed in 1.5.0. Please update if this is not correct.

Posted by Wil Sinclair (wil) on 2008-12-04T13:17:29.000+0000

Reassigning to Ralph since he's the new maintainer of Zend_Db

Posted by Ralph Schindler (ralph) on 2009-01-09T10:28:33.000+0000

Should this be done at the Zend_Db_Table level or perhaps a feature of Zend_Db_Adapter? ALso, should this be an opt-in feature? It seems like explicit casting of every property in a result set might incur quite a cost.


Posted by Marc Bennewitz (GIATA mbH) (mben) on 2009-01-09T11:43:02.000+0000

The table definition information are needed for this. Therefore it must be done in Zend_Db_Table.

Posted by Ralph Schindler (ralph) on 2009-08-27T15:57:21.000+0000

After discussing with several people, it seems like this issue would require several major archtectual changes to be done correctly. I'd like to do this for ZF 2.0, and will be put on the 2.0 roadmap

Posted by Thomas Weidner (thomas) on 2010-03-21T10:31:56.000+0000

Reassigned to component maintainer

Have you found an issue?

See the Overview section for more details.


© 2006-2018 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.