I like this modular MVC structure. But how can add socket.io support to this structure?

Actually i got confused with www file!

Hi there, thanks for the tutorial!

Seems that I'm getting an incorrect response when using postman to update a todo or any action (apart from a GET on the /api).

I noticed this after following the tutorial through, so thought I must have messed up somewhere. To double-check I downloaded this repo and ran the app (after running the sequelize db:migrate command). Still seem to be getting the wrong response back, compared with what the tutorial suggests I should be getting back.

Example:

GET http://127.0.0.1:8000/api/todos
(using Postman, no headers or auth set)

Response:

    "name": "SequelizeConnectionError",
    "parent": {
        "name": "error",
        "length": 99,
        "severity": "FATAL",
        "code": "28000",
        "file": "miscinit.c",
        "line": "502",
        "routine": "InitializeSessionUserId"
    },
    "original": {
        "name": "error",
        "length": 99,
        "severity": "FATAL",
        "code": "28000",
        "file": "miscinit.c",
        "line": "502",
        "routine": "InitializeSessionUserId"
    }

Am I missing something here? Any help very welcome!

Hi, I read your tutorial and I love it.
I'm getting this error in the section for creating todo items:

"parent": {
"name": "error",
"length": 128,
"severity": "ERROR",
"code": "42703",
"position": "31",
"file": "parse_target.c",
"line": "954",
"routine": "checkInsertTargets",
"sql": "INSERT INTO "TodoItems" ("id","content","complete","createdAt","updatedAt","todoId") VALUES (DEFAULT,'',false,'2017-10-08 19:33:17.599 +00:00','2017-10-08 19:33:17.599 +00:00','1') RETURNING *;"

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

When trying to create the controllers for creating new todos I get the following error: "TypeError: Cannot read property 'create' of undefined" when calling the API from Postman.

The part of the code where the error happens:
module.exports = {
create(req, res) {
return Todo
.create({ # This is the problem part
title: req.body.title,
})
.then(todo => res.status(201).send(todo))
.catch(error => res.status(400).send(error));
},
};

I'm not super familiar with ES6 syntax so I really don't know if I need to refactor this code

Regarding the server/controllers/todos.js snippet in the Listing todos section, “.all()” should be replaced with “.findAll()” - at least that resolved my “.all() is not a function” error.

Hi,
This is not an issue. Just a question.

Are there any best practices where to keep the files which access the postgres functions/stored procedures in your project? I liked the best practices mentioned here. Would like to know about functions.
Regards,
Manik Mittal

at the time running of nodemon app.js it shows the following error :
sequelize deprecated String based operators are now deprecated. Please use Symbol based operators for better security, read more at http://docs.sequelizejs.com/manual/tutorial/querying.html#operators node_modules/sequelize/lib/sequelize.js:236:13

Testing the API route for creating new todo items, the todoId field is null and I've followed every step of the tutorial but can't debug