SarahRector/fav-swanson-be

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]);
    }
});