The express-starter's discuss from mucahitnezir

mucahitnezir / express-starter Goto Github PK

View Code? Open in Web Editor NEW

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

License: MIT License

JavaScript 98.56% Dockerfile 1.44%

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 🖖

Recommend Projects