# OpenCongress - a Ruby on Rails application for displaying information about Congress
#
# Copyright (C) 2005-2009 Participatory Politics Foundation
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301 USA

== OpenCongress Rails Project

-- Installing OpenCongress --

First of all, the OpenCongress project is a PostgreSQL only project.  Don't have delusions of using MySQL with it or you will be hurtin.  Since I personally had little experience with Postgres before this, I will include some tips for all you Mysql only guys and gals out there.

Here is what you have to do to get OpenCongress close to working on your personal machine :

  1. install postgresql

  2. install tsearch in contrib

  3. gem install ferret, bluecloth, simple-rss, postgres-pr

  4. copy config/database.sample to config/database.yml and edit it

  5. create the databases
	createdb opencongress_dev
	opencongress_dev < db/tsearch2.sql
  	createdb opencongress_test

  6. rake migrate

--

Next, you will have to get the data from govtrack and fill in your database with the parsed govtrack data

  mkdir /data/govtrack/111
  cd /data/govtrack/111
  rsync -az govtrack.us::govtrackdata/us/111/bills .
  rsync -az govtrack.us::govtrackdata/us/111/repstats .
  rsync -az govtrack.us::govtrackdata/us/111/bills.index.xml .
  rsync -az govtrack.us::govtrackdata/us/111/committeeschedule.xml .
  rsync -az govtrack.us::govtrackdata/us/111/rolls .

Now, you will have to actually parse the data

  ruby bin/govtrack_parse_people.rb
  ruby bin/govtrack_parse_bills.rb 
  ruby bin/govtrack_parse_committees.rb 
  ruby bin/govtrack_parse_committee_schedules.rb 
  ruby parse_individual_bills.rb 

--

Now, just run 'mongrel_rails start' and you should have something going on localhost:3000 - have fun!

Lastly, some Postgres tips:
  
  starting pg:  pg_ctl -D data -l logfile start
  accessing pg from the command line : psql opencongress_dev