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