diff options
Diffstat (limited to 'VNF_Catalogue/routes/vnf_tag_association.js')
-rw-r--r-- | VNF_Catalogue/routes/vnf_tag_association.js | 75 |
1 files changed, 75 insertions, 0 deletions
diff --git a/VNF_Catalogue/routes/vnf_tag_association.js b/VNF_Catalogue/routes/vnf_tag_association.js new file mode 100644 index 00000000..24ad5995 --- /dev/null +++ b/VNF_Catalogue/routes/vnf_tag_association.js @@ -0,0 +1,75 @@ +/******************************************************************************* + * Copyright (c) 2017 Kumar Rishabh and others. + * + * All rights reserved. This program and the accompanying materials + * are made available under the terms of the Apache License, Version 2.0 + * which accompanies this distribution, and is available at + * http://www.apache.org/licenses/LICENSE-2.0 + *******************************************************************************/ + +var express = require('express'); +var router = express.Router(); + +/* Post controller for VNF_TAG Association */ +router.post('/', function(req, res) { + req.checkBody("tag_name", "TAG Name must not be empty").notEmpty(); + req.checkBody("vnf_name", "VNF Name must not be empty").notEmpty(); + + var errors = req.validationErrors(); + console.log(errors); + + var response = ''; for(var i = 0; i < errors.length; i++) { + console.log(errors[i]['msg']); + response = response + errors[i]['msg'] + '; '; + } + + if(errors) { res.status(500); + res.send({'error': response}); + return; + } + + var tag_name = req.param('tag_name').toLowerCase(); + var vnf_name = req.param('vnf_name').toLowerCase(); + + db_pool.getConnection(function(err, connection) { + sql_query = 'select vnf_tag_id from vnf_tags where vnf_id = (select vnf_id from vnf where vnf_name = \'' + vnf_name + '\' limit 1) and tag_id = (select tag_id from tag where tag_name = \'' + tag_name + '\' and is_vnf_name = 0 limit 1)'; + console.log(sql_query); + connection.query(sql_query, function (error, results, fields) { + console.log(results); + if (results.length >= 1) { + connection.release(); + res.status(500); + res.send('{"error" : "Tag VNF connection already exists...."}'); + return; + } else { + // Use the connection + //sql_query = 'INSERT INTO tag SET ?' + sql_query = 'insert into vnf_tags(vnf_id, tag_id) values ((select vnf_id from vnf where vnf_name = \'' + vnf_name + '\' limit 1), (select tag_id from tag where tag_name = \'' + tag_name + '\' and is_vnf_name = 0 limit 1))'; + console.log(sql_query); + connection.query(sql_query, function (error, results, fields) { + // And done with the connection. + + connection.release(); + + // Handle error after the release. + if (error) { + console.log(error); + res.status(500); + res.send({'error' : 'Adding vnf tag association did not succeed, Check names(rely on autocomplete)'}); + return; + } else { + res.end('{"success" : "Updated Successfully", "status" : 200}'); + return; + } + // Don't use the connection here, it has been returned to the pool. + }); + } + }); + + }); + + //res.end('{"success" : "Updated Successfully", "status" : 200}'); + //res.render('vnf_tag_association', { title: 'Express' }); +}); + +module.exports = router; |