Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > Fun::Movie.eager_graph(:schedules)
- ~ SELECT * FROM `fun_events` WHERE (`type` = 'Fun::Movie') LIMIT 1
- # type comes from set_dataset dataset.filter {:type == self.name}, this one is STI
- ~ SELECT * FROM `fun_schedule` LIMIT 1
- => #<Sequel::MySQL::Dataset: "SELECT `fun_events`.`id`, `fun_events`.`title`, `fun_events`.`slug`, `fun_events`.`thumbnail_small`, `fun_events`.`thumbnail_large`, `fun_events`.`description`, `fun_events`.`description_html`, `fun_events`.`meta1`, `fun_events`.`meta2`, `fun_events`.`meta3`, `fun_events`.`meta4`, `fun_events`.`meta5`, `fun_events`.`type`, `fun_events`.`created_at`, `schedules`.`id` AS `schedules_id`, `schedules`.`event_id`, `schedules`.`place_id`, `schedules`.`happens_at` FROM `fun_events` LEFT OUTER JOIN `fun_schedule` `schedules` ON (`schedules`.`event_id` = `fun_events`.`id`) WHERE (`type` = 'Fun::Movie')">
- >> z = _
- => #<Sequel::MySQL::Dataset: "SELECT `fun_events`.`id`, `fun_events`.`title`, `fun_events`.`slug`, `fun_events`.`thumbnail_small`, `fun_events`.`thumbnail_large`, `fun_events`.`description`, `fun_events`.`description_html`, `fun_events`.`meta1`, `fun_events`.`meta2`, `fun_events`.`meta3`, `fun_events`.`meta4`, `fun_events`.`meta5`, `fun_events`.`type`, `fun_events`.`created_at`, `schedules`.`id` AS `schedules_id`, `schedules`.`event_id`, `schedules`.`place_id`, `schedules`.`happens_at` FROM `fun_events` LEFT OUTER JOIN `fun_schedule` `schedules` ON (`schedules`.`event_id` = `fun_events`.`id`) WHERE (`type` = 'Fun::Movie')">
- >> z.count
- ~ SELECT COUNT(*) FROM `fun_events` LEFT OUTER JOIN `fun_schedule` `schedules` ON (`schedules`.`event_id` = `fun_events`.`id`) WHERE (`type` = 'Fun::Movie') LIMIT 1
- => 0
- #however! The exact same SQL query in CocoaMYSQL returns 314 in a single cell.
- >> z.all.size
- ~ SELECT `fun_events`.`id`, `fun_events`.`title`, `fun_events`.`slug`, `fun_events`.`thumbnail_small`, `fun_events`.`thumbnail_large`, `fun_events`.`description`, `fun_events`.`description_html`, `fun_events`.`meta1`, `fun_events`.`meta2`, `fun_events`.`meta3`, `fun_events`.`meta4`, `fun_events`.`meta5`, `fun_events`.`type`, `fun_events`.`created_at`, `schedules`.`id` AS `schedules_id`, `schedules`.`event_id`, `schedules`.`place_id`, `schedules`.`happens_at` FROM `fun_events` LEFT OUTER JOIN `fun_schedule` `schedules` ON (`schedules`.`event_id` = `fun_events`.`id`) WHERE (`type` = 'Fun::Movie')
- => 9
Add Comment
Please, Sign In to add comment