# How to create a command line script that acts on a model?

**URL:** <https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025>\
**Category:** Rails\
**Created:** [February 1, 2006, 11:37pm UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025 "2006-02-01T23:37:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 1, 2006, 11:37pm UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/1 "2006-02-01T23:37:20Z")

</div>

Hi,

I’m looking to create a ruby script that loads a bunch of records and  
manipulates these. Where do I start?

I got this to begin with:  
#!/usr/bin/env ruby  
require File.dirname( **FILE** ) + ‘/…/config/boot’

players = Player.find :all

But it complains about a DB connection. How do I set this up?

Jeroen

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 1, 2006, 11:58pm UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/2 "2006-02-01T23:58:45Z")

</div>

#!/usr/bin/env ruby  
require File.dirname( **FILE** ) + ‘/…/config/boot’  
require File.dirname( **FILE** ) + ‘/…/config/environment’

ActiveRecord::Base.establish\_connection  
(ActiveRecord::Base.configurations[“development”])

user = User.find(:first)  
puts user.to\_yaml

Warren

On 01-Feb-06, at 2:34 PM, Jeroen H. wrote:

> But it complains about a DB connection. How do I set this up?
> 
> Jeroen
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

Best Regards,  
Warren N…  
GNU ([http://www.gnu.org.in](http://www.gnu.org.in))

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 1, 2006, 11:58pm UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/3 "2006-02-01T23:58:46Z")

</div>

#!/usr/bin/env ruby  
require File.dirname( **FILE** ) + ‘/…/config/boot’  
require File.dirname( **FILE** ) + ‘/…/config/environment’

ActiveRecord::Base.establish\_connection  
(ActiveRecord::Base.configurations[“development”])

user = User.find(:first)  
puts user.to\_yaml

Warren

On 01-Feb-06, at 2:34 PM, Jeroen H. wrote:

> But it complains about a DB connection. How do I set this up?
> 
> Jeroen
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

Best Regards,  
Warren N…  
GNU ([http://www.gnu.org.in](http://www.gnu.org.in))

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 2, 2006, 12:14am UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/4 "2006-02-02T00:14:13Z")

</div>

Jeroen H. wrote:

> Hi,
> 
> I’m looking to create a ruby script that loads a bunch of records and  
> manipulates these. Where do I start?

script/runner your\_script\_here.rb

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 2, 2006, 9:52am UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/5 "2006-02-02T09:52:43Z")

</div>

Alex Y. wrote:

> Jeroen H. wrote:
> 
> > Hi,
> > 
> > I’m looking to create a ruby script that loads a bunch of records and  
> > manipulates these. Where do I start?
> 
> script/runner your\_script\_here.rb

It doesn’t seem to take a file as an argument, just a string…

Jeroen

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 2, 2006, 10:17am UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/6 "2006-02-02T10:17:02Z")

</div>

Jeroen H. wrote:

> It doesn’t seem to take a file as an argument, just a string…  
> … Ok…

script/runner ‘require “your\_script\_here”’

---

<div class="post-metadata">

**Author:** ![jeroen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/bbe5ce/32.png) [@jeroen](https://www.ruby-forum.com/u/jeroen)\
**Post date:** [February 2, 2006, 11:52am UTC](https://www.ruby-forum.com/t/how-to-create-a-command-line-script-that-acts-on-a-model/100025/7 "2006-02-02T11:52:18Z")

</div>

Alex Y. wrote:

> > It doesn’t seem to take a file as an argument, just a string…  
> > … Ok…
> 
> script/runner ‘require “your\_script\_here”’

Why didn’t I think of that?? Anyway, thanks for you help, this works  
perfectly!

Jeroen