Advertisement
Guest User

Untitled

a guest
Feb 29th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. messages = new MysqlSubscription('getMessages');
  2.  
  3. messages.addEventListener('update', function(diff, data) {
  4. console.log("Event listener");
  5. });
  6.  
  7. if (Meteor.isClient) {
  8. Template.messageHistory.helpers({
  9. messages: function () {
  10. return messages.reactive();
  11. }
  12. });
  13. }
  14. if (Meteor.isServer) {
  15.  
  16. var Tunnel = Meteor.npmRequire('tunnel-ssh');
  17. var config = {
  18. host: "ourhost",
  19. username: "uname",
  20. password: "password",
  21. port:22,
  22. dstPort:3306,
  23. srcPort:3307,
  24. };
  25.  
  26. Tunnel.tunnel(config, function(err) { (err == null) ? console.log(config) : console.log(err) })
  27.  
  28. var liveDb = new LiveMysql({
  29. host:"localhost",
  30. port:3307,
  31. database: "db",
  32. user: "root",
  33. password: "password"
  34. });
  35.  
  36. Meteor.publish('getMessages', function() {
  37. return liveDb.select(
  38. 'SELECT * FROM messages ORDER BY Timestamp',
  39. [ { table: 'messages' } ]
  40. );
  41. });
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement