How to use ActiveRecord outside Rails?

ruby-on-rails ruby ruby-on-rails-4 activerecord rails-postgresql
Kamil Lelonek picture Kamil Lelonek · Dec 21, 2014 · Viewed 7.5k times · Source

I'm building a Rails application based on hexagonal architecture.

One of my adapters is storage adapter (maintained as a gem) that manages access to database and provides simple interface for rails application to store and query data in database.

I'd like to use ActiveRecord in this gem with all rake tasks (create, migrate, drop, rollback) for managing database.

How can I use AR outside rails, but with all rake tasks?

Answer

Austio picture Austio · Dec 21, 2014

Install it like any other gem 

gem install activerecord

Then you configure it somewhere like this

ActiveRecord::Base.establish_connection(
  :adapter  => 'mysql',
  :database => 'database',
  :username => 'user',
  :password => 'password',
  :host     => 'localhost')

Models can then inherit as normal from ActiveRecord::Base

You get all of the rake tasks but you do have to do some extra configuration since you will not have the Rails. Here is the link inside of activerecord for how to configure that stuff.

Database tasks

Related questions

In Rails, what's the difference between find_each and where?

In Rails, both find_each and where are used for retrieving data from Database supported by ActiveRecord. You can pass your query condition to where, like: c = Category.where(:name => 'Ruby', :position => 1) And you can pass batch size …

Read More
Change the default value for table column with migration

I try to change the default column value from false to true. But when I run rake db:migrate VERSION=904984092840298 I got the following ERROR. StandardError: An error has occurred, this and all later migrations canceled: PG::InvalidTextRepresentation: ERROR: invalid …

Read More
Specify custom index name when using add_reference

I have the following migration class LinkDoctorsAndSpecializations < ActiveRecord::Migration def up add_reference :doctors, :doctor_specialization, polymorphic: true, index: true end def down remove_reference :doctors, :doctor_specialization, polymorphic: true end end when i run rake db:migrate i …

Read More