On Thursday, July 23, 2015 at 4:36:52 PM UTC-7, [email protected] wrote: > > Also, here is the actual SQL. > > > FYI - I'm pretty sure the group by is only because of the order by which > is not in the *query.rb* gist I gave but is in the > *original_datamapper_classes.rb* gist...hence all the properties also > being listed. *So that part of the query you can ignore.* > > *DataMapper SQL* > SELECT `people`.`id`, `people`.`created_date`, ......(all properties).... > FROM `people` > INNER JOIN `group_people` ON `people`.`id` = `group_people`.`person_id` > INNER JOIN `groups` ON > `group_people`.`group_id` = `groups`.`id` > AND > `group_people`.`group_school_id` = `groups`.`school_id` > WHERE (`groups`.`ems_type` = 'Ready' AND `people`.`first_name` = 'Bob') > GROUP BY `people`.`id`, `people`.`created_date`, ......(all > properties).... > ORDER BY `people`.`id` > > *Sequel SQL* > SELECT * FROM `people` > WHERE > ((`group` IN (SELECT * FROM `groups` WHERE (`ems_type` = 'Ready'))) > AND > (`first_name` = 'Bob')) >
This is because you are using :group instead of :groups (you have to use the association name, not the singular version). The foreign key violations appear to be due to invalid references, i.e. you are trying to add a group_people record with a person_id where no person with that id exists in the person table. Try switching to Group.create and Person.create (which save the objects) instead of Group.new and Person.new (which don't save the objects). Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
