function deletePlugin(req, res, next)
{
console.log("Enter deletePlugin");
var plugin_name = req.query.plugin_name;
var vendorID = req.session.vendorID;
console.log(plugin_name);
var query_str = "DELETE FROM " + db.plugin_table
+ " WHERE vendor_id = '"
+ vendorID
+ "' and plugin_name = '"
+ plugin_name
+ "';"
console.log(query_str);
var db_query = client.query(query_str);
db_query.res = res;
db_query.on('end', deletePluginHandler);
db_query.on('error', db_error_handler);
}
function addPlugin(req, res, next)
{
console.log("Enter addPlugin");
console.log(req.session.vendorID);
console.log(req.body);
console.log("Exit addPlugin");
var insert_str = "INSERT INTO " + db.plugin_table
+ " VALUES('"
+ req.session.vendorID + "', '"
+ req.body.plugin_name + "', '"
+ req.body.plugin_desc
+ "');";
console.log(insert_str);
var db_query = client.query(insert_str);
db_query.req = req;
db_query.res = res;
db_query.on('end', insert_end_handler);
db_query.on('error', db_error_handler);
}
function queryAllPlugin(req, res, next)
{
console.log("Enter queryAllPlugin");
console.log(req.session.vendorID);
var vendorID = req.session.vendorID;
var query_str = "SELECT * from " + db.plugin_table
+ " WHERE vendor_id = '"
+ vendorID
+ "';";
console.log(query_str);
var db_query = client.query(query_str);
db_query.req = req;
db_query.res = res;
db_query.rows = new Array();
db_query.on('row', db_row_handler);
db_query.on('end', queryAllPluginHandler);
}