This is very helpful. I was expecting this problem. How are datetimes supposed to be stores in CouchDB?
On Oct 22, 3:13 am, "H.C. v. Stockhausen" <[email protected]> wrote: > Hi > > I am just testing the CouchDB Adapter and it fails when registering a > new user. I tired both w2py's default auth and janrain. The problem > appears to be the time_stamp field. > > - w2py Version 1.99.2 (2011-09-26 06:55:33) stable > - driver CouchDB-0.8-py2.6.egg > > Traceback > ======== > File "/home/hcvst/web2py/gluon/dal.py", line 3510, in insert > ctable.save(values) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/client.py", line 407, in save > _, _, data = func(body=doc, **options) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 405, in put_json > status, headers, data = self.put(*a, **k) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 384, in put > return self._request('PUT', path, body=body, headers=headers, > **params) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 419, in _request > credentials=self.credentials) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 239, in request > resp = _try_request_with_retries(iter(self.retry_delays)) > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 196, in _try_request_with_retries > return _try_request() > File "/usr/local/lib/python2.6/dist-packages/CouchDB-0.8-py2.6.egg/ > couchdb/http.py", line 222, in _try_request > chunk = body.read(CHUNK_SIZE) > AttributeError: 'dict' object has no attribute 'read' > > DAL CODE (dal.py at line 3510) > ========= > def insert(self,table,fields): > id = uuid2int(web2py_uuid()) > ctable = self.connection[table._tablename] > values = dict((k.name,NoSQLAdapter.represent(self,v,k.type)) > for k,v in fields) > values['_id'] = str(id) > ctable.save(values) # line 3510 > > DRIVER CODE (..egg/couchdb/http.py in _try_request at line 222) > ============ > if body is not None: > if isinstance(body, str): > conn.sock.sendall(body) > else: # assume a file-like object and send in > chunks > while 1: > chunk = body.read(CHUNK_SIZE) # line 222 > > BODY VARIABLE > ============== > {'_id': '156782505411822007491552899341462059095', 'client_ip': > u'127.0.0.1', 'description': u'Group > 128304130898558275345572010972780625739 created', 'origin': u'auth', > 'time_stamp': datetime.datetime(2011, 10, 22, 3, 48, 48, 413381), > 'user_id': None} > > The problem is probably that the BODY time_stamp attribute of type > datetime cannot be JSON serialized but I don't know dal.py well enough > to say what NoSQLAdapter.represent should return. > > Best regards, > HC
