Advertisement
Guest User

Untitled

a guest
Feb 19th, 2018
284
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. 'use strict';
  2.  
  3. const express = require('express')
  4. const app = express()
  5. const port = 8080
  6.  
  7. const pg = require('pg');
  8. const connectionString = process.env.DATABASE_URL || 'postgres://UXNFVOcn6Taob4ua:evAq4ilbedRuI9Ch@10.11.241.42:41658/FwWwKlzcwomdv8_l';
  9.  
  10. const client = new pg.Client(connectionString);
  11. client.connect();
  12.  
  13.  
  14. app.get('/', (request, response) => {
  15. const res = await client.query('SELECT $1::text as message', ['Hello world!'])
  16. console.log(res.rows[0].message) // Hello world!
  17. response.end(JSON.stringify(res.rows[0].message))
  18. })
  19.  
  20. app.post('/kek', (request, response) => {
  21. str = 'kek';
  22. response.send('OK')
  23. })
  24.  
  25. app.listen(port, (err) => {
  26. if (err) {
  27. return console.log('something bad happened', err)
  28. }
  29.  
  30. console.log(`server is listening on ${port}`)
  31. })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement