Confirmation

v0.1 Features:

• devise implementation for candidate & admin
• Home page
• About page
• Admin:
  • login
  • creation
  • reset password
  • edit account
  • cancel account
  • list of Admins
• Candidate:
  • login
  • creation
  • reset password
  • edit account
  • cancel account

================

Confirmation github

Deploying:

• forking production: https://devcenter.heroku.com/articles/fork-app#setup
• Managing Multiple Environments for an App: https://devcenter.heroku.com/articles/multiple-environments#managing-staging-and-production-configurations
• remote versions: git remote -v
• staging: git push staging master
• production: git push heroku master

This application was generated with the rails_apps_composer gem provided by the RailsApps Project.

Rails Composer is supported by developers who purchase our RailsApps tutorials.

Documentation:

• http://docs.seattlerb.org/rdoc/RDoc
• https://github.com/zzak/sdoc

Create a file in config named local_env.yml

• EMAIL_PROVIDER_ADDRESS: ''
• EMAIL_PROVIDER_USERNAME: ''
• EMAIL_PROVIDER_PASSWORD: '' Problems? Issues?

---

Need help? Ask on Stack Overflow with the tag 'railsapps.'

Your application contains diagnostics in the README file. Please provide a copy of the README file when reporting any issues.

If the application doesn't work as expected, please report an issue and include the diagnostics.

Ruby on Rails

This application requires:

• Ruby 2.3.0
• Rails 4.2.5.1 - actually v4.2.6

• Learn more about Installing Rails.
• Learn more about Associatiions.
• Learn more about [Heroku] (https://devcenter.heroku.com/articles/getting-started-with-rails4).
• Learn more about [Heroku Assets] (https://devcenter.heroku.com/articles/rails-asset-pipeline).
• Learn more about [Capybara] (http://www.rubydoc.info/github/jnicklas/capybara/Capybara/).
• Learn more about [ActiveRecord] (http://api.rubyonrails.org/classes/ActiveRecord/).
• Learn more about [file upload] (http://ryan.endacott.me/2014/06/10/rails-file-upload.html, http://mattberther.com/2007/10/19/uploading-files-to-a-database-using-rails).
• Learn more about [Migration] (http://guides.rubyonrails.org/active_record_migrations.htm).
  • db:migrate runs (single) migrations that have not run yet.
  • db:create creates the database
  • db:drop deletes the database
  • db:schema:load creates tables and columns within the (existing) database following schema.rb
  • db:setup does db:create, db:schema:load, db:seed
  • db:reset does db:drop, db:setup
• heroku cli migration
  • heroku run --app confirmation-staging rake db:version
  • heroku run --app confirmation-production rake db:version
• Learn more about [MD-markdown] (https://github.com/adam-p/markdown-here/wiki/Markdown-Cheatsheet).
• Gmail mailing do https://accounts.google.com/DisplayUnlockCaptcha if gmail is not authenticating.
• hiding passwords http://railsapps.github.io/rails-environment-variables.html
• pdf = http://prawnpdf.org/manual.pdf
• sorting table = github.com/themilkman/jquery-tablesorter-rails
  • doc:
• tinymc - editig gem

Postgres Production

https://dashboard.heroku.com/apps

• Production: https://confirmation-production.herokuapp.com/
• Staging: https://confirmation-staging.herokuapp.com/

Copy production db to staging

• heroku pg:copy your-app::DATABASE_URL DATABASE_URL -a yourapp-staging
• https://stackoverflow.com/questions/10673630/how-do-i-transfer-production-database-to-staging-on-heroku-using-pgbackups-gett/24005476#30495448

Copy production(confirmation-production) db to staging(confirmation-staging)

• heroku pg:copy confirmation-production::DATABASE_URL DATABASE_URL -a confirmation-staging
• heroku pg:copy stmichael-confirmation-prod::DATABASE_URL DATABASE_URL -a stmichael-confirmation-staging

Production => local

• heroku pg:backups:download --app confirmation-production
• pg_restore --verbose --clean --no-acl --no-owner -h localhost -U paulkristoff -d confirmation_development latest.dump > restore.log

PSQL

• heroku pg:psql postgresql-corrugated-19133 --app confirmation-production
• heroku pg:psql postgresql-encircled-80532 --app confirmation-staging
• https://data.heroku.com/datastores/f944f9a2-8738-4d80-915a-9fe4f83fd7e0#administration

Restore dump to Production:

• save dump to Dropbox
• in Dropbox make link visable by all
• copy link and convert it to ...
• see http://albertnetymk.github.io/2014/08/28/import_heroku/

Postgres local

Install postgres

• Login as administrator
• bring up terminal
• brew update
• if postgres is installed
  • brew uninstall postgres
  • remove rm -r /usr/local/postgres
• brew install postgres
  • if brew postgres post install did not work then do
    • ls -al /usr/local/var/
    • if /usr/local/var/postgres is owned by root then
      • sudo chown -R $(whoami) /usr/local/var/postgres
    • brew postinstall postgres
    • if still having problems with permissions then
      • sudo chmod -R 700 /usr/local/var/postgres
  • try: psql postgres - should take you into postgres console.
    • if not reboot
  • create role for current login
    • CREATE ROLE paulkristoff LOGIN SUPERUSER CREATEROLE CREATEDB REPLICATION BYPASSRLS;

Devise emails

• views/devise/mailer/*.html.erb

Upgrade local DB

• su - administrator
  • brew upgrade postgresql
  • brew postgresql-upgrade-database

Start DB

• login as paulkristoff
• open terminal
• su - administrator
• show-pg-status
  • if running do nothing
  • if not do start-pg

Creating DBs.

• open terminal
• cd dev/confirmation
• rake db:setup

delete candidate by hand:

• delete from candidates where id=854;
• delete from baptismal_certificates where id= 2341;
• delete from addresses where id=5423;
• delete from sponsor_covenants where id= 2206;
• delete from pick_confirmation_names where id=2158;
• delete from christian_ministries where id= 21269;
• delete from candidate_sheets where id= 1788;
• delete from addresses where id=5422;
• delete from retreat_verifications where id= 2140;

SendGrid

• https://sendgrid.com/docs/API_Reference/api_v3.html
• https://github.com/sendgrid/sendgrid-ruby/blob/master/examples/helpers/mail/example.rb#L21

Year End

• get copy of db
  • heroku pg:backups:download --app confirmation-production
  • mv latest.dump ~/Dropbox/Confirmation/2018-05/year-end/V1.0.18-ye.2017-18.dump
• tag code ex: V1.0.18-ye.2017-18

Time consuming bugs

• When exporting spreadsheet to excel get the error:
  • An Encoding::CompatibilityError occurred in candidate_imports#export_to_excel:
    • incompatible character encodings: UTF-8 and ASCII-8BIT
    • app/controllers/candidate_imports_controller.rb:52:in `export_to_excel'
  • Solution: I was putting biary image in worksheet.
• Getting error in log -
  • ActionController::RoutingError (No route matches [GET] "/apple-touch-icon.png"):
  • Solution:
    • install: https://github.com/RealFaviconGenerator/rails_real_favicon
    • https://realfavicongenerator.net/favicon_result?file_id=p1c10406bt1t7r1c1mmts1pes18vb6#.Wi5pULQ-fOS
    • select RoR

Other Links

• Bootstrap 4.1
  • https://getbootstrap.com/docs/4.1/getting-started/introduction
• Aside
  • https://www.codeply.com/go/Rgq96HykJ2/sidebar-that-changes-to-navbar
• sorting table
  • https://mottie.github.io/tablesorter/docs/example-option-theme-bootstrap-v3.html
  • _sorting_candidate_selection.html.erb
  • tablesorter.js.coffee

Getting Started

Documentation and Support

Issues

Similar Projects

Contributing

Credits

License