I'm trying to move an app from a old version of web2py (2.14) to latest
version. After updating some code i'm stuck on the error below.
If i remove the left join the query works. And I dont find anything about
changes on 'left' syntax.
Someone knows whats wrong?
<type 'exceptions.TypeError'> left_join() takes exactly 2 arguments (3
given)
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 "C:\Users\fiscal\Desktop\web2py\gluon\restricted.py", line 219, in
restricted
exec(ccode, environment)
File
"C:\Users\fiscal\Desktop\web2py\applications\manager\controllers/atendimento.py",
line 3014, in <module>
File "C:\Users\fiscal\Desktop\web2py\gluon\globals.py", line 421, in <lambda>
self._caller = lambda f: f()
File "C:\Users\fiscal\Desktop\web2py\gluon\tools.py", line 3868, in f
return action(*a, **b)
File
"C:\Users\fiscal\Desktop\web2py\applications\manager\controllers/atendimento.py",
line 100, in dashboardInicial
orderby=~dbOracle.OSC.chave
File "C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\objects.py",
line 2378, in select
return adapter.select(self.query, fields, attributes)
File
"C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\adapters\base.py",
line 758, in select
colnames, sql = self._select_wcols(query, fields, **attributes)
File
"C:\Users\fiscal\Desktop\web2py\gluon\packages\dal\pydal\adapters\base.py",
line 651, in _select_wcols
tokens += [self.dialect.left_join(t, query_env) for t in join_on]
TypeError: left_join() takes exactly 2 arguments (3 given)
Query:
resultado= dbOracle(query
&(dbOracle.OSC.chave_cliente ==
dbOracle.clientes.codcli) &(dbOracle.OSC.chave_tecnico ==
dbOracle.tecnicos.chave)
&(dbOracle.OSC.chave_tag == dbOracle.tag.chave)
&(dbOracle.tag.chave_produto==dbOracle.produtos.cprod)
&(dbOracle.tipos_chamados.chave ==
dbOracle.OSC.chave_tipo_chamado)
).select(dbOracle.OSC.chave,
dbOracle.OSC.data_emissao, dbOracle.tag.numero_serie , dbOracle.tag.chave,
dbOracle.clientes.nome,
dbOracle.clientes.codcli, dbOracle.OSC.sla,
dbOracle.OSC.previsao_atendimento , dbOracle.OSC.time_abertura
,dbOracle.OSC.time_atendimento ,
[MANY OTHER FIELDS],
left=
[dbOracle.pedidos_contratos.on(dbOracle.OSC.chave_contrato==dbOracle.pedidos_contratos.chave),
dbOracle.tecnicos_zonas.on(dbOracle.OSC.chave_tecnico==dbOracle.tecnicos_zonas.chave_tecnico),
dbOracle.territorios.on(dbOracle.tecnicos_zonas.chave_territorio==dbOracle.territorios.chave)],
orderby=~dbOracle.OSC.chave
)
--
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/d/optout.
