Hi folks.
I'm migrating to Sequel from using the PG gem, due to the async nature of
some of their calls. I was getting closure on the connections so I thought
I'd ride this train.
I have some dashboard charts that require SQL statement like the
following. Is it recommended that I use straight SQL for these, or can
Sequel handle them?
res = DBN.fetch( %Q{ SELECT a."TheDate", COALESCE(b."recs", 0) mycount
FROM
(
SELECT CURRENT_DATE - i "TheDate"
FROM generate_series(0, 29) i
) a
LEFT OUTER JOIN (
SELECT ts::date, COUNT(*) "recs"
FROM ptree_admin
WHERE ts::date > (CURRENT_DATE - INTERVAL '30 DAY')::DATE
AND kind = 'search_done'
GROUP BY ts::date
)b ON a."TheDate"=b.ts::date
} ).to_a
It's a bit of a doozie even for straight SQL. Just wondering how advanced
Sequel is. I'm happy all the same as it provides DB.fetch.
Cheers
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/eff37c1d-f1ff-4df7-aa04-4aaacbd70662%40googlegroups.com.
