var mysql = require('mysql');

// First you need to create a connection to the db
var con = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'alphaomega*9',
  database: 'db_taxies'
});

con.connect(function(err){
  if(err){
    console.log('Error connecting to Db');
    return;
  }
  console.log('Berhasil connect to MySQL');
});

var id_devices = 'DV007';

con.query(
    'SELECT * FROM taxi_cars WHERE id_devices =' + mysql.escape(id_devices),
    function(err,rows){
      if(err) throw err;

      console.log('Data received from Db:\n');

      var data = {};
      data['id_taxi_company'] = rows[0].id_taxi_company;
      data['jenis_mobil'] = rows[0].jenis_mobil;
      data['plat'] = rows[0].no_kendaraan;

      var drivers_id = rows[0].id_driver;
      var drivers = getDrivers(drivers_id);
      data['driver'] = drivers;

      console.log(data);

      });

      function getDrivers(driver_id) {
        var drivers = {};
        con.query(
          'SELECT * FROM drivers WHERE id =' + mysql.escape(driver_id),
          function(err, driver) {
            drivers['id'] = driver_id,
            drivers['name'] = driver[0].name,
            drivers['taxi_companies'] = driver[0].taxi_companies,
            drivers['no_hp'] = driver[0].no_hp,
            drivers['id_karyawan'] = driver[0].id_karyawan,
            drivers['status'] = driver[0].status,
            drivers['picture'] = driver[0].picture,
            drivers['created_at'] = driver[0].created_at,
            drivers['updated_at'] = driver[0].updated_at
            // console.log(drivers);

          });
          return drivers;
      }