bem tenho o seguinte problema dessa vez, estou tentando criar a primeira
tabela com relacionamento, só que não to conseguindo inserir nd dos dados
na tabela pq ele fica dando esse erro "long() argument must be a string or
a number, not 'list'
meu controller
@auth.requires_login()
def CadastroPropriedade():
formulario = db.PropriedadeRural.insert(area=request.vars.area)
return dict(mensagem=" ")
meu BD :
propriedadeRural = db.define_table('PropriedadeRural'
,Field('area','integer',label='Area de platação')
,Field('ano','date',label='ano da colheita')
,Field('lavoura','string',label='Tipo de cultivo')
,Field('producao','integer',label='Produção em sacos')
,Field('valorProducao','integer',label='Receita de Venda')
,Field('agricultor','references auth_user',label='Dono Da Lavoura'))
e o erro completo:
Número do Ticket
127.0.0.1.2019-07-30.12-01-32.d039c906-1e98-41a0-8ae5-e0657181b244
<type 'exceptions.TypeError'> long() argument must be a string or a number,
not 'list'Versão
web2py™ Version 2.18.5-stable+timestamp.2019.04.08.04.22.03
Python Python 2.7.15+: /usr/bin/python (prefix: /usr)Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
Traceback (most recent call last):
File "/home/nti/Área de Trabalho/web2py/gluon/restricted.py", line 219, in
restricted
exec(ccode, environment)
File "/home/nti/Área de
Trabalho/web2py/applications/ProjetoMargem/controllers/template.py"
<http://127.0.0.1:8000/admin/default/edit/ProjetoMargem/controllers/template.py>,
line 66, in <module>
File "/home/nti/Área de Trabalho/web2py/gluon/globals.py", line 421, in
<lambda>
self._caller = lambda f: f()
File "/home/nti/Área de Trabalho/web2py/gluon/tools.py", line 3869, in f
return action(*a, **b)
File "/home/nti/Área de
Trabalho/web2py/applications/ProjetoMargem/controllers/template.py"
<http://127.0.0.1:8000/admin/default/edit/ProjetoMargem/controllers/template.py>,
line 21, in CadastroPropriedade
formulario = db.PropriedadeRural.insert(area=request.vars.area)
File "/home/nti/Área de Trabalho/web2py/gluon/packages/dal/pydal/objects.py",
line 762, in insert
ret = self._db._adapter.insert(self, row.op_values())
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 480, in insert
query = self._insert(table, fields)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 476, in _insert
','.join(self.expand(v, f.type) for f, v in fields))
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 476, in
<genexpr>
','.join(self.expand(v, f.type) for f, v in fields))
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 445, in _expand
rv = self.represent(expression, field_type)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 382, in
represent
return super(SQLAdapter, self).represent(obj, field_type)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/adapters/base.py", line 336, in
represent
return self.representer.represent(obj, field_type)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/representers/__init__.py", line 251,
in represent
rv = self.get_representer_for_type(field_type)(rv, field_type)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/representers/__init__.py", line 139,
in __call__
return self.adapt(self.call(value, field_type))
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/representers/__init__.py", line 136,
in _call
return self.inner_call(value)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/representers/__init__.py", line 124,
in _inner_call
return self.obj.f(self.representer, value, **kwargs)
File "/home/nti/Área de
Trabalho/web2py/gluon/packages/dal/pydal/representers/base.py", line 30, in
_integer
return str(long(value))
TypeError: long() argument must be a string or a number, not 'list'
Momento do Erro [image: help]
<http://127.0.0.1:8000/admin/default/ticket/ProjetoMargem/127.0.0.1.2019-07-30.12-01-32.d039c906-1e98-41a0-8ae5-e0657181b244#>
<type 'exceptions.TypeError'>(long() argument must be a string or a number,
not 'list')
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/56ca94ee-e430-439a-8c28-c20455f398d6%40googlegroups.com.
