This now works with dal in trunk:
from gluon.dal import DAL, Field
db=DAL('couchdb://127.0.0.1:5984')
db.define_table('person',Field('name'),Field('age','integer',default=2))
id=db.person.insert(name='Jim')
print id
print db.person(id)
print db(db.person.id==id).update(name="john", age=5)
print db.person(id)
for row in db(db.person.name=='john').select(): print 'row:',row
assert(db(db.person.name=='john').update(name='Tim')==1)
assert(db(db.person.name=='Tim').count()==1)
del db.person[id]
assert(db(db.person.name=='Tim').delete()==0)
I am not sure about boolean, date, time and datetime fields in
searches.
If you can help with tests please report here.
print db(db.person.name=='john')._select()[0]
return the JS code used for the query
