Produits Entr'ouvert » w.c.s.

def test_workflow_set_bo_table_field(pub):

    user = create_user(pub)

    formdef = create_formdef()

    formdef.fields = [fields.TableField(

        id='0', label='fo table field', type='table', varname='input',

        rows=['row1', 'row2'], columns=['col1', 'col2'])]

    wf = Workflow(name='xxx')

    wf.backoffice_fields_formdef = WorkflowBackofficeFieldsFormDef(wf)

    wf.backoffice_fields_formdef.fields = [

        fields.TableField(

            id='bo0', label='bo table field',

            type='table', varname='backoffice_table',

            rows=['row1', 'row2'], columns=['col1', 'col2'])

    ]

    st1 = wf.add_status('Status1')

    setbo = SetBackofficeFieldsWorkflowStatusItem()

    setbo.fields = [{'field_id': 'bo0', 'value': '{{ form_var_input }}'}]

    st1.items.append(setbo)

    setbo.parent = st1

    wf.store()

    formdef.workflow_id = wf.id

    formdef.store()

    resp = get_app(pub).get('/test/')

    resp.form['f0$c-0-0'] = 'a1'

    resp.form['f0$c-0-1'] = 'a2'

    resp.form['f0$c-1-0'] = 'b1'

    resp.form['f0$c-1-1'] = 'b2'

    resp = resp.form.submit('submit')  # -> validation page

    resp = resp.form.submit('submit')  # -> submission       ## here we get 500 on sql (*)

    resp = resp.follow()

    assert formdef.data_class().select()[0].data['0'] == [['a1', 'a2'], ['b1', 'b2']]

    assert formdef.data_class().select()[0].data['bo0'] == "[['a1', 'a2'], ['b1', 'b2']]"