Zend Framework Forum

Zend Framework Forum - Databases http://www.zfforums.com/ Zend_Db, Zend_Db_Adapter, Zend_Db_Profiler, Zend_Db_Select, Zend_Db_Table en Thu, 09 Sep 2010 22:32:03 GMT vBulletin 60 http://www.zfforums.com/images/misc/rss.png Zend Framework Forum - Databases http://www.zfforums.com/ Relationship of other relationship result http://www.zfforums.com/zend-framework-components-13/databases-20/relationship-other-relationship-result-5502.html Wed, 08 Sep 2010 12:31:27 GMT I have a main table "Order" that has depedentTables "Orderitems". And that relationship works well.
But I also have a relationship in each order item row to select Unittype from third table "Set_unittypes".
And I don't get how to make this last relationship work out.

Order_items:

Code:

        protected $_referenceMap = array(

                        'orderitems' => array(

                                        'columns' => array('parent_id'),

                                        'refTableClass' => 'Model_DbTable_Order',

                                        'refColumns'        => array('entity_ID')

                                ),

                        'setunittypes' => array(

                                        'columns' => array('unittype'),

                                        'refTableClass' => 'Model_DbTable_SetUnittypes',

                                        'refColumns'        => array('id')

                                ),        

        );

The setunittypes as Orderitems as depedenttable.

The relationship Order to Order_items work great. But I don't know how I shall connect the Order_items relationship to Unittype for each row.

Code:

                        $order = $this->orderService->GetOrder($get_entity_id);

                        $this->view->order = $order;

                        

                        if ($order) {

                        $order_items = $this->view->order->findDependentRowset('Model_DbTable_Orderitems');

]]> Databases Skatan http://www.zfforums.com/zend-framework-components-13/databases-20/relationship-other-relationship-result-5502.html <![CDATA[Switching between multidb 's]]> http://www.zfforums.com/zend-framework-components-13/databases-20/switching-between-multidb-s-5486.html Wed, 01 Sep 2010 13:54:32 GMT Hi there

Pleas help :-\
How? & Where? do I switch between the multiple databases that I have listed in my Zend_Application config file?

resources.multidb.db1.adapter = "pdo_mysql"
resources.multidb.db1.host = "localhost"
resources.multidb.db1.username = "dba"
resources.multidb.db1.password = "XXXX"
resources.multidb.db1.dbname = "db1"
resources.multidb.db1.default = true

resources.multidb.db2.adapter = "pdo_mysql"
resources.multidb.db2.host = "localhost"
resources.multidb.db2.username = "dba"
resources.multidb.db2.password = "XXXX"
resources.multidb.db2.dbname = "db2"

How? ..do I need to get them into Zend_Regisry somehow?
Where? ...do I do this in my Controller? or my Model? or DB_Table_?

Thank you
Much Appreciated ]]> Databases altergothen http://www.zfforums.com/zend-framework-components-13/databases-20/switching-between-multidb-s-5486.html Question about mapping objects to your database http://www.zfforums.com/zend-framework-components-13/databases-20/question-about-mapping-objects-your-database-5472.html Thu, 26 Aug 2010 18:18:38 GMT Let say I have the following objects Employee (id, name, type, email, department) Department (id, name, building) I have the following tables... Let say I have the following objects
Employee (id, name, type, email, department)
Department (id, name, building)

I have the following tables storing the info
employee (id-int, type-int, email-varchar, department-int)
type (id-int, name-varchar) - lookup table
department (id-int, name-building, building-int)
building (id-int, name-varchar) - lookup table

I would create a domain model for each object(Employee, Department)

I would create a DbTable for each table (DbTable_Employee, DbTable_Department)
First Question: should I create a DbTable for the lookup tables?

Second Question: how should the objectMapper join the data from the different tables?

Thanks ]]> Databases Jay59 http://www.zfforums.com/zend-framework-components-13/databases-20/question-about-mapping-objects-your-database-5472.html Please Help : : Zend_Db_Table_Row_Exception Error http://www.zfforums.com/zend-framework-components-13/databases-20/please-help-zend_db_table_row_exception-error-5329.html Sat, 21 Aug 2010 19:21:33 GMT Hi.. I am a novice PHP programmer and I have no knowledge of the Zend Framework. I run website on a social networking PHP script (based on Zend... Hi..

I am a novice PHP programmer and I have no knowledge of the Zend Framework. I run website on a social networking PHP script (based on Zend Framework) called Social Engine. But I have started getting an error after I installed a third party plugin which enables users to manage music on their profiles. And I am not getting proper service from the plugin developer, so I have come to you guys for help.

I am hereby posting the data from the error log. I know it might be impossible to suggest a solution from viewing an error log alone. But if you direct me in some way, or atleast let me know where to start looking for problems, I would be really really grateful.

Quote:

exception 'Zend_Db_Table_Row_Exception' with message 'Specified column "isdownload" is not in the row' in /home/mysite/public_html/application/libraries/Zend/Db/Table/Row/Abstract.php:197
Stack trace:
#0 /home/mysite/public_html/application/modules/Music/Form/CreateAlbum.php(203): Zend_Db_Table_Row_Abstract->__set('isdownload', '1')
#1 /home/mysite/public_html/application/modules/Music/controllers/AlbumController.php(45): Music_Form_CreateAlbum->saveValues()
#2 /home/mysite/public_html/application/libraries/Zend/Controller/Action.php(513): Music_AlbumController->createAction()
#3 /home/mysite/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('createAction')
#4 /home/mysite/public_html/application/libraries/Zend/Controller/Front.php(946): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#5 /home/mysite/public_html/application/modules/Core/Bootstrap.php(67): Zend_Controller_Front->dispatch()
#6 /home/mysite/public_html/application/libraries/Engine/Application.php(99): Core_Bootstrap->run()
#7 /home/mysite/public_html/application/index.php(173): Engine_Application->run()
#8 /home/mysite/public_html/index.php(15): include('/home/mysite/...')
#9 {main}

If you need any more info, or screenshots, I will b happy to provide..

Hopefully..
Thanks. ]]> Databases punarnava http://www.zfforums.com/zend-framework-components-13/databases-20/please-help-zend_db_table_row_exception-error-5329.html Issues with Sub Queries in ZF http://www.zfforums.com/zend-framework-components-13/databases-20/issues-sub-queries-zf-5303.html Sun, 15 Aug 2010 05:12:50 GMT Hey guys, Just a quick one, im trying to perform a sub query inside a left join statement anyone shed any light on this? ---Quote---... Hey guys,

Just a quick one, im trying to perform a sub query inside a left join statement anyone shed any light on this?

Quote:

INNER JOIN
(SELECT MAX(rvId) AS id FROM recentlyviewed WHERE
rvSessionid = 'qb52hgec8hcd44glu2hp4d8h44' group by rvProductid) idSort
ON
recentlyviewed.rvId = idSort.id

ive converted most of the code to zf syntax already... just this is stumped me. ]]> Databases slyvampy http://www.zfforums.com/zend-framework-components-13/databases-20/issues-sub-queries-zf-5303.html Strange ID problem with Zend_Db_Select joining 3 tables http://www.zfforums.com/zend-framework-components-13/databases-20/strange-id-problem-zend_db_select-joining-3-tables-5300.html Fri, 13 Aug 2010 09:42:42 GMT Can anyone help me work out why I'm not able to extract the classes.id data in the following Zend_Db_Select join query.

I need the class id to allow me to include an 'edit class' link. Problem is the query is outputting an id for each class which is different to classes.id in the database table.

What am I doing wrong?

I have three tables: classes, teacher and day whose structure is as follows:

classes
id [primary key a/i]
classname [varchar]
duration [int]
time [time]
teacher_id [int]
day_id [int]

teacher
id [primary key a/i]
firstname [varchar]
lastname [varchar]

day
id [primary key a/i]
dayname [varchar]

I have written the following Zend_Db_Select query to join the tables:

Code:

public function listteacherClass()

    {

        $db = Zend_Registry::get('db');

        $select = new Zend_Db_Select($db);

        $statement = $select->from(array('t' => 'teacher'),

                                array('c.classname', 'c.duration', 'c.time', 'c.id', 't.firstname', 't.lastname', 'd.dayname'))

                            ->join(array('c' => 'classes'), 'c.teacher_id = t.id')

                            ->join(array('d' => 'day'), 'c.day_id = d.id')

                            ->order(array('d.id ASC', 'c.time ASC'));

        $results = $db->query($statement);

        $rows = $results->fetchAll();

        return $rows;

    }

This query lists the teacher, days and classes data from the three database tables correctly in an array, but ...

It doesn't pull the classes.id data from the classes table. The classes.id it outputs is the same as the day.id data.

If I restrict the above to one join on the teacher and classes tables, then the correct classes.id appears in the array.

Is there something wrong with the syntax of my query that is creating this problem?

Many thanks for any help. This one's tearing my hair out! ]]> Databases beatificboy http://www.zfforums.com/zend-framework-components-13/databases-20/strange-id-problem-zend_db_select-joining-3-tables-5300.html