Guest User

Untitled

a guest
Jun 2nd, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. var pg = require("pg");
  2. var rest;
  3.  
  4. var pool = new pg.Pool({
  5. host:"***",
  6. port:"***",
  7. user:"***",
  8. password:"****",
  9. database:"***"
  10. });
  11.  
  12. pool.connect(function(err, client, done) {
  13. if (err)
  14. console.log("connect " + err.toString());
  15. else
  16. client.query('SELECT *' +
  17. 'FROM public."GeneralInfo";', function(err, result) {
  18.  
  19. if (err)
  20. console.log("query " + err.toString());
  21. else {
  22. console.log(result.rows[0]);
  23. rest = result.rows[0];
  24. }
  25. done();
  26. });
  27. });
  28. pool.end();
  29.  
  30. module.exports.res = rest;
  31.  
  32. var express = require('express');
  33. var connectResult = require('./ConnectDB/connect');
  34.  
  35. app.get("/",function (req,res) {
  36. console.log(connectResult);
  37. res.send(connectResult);
  38. });
  39.  
  40. var controller = function ($scope,$http) {
  41. $http.get("http://localhost:8080").then (function (response) {
  42. console.log("I get date with DB");
  43. console.log(response);
  44. $scope.dateWithDb = response;
  45. },function (res) {console.log(res.toString()) });
  46. }
  47. angular.module("DB",[]).controller("controller",controller);
  48.  
  49. <!DOCTYPE html>
  50. <html lang="en" ng-app = DB>
  51. <head>
  52. <meta charset="UTF-8">
  53. <title>Title</title>
  54. </head>
  55. <body ng-controller="controller">
  56. <h1>{{dateWithDb}}</h1>
  57. <script src="./angular/angular.min.js"></script>
  58. <script src="./javascripts/controllerInfo.js"></script>
  59. </body>
  60. </html>
  61.  
  62. app.listen(8000, () => {
  63. console.log('Сервер стартовал!');
  64. });
Add Comment
Please, Sign In to add comment