mucahitnezir / express-starter

🚀 A boilerplate for Node.js api projects with Express.js, Sequelize, PostgreSQL and ES6+

Hi there 👋

express-starter's Issues

Initialization failed while creating first user

Firstly thank you so much for creating a such starter. I'm preparing some stuff around it that may result in a future PR 😉.

The issue is that even if the Postgres starts well, when I want to make an API call to create the first user /auth/register (c.f. documentation about routes), I got the following error :

postgres         | 2021-06-16 08:33:37.651 UTC [50] ERROR:  relation "users" does not exist at character 13
postgres         | 2021-06-16 08:33:37.651 UTC [50] STATEMENT:  INSERT INTO "users" ("firstName","lastName","email","password","updatedAt","createdAt") VALUES ($1,$2,$3,$4,$5,$6) RETURNING *;
node-api    | Executing (default): INSERT INTO "users" ("firstName","lastName","email","password","updatedAt","createdAt") VALUES ($1,$2,$3,$4,$5,$6) RETURNING *;
node-api    | POST /auth/register 500 97.217 ms - 1339

So maybe could you push into the repo a "starting init" SQL file to run with the Postgres at starting because the database is empty at first start and btw it throws errors.

Cheers 🖖