Guest User

Untitled

a guest
Feb 18th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. function GetTableData() {
  2.  
  3.  
  4. var connection = mysql.createConnection({
  5. host: setup.host,
  6. user: setup.user,
  7. password: setup.password,
  8. database: setup.database
  9. });
  10.  
  11. connection.connect();
  12. var query = connection.query("SELECT * FROM tables", function (error, result) {
  13. if (error) { console.log(error.message); throw error; }
  14.  
  15. jdata = JSON.stringify(result);
  16.  
  17. console.log('mod_mysql_GetTables:AppData:' + jdata);
  18. return jdata;
  19.  
  20. });
  21.  
  22. connection.end(function () {
  23. console.log('Connection Close!');
  24.  
  25. });
  26. function GetTest(){
  27. var x =5 ;
  28. return x;
  29. }
  30.  
  31. module.exports.GetTableData = GetTableData();
  32. module.exports.GetTest = GetTest();
  33.  
  34. var mod_mysql = require('./mod_mysql');
  35. var tables = mod_mysql.GetTableData;
  36. console.log(tables);
Add Comment
Please, Sign In to add comment