SequelizeDatabaseError

[shivanandbhangari]

Nice tutorial sir, but i am getting Dequelize DatabaseError while trying to request localhost:8000/api/todos in postman. The below is the output

{
"name": "SequelizeDatabaseError",
"parent": {
"name": "error",
"length": 115,
"severity": "ERROR",
"code": "42P01",
"position": "13",
"file": "src\backend\parser\parse_relation.c",
"line": "984",
"routine": "parserOpenTable",
"sql": "INSERT INTO "Todos" ("id","title","createdAt","updatedAt") VALUES (DEFAULT,'first-todo','2017-06-15 06:11:49.889 +00:00','2017-06-15 06:11:49.889 +00:00') RETURNING *;"
},
"original": {
"name": "error",
"length": 115,
"severity": "ERROR",
"code": "42P01",
"position": "13",
"file": "src\backend\parser\parse_relation.c",
"line": "984",
"routine": "parserOpenTable",
"sql": "INSERT INTO "Todos" ("id","title","createdAt","updatedAt") VALUES (DEFAULT,'first-todo','2017-06-15 06:11:49.889 +00:00','2017-06-15 06:11:49.889 +00:00') RETURNING *;"
},
"sql": "INSERT INTO "Todos" ("id","title","createdAt","updatedAt") VALUES (DEFAULT,'first-todo','2017-06-15 06:11:49.889 +00:00','2017-06-15 06:11:49.889 +00:00') RETURNING *;"
}

Can you please help me out to resolve this error. Thank you

[waiyaki]

Hey @shivanandbhangari.

After creating the db and writing the code for models and the migrations, make sure you run

sequelize db:migrate

to actually create the necessary tables in the db.
Let me know if that fixes that issue.

[shivanandbhangari]

@waiyaki
Yes it works thanks a lot Waiyaki. Super exapmle, learnt lot from this code. Thank you once again.

[waiyaki]

Great, thank you!

[jerrychong25]

Hey @shivanandbhangari.

After creating the db and writing the code for models and the migrations, make sure you run

sequelize db:migrate

to actually create the necessary tables in the db.
Let me know if that fixes that issue.

Thanks!