How to conveniently insert a MySQL query as argument into Javascript function?

Question

I have this MySQL query which works fine in Node.js.

connection.query(
    'SELECT reading.device_id,' +
    'reading.temperature,' +
    'reading.humidity,' +
    'reading.light,' +
    'reading.time_taken ' +
    'FROM sensors.reading reading',
    function (err, results, fields) {
        console.log(results);
        console.log(fields);
    }

However, it is inconveniently adding those + signs at the end of each line of the query.

Can I do something like this in javascript similar to what is done in python?

connection.query(
    """SELECT reading.device_id,
        reading.temperature,
        reading.humidity,
        reading.light,
        reading.time_taken
    FROM sensors.reading reading""",
    function (err, results, fields) {
        console.log(results);
        console.log(fields);
    }

Of course, this won't work in javascript. But I am wondering how can I avoid adding those + signs at the end of each line in the query.

KeyNone · Accepted Answer · 2015-07-28 10:21:09Z

1

You can use the backslash:

connection.query(
  "SELECT reading.device_id,\
     reading.temperature,\
     reading.humidity,\
     reading.light,\
     reading.time_taken \
   FROM sensors.reading reading",
  function (err, results, fields) {
    console.log(results);
    console.log(fields);
  }
)

Be aware that this is quite undefined, as this is not part of the ECMA spec. It can break minifiers and may not be supported at all.

answered Jul 28, 2015 at 10:21

KeyNone

9,2904 gold badges37 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to conveniently insert a MySQL query as argument into Javascript function?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related