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);
  });
});

Dez · Accepted Answer · 2018-07-25 20:49:15Z

2

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.

answered Jul 25, 2018 at 20:49

Dez

5,8878 gold badges47 silver badges53 bronze badges

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

1 Comment

A.Kallas Over a year ago

Thank you so much, I can not imagine that it is that simple

Blue · Accepted Answer · 2018-07-25 20:49:25Z

1

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);
  });
});

answered Jul 25, 2018 at 20:49

Blue

23k7 gold badges69 silver badges102 bronze badges

Collectives™ on Stack Overflow

How to write long MySQL queries in node JS

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related