Hi,
i have this table:
def tempo_total_produto(produto_id):
try:
query = ((db.produto.id == produto_id))
result = db(query).select()
data_status = result[0]["data_criacao"]
data_hoje = datetime.date.today()
retorno = abs((data_hoje - data_status).days)
except:
retorno = "sem data"
return retorno
Produto = db.define_table('produto',
Field('ficha_tecnica', 'upload', label=T("Ficha Tecnica")),
Field('descricao_produto', 'string', label=T("Descricao Produto")),
Field('foto_frente', 'upload', label=T("Foto Frente")),
Field('foto_costas', 'upload', label=T("Foto Costas")),
Field('foto_detalhe', 'upload', label=T("Foto Detalhe")),
Field('cliente_id', db.clientes, label=T("Cliente ID")),
Field('data_criacao', 'date', default=datetime.date.today,
label=T("Data Criacao Produto")),
Field('referencia', 'string', label=T("Referencia")),
Field('colecao', 'string', label=T("Colecao")),
Field('previsao_entrega', 'date', label=T("Previsão Entrega")),
Field('cronoanalise', 'integer', label=T("Cronoanálise")),
Field('custo', 'double', label=T("Custo Producao")),
Field('preco_venda', 'double', label=T("Preco Venda")),
Field('qtd_estimada', 'integer', label=T("Qtd Estimada")),
Field('lacrado', 'boolean', label=T("LACRADO")),
Field('finalizado', 'boolean', label=T("FINALIZADO")),
Field('cancelado', 'boolean', label=T("CANCELADO")),
Field.Virtual('tempo_total', lambda row: tempo_total_produto(
row.produto.id)),
)
#REQUIRES
Produto.cliente_id.requires = IS_IN_DB(db(Clientes), 'clientes.id',
'%(nome_cliente)s')
It is possible create and show a Produto using SQLFORM, but i am getting a
error when i am trying to edit.
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/modasustentavel/web2py/gluon/restricted.py", line 227,
in restricted
exec ccode in environment
File
"/home/modasustentavel/web2py/applications/modasustentavel/controllers/default.py"
<https://modasustentavel.pythonanywhere.com/admin/edit/modasustentavel/controllers/default.py>,
line 677, in <module>
File "/home/modasustentavel/web2py/gluon/globals.py", line 417, in <lambda>
self._caller = lambda f: f()
File "/home/modasustentavel/web2py/gluon/tools.py", line 4241, in f
return action(*a, **b)
File
"/home/modasustentavel/web2py/applications/modasustentavel/controllers/default.py"
<https://modasustentavel.pythonanywhere.com/admin/edit/modasustentavel/controllers/default.py>,
line 240, in cadastro_produto
maxtextlength=64,paginate=40)
File "/home/modasustentavel/web2py/gluon/sqlhtml.py", line 2346, in grid
update_form = SQLFORM(table, record, **sqlformargs)
File "/home/modasustentavel/web2py/gluon/sqlhtml.py", line 1295, in __init__
inp = self.widgets.options.widget(field, default)
File "/home/modasustentavel/web2py/gluon/sqlhtml.py", line 313, in widget
options = requires[0].options()
File "/home/modasustentavel/web2py/gluon/validators.py", line 598, in options
self.build_set()
File "/home/modasustentavel/web2py/gluon/validators.py", line 584,
in build_set
records = self.dbset(table).select(*fields, **dd)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/objects.py",
line 2020, in select
return adapter.select(self.query, fields, attributes)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1296, in select
return self._select_aux(sql,fields,attributes)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1277, in _select_aux
return processor(rows,fields,self._colnames,cacheable=cacheable)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1767, in parse
for row in rows]
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1677, in _parse
value = self.parse_value(value, ft, blob_decode)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1527, in parse_value
return self.parsemap[key](value,field_type)
File "/home/modasustentavel/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1622, in parse_id
return long(value)
ValueError: invalid literal for long() with base 10: ''
Any idea to fiz this ?
Rgds
Diego
--
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.
