kat-sauma / city-explorer

Create Alchemy SQL BE

Getting started

1. Clone your repo down and run npm i to install dependencies.
2. Change all the files in the data directory to match the data model of your app.
3. Run heroku create
4. Run npm run setup-heroku to create a heroku SQL database in the cloud to go with your heroku app.
5. Run heroku config:get DATABASE_URL to get your heroku sql database url from the cloud.
6. Put the database URL in your .env file, under DATABASE_URL. (Don't forget to changge the file name from .env-example to .env!)
7. Run npm run setup-db
8. Run npm run start:watch to start the dev server
9. 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]);
    }
});