diff options
author | 2017-03-17 08:13:10 +0000 | |
---|---|---|
committer | 2017-03-17 08:13:10 +0000 | |
commit | 5a681846dd3c0ef0dd290384bbbcfe678683d923 (patch) | |
tree | 915be1025ec348a8808fb064dfb0f1a39967363b /utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js | |
parent | be549321b959a27d4c1bedce6d058366eba6e5ac (diff) | |
parent | 0ddfff32a990dda5a487229641aa189161f3d25a (diff) |
Merge "Add vnf, tag create & Associate Plugins"
Diffstat (limited to 'utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js')
-rw-r--r-- | utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js b/utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js new file mode 100644 index 000000000..a5cf09ca7 --- /dev/null +++ b/utils/test/vnfcatalogue/VNF_Catalogue/routes/search_vnf.js @@ -0,0 +1,36 @@ +/******************************************************************************* + * 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 Search Vnf autocomplete form */ +router.get('/', function(req, res) { + tag_partial = req.param('key'); + db_pool.getConnection(function(err, connection) { + + sql_query = 'select vnf_name from vnf where vnf_name like "%'+ tag_partial + '%" limit 5'; + // TODO find why it works and not above + connection.query(sql_query, function (error, results, fields) { + console.log(results); + + var data=[]; + for(i = 0; i < results.length; i++) { + data.push(results[i].vnf_name.replace(/\r?\n|\r/g, '')); + } + console.log(results); + connection.release(); + res.end(JSON.stringify(results)); + + if (error) throw error; + }); + }); +}); + +module.exports = router; |