[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
@Poetawd

You've got something set up wrong. You've got the columns rg_id and cpf_id on the documents table, but those need to be on the profiles table. The document object isn't even related to an object called "rg" or "cpf", it is instead related to an object called "drg" or "dcpf", respectively, and it is $has_many.

The ITFK is always stored on the table that has only one of the other object. It can never exist on an object that $has_many. DMZ doesn't even look for ITFKs on $has_many relationships.

I'm pretty sure you want to rewrite it like this:

Code:

class Document extends DataMapper {

    var $has_one = array(
        'tipodocumento',
        'profile',
        'dcpf' => array(
            'class' => 'profile',
            'other_field' => 'cpf'
        ),
        'drg' => array(
            'class' => 'profile',
            'other_field' => 'rg'
        )
    );
    var $has_many = array();

And then add "rg_id" and "cpf_id" to the Profiles table.

FYI: DMZ assumes you want to store the relationship on the documents_profiles join table (in Portuguese, of course ;-) ), because it couldn't find the column "cpf_id" on the Profiles table.