Using ActiveRecord 3.1 without Rails in a script

Question

The following ought to work as a script, with ActiveRecord 3.1 (note that this is without Rails, not the other way around):

#!/usr/bin/env ruby

require "rubygems"
require "active_record"
dbconfig = YAML::load(File.open('database.yml'))
ActiveRecord::Base.establish_connection(dbconfig)

irb

Unfortunately, it gives the error:

... connection_specification.rb:71:in `rescue in establish_connection': ...
Please install the mysql2 adapter: `gem install activerecord-mysql2-adapter` ...

Adding the line gem 'mysql2', '<0.3' before require "active_record" as suggested by some previous posts (which reference 0.2.7, the 0.2 gem at the time; presently it's 0.2.18) doesn't change it.

How can I get it to work? I want ActiveRecord but not the whole of Rails.

Possible duplicate of How to use ActiveRecord in a ruby script outside Rails? — Mogsdad
– Mogsdad, Commented Mar 8, 2016 at 21:04

alexkv · Accepted Answer · 2012-01-19 15:24:53Z

2

Run in terminal

gem install mysql2

and add row to you code require 'mysql2'

#!/usr/bin/env ruby

require "rubygems"
require 'mysql2'
require "active_record"

dbconfig = YAML::load(File.open('database.yml'))
ActiveRecord::Base.establish_connection(dbconfig)

answered Jan 19, 2012 at 15:24

alexkv

5,1842 gold badges24 silver badges18 bronze badges

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

1 Comment

newUserNameHere Over a year ago

Here's how you do it without needing a database.yml file - stackoverflow.com/a/3661927/2229277

Sai · Accepted Answer · 2012-01-19 19:16:27Z

0

This has fixed my issue, at least temporarily. I haven't yet restarted, so I don't know if it'll survive that. And it seems like a dirty hack; there's got to be a better way.

I haven't yet tested Aleksei's answer above, since I'm not having the same issue after having run this command. Will update ifwhen I do.

sudo install_name_tool -change libmysqlclient.18.dylib /usr/local/mysql/lib/libmysqlclient.18.dylib ~/.rvm/gems/`rvm current`/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle

answered Jan 19, 2012 at 19:16

Sai

7,2897 gold badges44 silver badges56 bronze badges

Collectives™ on Stack Overflow

Using ActiveRecord 3.1 without Rails in a script

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related