server.js

/*var http = require('http');
var app = require('./app');

http.createServer(app.handleRequest).listen(8000);*/
var express = require('express');
var app = express();

var dockerCLI = require('docker-cli-js');
var DockerOptions = dockerCLI.Options;
var Docker = dockerCLI.Docker;

var docker = new Docker();

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'localhost',
  user     : 'root',
  password : 'root',
  database : 'CLOUD'
});

connection.connect(function(err){
  if(err)
    throw err;
});

app.use(function(req, res, next) {
  res.header("Access-Control-Allow-Origin", "*");
  res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
  next();
});

app.get('/', function (req, res) {
    res.sendFile( __dirname + "/" + "index.html" );
 });

app.get('/login', function (req, res) {
  var name = req.query.userName;
  var pass = req.query.pass;
      connection.query('SELECT password from login WHERE username = ?',[name], function(err, rows, fields){
        if(err) throw err;
        if(rows.length>0){
            if(rows[0].password == pass){
                res.json({
                  status: true,
                  message: "Successfully Logged In"
                });
            }else{
                res.json({
                  status:false,
                  message:"password invalid"
                });
            }
        }else{
          res.json({
            status:false,
            message:"Invalid username"
          });
        }
     });//query ends
});

app.get('/signup', function (req, res) {
  var values ={
  username:req.query.userName,
  password:req.query.pass
  }
      connection.query('INSERT INTO login SET ?',[values], function(err, rows, fields){
        if(err){
          if(err.code=='ER_DUP_ENTRY'){
            res.json({
              status:false,
              message:"User Already exists"
            });
          }else{
            throw err;
          }
        }else{
          res.json({
            status:true,
            message:"User Created Successfully"
          });
        }
     });//query ends
});

app.get('/dashboard/sysinfo',function(req,res){
    docker.command('info',function (err, data) {
      res.json(data.object);
    });
});

app.get('/dashboard/containers',function(req,res){
    docker.command('ps -a --no-trunc',function (err, data) {
      var name = req.query.userN;
      connection.query('SELECT cId from containerInfo WHERE username = ?',[name], function(err, rows, fields){
        if(err) throw err;
        res.json({
          data:data.containerList,
          containerIds:rows
        })
      });//query ends
    });
});

app.get('/dashboard/networking',function(req,res){
  var name = req.query.userN;
  connection.query('SELECT cId from containerInfo WHERE username = ?',[name], function(err, rows, fields){
    if(err) throw err;
    res.json({
      containerIds:rows
    })
  });//query ends
});

app.get('/dashboard/inspect',function(req,res){
  var id = req.query.id;
    docker.command('inspect '+id,function (err, data) {
      res.json(data.object[0]);
    });
});

app.get('/dashboard/containers/start',function(req,res){
  id = req.query.id;
  docker.command('start '+id,function(err,data){
    if(err){
      res.json({
        status:false
      });
    }else{
      res.json({
        status:true
      });
    }
  });
});

app.get('/dashboard/containers/stop',function(req,res){
  id = req.query.id;
  docker.command('stop '+id,function(err,data){
    if(err){
      res.json({
        status:false
      });
    }else{
      res.json({
        status:true
      });
    }
  });
});

app.get('/dashboard/containers/del',function(req,res){
  id = req.query.id;
  docker.command('rm '+id,function(err,data){
    if(err){
      res.json({
        status:false
      });
    }else{
      connection.query('delete from containerInfo where cId=?',[id], function(err, rows, fields){
        if(err){
          throw err;
        }else{
          console.log(rows);
          res.json({
            status:true
          });
        }
      });//query ends

    }
  });
});

app.get('/dashboard/create',function(req,res){
    docker.command('images',function (err, data) {
      res.json(data.images);
    });
});

app.get('/dashboard/createContainer',function(req,res){
  imageName = req.query.imageName;
  containerName = req.query.containerName;
  userN =req.query.userN;
    if(containerName==''){
      cmd =imageName;
    }else{
      cmd ='--name '+containerName+' '+imageName;
    }
    docker.command('create -t '+cmd,function(err,data){
        if(data=='null'){
          res.json({
            status:false
          });
        }else{
          var values ={
            cId:data.raw,
            username:req.query.userN
          }
            connection.query('INSERT INTO containerInfo SET ?',[values], function(err, rows, fields){
              if(err){
                throw err;
              }else{
                res.json({
                  status:true
                });
              }
           });//query ends
        }
    });
});
var server = app.listen(8000, function () {
  var port = server.address().port

  console.log("Example app listening at port %s",port)
})