Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. test.js:27
  2. export async function vList() {
  3. ^^^^^^
  4. SyntaxError: Unexpected token export
  5.  
  6. const sql = require('mssql');
  7.  
  8. const config = {
  9. user: 'sa',
  10. password: 'pwd',
  11. server: '192.168.10.24',
  12. database: 'vmaint'
  13. };
  14.  
  15. let aList;
  16.  
  17. async function getList() {
  18. try {
  19. let pool = await sql.connect(config);
  20. let result = await pool
  21. .request()
  22. .query('SELECT item1, item2, item3, item4 FROM items');
  23.  
  24. aList = result.recordset;
  25. console.dir(aList);
  26. pool.close();
  27. } catch (err) {
  28. console.log(err);
  29. }
  30. }
  31.  
  32. export async function vList() {
  33. if (!aList) {
  34. await getList();
  35. }
  36. if (!aList) {
  37. throw new Error('Could not get items');
  38. }
  39. return aList;
  40. }
  41. // getList();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement