Workshop 3 Online Taxi Booking System

To Do:
1. Setup the MySQL Tools
a: MySQL Query Browser with the inserted records and result

b. MySQL Administrator Tool with table properties added

c. MySQL Administrator creatd the database: itc and table : passsengers

2. Setup the new project called Taxi and created with the startup server Taxiserver

3. The Taxi Server is started , http://localhost:3000

3b. Database.yml

# MySQL version # gem install mysql -ruby (not necessary on OS X Leopard)

development:

adapter: mysql

database: itc

username: root

password: 123456

host: localhost
# Warning: The database defined as "test" will be erased and# re-generated from your development database when you run "rake".# Do not set this db to the same as development or production.

test:

adapter: mysql

database: itc

username: root

password: 123456

host: localhost
production:

adapter: mysql

database: itc

username: root

password: 123456

host: localhost

4.a. Generate the Passengers model and create the database table

- Firstly, the passengers must be created under the model by the generator

- Secondly, amend the 20090412090902_create_passengers.rb which is created by the generator under the db migrate folder

- Thirdly, add the table fields like t.column : name, :string into the file , show under the screenshot

4.b. Rake tasks and select db:migrate, then all the table fields will be created under the passengers.