From 1f6b18a1974c1b53a079b21b6be39af86deb2432 Mon Sep 17 00:00:00 2001 From: Kumar Rishabh Date: Thu, 29 Jun 2017 11:54:06 +0530 Subject: VNF_Catalogue Codebase Catalogue of Open Source VNFs consist in helping the end users to get information of the VNF we can deploy on top of an OPNFV solution [Deepak]: Removed all swp files. Change-Id: Ib2ea7330e964f1b684f32aedf631accd580df968 Signed-off-by: Kumar Rishabh Signed-off-by: Deepak S --- VNF_Catalogue/routes/search_tag.js | 41 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) create mode 100644 VNF_Catalogue/routes/search_tag.js (limited to 'VNF_Catalogue/routes/search_tag.js') diff --git a/VNF_Catalogue/routes/search_tag.js b/VNF_Catalogue/routes/search_tag.js new file mode 100644 index 00000000..a3a4b946 --- /dev/null +++ b/VNF_Catalogue/routes/search_tag.js @@ -0,0 +1,41 @@ +/******************************************************************************* + * 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 Tag autocomplete form */ +router.get('/', function(req, res) { + tag_partial = req.param('key'); + db_pool.getConnection(function(err, connection) { + + sql_query = 'select tag_name from tag where tag_name like "%'+ tag_partial + '%" and is_vnf_name = false limit 5'; + // TODO find why it works and not above + console.log(sql_query); + connection.query(sql_query, function (error, results, fields) { + console.log(results); + + if(results == null) { + connection.release(); + res.end(JSON.stringify({})); + } else { + var data=[]; + for(i = 0; i < results.length; i++) { + data.push(results[i].tag_name.replace(/\r?\n|\r/g, '')); + } + console.log(results); + connection.release(); + res.end(JSON.stringify(results)); + } + //if (error) throw error; + }); + }); +}); + +module.exports = router; -- cgit 1.2.3-korg