Ruby gem to run sql commands

Question

I want to run sql commands directly in my rails application. Is there any gem to do this?

For example:

I want to delete a user , who is having id 2 using below sql command

 delete from users where id=2

pangpang · Accepted Answer · 2014-08-28 12:12:15Z

4

ActiveRecord::Base.connection.execute("delete from users where id=2")

answered Aug 28, 2014 at 12:12

pangpang

8,86915 gold badges67 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vijikumar · Accepted Answer · 2014-08-28 12:11:37Z

1

Yes. We can do that by using query_exec

answered Aug 28, 2014 at 12:11

vijikumar

1,82512 silver badges16 bronze badges

Igor Kasyanchuk · Accepted Answer · 2015-10-16 16:39:03Z

0

If you want to run SQL from your browser try https://github.com/igorkasyanchuk/rails_db

answered Oct 16, 2015 at 16:39

Igor Kasyanchuk

7746 silver badges12 bronze badges