h1. RailsOnPG

This is timesaver for middle/large Rails application which used PostgreSQL as database. Create/drop Views, Functions, Triggers, Foreign keys in your migrations using ruby syntax.

h2. Installation

<pre>

script/plugin install git://github.com/alex3t/rails_on_pg.git

</pre>

h2. Views

<pre>

create_view :active_patients do |view|
  view.select 'p.patient_id as id' ,'p.id as visit_id'
  view.from 'patients as p'
  view.join 'left join demographics d on d.visit_id=v.id'
  view.conditions 'p.status'=>'active','p.name' => 'John' #or "p.status='active' and p.name='John'"
end

</pre>

h2. Functions

<pre>

create_function 'format_name', {:returns=>'character varying'}, 'first_name character varying(125)', 'middle_name character varying(15)', "last_name character varying(20)" do
  "RETURN COALESCE(last_name, 'no last name') || ', ' || COALESCE(first_name, 'no first name');"
end

</pre>

h2. Triggers

<pre>

create_trigger "update_status", :before, "users", "insert","update"
  #update status function body here
end

</pre>

h2. Foreign keys

<pre>

add_foreign_key :order_items, :product_id, :orders, :on_delete=>""

</pre>

For more details see rdoc or tests

h3. Todo

Make as gem

Copyright © 2009 Alex Tretyakov, released under MIT license