cookiescrumbs / lets-fish

A website for finding places to go fly fishing

Let's Fish

A website for finding places to go fly fishing.

Getting your development machine setup

Install RVM

https://rvm.io/

Create a Ruby environment using RVM

http://stackoverflow.com/questions/15212104/ruby-openssl-issues-on-mac

This is a fix for the openssl problem with RVM compiled rubies

rvm get stable
brew install libyaml
rvm pkg install openssl
rvm osx-ssl-certs update all
rvm install ruby-2.3.1 --with-openssl-dir=$HOME/.rvm/usr --disable-binary

Install bundler to manage dependencies

gem install bundler

Create the repository locally

git clone https://github.com/cookiescrumbs/lets-fish.git

Install rails and other dependencies

bundle install

Setting up your Postgres DB

Install Postgres via brew

psql --version
brew install postgresql
initdb /usr/local/var/postgres
pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

May need to symlink the socket for postgres

mkdir /var/pgsql_socket/ 
ln -s /private/tmp/.s.PGSQL.5432 /var/pgsql_socket/

More information about installing Postgres for Rails

Start Postgres

bundle exec rake pg_db:start

or for postgresql installed via Brew

brew services start postgresql

Create development and test db

bundle exec rake pg_db:create_development #create and load the dev db
bundle exec rake pg_db:create_test #create and load the test db

Add some development data to your database

bundle exec rake pg_db:restore #Restore development db (data only) from /db/pg_backups (using "live" data)

Setup Heroku

Download the toolbelt

heroku git:remote -a lets-fish #add Heroku remote to git repo

Restore DB from dump

pg_restore  --verbose  --no-acl --no-owner -h localhost --data-only -d lets_fish_development ~/Desktop/lets-fish-22-37.dump

rake pg_db:restore  # Restore development db (data only) from /db/pg_backups

Use rake pg_db:restore locally to add test data to your dev app. It grabs the data from from /db/pg_backups. I'll periodically backup the directory with live data. So you should have somthing similiar to "live".

Removes DB config

Removed so I can run the app in production on my dev machine without having to alert this file or worry about it. I can precompile my production assets and debug locally.

RAILS_ENV=production bundle exec rake assets:clobber
RAILS_ENV=production bundle exec rake assets:precompile

Example /config/database.yml

test: &test
  adapter: postgresql
  encoding: unicode
  database: lets_fish_test
  username: stevencook
  password:
  pool: 5
  timeout: 5000

development:
  adapter: postgresql
  encoding: unicode
  database: lets_fish_development
  username: stevencook
  password:
  pool: 5
  timeout: 5000

production:
  adapter: postgresql
  encoding: unicode
  database: lets_fish_development
  username: stevencook
  password:
  pool: 5
  timeout: 5000

Running Let's Fish locally

Install the Foreman gem

gem install foreman

create a .env file for running locally

RAILS_SERVE_STATIC_FILES=false
RAILS_ENV=development
RACK_ENV=development
AWS_ACCESS_KEY_ID=xxxxxxxx
AWS_REGION=eu-west-1
AWS_SECRET_ACCESS_KEY=xxxxxx
S3_BUCKET_NAME=lets-fish
S3_REGION=eu-west-1
ASSET_HOST=dur8xuaowfaya.cloudfront.net
SECRET_KEY_BASE=xxxxxx
GEOGRAPH_API_KEY=xxxxx
DARK_SKY_API=xxxxx
GOOGLE_API_KEY_BROWSER=xxxxxx
INSTAGRAM_API_KEY=xxxx

Start Redis

redis-server /usr/local/etc/redis.conf

Start DB

rake pg_db:start

Start let's fish, run foreman from the root folder

foreman start

Foreman will pick up the .env file :)

Member when the assest pipeline couldn't find assets like Fonts? Member?

Asset pipeline

Member to use asset_path () and change the css file from .css to .css.erb

@font-face {
    font-family: 'Glyphicons Halflings';
    src: url(<%= asset_path 'glyphicons-halflings-regular.eot' %>);

Domain Model

Domain model

App requirements

proj is used to calculate and convert the lat,lng from a OS grid ref. It is a requirement of the global_convert gem, which is a requirement of the Northern Pike gem.

```brew install proj``

lets-fish's Issues

Add the season period to waters

The model has a season field ready to use. Need to add a data picker into the water form to enable users to pick a start and an end date.

Change from HABTM to has_many :through for waters and species

Can't clean up the link table once a water is deleted using HABTM

Modelling data and relationships - Creating a common language

Markers that contain more than one character.

The regular Google marker can only contain on character.
Create a marker to accommodate more than one character.

https://developers.google.com/maps/documentation/javascript/markers

Amazon keys

What's the best way to handle production and development keys. At the moment the same key is used for production and development.

Model prices

Model Prices and create has_many relationship with Waters

Result card Icons

Need to find and add icons to the result cards for species, location and water type.

https://thenounproject.com/Yorlmar%20Campos/collection/super-kitchen/?i=113750
https://thenounproject.com/search/?q=water&i=21953
https://thenounproject.com/search/?q=water&i=48423
https://thenounproject.com/search/?q=water&i=38436
https://thenounproject.com/mockturtle/collection/wild-life/
https://thenounproject.com/mockturtle/uploads/?i=193955
https://thenounproject.com/mockturtle/uploads/?i=193954

Clean up project

Remove insects and create one migration

Add a default water image

Add a default water image

Geocoder as background process

reverse_geocoded_by :latitude, :longitude
Should be added as a background process rather than when a new water is added.
Timeout of external services is a problem.

Add a water to a fishery

Result cards need styling

Highlight corresponding marker when rolling over the search results

Restrict the search to UK only

Restrict the Google places search to UK only. For now
https://developers.google.com/places/web-service

Use the Google places id for the fishery contact details

Store the Google places id for a fishery's contact details

Remove waters from join table of HABTM

Added "waters close to you now" to the home page

"Featured" or "explored" the start of the Fishery page

Fisheries will be featured with travel information, stories, photos, a map marking the waters.
contact in formation, booking etc ...
Similar to these pages ... https://www.airbnb.co.uk/getaways/Manchester?destination=Bath
I see these as the start of the Fishery pages. Like these pages....
http://www.fishpal.com/Scotland/Annan/?dom=Pal

Water type

Need to add a type of water.

Stillwater or River

Use GET instead of POST for search API

Permit information

Where to buy permits

Added Credit link to water image

http://creativecommons.org/licenses/by-sa/2.0/

Friendly URLs

https://github.com/norman/friendly_id

Waters should have a model for tariffs or rates

So you can index the rates. Perhaps force all fisheries to have at least one standard rate to index by.

Delete a fishery and delete associated waters

Waters link to themselves

In the "Other waters run by this fishery" section a water page links to itself:
http://www.gone-fishing.co.uk/waters/100

Structured data

Create json-ld structured data for search results.

Here's something minimal:
https://gist.github.com/tfgrahame/0df4e51711e44e71f7c8

This adds coordinates:
https://gist.github.com/tfgrahame/47a7a502426709ca4419
You can get them from GeoHack, which is a wikipedia thing: https://tools.wmflabs.org/geohack/geohack.php?pagename=Cow_Green_Reservoir&params=54_40_5_N_2_18_30_W_type:waterbody_region:GB
If you put a sameAs property in, then feasibly you could map to entities in the Knowledge graph API

Some things aren't in Wikipedia, but they still have coordinates and Google maps
https://gist.github.com/tfgrahame/53a8594a1b76941369bf
And Geohack:
https://tools.wmflabs.org/os/coor_g/?pagename=List_of_lochs_of_Scotland&params=NR540852_region%3AGB_scale%3A25000

But I think you need to be focussing on the business and offers:
https://gist.github.com/tfgrahame/c74e53f9fa47ddc01459
Note areaCovered and the hasOfferCatalog.

Also found this, of interest:
http://gateway.snh.gov.uk/pls/apex_cagdb2/f?p=111:1000:16005290815488

Waters page grey title bar overlaps image

It looks a bit odd to me:
http://www.gone-fishing.co.uk/waters/100

Search doesn't always post the lat & Lang

Add an & to the fish species

Brown Trout, Sea Trout, Rainbow Trout, Salmon

Brown Trout, Sea Trout, Rainbow Trout & Salmon

Empty panes when using a region as a search location

If I search for a region, I expect to see the map zoomed out and a summary of locations for that region. Instead the panes empty and I see no map at all:
http://gone-fishing.herokuapp.com/search?location=scotland
http://gone-fishing.herokuapp.com/search?location=wales
http://gone-fishing.herokuapp.com/search?location=england

Message to add fishery when there are no fisheries

Delete associated species when water is deleted

Guide "Map packs"

Edit image on the waters form not working

Split waters out into separate model

The waters is part of the fishery model. Is needs to be split out as one fishery can have several waters.

Recently stocked alert!!!

Fishery waters map

Edit water photo

Need to be able to edit the water photo

Split out the Fishery model

contact_details
address

Add a water location

Add a water location to the water table. Currently hard coded as "Settle, North Yorkshire".

Default water image for waters without an image

Admin homepage

Simple admin login for managing fisheries and waters

Need a simple authentication for administrators to manage and validate fisheries and waters

finish waters

Finish species

Species of fish needs finishing

Search form adding multiple locations

Search input appends lat & lng. Can result in multiple places inserted into the form.

Water image

Admin needs away of uploading an image of a water.

Modelling the data to use schema.org and jsonld

Tom said we should look at schema.org to surface data to google.
http://json-ld.org

Added a limit to the search