suyesh suyesh - 1 month ago 5
Ruby Question

How to put a raw SQL query in Sequel

I am trying to convert SQL code to Seqel to run it from my script. How do I convert this:

select code, count(1) as total
from school_districts
group by code order by total desc;


into Sequel? Or, is there a way to pass raw SQL to Sequel? Also the
school_districts
will be interpolated
#{table_name}
.

Answer

You can do it a couple ways:

  1. Use []:

    DB["your sql string"]
    
  2. Use fetch:

    DB.fetch("your sql string")
    
Comments