Hi Massimo,
I tested and get a error now. The problem is that value is None.
Function argument list(self=<gluon.dal.CouchDBAdapter object>,
obj=None, fieldtype='reference auth_user')
Code listing line 3531 pp
-------------------------
value = NoSQLAdapter.represent(self, obj, fieldtype) if
fieldtype=='id': return repr(str(int(value))) elif
fieldtype in ('date','time','datetime','boolean'): return
serializers.json(value) return repr(not
isinstance(value,unicode) and value or value.encode('utf8')) #ERROR
value has not attribute encode
The following tables and records are created in a fresh couchdb after
trying to register a new user.
NAME Number of records
auth_cas 0
auth_event 0
auth_group 1
auth_membership 0
auth_permission 0
auth_user 1
I tested this serverside as my local env isn't setup for couchdb. Let
me set it up and then I can also debug but perhaps you have a
suspicion already. Thanks for your help.
On a different note, I realize that the adapter is still experimental
but before we can use it in production we have to address the
temporary views, which are to expensive to run in prod. Not unlike GAE
and index.yaml, CouchDb views have to be defined upfront. This is not
the thread to discuss it at length but I wonder whether one should
allow temporary views at all. Perhaps DAL should error out if it does
not find a permanent view to to answer a query (one could tell the
developer what view needs to be added...).
Best regards,
HC
On Oct 25, 3:51 am, Massimo Di Pierro <[email protected]>
wrote:
> I made some changes in trunk that should have fixed the date/datetime
> issue but I am not sure. Can you try it?
>
> On Oct 24, 7:25 pm, "H.C. v. Stockhausen" <[email protected]> wrote:
>
>
>
>
>
>
>
> > Hi Massimo,
>
> > thanks for your reply. I don't think CouchDB has a datetime type but
> > the CouchDB-0.8 driver itself maps to and from iso string
> > representations '2007-04-01T15:30:00Z'. See Chapter 4 "Mapping CouchDB
> > documents to Python objects: couchdb.mapping"
> > athttp://packages.python.org/CouchDB/mapping.html
> > Would it make sense for DAL to use couchdb.mapping directly?
>
> > I'd like to help but I don't understand dal well enough yet and in
> > particular the importance of the base class NoSQLAdapter. Does the
> > couchDB adapter really need to derive from it?
>
> > Best regards,
> > HC
>
> > On Oct 23, 5:48 pm, Massimo Di Pierro <[email protected]>
> > wrote:
>
> > > 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
