I don’t think Datamapper supports in table foreign keys, so every relation amongst two tables must have its own join table.

Check out Overzealous Extension to Datamapper for support of in-table foreign keys, which eliminate the need for join tables in cases of has_one relationships.

I was wondering How I would go about this with datamapper,

I have a clients table and a clients_clients table that links a client as a child of another clinet (id, parent_id, child_id)

But it doesnt seem to work,  can datamapper models relate to them selfs?

I have jst had a look under the advanced relationshops section still a bit confused though

Sorry if what i write seems confusing

Cheers.

@ennis
I hate to keep repeating myself, but if you want more advanced features (such as self relationships), you should switch to using DMZ, my extended version of DataMapper.

The discussion board is available in my signature, and you can learn a lot more about it from the link above.

Was just about to post

  var $has_many = array(
      ‘relatedclient’ => array(
        ‘class’ => ‘client’,
        ‘other_field’ => ‘client’
      ),
      ‘client’ => array(
        ‘other_field’ => ‘relatedclient’
      )
  );

Thanks you I figured it out was already using DMZ thanks

Hi,
As far as I understood everything is an object.

So if I have a car (table: cars) and this car has a color (table: colors) I have two models, a car model and a color model, right?

So let’s say my car has a lot more attributes, e.g. what kind of tyres, what kind of radio, what kind of seats etc, I have also the tables “tyres”, “radios”, “seats” etc, right?

So let’s assume I want to bundle these attributes and set a prefix only for the car’s attributes. How can I do this?

I want to have the “main objects” like “car” without any table-prefix. But attributes should be with a prefix. I know how to set a join-prefix and a table-prefix for certain models. Then I can also set the table name für “plurals”. Could I do the following to realize the grouping (same prefix for the car’s attributes):

Color-Model:
$table = ‘car_colors’;
$prefix = ‘’;
$join_prefix = ‘join_’;

Car-Model:
$table = ‘cars’;
$prefix = ‘’;
$join_prefix = ‘join_’;

etc.

Would that work?

Thanks for your help!!!

Sorry for spamming this thread, but is Datamapper still under active development, e.g. update to more recent versions of CodeIgniter if necessary?

I’m studying any Codeigniter ORM, is this project still active ?
Thanks in advance.

HI,

can you please tell me benefits of DMZ DataMapper against Doctrine? Why i should use DMZ Datamaper instead of Doctrine?

OverZealous - 15 October 2009 06:35 AM

@ennis
I hate to keep repeating myself, but if you want more advanced features (such as self relationships), you should switch to using DMZ, my extended version of DataMapper.

The discussion board is available in my signature, and you can learn a lot more about it from the link above.

Follow this

I had weird issue using Datamapper. If I do this :

Using the get_by_id method I have all the object even if ID exists. Using the where method I have the object I requested.

Any idea? I didn’t take a closer look to those method within the lib yet.