orm.coffee

orm = require "orm"

orm.connect "postgresql://postgres:testing@localhost/orm", (success, db) ->
  if not success then console.log db.message
  else
    Place = db.define "place", {
      description:
        type: "string"
      geom:
        type: "geom"
    }
    Place.sync()

    berlin = new Place {
      description: "Berlin"
      geom: "POINT(1 1)"
    }

    berlin.save (error, copy) ->
      if error then console.log error
      else

        console.log berlin.id

        fn = ->
          Place.find { description: "Berlin" }, (places) ->
            if places
              console.log places
              #db._db._client.end()
              db.end()
            else console.log "No place with description Berlin"


        setTimeout fn, 10