iphone and gis development notes

sudo gem list
sudo gem update --system

/Users/rupert/.gem/ruby/1.8/gems
/Library/Ruby/Gems/1.8/gems

rupert:1.8 rupert$ gem env
RubyGems Environment:
  - RUBYGEMS VERSION: 1.3.5
  - RUBY VERSION: 1.8.6 (2008-08-08 patchlevel 286) [i686-darwin9.5.0]
  - INSTALLATION DIRECTORY: /usr/local/lib/ruby/gems/1.8
  - RUBY EXECUTABLE: /usr/local/bin/ruby
  - EXECUTABLE DIRECTORY: /usr/local/bin
  - RUBYGEMS PLATFORMS:
    - ruby
    - x86-darwin-9
  - GEM PATHS:
     - /usr/local/lib/ruby/gems/1.8
     - /Users/rupert/.gem/ruby/1.8
  - GEM CONFIGURATION:
     - :update_sources => true
     - :verbose => true
     - :benchmark => false
     - :backtrace => false
     - :bulk_threshold => 1000
  - REMOTE SOURCES:
     - http://gems.rubyforge.org/

gem install -V rails-2.3.3.gem
gem install -V mysql

gem install -V passenger
cd /Users/rupert/.gem/ruby/1.8/gems/passenger-2.2.5/bin
passenger-install-apache2-module

469 LoadModule passenger_module /Users/rupert/.gem/ruby/1.8/gems/passenger-2.2.5/ext/apache2/mod_passenger.so
470 PassengerRoot /Users/rupert/.gem/ruby/1.8/gems/passenger-2.2.5
471 PassengerRuby /usr/local/bin/ruby
472 
473 <VirtualHost *:80>
474   RailsBaseURI /rails/travelsiteph
475 </VirtualHost>

$ cd /Users/rupert/projects/rails
$ rails travelisteph
      create  
      create  app/controllers
      create  app/helpers
      create  app/models
      create  app/views/layouts
      create  config/environments
	.....
$ ls -la travelsiteph
drwxr-xr-x  15 rupert  admin    510  2 Sep 21:14 .
drwxr-xr-x   5 rupert  admin    170 30 Sep 16:31 ..
-rw-r--r--   1 rupert  admin  10011  2 Sep 21:14 README
-rw-r--r--   1 rupert  admin    307  2 Sep 21:14 Rakefile
drwxr-xr-x   6 rupert  admin    204  2 Sep 21:14 app
drwxr-xr-x   9 rupert  admin    306  2 Sep 21:14 config
drwxr-xr-x   4 rupert  admin    136  2 Sep 21:18 db
drwxr-xr-x   3 rupert  admin    102  2 Sep 21:14 doc
drwxr-xr-x   3 rupert  admin    102  2 Sep 21:14 lib
drwxr-xr-x   6 rupert  admin    204  2 Sep 21:14 log
drwxr-xr-x  11 rupert  admin    374  2 Sep 21:14 public
drwxr-xr-x  11 rupert  admin    374  2 Sep 21:14 script
drwxr-xr-x   8 rupert  admin    272  2 Sep 21:55 test
drwxr-xr-x   6 rupert  admin    204  2 Sep 22:07 tmp
drwxr-xr-x   3 rupert  admin    102  2 Sep 21:14 vendor

cd /wwwroot
mkdir rails
ln -s /Users/rupert/projects/rails/travelsiteph/public travelsiteph
 
$ ls -la
total 8
drwxr-xr-x   3 rupert  admin   102  2 Sep 14:09 .
drwxrwxr-x  60 root    admin  2040  2 Sep 14:08 ..
lrwxr-xr-x   1 rupert  admin    42  2 Sep 14:09 travelsiteph -> /Users/rupert/projects/rails/travelsiteph/public

sudo /Library/StartupItems/Apache2/Apache2 restart

GRANT ALL PRIVILEGES ON *.* TO rupert@'%' IDENTIFIED BY '*************' WITH GRANT OPTION;
$ mysql -u rupert -p

mysql> CREATE DATABASE travelsiteph_development;
Query OK, 1 row affected (0.00 sec)
 
mysql> CREATE DATABASE travelsiteph_test;
Query OK, 1 row affected (0.00 sec)
 
mysql> CREATE DATABASE travelsiteph_deployment;
Query OK, 1 row affected (0.00 sec)

cd /Users/rupert/projects/rails/travelsiteph
mate .

development:
  adapter: mysql
  database: travelsiteph_development
  username: root
  password: xxxxxxx
  host: localhost
 
test:
  adapter: mysql
  database: travelsiteph_test
  username: root
  password: xxxxxxx
  host: localhost
 
production:
  adapter: mysql
  database: travelsiteph_deployment
  username: root
  password: xxxxxxx
  host: localhost

$ ruby script/generate model Poi
      exists  app/models/
      exists  test/unit/
      exists  test/fixtures/
      create  app/models/poi.rb
      create  test/unit/poi_test.rb
      create  test/fixtures/pois.yml
      create  db/migrate
      create  db/migrate/20090902111538_create_pois.rb

class Poi < ActiveRecord::Migration
  def self.up
    create_table :pois, :id => :poi_id do |t|
      t.column :name, :string
      t.column :full_address, :string
      t.column :location, :string
      t.column :get_there, :string
      t.column :short_description, :string
      t.column :full_description, :text
      t.column :other_info, :text
      t.column :tel_no, :string
      t.column :fax_no, :string
      t.column :mobile_no, :string
      t.column :email, :string
      t.column :website, :string
      t.column :other_contact_details, :text
      t.column :longitude, :decimal, :precision => 10, :scale => 7
      t.column :latitude, :decimal, :precision => 10, :scale => 7
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.timestamps
    end
  end
 
  def self.down
    drop_table :pois
  end
end

$ rake db:migrate
(in /Users/rupert/projects/rails/travelsiteph)
==  CreatePois: migrating =========================================
-- create_table(:point_of_interests, {:id=>:poi_id})
   -> 0.0353s
==  CreatePois: migrated (0.0362s) ================================

$ script/generate controller Poi
      exists  app/controllers/
      exists  app/helpers/
      create  app/views/poi
      create  test/functional/
      create  test/unit/helpers/
      create  app/controllers/poi_controller.rb
      create  test/functional/poi_controller_test.rb
      create  app/helpers/poi_helper.rb
      create  test/unit/helpers/poi_helper_test.rb

class PoiController < ApplicationController
  def list
    @pois = Poi.find(:all)
  end
end

$ruby script/server

<% if @pois.blank? %>
 
	<p>There are currently no pois in the system. </p>
 
<% else %>
 
	<p>These are the pois in the system: </p>
 
	<ul>
		<% @pois.each do |poi| %>
			<li><%= link_to poi.name, {:action => 'show', :id => poi.id} -%></li>
		<% end %>
	</ul>
 
<% end %>

set :port, 2210
set :application, "halalan2010"
#set :repository,  "svn+ssh://2rmobile.com/data/repos/web/rails/halalan2010/"
set :repository,  "http://2rmobile.com/repos/web/rails/halalan2010/"
 
set :scm, :subversion
set :scm_username, 'rupert'
set :scm_password, proc{Capistrano::CLI.password_prompt('SVN pass:')}
# Or: `accurev`, `bzr`, `cvs`, `darcs`, `git`, `mercurial`, `perforce`, `subversion` or `none`
 
role :web, "2rmobile.com" # IP Your HTTP server, Apache/etc
role :app, "2rmobile.com" # This may be the same as your `Web` server
role :db,  "2rmobile.com", :primary => true # This is where Rails migrations will run
#role :db,  "your slave db-server here"
 
set :user,  "rupert"
set :runner, "rupert"
set :deploy_to, "/opt/rails/#{application}"
 
# If you are using Passenger mod_rails uncomment this:
# if you're still using the script/reapear helper you will need
# these http://github.com/rails/irs_process_scripts
 
namespace :deploy do
  task :start do
    run "/etc/init.d/apache2 start"
  end
  task :stop do
    run "/etc/init.d/apache2 stop"
  end
  task :restart, :roles => :app, :except => { :no_release => true } do
     run "#{try_sudo} touch #{File.join(current_path,'tmp','restart.txt')}"
  end
  task :production do
    run "export RAILS_ENV=production"
  end
end
 
namespace :db do
  task :seed do
    run "cd #{deploy_to}/current && RAILS_ENV=production rake db:seed"
  end
  task :populate do
    run "cd #{deploy_to}/current && RAILS_ENV=production rake db:populate"
  end
end

#on local
#cap deploy:setup
 
#on remote and change owner and permissions of project
sudo chown -Rf rupert:root halalan2010
 
#on local
#cap deploy
#cap db:seed
#cap db:populate

rupert:halalan2010 rupert$ export RAILS_ENV=production
rupert:halalan2010 rupert$ rake db:migrate
(in /Users/rupert/projects/rails/halalan2010)
==  CreateDatabase: migrating =================================================
-- create_table(:candidates)
   -> 0.0036s
-- create_table(:voters)
   -> 0.0031s
-- create_table(:votes)
   -> 0.0027s
==  CreateDatabase: migrated (0.0100s) ========================================

#create a remote dir
svn mkdir http://www.2rmobile.com/repos/web/rails/virginmobilechecker
 
#checkout and copy all files
cd ~/projects/rails
mv virginmobilechecker virginmobilechecker_old
svn co "svn+ssh://2rmobile.com/data/repos/web/rails/virginmobilechecker" virginmobilechecker
mv virginmobilechecker_old/* virginmobilechecker/
cd virginmobilechecker
svn add *
 
#ignoring log files
svn revert log/*
svn propset svn:ignore "*.log" log
svn propset svn:ignore "*" tmp
svn propset svn:ignore "*" doc
 
#commit the files
svn commit -m "first commit" *