Thread

Then you’re stuck with a large where clause if you need to search for multiple items…

I’m speak english very bad, sorry.
I install DataMapper from the Sparks, and catch error like that http://ellislab.com/forums/viewreply/959058/
I have a fresh installation of CI, and put bootstrap into an index.php

Yes, when i install Datamapper without using Sparks, all working.

hm… when i copy folder “sparks/DataMapper-ORM/1.8.2/third_party” to application folder, all working.
But it’s no Sparks way.

Sounds like a path issue somewhere?

Yes, bootstrapping from sparks enviropment not working. I wrote in index.php direct path то bootstrap.php, but it not work.
Help me, please, if you can.

Hi, one quick question, is it now field “root_id” mandatory in tables for Nested Sets Extension, because I had a problem with dump_tree() method, until I returned value NULL for $ _rootfield in nestedsets.php

root_id is optional. It is needed when you store multiple trees in a single table, where this id acts as the tree selector.

and why doas not work for me, I used fresh copy of CI, Datamapper 1.8.2, and simplest example… and everything works except dump_tree and dump_dropdown

Please define “not work”? What happens? Error messages?

that is the problem, no errors, just an blank page, but when I change a variable “$_rootfield” to NULL (nestedsets.php) all starts to work

Well, this is exactly what you should do if your table doesn’t have a root column.

In the config, set ‘root’ to NULL.

(p.s. it should be NULL by default, as written in the manual. I don’t know why it is not so in the code, might be a leftover of some testing).

Sorry, this comes from codeigniter .com/forums/viewreply/979474/, I re posted because I’m using 1.8.2 instead of 1.8.0

Hi guys, I’m struggling to set up the validation rules to validate the related items on a specific object, ie: A user can have no more than 3 products related to it.

I believe DataMapper can check for this validation using _related_max_size rule in Related validation, but I can’t figure out how to use it on the $validation array in the model.

So far I’ve tried this in both my user and product models:

var $validation = array(
    'product' => array(
         'rules' => array('max_size' => 3)
    )
);

Can somebody show me an example on how to set up this at the model, controller and finally the view (specificly how to show the errors for this)?

Edit: What I mean is, a user has many products, and can create a certain amount of them, let’s say 3 products, when that amount is reached, the user can no longer create products, and this validation rule should not permit the user to create more products.

This would be the DB Schema:

Users table
------------------
id   |  username  |
------------------

Products table
------------------------
id  | user_id |  name   |
------------------------

Thanks!

I already answered there… 😉

Doesn’t really matter, the answer is the same for 1.8.0 and 1.8.2.

I am not sure if this has been posted yet and I can’t access the issue tracker on bitbucket.

I just installed Datamapper 1.8.2 on an existing site. Previously I had to modify the core database files and remove the protected functions. Everything worked fine out of the box with the new bootstrap method except when using the count() function.

$m = new Message();
$new_messages_count = $m->where_related_user('id', $this->ion_auth->get_user()->id)->where_join_field('user', 'is_sender', 0)->where_join_field('user', 'is_deleted', 0)->where_join_field('user', 'is_read', 0)->count();

This is the code I am using and it throws this error

PHP Fatal error:  Cannot access protected property DM_DB_Driver::$_count_string in /application/libraries/datamapper.php on line 2588

I have fixed this temporarily by changing:

protected $_count_string = 'SELECT COUNT(*) AS ';

to

public $_count_string = 'SELECT COUNT(*) AS ';

in system/database/drivers/mysql/mysql_driver.php

Oops, indeed something I’ve missed.

That line should read:

$select = $this->dm_get('_count_string');