var zazler = require('zazler');

guide = zazler.db('guide', 'postgresql://giid:alfa@127.0.0.1:5434/guide',
{
  // which tables/fields are accessible
  "read" : "guide(id) guide_lang guide_img feedback request",

  // use basic authentication if needed
  "auth": { "table": "usr", "select": "id,login", "where": "login=req.user:password=req.passMd5", realm: "Guide" },

  "filters":
  [ { "table": "guide_img", "where": "isnull(deleted_at)" }
  ], // only show not deleted images

  "write-rules":
  [ { "table": "feedback", "on": "true", "action": "insert", "set": { "usr: "auth.id" } } ]
});

zazler.listen(9000);
// now access http://127.0.0.1:9000/guide/