node.js – Grimtech

swagger project test shows [SyntaxError: Unexpected identifier]

May 20, 2016

I’ve been working with Swagger to make an API server. With it, I created https://myopenbazaar.top. Pretty cool software, but I found testing with it pretty confusing. Swagger abstracts away mochajs, and for whatever reason, Swagger was hiding a stack trace of a failure when I was doing testing.

$ swagger project test
Running tests in: /Users/chrisgrimmett/scripts/imobso2/test...
[SyntaxError: Unexpected identifier]

1

2

3

4

$ swagger project test

Running tests in: /Users/chrisgrimmett/scripts/imobso2/test...

[SyntaxError: Unexpected identifier]

That’s so not helpful! Looking for […]

Bitnet Project

August 31, 2013

| No Comments

| Category: Bitcoin, Linux, Programming

I’m working on what I’m calling a bitnet. In a nutshell, it is a project to monitor and manage crypto currency mining on several remote computers I have at my disposal. There are other projects out there that do this already, but I haven’t found any that meet my requirements or suit my fancy. What […]

node.js node-sqlite3 error

August 27, 2013

| No Comments

| Category: Creative Projects, Linux, Programming

I got this wonderful error when setting up CRUD functions on a little node project I’m working on: { [Error: SQLITE_RANGE: bind or column index out of range] errno: 25, code: 'SQLITE_RANGE' } Here is the code that caused the error:

var row_update = function(index, name, password, comment, callback) {

var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

update.run(name, password, comment, index, function(err) {
if (err) {
console.log(err);
callback(err);

} else {
callback(0);
}
});
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

var row_update = function(index, name, password, comment, callback) {

var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

update.run(name, password, comment, index, function(err) {

if (err) {

console.log(err);

callback(err);

} else {

callback(0);

}

});

}

The problem here is that I enclosed the question mark placeholders in single quotes:

var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

1	var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

Here is the corrected code which executes without error:

var row_update = function(index, name, password, comment, callback) {

    var update = db.prepare("UPDATE workers SET name = ?, password = ?, comment = ? WHERE id = ?");

    update.run(name, password, comment, index, function(err) {
        if (err) {
            console.log(err);
            callback(err);

        } else {
            callback(0);
        }
    });
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

var row_update = function(index, name, password, comment, callback) {

var update = db.prepare("UPDATE workers SET name = ?, password = ?, comment = ? WHERE id = ?");

update.run(name, password, comment, index, function(err) {

if (err) {

console.log(err);

callback(err);

} else {

callback(0);

}

});

}

greetz

Grimtech

Tag: node.js

swagger project test shows [SyntaxError: Unexpected identifier]

Bitnet Project

node.js node-sqlite3 error

About Me

Main Navigation

Recent Posts

My Top 10 Sad Vocaloid Songs

Happy Sakuracon 2019!

Contact Info