Can I change request.vars before inserting to sqlform ?

[JorgeH]

Hello

I've been trying to use a compute field that needs to use a class I created . But I get the error  : TypeError: unhashable type: 'list'

Thus I intend to instead of a computed field, just do the calculations before  processing the form.

  if form1.process(session=None, formname='tabla1').accepted:

The field I intend to calculate before inserting is 'consumo_mensual'

my code so  far is similar to this:

form1 = SQLFORM(db.energia_termica)

request.vars.consumo_mensual = ConvEtermica(request.vars.tipo ,request.vars.consumo_teorico, request.vars.horas_uso_mes).consumo_mensual()

form1.vars.consumo_mensual = request.vars.consumo_mensual
 if form1.process(session=None, formname='tabla1').accepted:



but it really is ignoring my tweak

What is the correct way to doing it?

Thanks

[Anthony]

Make the change before creating the form. But perhaps we should figure out how to make your computed field work instead.

[JorgeH]

Thanks for your reply:

This does not work:

  request.vars.consumo_mensual = ConvEtermica(request.vars.tipo ,request.vars.consumo_teorico, request.vars.horas_uso_mes).consumo_mensual()

  form1 = SQLFORM(db.energia_termica)

and this:
  form1.vars.consumo_mensual = ConvEtermica(request.vars.tipo ,request.vars.consumo_teorico, request.vars.horas_uso_mes).consumo_mensual()
  form1 = SQLFORM(db.energia_termica)
 
give me this error;

    form1.vars.consumo_mensual = ConvEtermica(request.vars.tipo ,request.vars.consumo_teorico, request.vars.horas_uso_mes).consumo_mensual()
UnboundLocalError: local variable 'form1' referenced before assignment

Error snapshot

<type 'exceptions.UnboundLocalError'>(local variable 'form1' referenced before assignment)

[Anthony]

Try request.post_vars instead of request.vars.

[JorgeH]

Ok

this do the trick:

  request.post_vars.consumo_mensual= ConvEtermica(request.vars.tipo ,request.vars.consumo_teorico, request.vars.horas_uso_mes).consumo_mensual()
  form1 = SQLFORM(db.energia_termica)
 

Thanks!