A server for the ChineseMe project.
ChineseMe (an online Chinese course) is no longer maintained nor available online. This repository is published here as a reference.
The application is built with express.
It is based on the Express & ES6 REST API Boilerplate.
$ npm install
$ npm run devESLint config comes from https://github.com/rangle/react-redux-example/blob/master/.eslintrc
$ npm run lintThe app is deployed to Heroku.
$ heroku create chinese-me-server --remote production
$ heroku addons:create heroku-postgresql:hobby-dev --remote production
# Set environment variables on Heroku (IMPORTANT: need to be done before building)
$ git push production master
$ heroku run bash --remote production
$ sequelize db:migrate
# Run seeds (needs to have at least the 'en' language and the lesson 0)
$ exit/** connect to DB **/
$ psql -p5432 -d 'chinese-me' // development
$ heroku pg:psql --remote staging // staging
$ heroku pg:psql --remote production // production
/** useful commands **/
$ heroku pg:info
$ watch heroku pg:infoRestore dump in local DB:
# If starting from existing DB
$ sequelize db:migrate:undo:all
$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U timotheeastier -d chinese-me latest.dumpRestore dump in Heroku App:
# Create a dump and upload to s3
# See: https://devcenter.heroku.com/articles/heroku-postgres-import-export
# NOTE: pg-dump version is outated.
$ heroku pg:backups:restore 'https://s3.amazonaws.com/me/items/XXXX/mydb.dump' DATABASE_URL --remote productionRunning seeds:
$ sequelize db:seed:all
Undoing changes from a seed file:
$ sequelize db:seed:undo --seed seedfile.js
Automatic daily backups of the db are scheduled at 02:00 America/Los_Angeles.
The project is relying on Forest Admin.
- development: http://app.forestadmin.com/9499
- staging: https://app.forestadmin.com/9558
- production: https://app.forestadmin.com/9563
See .env.example file
Note: In order for Environment variables to be updated in the code after a change, the app needs to be rebuilt. This can be done by pushing an empty commit like so:
$ git commit --allow-empty -m "empty commit"
$ git push heroku master
- development - http://localhost:8080
- staging - https://frozen-temple-75832.herokuapp.com
- production - https://chinese-me-server.herokuapp.com
- Foreign key constraints are not correctly implemented in the DB schema because the 'reference' option used in most migration files has a typo. The constraints still exists in models thanks to Sequelize.