Express Boilerplate!

This is a boilerplate project used for starting new projects!

Set up

Complete the following steps to start a new project (NEW-PROJECT-NAME):

1. Clone this repository to your local machine git clone BOILERPLATE-URL NEW-PROJECTS-NAME
2. cd into the cloned repository
3. Make a fresh start of the git history for this project with rm -rf .git && git init
4. Install the node dependencies npm install
5. Move the example Environment file to .env that will be ignored by git and read by the express server mv example.env .env
6. Edit the contents of the package.json to use NEW-PROJECT-NAME instead of "name": "express-boilerplate",

Scripts

Start the application npm start

Start nodemon for the application npm run dev

Run the tests npm test

Deploying

When your new project is ready for deployment, add a new Heroku application with heroku create. This will make a new git remote called "heroku" and you can then npm run deploy which will push to this remote's master branch.

Create boiler plate migration script

Create migrations with following command:

knex migrate:make create_bookmarks --debug 

Format migration script to create tables

exports.up = function(knex) {
    return knex.schema.createTableIfNotExists("bookmarks", function(table) {
        table.increments('id').primary();
        table.string('title').notNullable();
        table.string('url').notNullable();
        table.timestamp('rating');
        table.boolean('description').defaultTo(false);
        table.timestamp('date_created').defaultTo(knex.fn.now());
        table.timestamp('date_updated').defaultTo(knex.fn.now());
    });
};

exports.down = function(knex) {
    return knex.schema.dropTableIfExists("bookmarks");
};

Execute Migrations scripts on Database

Run migrations in debug mode on development environment with following command:

knex migrate:latest --debug --env development

Execute Migrations scripts on Database

Run migrations in debug mode on production environment with following command:

knex migrate:latest --debug --env production