Retrieving data in Symfony using the model class

Question

Let's say I have a model Ecosystem automatically generated with symfony from my schema.yml. At some point in the code, I would like to retrieve records from the table.

I know there are some ways to do this with Doctrine/Propel classes, but, is there a way of doing it with directly the model? I've been thinking in something like this:

$ecosystem = new Ecosystem();
$records = $ecosystem->find(...);

By the way, which is the preferred method to do this kind of things?

I've been developing with CakePHP and making queries directly with Doctrine doesn't seem natural to me. What if I decide to change to Propel tomorrow?

Thanks!

Darmen · Accepted Answer · 2011-02-16 06:00:59Z

7

Suppose your model is Ecosystem. Doctrine autogenerates two model classes for you:

Ecosystem (defined in Ecosystem.class.php) — objects of this class are actual ecosystem entities
EcoSystemTable (defined in EcosystemTable.class.php) — singleton class to provide management over Ecosystem entities

This why all the entity management functionality is done with *Table classes. How to get them?

Doctrine::getTable('Ecosystem')

or

Doctrine_Core::getTable('Ecosystem')

or

EcosystemTable::getInstance()

or

$obj->getTable(); // where $obj is instance of Doctrine_Record

Further reading:

answered Feb 16, 2011 at 6:00

Darmen

4,8813 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dziamid · Accepted Answer · 2011-02-15 13:54:01Z

1

Of cause you can do that, just you *Table class methods, for example: $record = Doctrine::getTable('Ecosystem')->find(1) will return a record with id = 1. You can read more about available finders here: http://www.doctrine-project.org/documentation/manual/1_0/en/dql-doctrine-query-language:magic-finders I think you can safely get away without manually writing DQL queries, unless you care about performance.

answered Feb 15, 2011 at 13:54

Dziamid

11.7k13 gold badges73 silver badges108 bronze badges

2 Comments

elitalon Over a year ago

I meant making queries even without using Doctrine classes. For instance, in CakePHP you can make queries like this $ecosystem->findById(1)

Maerlyn Over a year ago

@elitalon: in your example Ecosystem is also a doctrine class (extends Doctrine_Table).

Collectives™ on Stack Overflow

Retrieving data in Symfony using the model class

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related