diff options
Diffstat (limited to 'VNF_Catalogue/routes/search_max.js')
-rw-r--r-- | VNF_Catalogue/routes/search_max.js | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/VNF_Catalogue/routes/search_max.js b/VNF_Catalogue/routes/search_max.js new file mode 100644 index 00000000..5fdca19e --- /dev/null +++ b/VNF_Catalogue/routes/search_max.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 Tag autocomplete form */ +router.post('/', function(req, res) { + console.log('here here here here'); + order_key = req.param('order_key'); + db_pool.getConnection(function(err, connection) { + + sql_query = 'select * from vnf order by ' + order_key + ' desc limit 8'; + // TODO find why it works and not above + console.log(sql_query); + connection.query(sql_query, function (error, results, fields) { + console.log(results); + + console.log(results); + connection.release(); + if (error) { + res.end(JSON.stringify({})); + } else { + res.end(JSON.stringify(results)); + } + }); + }); +}); + +module.exports = router; |