How to write long MySQL queries in node JS

Question

How to write long MySQL queries on many lines instead of one very long line for easy reading and modifying. I only know this way to write them:

app.get('/example', function(req, res){
  x = 'SELECT doctors_schedule.*, employees.employee_name, doctors.degree FROM doctors_schedule JOIN employees ON employees.employee_id = doctors_schedule.doctor_id JOIN doctors ON doctors.doctor_id = employees.employee_id ORDER BY employees.employee_id';
  connection.query(x, function(error, rows, fields){
    if(error){console.log(error);}
    res.json(rows);
  });
});

score 2 · Accepted Answer · answered Jul 25 '18 at 20:49

Use template literals (template strings):

app.get('/example', function(req, res){
  const x = `SELECT doctors_schedule.*, employees.employee_name, doctors.degree 
    FROM doctors_schedule
    JOIN employees ON employees.employee_id = doctors_schedule.doctor_id
    JOIN doctors ON doctors.doctor_id = employees.employee_id
    ORDER BY employees.employee_id`;

  connection.query(x, function(error, rows, fields){
    if(error){
      console.log(error);
    }
    res.json(rows);
  });
});

This feature is available since Node.js v.4.0.0.

Thank you so much, I can not imagine that it is that simple – A.Kallas Jul 25 '18 at 20:52 — A.Kallas, Jul 25 '18 at 20:52

score 1 · Answer 2 · answered Jul 25 '18 at 20:49

es6 brought us template literals. You can use backticks, and span multiple lines easily. Read more about this here:

app.get('/example', function(req, res){
  x = `
     SELECT doctors_schedule.*, employees.employee_name, doctors.degree
     FROM doctors_schedule
     JOIN employees ON employees.employee_id = doctors_schedule.doctor_id
     JOIN doctors ON doctors.doctor_id = employees.employee_id
     ORDER BY employees.employee_id
  `;
  connection.query(x, function(error, rows, fields){
    if(error){console.log(error);}
    res.json(rows);
  });
});

How to write long MySQL queries in node JS

2 Answers2