test has required fields

be able to delete from the index or show pages

download CSV data on local machine

verify uniqueness

model returns the total count of stations

String formatting method needs to exist for the seed file.
This method should be in a data loading/cleaning module.
All module methods get called in seed file.
The date comes in as day/month/year and active record expects month/day/year

attributes:

• name
• dock count
• city
• installation date
  Model must have validations for all attributes.

Validations Info
http://guides.rubyonrails.org/active_record_validations.html

1. /station-dashboard
2. sees station(s) where the most bikes are available (based on docks)

1. /station-dashboard
2. fewest bikes available at a station(based on docks)

-normalize DB
-seed trip data

Will update structure after whiteboarding

Use restful route names

test for uniqueness

seed trip.csv in db/seeds

• formats and load data
• include & require this module in db/seeds.rb

1. /station-dashboard
2. sees where the fewest bikes are available (based on docks)

Run db:seed on databse to add entries

1. /stations/:id/edit
2. submits new info, click submit
3. redirects /stations/:id

Build migration for station. Attributes needed are
Name
Dock Count
City
Installation Date

1. /stations/:id
2. can edit & delete

model returns fewest amount of bikes at a station

test has required fields
test for uniqueness

1. User goes to /stations
2. user sees all 70 stations

Pre-populate the form with current information for a station for user

Must be able to delete from show page.

model returns the average # of bikes per station

each person downloads data on their machine

test has required fields
test for uniqueness

1. user goes to /stations
2. user sees all stations
3. can click delete & edit for a station
4. edit reroutes to /stations/:id, submits, redirects to /stations/:id to see edited version
5. delete redirects to /stations

1. /stations/new
2. clicks submit & redirects /stations/:id

1. /station-dashboard
2. most recently installed station

for all the trip things

layout erb creates structure / wrapper for other views

-set up layout.erb
-use consistent styling
-add classes & ids to HTML consistently
-bootstrap + /public direction styling sheet

1. /station-dashboard
2. user sees total count of stations

-Courtney will be doing this with mentor Saturday morning, using AR

Model returns newest station

1. /station-dashboard
2. sees average bikes available per station (based on docks)

Model returns oldest station

1. /station-dashboard
2. Most bikes available at a station (based on docks)

download CSV data on local machine

Must be able to delete from index page.

all attributes must be present, needs a test for each attribute, relevant, validation line goes in Station model
docs: http://guides.rubyonrails.org/active_record_validations.html

1. /station-dashboard
2. sees oldest station

/station-dashboard

• returns station with the most # of bikes

• add migration
• reduce redundancy
• reference homework & videos
• validates_uniqueness _of :city goes in class City
  description: https://gist.github.com/Carmer/f9e060bf1ac30e3ab7b3

Add csv data folder to gitignore
All team members must have this data locally.
add station.csv to /db/csv/
Dataset Link
https://www.kaggle.com/benhamner/sf-bay-area-bike-share

model returns station with the greatest # of bikes

1. Add station.csv file in db/csv directory
2. do Active Record things