Create Alchemy SQL BE -

Getting started

1. Change all the files in the data directory to match the data model of your app.
2. Run heroku create
3. Run npm run setup-heroku to create a heroku SQL database in the cloud to go with your heroku app.
4. Run heroku config:get DATABASE_URL to get your heroku sql database url from the cloud. Put this in your .env file, under DATABASE_URL
5. Run npm run setup-db
6. Run npm run start:watch to start the dev server
7. Routes are in app.js, not in server.js. This is so our tests will not launch a server every time.

HARD MODE: Override default queries

// OPTIONALLY pass in new queries to override defaults

const authRoutes = createAuthRoutes({
    selectUser(email) {
        return client.query(`
            SELECT id, email, hash
            FROM users
            WHERE email = $1;
        `,
        [email]
        ).then(result => result.rows[0]);
    },
    insertUser(user, hash) {
        console.log(user);
        return client.query(`
            INSERT into users (email, hash)
            VALUES ($1, $2)
            RETURNING id, email;
        `,
        [user.email, hash]
        ).then(result => result.rows[0]);
    }
});