Hello! In a company I'm working with, there is a coding department (typically working with Ruby & Sequel), and then there is another department for data-oriented/analytics work (no code, leveraging tools like SQL, Tableau etc).
In a number of cases, the data department has created some large SQL queries for analytics, which are then handed over to the coding department. I have two Sequel-specific questions related to this: 1/ Is there an easy way to enrich an existing SQL query, without rewriting the query itself into the Sequel DSL? To be more specific, I would like to reuse the query, but add an extra "AND order_id between X AND Y" or similar small stuff, to allow gradual data capture (N small queries with resumable synchronisation, instead of 1 big query which tend to time out). One way would be to issue a subquery (SELECT * from (... the raw sql) WHERE ...). Another way would be to parse the query, and append stuff programmatically. We are already using some form of "placeholders" and/or ERB templating for that purpose, but I wonder if something cleaner is possible with Sequel ? 2/ I love to have Sequel logging activated, but for these specific queries, the log is just huge. Is there a way to disable the logging on a per-query basis only? Many thanks for your insights! -- Thibaut -- 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/229fdbf6-2f57-4e6b-a773-c8ed2711b70en%40googlegroups.com.
