That worked perfectly! Thank you! On Friday, April 6, 2018 at 4:22:57 PM UTC-5, Jeremy Evans wrote: > > On Friday, April 6, 2018 at 1:44:55 PM UTC-7, Ransom Briggs wrote: >> >> Hello, >> >> I have an insert statement that is inserting values selected from another >> table based on some filters. I am trying to convert this to a prepared >> statement, but from what I can tell, the prepared statement version of >> insert >> <https://github.com/jeremyevans/sequel/blob/master/doc/prepared_statements.rdoc#prepared-statements> >> >> only works for inserts of the the type "INSERT INTO ... VALUES. Is there >> an easy way that I could turn an insert like the following into a prepared >> statement? >> >> DB[:bar].insert([:foo_id], DB[:foo].select(:id).where(biz: true)) >> # INSERT INTO "bar" ("foo_id") SELECT "id" FROM "foo" WHERE ("biz" IS TRUE) >> >> Thanks, >> Ransom >> > > Bound variables: > > DB[:bar].call(:insert, {:biz=>1}, [:foo_id], > DB[:foo].select(:id).where(biz: :$biz)) > > Prepared statements: > > ps = DB[:bar].prepare(:insert, :insert_foo, [:foo_id], > DB[:foo].select(:id).where(biz: :$biz)) > ps.call(:biz=>true) > DB.call(:insert_foo, :biz=>true) > > 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 https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
