Student_Instance1.js

/*
*
*
*/

// call the packages we need
var express    = require('express');        // call express
var app        = express();                 // define our app using express
var bodyParser = require('body-parser');
var configSchema = require('./config_student.js');
var student = require('./student.js');


// configure app to use bodyParser()
// this will let us get the data from a POST
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());


var port = process.env.PORT || 16386;        // set our port


// ROUTES FOR OUR API
// =============================================================================
var router = express.Router();              // get an instance of the express Router


// middle-ware to use for all requests
router.use(function(req, res, next) {
  // do logging
  console.log('Something is happening.');
  next(); // make sure we go to the next routes and don't stop here
});


// test route to make sure everything is working (accessed at GET http://localhost:16386/api)
router.get('/', function(req, res) {
  // Logic to show student here
  res.json({ message: 'Welcome to our student Instance 1 api!!' });
});

// more routes for our API will happen here


/************************************************************
*
* Student API Endpoints
*
*************************************************************/


//API endpoint to add student to the students table
router.route('/student')

// create a new student (accessed at POST http://localhost:16386/api/student)
.post(function(req, res) {
  student.addStudent(req,res,handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Student added!' , returnStatus : '200'});

    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!' , returnStatus : '500' });

    }
    else if(response.statusCode == 409){
      console.log('409');
      res.status(409);
      res.json({ message: 'Student already exists.' , returnStatus : '409'});

    }
  }
});




//API end point to get student details (accessed at GET http://localhost:16386/api/student/id)
router.route('/student/:student_id')

// get the student with that id (accessed at GET http://localhost:16386/api/student/:student_id)
.get(function(req, res) {

  // Logic to show student here
  student.getStudentDetails(req,res,handleResult);
  function handleResult(response, body, err)
  {
      if(err)
      {
          console.error(err.stack || err.message);
          return;
      }
      else {

          console.log("After parse" + body.cid);
          if(response.statusCode == 200){
            console.log('200');
            res.status(200);
            res.json({ message: body, returnStatus : '200'});

          }

          else if(response.statusCode == 404){
            console.log('404');
            res.status(404);
            res.json({ message: 'Does not exist', returnStatus : '404'});

          }

        }

  }

})


.delete(function(req, res) {

  student.deleteStudent(req,res,handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');

      res.status(200);
      res.json({ message: 'Successfully deleted student' , returnStatus : '200'});
      console.log(res);

    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!' , returnStatus : '500'});

    }
    else if(response.statusCode == 417){
      console.log('417');
      res.status(417);
      res.json({ message: 'Cannot delete a student that does not exist', returnStatus : '417'});

    }
  }
})
// Logic to show student here
// res.json({ message: 'Student details from Student Instance 1!' });



// update the student with this id (accessed at PUT http://localhost:16386/api/student/:student_id)
.put(function(req, res) {
  //Logic to update student details here

  student.updateStudent(req,res,handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Student updated!', returnStatus : '200'});

    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!', returnStatus : '500'});

    }
    else if(response.statusCode == 400){
      console.log('400');
      res.status(400);
      res.json({ message: 'Bad request. Please check body parameters.', returnStatus : '400'});

    }
    else if(response.statusCode == 417){
      console.log('417');
      res.status(417);
      res.json({ message: 'Cannot update a student that does not exist', returnStatus : '417'});

    }


  }

  //res.json({ message: 'Student updated!' });


});

router.route('/student/:student_id/course')

.post(function(req, res) {
  console.log("Entering Post of Student Instance 1");
  student.addCoursetoStudent(req, res, handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Student updated!', returnStatus : '200'});

    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!', returnStatus : '500'});

    }
    else if(response.statusCode == 417){
      console.log('417');
      res.status(417);
      res.json({ message: 'Invalid operation. Either student does not exist or student is already enrolled in the course.', returnStatus : '417'});

    }
  }




  // res.json({ message: 'Added course to student'})
});
router.route('/table/:tableName/column')

.post(function(req, res) {
  //Add functionality here for adding column.
  configSchema.addColumn(req,res,handleResult);
  function handleResult(response)
  {
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Student schema updated', returnStatus : '200'});
    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!', returnStatus : '500'});

    }
  }




  // res.json({ message: 'Added course to student'})
});


router.route('/table/:tableName/column/:columnId')

.delete(function(req, res) {
  //Add functionality here for removing column.
  configSchema.deleteColumn(req,res,handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log(response);
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Table updated!', returnStatus : '200'});
    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!', returnStatus : '500'});

    }
    else if(response.statusCode == 417){
      console.log('417');
      res.status(417);
      res.json({ message: 'Expectation Failed. Invalid Operation.', returnStatus : '417'});

    }
  }// res.json({ message: 'Added course to student'})
});



//API end point to get student details (accessed at POST http://localhost:8080/api/student/id)
router.route('/student/:student_id/course/:course_id')

// get the student with that id (accessed at GET http://localhost:8080/api/student/:student_id)
// .get(function(req, res) {

// })
.delete(function(req, res) {

  student.deleteCourseFromStudent(req, res, handleResult);
  function handleResult(response)
  {
    console.log('Callback received');
    console.log("Status code " +response.statusCode);
    if(response.statusCode == 200){
      console.log('200');
      res.status(200);
      res.json({ message: 'Student updated!', returnStatus : '200'});
    }

    else if(response.statusCode == 500){
      console.log('500');
      res.status(500);
      res.json({ message: 'Internal Server Error!', returnStatus : '500'});

    }
    else if(response.statusCode == 417){
      console.log('417');
      res.status(417);
      res.json({ message: 'Invalid Operation. Either student does not exist or student is not enrolled in the course', returnStatus : '417'});

    }
  }
//res.json({ message: 'Course deleted from student'})

});


// REGISTER OUR ROUTES -------------------------------
// all of our routes will be prefixed with /api
app.use('/api', router);

// START THE SERVER
// =============================================================================
app.listen(port);
console.log('Magic happens on port ' + port);