search

storeness / meteor-postgres

Postgres Collections for Meteor
48 stars 7 forks source link

Can't select existing table/collection #3

Open kkappel opened 8 years ago

kkappel commented 8 years ago

What does the log say? Sorry I'm lost...

meteor create jmapp
meteor add storeness:meteor-postgres
jm = new SQL.Collection('jm');

if (Meteor.isClient) {
  Template.body.helpers({
    jms: function () {
        return jm.select().fetch();
    }
  });
}

if (Meteor.isServer) {
  jm.publish('jm', function(){
      return jm.select();
  });
}
<body>
  <div class="container">
    <header>
      <h1>Anwesenheitsliste</h1>
    </header>
    <ul>
      {{#each jms}}
      {{> jme}}
      {{/each}}
    </ul>
  </div>
</body>

<template name="jme">
  <li>{{Vorname}} {{Nachname}} Zimmer {{Zimmer}}</li>
</template>

MP_POSTGRES=postgres://foo:bar@dev2.juhiwue.de:5432/jmdb meteor --port=3010

I20151022-17:31:23.710(2)? init 0 I20151022-17:31:23.796(2)? Exception from sub jm id 7W9KZDviw4iqdJ9n6 TypeError: Cannot read property 'submit' of undefined I20151022-17:31:23.797(2)? at [object Object].Client.query (/home/kkappel/.meteor/packages/storeness_meteor-postgres/.0.2.1.9y08wy++os+web.browser+web.cordova/npm/node_modules/pg/lib/client.js:311:29) I20151022-17:31:23.797(2)? at autoSelectHelper (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:645:1) I20151022-17:31:23.797(2)? at loadAutoSelectClient (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:641:1) I20151022-17:31:23.797(2)? at Array.SQL.Server.autoSelect (packages/storeness_meteor-postgres/packages/storeness_meteor-postgres.js:674:1) I20151022-17:31:23.797(2)? at Object._publishCursor (packages/storeness_meteor-postgres/packages/storenessmeteor-postgres.js:928:1) I20151022-17:31:23.797(2)? at [object Object]..extend._runHandler (livedataserver.js:1059:13) I20151022-17:31:23.798(2)? at [object Object]..extend._startSubscription (livedataserver.js:842:9) I20151022-17:31:23.798(2)? at [object Object]..extend.protocol_handlers.sub (livedata_server.js:614:12) I20151022-17:31:23.798(2)? at livedata_server.js:548:43 I20151022-17:31:29.955(2)? auto 1