I see your point now, you meant a Rows instance (kind of a subset of a table) Would you post the exception (if any), when trying to read the query result?
The point is that the select method has to instantiate properly a Rows object Have you read this web2py API section? http://web2py.com/examples/static/epydoc/web2py.gluon.dal.Rows-class.html I think it could help. That is the object wich is to be returned by a correct select Note that the Rows instance is normally returned by this web2py statement: dal_instance(query_object).select(*arguments) On Dec 3, 7:36 pm, Alan Etkin <[email protected]> wrote: > When you say that you try to convert a collection to arow, isn't > there a conflict with database systems? > > I looking for the first time themongodbdatabase design, and i assume > there is got to be some sort of mapping of objects: > > - A DAL Table is like a Collection > - A DALRowis (more or less) like a Document > - A DAL Field is like any object stored inside the Document at the > root Document level > > As long as there is not more depth in themongodbobject than the > described, the parsing by using a json like simplejson or similar > interface should be straightforward. I think this goes beyond my > database skills but i would like to see the interface implemented if > it is available (and shared) somewhere. > > Thanks for your feedback > > On Dec 3, 12:35 pm, Mark Breedveld <[email protected]> wrote: > > > I'm currently modifing the DAL.py file to get DAL working withmongoDB. I > > got the insert part working, but the of the select method. So __select is > > working, but select() ain't. Because I need to convert a pymongo collection > > to arow. The line I point to has been written by Massimo, but isn't > > working. I have no idea's at the moment to do this in a general way. The > > returned value is a dict or a list of dict's, but of course not formatted in > > a DAL way. > > > -----Oorspronkelijk bericht----- > > Van: [email protected] [mailto:[email protected]] Namens Alan > > Etkin > > Verzonden: zaterdag 3 december 2011 17:14 > > Aan: web2py-users > > Onderwerp: [web2py] Re: Convertingmongodbcollection torow > > > Mark, i don't understand your post. Did you modify web2py code? Could you > > provide a little background on the interface you are working on? > > Thank you > > > On Nov 30, 10:50 am, Mark Breedveld <[email protected]> wrote: > > > > I have got the select function ofmongodbadapter working, but know I > > > need to convert a pymongo cursor torow. > > > The point is the pymongo supports nested documents and that can be a > > > bit hard to convert for a parameter of the parse method. > > > > Here is the select function a have ajusted, but this one won't work > > > with yours because I also altered a lot of other functions. But this > > > is to get the idea. The line that has to be changed is pointed to with > > > <-- > > > def select(self,query,fields,attributes): > > > #if not isinstance(query,Query): > > > # raise SyntaxError, "Not Supported" > > > definition = self._select(query,fields,attributes) > > > > ctable = self.connection[str(definition['tablename'])] > > > if ((definition['sort'] == None) & (definition['skip'] == > > > None)): > > > result = ctable.find(definition['query']) > > > elif((definition['sort'] != None) & (definition['skip'] == > > > None)): > > > result = > > > ctable.find(definition['query']).sort(definition['sort']) > > > elif((definition['sort'] == None) & (definition['skip'] != > > > None)): > > > result = > > > ctable.find(definition['query']).skip(definition['skip']) > > > elif((definition['sort'] != None) & (definition['skip'] != > > > None)): > > > result = > > > ctable.find(definition['query']).sort(definition['sort']).skip(definit > > > ion['skip']) > > > else: > > > raise RuntimeError, "No valid query information found" > > > print str(result) > > > #rows = [cols['value'] for cols in result] <--- This line > > > converts the result to be parsed > > > return self.parse(rows, definition['colnames'], False) > > > > Anyone with advise on the matter or ideas? > > > ----- > > Geen virus gevonden in dit bericht. > > Gecontroleerd door AVG -www.avg.com > > Versie: 2012.0.1873 / Virusdatabase: 2102/4653 - datum van uitgifte: > > 12/02/11 > >
