I will. Thanks Paolo. Regards, Ron
On Sunday, May 10, 2015 at 11:49:37 AM UTC-4, Paolo Valleri wrote: > > Hi Ron, please open an issue on https://github.com/web2py/pydal/issues > it seems that mongo adapter doesn't support "list:reference table" yet > > On Sunday, May 10, 2015 at 4:09:51 PM UTC+2, Ron Chatterjee wrote: >> >> I have the following in model. I get an error invalide literal for int >> when I add the line Field("comments", "list: reference comment"). Otherwise >> it works fine >> >> db.define_table('Post', >> >> Field('author'), >> >> Field('content','Text'), >> >> Field("tags","list:string"), >> >> Field("comments","list:reference comment"), >> >> Field('date', 'datetime',default=request.now)) >> >> >> db.define_table("comment", >> >> Field("created_on","datetime",default=request.now), >> >> Field("body","text"), >> >> Field("author","reference auth_user")) >> >> posts = db._adapter.connection.posts_three >> >> >> >> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >> >> Below is the error I get. >> >> >> 1. >> 2. >> 3. >> 4. >> 5. >> 6. >> 7. >> 8. >> 9. >> 10. >> 11. >> 12. >> 13. >> 14. >> 15. >> 16. >> 17. >> 18. >> 19. >> 20. >> >> Traceback (most recent call last): >> File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\restricted.py", >> line 227, in restricted >> exec ccode in environment >> File >> "C:/Users/Ron/Desktop/web2py_new/web2py_new/applications/mongo_example1/controllers/appadmin.py" >> >> <http://127.0.0.1:8000/admin/default/edit/mongo_example1/controllers/appadmin.py>, >> line 704, in <module> >> File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\globals.py", line >> 393, in <lambda> >> self._caller = lambda f: f() >> File >> "C:/Users/Ron/Desktop/web2py_new/web2py_new/applications/mongo_example1/controllers/appadmin.py" >> >> <http://127.0.0.1:8000/admin/default/edit/mongo_example1/controllers/appadmin.py>, >> line 151, in insert >> if form.accepts(request.vars, session): >> File "C:\Users\Ron\Desktop\web2py_new\web2py_new\gluon\sqlhtml.py", line >> 1679, in accepts >> self.vars.id = self.table.insert(**fields) >> File >> "C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\objects.py", >> line 737, in insert >> ret = self._db._adapter.insert(self, self._listify(fields)) >> File >> "C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\mongo.py", >> line 359, in insert >> values[fieldname] = self.represent(v, fieldtype) >> File >> "C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\mongo.py", >> line 146, in represent >> value = NoSQLAdapter.represent(self, obj, fieldtype) >> File >> "C:\Users\Ron\AppData\Local\Enthought\Canopy\User\lib\site-packages\pydal-15.02.27-py2.7.egg\pydal\adapters\base.py", >> line 1795, in represent >> return map(int,obj) >> ValueError: invalid literal for int() with base 10: 'comment one' >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.