[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]ntheorist[/eluser]
pardon the mistake, i don't meet very many ninja girl programmers

anyway, i think i figured out a solution. Instead of getting all the company_ids from clients then cross referencing them again against the companies table (which requires a few queries) you can do it with a join and get records where the client id is null (thus, not a client)

i'm assuming since you're not using join tables, then datamappers relationship functions wont work for you. If you did, it would be as such

Code:

$comp = new Company();
$comp->where_related_client('id IS NULL')->get();

i tested this to get users in my own db who lacked roles. actually kinda a neat trick im glad u brought it up.

In your case you will probably want to use active record.

Code:

$comp = new Company();
$comp->select('*');
$comp->db->join('clients','clients.company_id = companies.id');
$comp->db->where('clients.id IS NULL');
$comp->get();

to be honest i can't promise mixing AR with Datamapper will not mess up anything but let me know if that works for you.

I feel you about not wanting to create relationship tables for everything, in some cases it can seem overkill. DM is designed to use them and provides handy functions based on them, but having too many can be a pia to manage.

cheers,

n