How do I write this SQL into Rails?

Question

I want to get the sequence for the id column in the tags table as

 SELECT pg_get_serial_sequence(‘tags’, ‘id’);

And then I want to use the result from the above Query (the sequence) as an input to the second query. Let s say the first query is called sequence I want to perform the second query as:

 SELECT setval(**sequence**, SELECT max(id) FROM tags);

Any idea on how to do this ?

Does this question help? http://stackoverflow.com/q/14824453/720164 — Jonathan Allard, Aug 13 '16 at 00:34
I figure it's just a matter of running the first query on a generic AR connection, then take the result, and insert it into another query. — Jonathan Allard, Aug 13 '16 at 00:40
BTW try the single query: `SELECT setval(pg_get_serial_sequence(‘tags’, ‘id’), SELECT max(id) FROM tags);` — Abelisto, Aug 13 '16 at 00:46

score 0 · Accepted Answer · answered Aug 13 '16 at 11:15

0

You can use ActiveRecord::Base.connection.execute("your SQL query here").

answered Aug 13 '16 at 11:15

kitz

879
2
9
24

How do I write this SQL into Rails?

1 Answers1