# Just ActiveRecord

**URL:** <https://www.ruby-forum.com/t/just-activerecord/50140>\
**Category:** Rails\
**Created:** [December 13, 2005, 4:10pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140 "2005-12-13T16:10:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![aap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/82dd89/32.png) [@aap](https://www.ruby-forum.com/u/aap)\
**Post date:** [December 13, 2005, 4:10pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140/1 "2005-12-13T16:10:11Z")

</div>

Dear all,

Is it possible to have ActiveRecord functionality  
using just a Ruby script rather than generating a  
full RoR application?

I’m looking for sth without interface nor control;  
a single ruby script to connect, read table1,  
write table2 and disconnect.

I’ve started declaring a

class Test \< ActiveRecord::Base

end

Any thoughts ?

Many thanks,  
Andre

---

<div class="post-metadata">

**Author:** ![aap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/82dd89/32.png) [@aap](https://www.ruby-forum.com/u/aap)\
**Post date:** [December 13, 2005, 4:14pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140/2 "2005-12-13T16:14:23Z")

</div>

On Tue, Dec 13, 2005 at 04:10:11PM +0100, Andre Parmeggiani wrote:

> class Test \< ActiveRecord::Base
> 
> end
> 
> Any thoughts ?

Sure.

require ‘rubygems’ # Or require the library directly without  
RubyGems  
require ‘activerecord’

ActiveRecord::Base.establish\_connection(  
:adapter =\> ‘…’, # Indicate your desired adapter  
:database =\> ‘…’  
)

class Foo \< ActiveRecord::Base  
end

That’s it.

marcel

---

<div class="post-metadata">

**Author:** ![aap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/82dd89/32.png) [@aap](https://www.ruby-forum.com/u/aap)\
**Post date:** [December 13, 2005, 4:17pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140/3 "2005-12-13T16:17:26Z")

</div>

require ‘rubygems’  
require\_gem ‘activerecord’

ActiveRecord::Base.establish\_connection(  
:adapter =\> ‘mysql’,  
:host =\> ‘localhost’,  
:database =\> ‘my\_database’,  
:username =\> ‘myuser’,  
:password =\> ‘mypassword’  
)

class MyModel \< ActiveRecord::Base  
end

Then do any ussual AR activity.

---

<div class="post-metadata">

**Author:** ![aap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/82dd89/32.png) [@aap](https://www.ruby-forum.com/u/aap)\
**Post date:** [December 13, 2005, 4:17pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140/4 "2005-12-13T16:17:25Z")

</div>

Andre,

Have a look here:  
[http://blog.dangdev.com/articles/2005/11/22/using-active-record-to-test-a-sql-server-legacy-db-connection](http://blog.dangdev.com/articles/2005/11/22/using-active-record-to-test-a-sql-server-legacy-db-connection)

This guy, I think, did what you are asking about.

HTH

Mel

---

<div class="post-metadata">

**Author:** ![aap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/82dd89/32.png) [@aap](https://www.ruby-forum.com/u/aap)\
**Post date:** [December 13, 2005, 5:01pm UTC](https://www.ruby-forum.com/t/just-activerecord/50140/5 "2005-12-13T17:01:36Z")

</div>

Yep, absolutely sweet ! I’ve just add

:socket =\> “/var/run/mysql/mysql.sock”

to the parameters and bingo!

Also, from Mel’s link, i’ve got this one:  
[http://www.intertwingly.net/blog/2005/08/09/Rails-Confidence-Builder](http://www.intertwingly.net/blog/2005/08/09/Rails-Confidence-Builder)

Many thanks again  
André