Comments on DragonBe's PHP blog: Zend Framework data models

This is a bad implementation and I don't sugge...

2011-12-02T03:22:46.954+01:00

This is a bad implementation and I don't suggest anyone use it

You are calling findDependentRowset twice (for contacts and addresses) for every row in the rowset. This is very slow...

Even worse, if you have a many to one relationship (e.g. many users assigned to one address) then you would end up running the same query multiple times.

Why not just do this:

1. Fetch all users

2. Get all the user IDs in the users rowset (you could extend Zend_Db_Table_Rowset to add this function)

3. Get all the contacts in 1 query. e.g. $contactTable->find($userIds);

4. Get all the addresses in 1 query. e.g. $addressTable->find($userIds);

Then all you have is 3 queries which gets exactly the same data.

You could also create a rowset class for addresses and contacts to add a function like getByUser so you can return a subset just for 1 user

If you find that you need a particular model globa...

2011-10-11T12:58:55.708+02:00

If you find that you need a particular model globally throughout your application, you can tell CodeIgniter to auto-load it during system initialization. This is done by opening the application/config/autoload.php file and adding the model to the autoload array. I hope my post will be helpful with respect to some marketing solutions

You can find some helpful articles about Zend Fram...

2011-09-25T19:49:26.403+02:00

You can find some helpful articles about Zend Framework here http://plutov.by/tag/zf

Well, so much for comprehending well-written docum...

2011-06-30T17:43:12.043+02:00

Well, so much for comprehending well-written documentation. For those as dim as me at times, this worked:

sudo svn checkout https://svn2.hosted-projects.com/in2it/datamodels/tags/step_1

This is the simple example I've been seeking! ...

2011-06-30T17:38:16.383+02:00

This is the simple example I've been seeking!

Is there an easier way to obtain the four data models, mappers and table gateways? The svn asks for a username and password.

Thanks!

Why didnt you show us the Mapper_Abstract? You def...

2011-06-13T17:32:05.828+02:00

Why didnt you show us the Mapper_Abstract? You define the set_mapper function but provide no code. This post seems to be missing a lot of information

I found you have noted each step in a different ma...

2011-05-19T06:58:38.528+02:00

I found you have noted each step in a different manner and i like the conversation you made on these topic.You definitely put new spin on a subject thats been written about years.I enjoyed reading your blogs.

A very nice tutorial about the data models, I have...

2011-02-16T11:12:02.785+01:00

A very nice tutorial about the data models, I have been testing this also but could not get it to waork as i wanted

Warning. dont use "findDependentRowset" ...

2011-02-16T11:05:37.610+01:00

Warning. dont use "findDependentRowset" in this manner:
Use joins

http://stackoverflow.com/questions/356778/php-query-single-value-per-iteration-or-fetch-all-at-start-and-retrieve-from-ar

I am satisfied with your blog. Your post is dear. ...

2011-01-12T13:19:08.177+01:00

I am satisfied with your blog. Your post is dear. Thanks for sharing your precious comprehension with me.

I would like a clarification on your following com...

2011-01-11T13:39:06.232+01:00

I would like a clarification on your following comment:

"I agree you have a point there, populate and toArray are methods that should reside in the mapper class....The reason I had them in my model is that I wanted to populate my model with data (from any source) and represent my model as an array."

The "populating of models from any source and representing model as array" can be accomplished even if the toArray and Populate functions are moved to the Mapper class, right? I am not thinking this through correctly?

BTW, for other who had the class not found error, you probably named your mapper folder "mapper" instead of "mappers". I made that mistake because that is how the folder is named in the svn upload.

Thanks a zillion for the awsome article Michaelangelo!

ZF_Mapper

very informatory tutorial.

2010-12-10T11:09:22.323+01:00

very informatory tutorial.

Very nice and helpful tutorial. Helped me much bec...

2010-12-09T22:54:49.436+01:00

Very nice and helpful tutorial. Helped me much because of the populate and toArray-methods. Thanks a lot.

Hi, the information you provide is very informativ...

2010-12-01T15:21:35.997+01:00

Hi, the information you provide is very informative and I would like to say that the php based application is also easy to use and they are very user friendly. Please keep share the information.

Thanks Jatin, you the man.

2010-11-14T19:00:18.298+01:00

Thanks Jatin, you the man.

Awesome article! I have gradually become fan of yo...

2010-11-10T12:49:41.303+01:00

Awesome article! I have gradually become fan of your article and would like to suggest putting some new updates to make it more effective.

Hello, interesting posting. But what about n:m rel...

2010-10-27T08:10:49.373+02:00

Hello,
interesting posting. But what about n:m relations?

@Teklab I faced the similar problem and fixed it...

2010-10-08T14:28:57.767+02:00

@Teklab

I faced the similar problem and fixed it with the help of BootStrap.php.

You will have to modify BootStrap.php to this :-

class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
protected function _initAutoload()
{
$autoloader = new Zend_Application_Module_Autoloader(array (
'namespace' => 'Default',
'basePath' => APPLICATION_PATH,
));

$autoloader->addResourceType('mappers', 'models/Mapper/');

return $autoloader;
}
}

@Anonymous, The reason one chooses Zend Framewor...

2010-09-18T21:19:20.920+02:00

@Anonymous,

The reason one chooses Zend Framework is to have a very powerful, stable and highly extensible framework that already solves about 60% of all your needs. But this power comes with a small cost.

But nothing prevents you to query your data using static SQL.

@Anonymous,

I agree you have a point there, populate and toArray are methods that should reside in the mapper class.

The reason I had them in my model is that I wanted to populate my model with data (from any source) and represent my model as an array.

@Niels,

Yes, in consistency with what @anonymous mentioned, it would make more sense.

@Tektlab,

Well, the example presented here uses the autoloading heavily and when it cannot find it's class it can mean one or all of the following:

1) you haven't set the namespace in your bootstrap
2) you have your mappers in directory "mapper" in stead of "mappers" (plural)

Go check your settings and see if you can debug the steps right to the point where you call 'getMapper()' where you set your mapper.

Let me know if it gives you some results or not.

Hi Michelangelo, I keep getting this error: Messa...

2010-09-18T12:14:53.149+02:00

Hi Michelangelo,
I keep getting this error:

Message: Non-existing mapper class provided

Stack trace:

#0 D:\Work\testingServer\datamodels\application\models\Accounts.php(68): Default_Model_Abstract->setMapper('Default_Model_M...')
#1 D:\Work\testingServer\datamodels\application\models\Abstract.php(103): Default_Model_Accounts->getMapper()
#2 D:\Work\testingServer\datamodels\application\controllers\IndexController.php(14): Default_Model_Abstract->fetchAll()
#3 D:\Work\testingServer\datamodels\library\Zend\Controller\Action.php(513): IndexController->indexAction()
#4 D:\Work\testingServer\datamodels\library\Zend\Controller\Dispatcher\Standard.php(295): Zend_Controller_Action->dispatch('indexAction')
#5 D:\Work\testingServer\datamodels\library\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#6 D:\Work\testingServer\datamodels\library\Zend\Application\Bootstrap\Bootstrap.php(97): Zend_Controller_Front->dispatch()
#7 D:\Work\testingServer\datamodels\library\Zend\Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#8 D:\Work\testingServer\datamodels\public\index.php(26): Zend_Application->run()
#9 {main}
Request Parameters:

array (
'controller' => 'index',
'action' => 'index',
'module' => 'default',
)

Any ideas how I can diagnose it?
Sorry to be so rubbish.
Phil

Just to follow up on that. I would suggest putti...

2010-09-15T16:10:36.346+02:00

Just to follow up on that.

I would suggest putting up 2 abstract methods in the Mapper_Abstract class:

abstract public function Populate($model);

and

abstract public function toArray($model);

and than let end users implement populate and toArray in the specific mapper classes.

Hi Michelangelo, great post. I've got a questi...

2010-09-15T15:50:52.827+02:00

Hi Michelangelo, great post. I've got a question though about the toArray function.

As it is, it's located in the Default_Model_Account class. However, shouldn't it be located in the corresponding mapper class (hence Default_Model_Mapper_Account)? The primary function of a mapper object is to link dbtable fields to object class properties, right?

In the current example the Model class "knows" about database table fields...

Like to here you're insights.

don't get the advantage of zend.. just to crea...

2010-09-11T18:38:48.750+02:00

don't get the advantage of zend.. just to create a listing so many thing need to be done. if procedural or even simple ooPHP it can be written within less than 5 lines

Hi Michelangelo, Nice post. I like your approach ...

2010-01-13T15:53:16.935+01:00

Hi Michelangelo,

Nice post. I like your approach on creating a model that represents the 'view' of that you wanted to achieve. I am currently also working on some examples using table relations. Which I will post in the near future on my blog. As all roads lead to Rome I have a different take on it…

Instead of creating a model that represents the view I add properties to the parent Model class. In your example this would be the User class.

In the mapping of the User TDG to the User Model I have added something along the lines of(blog example):

Inside my Blog Entry (posting) mapper map() function:
/**
* Get comments, find dependant rows in comments table
*/
$commentMapper = new Blog_Model_CommentMapper();
$commentRowset = $row->findBlog_Model_DbTable_Comment();
// or $commentRowset = $data->findDependentRowset('Blog_Model_DbTable_Comment');
$commentModelSet = $commentMapper->mapToModelSet($commentRowset);
$model->setComments($commentModelSet);

I set the blog entry property comments to contain a set of Blog_Entry_Comment models.
With this solution, I can iterate trough child classes and use the full features in them; such as save, find, fetch all and such.

Enough; I will send you what I am working on so you can see what I mean.

Cheers, Leonard (VNU Media)

Others check www.sreknord.net in the near future.

Free online Quiz

PHP questions and answers

Comments on DragonBe's PHP blog: Zend Framework data models

This is a bad implementation and I don't sugge...

If you find that you need a particular model globa...

You can find some helpful articles about Zend Fram...

Well, so much for comprehending well-written docum...

This is the simple example I've been seeking! ...

Why didnt you show us the Mapper_Abstract? You def...

I found you have noted each step in a different ma...

A very nice tutorial about the data models, I have...

Warning. dont use "findDependentRowset" ...

I am satisfied with your blog. Your post is dear. ...

I would like a clarification on your following com...

very informatory tutorial.

Very nice and helpful tutorial. Helped me much bec...

Hi, the information you provide is very informativ...

Thanks Jatin, you the man.

Awesome article! I have gradually become fan of yo...

Hello, interesting posting. But what about n:m rel...

@Teklab I faced the similar problem and fixed it...

@Anonymous, The reason one chooses Zend Framewor...

Hi Michelangelo, I keep getting this error: Messa...

Just to follow up on that. I would suggest putti...

Hi Michelangelo, great post. I've got a questi...

don't get the advantage of zend.. just to crea...

Hi Michelangelo, Nice post. I like your approach ...

Free online QuizPHP questions and answers

Free online Quiz

PHP questions and answers