This is a join
table=db((db.mytable.id==db.another_table.mytable)).select()
Mongodb does not provide joins (nor transactions) that is why it can do
sharding. That is the all point of nosql.
On Sunday, 10 November 2013 17:39:07 UTC-6, Tito Garrido wrote:
>
> Hi Folks,
>
> I am trying to execute a simple test in mongodb (it worked on SQLite):
> Model:
> db.define_table('mytable',
> Field('name','string'),
> Field('age', 'integer'),
> Field('description', 'text'))
>
> db.define_table('another_table',
> Field('mytable', 'reference mytable'),
> Field('name', 'string'),
> Field('description', 'text'))
>
> Controller:
> def index():
> table=db((db.mytable.id==db.another_table.mytable)).select()
> return dict(table=table)
>
> Ticket ID
>
> 177.205.253.190.2013-11-10.18-36-12.7a03dad2-ba10-45f0-93b1-958b0f02c843
> <type 'exceptions.RuntimeError'> Too many tables selected Versão web2py™
> Version
> 2.7.4-stable+timestamp.2013.10.14.15.16.29 Python Python 2.7.3:
> /usr/local/bin/uwsgi (prefix: /usr) Traceback
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
> 15.
> 16.
> 17.
> 18.
>
> Traceback (most recent call last):
> File "/home/www-data/web2py/gluon/restricted.py", line 217, in restricted
>
>
> exec ccode in environment
> File "/home/www-data/web2py/applications/bootstrap/controllers/default.py"
> <https://162.243.7.55/admin/default/edit/bootstrap/controllers/default.py>,
> line 78, in <module>
>
>
> File "/home/www-data/web2py/gluon/globals.py", line 372, in <lambda>
>
>
> self._caller = lambda f: f()
>
>
> File "/home/www-data/web2py/applications/bootstrap/controllers/default.py"
> <https://162.243.7.55/admin/default/edit/bootstrap/controllers/default.py>,
> line 21, in index
>
>
> table=db((db.mytable.id==db.another_table.mytable)).select()
>
>
> File "/home/www-data/web2py/gluon/dal.py", line 10111, in select
>
>
> return adapter.select(self.query,fields,attributes)
>
>
> File "/home/www-data/web2py/gluon/dal.py", line 5552, in select
>
>
> limitby_limit, limitby_skip = self._select(query, fields, attributes)
>
>
> File "/home/www-data/web2py/gluon/dal.py", line 5534, in _select
>
>
> tablename = self.get_table(query)
>
>
> File "/home/www-data/web2py/gluon/dal.py", line 1544, in get_table
>
>
> raise RuntimeError("Too many tables selected")
>
> RuntimeError: Too many tables selected
>
>
>
> This is what I got... Is there any inner join limit on mongodb?
>
> Thanks!
>
> Tito
>
> --
>
> Linux User #387870
> .........____
> .... _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:_______
>
--
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
