Produits Entr'ouvert » w.c.s.

def assert_option_display(resp, label, value):

    option_line = re.findall('%s.*%s' % (label, value), resp.text, re.DOTALL)

    assert option_line

def test_forms_edit(pub):

    resp = resp.click('change title')

    assert resp.form['name'].value == 'form title'

    assert 'data-slug-sync' in resp.text

    resp.form['name'] = 'new title'

    resp = resp.form.submit()

    assert resp.location == 'http://example.net/backoffice/forms/1/'

    resp = app.get('/backoffice/forms/1/')

    resp = resp.click('change title')

    formdef.data_class()().store()

    resp = app.get('/backoffice/forms/1/')

    resp = app.get('/backoffice/forms/1/')

    resp = resp.click(href=re.compile('^roles$'))

    resp.form['roles$element0'] = 'logged-users'

    resp = resp.form.submit()

    assert FormDef.get(formdef.id).roles == ['logged-users']

    resp = app.get('/backoffice/')

    resp = resp.click('Management', index=0)

    resp = resp.follow()

    assert re.findall('Other Forms.*form-title', resp.text)

    # 2nd time with user set as receiver of the forms

    resp = app.get('/backoffice/management/form-title/')

    assert resp.text.count('</th>') == 8  # six columns

    resp.forms['listing-settings']['1'].checked = False

    assert 'last_update_time' in resp.forms['listing-settings'].fields

    resp = resp.forms['listing-settings'].submit()

    assert resp.text.count('</th>') == 7  # fixe columns

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    formdef = FormDef.get_by_urlname('form-title')

    formdef.backoffice_submission_roles = user.roles

    resp = resp.forms['listing-settings'].submit()

    assert resp.text.count('</th>') == 9  # seven columns

    assert resp.text.count('data-link') == 17  # 17 rows

    resp = resp.click('Export as CSV File')

    assert len(resp.text.splitlines()) == 18  # 17 + header line

    for formdata in formdef.data_class().select():

        formdata.submission_agent_id = str(agent.id)

    create_environment(pub)

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    formdef = FormDef.get_by_urlname('form-title')

    formdef.fields[1].in_filters = True

    )

    formdef.store()

    resp = app.get('/backoffice/management/form-title/')

    formdef.fields[-1].in_filters = True

    formdef.store()

    assert 'Resolution time' in resp.text

    assert 'To Status "New"' in resp.text

    assert 'To Status "Finished"' in resp.text

    resp.forms['listing-settings']['filter-end-value'] = '2013-01-01'

    resp = resp.forms['listing-settings'].submit()

    workflow.store()

    resp = app.get('/backoffice/management/form-title/')

    assert 'id="multi-actions"' in resp.text

    # action for function

    trigger.roles = ['_foobar']

    resp = app.get('/backoffice/management/form-title/')

    resp = resp.click('Statistics')

    assert 'filter' not in resp.forms['listing-settings'].fields  # status is not displayed by default

    # add 'status' as a filter

    resp.forms['listing-settings']['filter-status'].checked = True

    resp = resp.forms['listing-settings'].submit()

    assert 'filter' in resp.forms['listing-settings'].fields

    assert resp.forms['listing-settings']['filter'].value == 'all'

    resp.forms['listing-settings']['filter'].value = 'pending'

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    resp = resp.click('Statistics')

    resp.forms['listing-settings']['filter-2'].checked = True

    resp = resp.forms['listing-settings'].submit()

    assert re.findall('<tbody.*\/tbody>', resp.text, re.DOTALL)[0].count('<tr') == 17

    # check there's no link to map the sidebar

    formdef = FormDef.get_by_urlname('form-title')

    formdef.geolocations = {'base': 'Geolocafoobar'}

    assert (' with the number %s.' % number31.get_display_id()) in resp.text

    # check there's nothing in the sidebar

    number31.submission_channel = 'mail'

    number31.user_id = user.id

    assert (' with the number %s.' % number31.get_display_id()) in resp.text

    # check there's nothing in the sidebar

    number31.geolocations = {'base': {'lat': 48.83, 'lon': 2.32}}

    number31.store()

    resp = app.get('/backoffice/management/form-title/%s/' % number31.id)

    assert (' with the number %s.' % number31.get_display_id()) in resp.text

    assert 'CLICK ME!' in resp.text

    # add an info text to the status

    st1.backoffice_info_text = '<p>Foo</p>'

    app2 = login(get_app(pub), username='foobar', password='foobar')

    resp = app2.get('/backoffice/management/form-title/%s/' % number31.id)

    assert 'Be warned forms of this user are also being looked' in resp.text

    # remove info text from the status

    st1.backoffice_info_text = None

    workflow.store()

    resp = app.get('/backoffice/management/form-title/%s/' % number31.id)

    assert 'backoffice-description' in resp.text

    assert '<p>Bar</p>' in resp.text

    # add info text to second button

    workflow.store()

    resp = app.get('/backoffice/management/form-title/%s/' % number31.id)

    assert 'backoffice-description' in resp.text

    assert '<p>Bar</p>' in resp.text

    # remove info text from first button

    commentable.backoffice_info_text = None

    workflow.store()

    resp = app.get('/backoffice/management/form-title/%s/' % number31.id)

def test_backoffice_handling_post_dispatch(pub):

    # check there's no access at the moment

    resp = app.get('/backoffice/management/').follow()

    resp = app.get('/backoffice/management/form-title/', status=403)

    resp = app.get('/backoffice/management/form-title/%s/' % number31.id, status=403)

    # the failure message shouldn't be displayed in the frontoffice

    resp = app.get('/form-title/%s/' % number31.id)

    assert (' with the number %s.' % number31.get_display_id()) in resp.text

@pytest.mark.parametrize('notify_on_errors', [True, False])

    resp = resp.form.submit('button_wfedit')

    resp = resp.follow()

    assert 'http://www.example.com/test.pdf' in resp.text  # make sure sidebar has details

    assert resp.form['f1'].value == number31.data['1']

    assert resp.form['f2'].value == number31.data['2']

    assert resp.form['f3'].value == number31.data['3']

    assert 'Global View' in resp.text

    resp = resp.click('Global View')

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 20

    resp = app.get('/backoffice/management/listing?limit=500')

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 37  # 17 formdef1 + 20 formdef2

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 20

    assert 'http://example.net/backoffice/management/other-form/' in resp.text

    formdef = FormDef.get_by_urlname('form-title')

    last_update_time = formdef.data_class().select(lambda x: not x.is_draft())[0].last_update_time

    assert 'digest of number <%s>' % formdata.id_display in resp.text

    # check a Channel column is added when welco is available

    if not pub.site_options.has_section('variables'):

        pub.site_options.add_section('variables')

    resp.forms['listing-settings']['status'] = 'waiting'

    resp = resp.forms['listing-settings'].submit()

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 20

    resp.forms['listing-settings']['status'] = 'open'

    resp = resp.forms['listing-settings'].submit()

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 20

    resp.forms['listing-settings']['status'] = 'all'

    resp = resp.forms['listing-settings'].submit()

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 20

    resp.forms['listing-settings']['status'] = 'done'

    resp = resp.forms['listing-settings'].submit()

    assert resp.text[resp.text.index('<tbody') :].count('<tr') == 0

def test_global_listing_parameters_from_query_string(pub):

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/listing?limit=500')

    cat1 = Category(name='cat1')

    cat1.store()

    resp.forms['listing-settings']['category_id'] = cat1.id

    resp = resp.forms['listing-settings'].submit()

    assert 'management/form-title/' in resp.text

    resp.forms['listing-settings']['category_id'] = cat2.id

    resp = resp.forms['listing-settings'].submit()

    assert 'management/other-form/' in resp.text

def test_datetime_in_global_listing(pub):

    assert (' with the number %s.' % number31.get_display_id()) in resp.text

    # check there's nothing in the sidebar

    number31.formdef.digest_template = 'digest of number {{form_number}}'

    number31.user_id = user.id

    assert '/user-pending-forms' in resp.text

    user_pending_form_url = re.findall('data-async-url="(.*/user-pending-forms)"', resp.text)[0]

    partial_resp = app.get(user_pending_form_url)

    assert number31.digest in partial_resp.text

    assert '<span class="formname">%s</span>' % number31.formdef.name in partial_resp.text

    assert '/user-pending-forms' in resp.text

    user_pending_form_url = re.findall('data-async-url="(.*/user-pending-forms)"', resp.text)[0]

    partial_resp = app.get(user_pending_form_url)

    assert number34.get_url(backoffice=True) in partial_resp.text

    cat1 = Category(name='cat1')

    resp = app.get('/backoffice/management/users/%s/' % user.id)

    for item in to_match:

    assert resp.text.count('<li') == count_li

    # mark formdef so it's not listed in per-user view

    number31.store()

    resp = app.get('/backoffice/management/users/%s/' % user.id)

    formdef.enable_tracking_codes = True

    formdef.store()

    pub.cfg['sms'] = {}

    pub.write_cfg()

    resp = user_view_resp.click('Send tracking code')

    assert resp.form['email'].value == user.email

    resp = resp.form.submit()

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    first_link = re.findall('data-link="(\d+)/?"', resp.text)[0]

    formdata = FormDef.get_by_urlname('form-title').data_class().get(first_link)

    formdata.backoffice_submission = True

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/listing?limit=100')

    formdef = FormDef.get_by_urlname('form-title')

    formdata = formdef.data_class().get(

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/')

    first_link = re.findall('data-link="(\d+/)?"', resp.text)[0]

    app2 = login(get_app(pub), username='foobar', password='foobar')

    resp = app2.get('/backoffice/management/form-title/')

    resp = app.get('/backoffice/management/form-title/' + first_link)

    resp = app2.get('/backoffice/management/form-title/')

    assert 'advisory-lock' in resp.text

    resp = app.get('/backoffice/management/form-title/')

    if pub.is_using_postgresql():

        # check global view

        resp = app2.get('/backoffice/management/listing?limit=100')

        assert 'advisory-lock' in resp.text

        resp = app.get('/backoffice/management/listing?limit=100')

    resp = app.get('/backoffice/management/form-title/' + first_link)

    assert 'button_commentable' in resp.text

    assert len(resp.forms)

    resp = app2.get('/backoffice/management/form-title/' + first_link)

    assert 'Be warned forms of this user are also being looked' in resp.text

    assert len(resp.forms) == 0

    # revisit with first user, no change

    resp = app.get('/backoffice/management/form-title/' + first_link)

    assert 'button_commentable' in resp.text

    # back to second

    resp = app2.get('/backoffice/management/form-title/' + first_link)

    assert 'Be warned forms of this user are also being looked' in resp.text

    resp = resp.click('(unlock actions)')

    resp = resp.follow()

    assert 'Be warned forms of this user are also being looked' in resp.text

    assert 'button_commentable' in resp.text

    assert len(resp.forms)

    # submit action form

    resp.form['comment'] = 'HELLO'

    resp = resp.form.submit('button_commentable')

    # locks are reset after an action

    # but as the current user is redirected to the form, a lock will be

    # acquired (unless the user didn't have actions anymore, but it's not the

    # case here)

    resp = resp.follow()

    assert 'advisory-lock' in app.get('/backoffice/management/form-title/')

    app = login(get_app(pub))

    resp = app.get('/backoffice/management/form-title/%s/' % formdatas[0].id)

    app.get(re.findall('data-async-url="(.*/user-pending-forms)"', resp.text)[0])

    app2 = login(get_app(pub), username='foobar', password='foobar')

    # another by another user

    resp2 = app2.get('/backoffice/management/form-title/%s/' % formdatas[3].id)

    app2.get(re.findall('data-async-url="(.*/user-pending-forms)"', resp.text)[0])

    # check another formdef is only marked as visited if the user has potential

    other_formdata = second_formdef.data_class().get(other_formdatas[0].id)

    other_formdata.store()  # update concerned_roles

    session.visiting_objects = {}

    session.store()

    app = login(get_app(pub))

    resp = app.get(formdata.get_url(backoffice=True))

    formdata.data = {'bo1': 'HELLO WORLD'}

    formdata.store()

    workflow.store()

    resp = app.get(formdata.get_url(backoffice=True))

    again = ChoiceWorkflowStatusItem()

    again.id = '_again'

    resp = app.get('/')

    assert 'Status1' in resp

    assert '<a href="/test/%s/"' % formdata.id in resp

    resp = app.get('/test/%s/' % formdata.id)

    resp = app.get('/test/%s/' % draft.id, status=302)

    resp = resp.follow(status=403)

    formdef.store()

    home = get_app(pub).get('/')

    assert 'category-foobar' in home.text

    assert '<a class="" href="foobar/test/">test</a>' in home.text

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

    assert 'category-foobar' in resp.text  # 1st formdef

    assert 'category-barfoo' in resp.text  # 2nd formdef

def test_home_keywords(pub):

    formdef.disabled = True

    formdef.store()

    home = get_app(pub).get('/')

    # check access is denied

    get_app(pub).get('/test/', status=403)

    assert next_page.status_int == 302

    next_page = next_page.follow()

    assert 'The form has been recorded' in next_page.text

    assert formdef.data_class().count() == 1

    assert '<div class="section foldable folded" id="summary">' in next_page.text

    formdef.store()

    formdef.data_class().wipe()

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

    assert resp.forms[0]['f1'].value == 'Foo'  # preset

    resp = resp.forms[0].submit('submit')

    assert '2nd page' in resp.text

    assert_current_page(resp, '2nd page')

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

    resp.forms[0]['f1'] = 'Bar'

    resp = resp.forms[0].submit('submit')

    assert '3rd page' in resp.text

    assert_current_page(resp, '3rd page')

    formdef.store()

    formdef.data_class().wipe()

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

    resp.forms[0]['f1'] = 'Foo'

    resp = resp.forms[0].submit('submit')

    assert '2nd page' in resp.text

    assert_current_page(resp, '2nd page')

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

    resp.forms[0]['f1'] = 'Bar'

    resp = resp.forms[0].submit('submit')

    assert '3rd page' in resp.text

    assert_current_page(resp, '3rd page')

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

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

    assert 'Check values then click submit.' in resp.text

    resp = resp.form.submit('submit')

    assert formdef.data_class().count() == 1

    formdata = formdef.data_class().select()[0]

    formdef.data_class().wipe()

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

    assert '<h4 data-field-id="5">subtitle of 1st page</h4>' in resp.text

    resp.form['f1'] = 'foo'

    resp = resp.form.submit('submit')

    assert '<h3 data-field-id="6">title of second page</h3>' in resp.text

    resp = resp.form.submit('submit').follow()  # -> submit

    assert '<h3>1st page</h3>' in resp.text

    assert '<div class="subtitle "><h4>subtitle of 1st page</h4></div>' in resp.text

    assert '<div class="title "><h3>title of second page</h3></div>' in resp.text

    assert formdef.data_class().select()[0].data['1'] == 'plop1'

    assert formdef.data_class().select()[0].data['2'] == 'plop2'

    assert formdef.data_class().select()[0].data['3'] == 'plop3'

    assert 'plop3' in resp.text

    assert 'Bla bla bla' in resp.text

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

    pq = resp.pyquery.remove_namespaces()

    assert pq('div[style="display: none;"] [name=f1]')  # but page 1 field included, hidden

    assert '<h3>2nd page</h3>' in resp.text  # page 2 title

    assert 'Bla bla bla' in resp.text  # and page 2 comment field

    formdef.enable_tracking_codes = False

    formdef.store()

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

def test_form_no_tracking_code_variable(pub):

    # visit page, check there's no remove draft button

    resp = app.get('/test/')

    assert '<h3>Tracking code</h3>' in resp.text

    # check we can load the formdata as a draft

    resp = app.get('/')

    resp.form['f0'] = 'test'

    resp = resp.form.submit('submit')

    assert 'Check values then click submit.' in resp.text

    # check anonymous user gets the captcha

    app = get_app(pub)

    resp.form['f0'] = 'test'

    resp = resp.form.submit('submit')

    assert 'Check values then click submit.' in resp.text

def test_form_captcha_and_no_validation_page(pub):

        resp = app.get('/test/')

        resp.forms[0]['f0$file'] = upload

        resp = resp.forms[0].submit('submit')

def test_form_file_field_submit_document_type(pub):

    formdef.store()

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

    resp = resp.form.submit('submit')

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

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

    formdef.store()

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

    resp = resp.form.submit('submit')

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

    resp.form['f0$element0$col0'] = 'a'

    # check required field

    resp = resp.forms[0].submit('submit')

    assert 'data-geolocation="road"' in resp.text

    resp.forms[0]['f1'].value = 'bla'

    # not filled completed, no call to .autocomplete

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

    # straight URL

    formdef.fields[0].data_source = {'type': 'jsonp', 'value': 'http://example.org'}

    display1.condition = {'type': 'django', 'value': 'xxx'}

    workflow.store()

    page = app.get(formdata.get_url())

def test_session_cookie_flags(pub):

    resp = login(get_app(pub), username='foo', password='foo').get('/test/')

    assert resp.form['f0'].value == 'foo@localhost'

    resp.form['f0'].value = 'Hello'

    resp = resp.form.submit('submit')

    assert 'Check values then click submit.' in resp.text

        resp.form['f0'].value = 'Hello'  # try changing

        resp = resp.form.submit('previous')

        assert 'readonly' in resp.form['f0'].attrs

        assert resp.form['f0'].value == 'foo@localhost'

        # try it without validation page

    resp = login(get_app(pub), username='foo', password='foo').get('/test/')

    assert resp.form['f0'].value == '2018-09-27'

    resp.form['f0'].value = '2018-09-27'

    resp = resp.form.submit('submit')

    assert 'Check values then click submit.' in resp.text

        data = {'data': [{'id': '1', 'text': 'hello', 'disabled': True}, {'id': '2', 'text': 'world'}]}

        urlopen.side_effect = lambda *args: io.StringIO(json.dumps(data))

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

        resp.form['f0$element2'].checked = True

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

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

    formdef.store()

    formdef.data_class().wipe()

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

    formdef.fields[0].extra_css_class = 'template-test'

    formdef.store()

    formdata = formdef.data_class().select()[0]

    resp = app.get(formdata.get_url())

    trigger.roles = ['_submitter']

    workflow.store()

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

    resp.form['f1'] = 'hello'

    resp = resp.form.submit('submit')

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

    resp.form['f1'] = 'éléphant'

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

    resp.form['f1'] = 'hello'

    resp = resp.form.submit('submit')

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

    resp.form['f1'] = 'éléphant'

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

    resp.form['f1'] = 'hello'

    resp = resp.form.submit('submit')

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

    resp.form['f1'] = 'éléphant'

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

    resp.form['f1$element1'].checked = True

    resp = resp.form.submit('submit')

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

    resp.form['f1$element1'].checked = True

    assert live_resp.json['result']['1']['visible']

    assert live_resp.json['result']['2']['visible']

    assert live_resp.json['result']['3']['visible']

    resp.form['f2'] = 'plop'

    live_resp = app.post('/foo/live?modified_field_id=2', params=resp.form.submit_fields())

    assert live_resp.json['result']['1']['visible']

    assert live_resp.json['result']['1']['visible']

    assert live_resp.json['result']['2']['visible']

    assert live_resp.json['result']['3']['visible']

    resp.form['f2'] = 'plop'

    live_resp = app.post('/foo/live?modified_field_id=2', params=resp.form.submit_fields())

    assert live_resp.json['result']['1']['visible']

    assert live_resp.json['result']['xxx_1']['visible']

    assert live_resp.json['result']['xxx_2']['visible']

    assert live_resp.json['result']['xxx_3']['visible']

    resp.form['fxxx_2'] = 'plop'

    live_resp = app.post('/test/1/live?modified_field_id=xxx_2', params=resp.form.submit_fields())

    assert live_resp.json['result']['xxx_1']['visible']

    app = login(get_app(pub), username='foo', password='foo')

    resp = app.get('/test/')

    draft = formdef.data_class()()

    draft.user_id = user.id

    HOBO_JSON['profile']['fields'][8]['disabled'] = True

    hobo_cmd.update_profile(profile, pub)

    formdef = UserFieldsFormDef(pub)

    # add a custom local field

    formdef = UserFieldsFormDef(pub)

        attribute_name = str(field['name'])

        field_id = str('_' + attribute_name)

        if field.get('disabled'):

        else:

            assert attribute_mapping[attribute_name] == field_id

    assert emails.emails['test']['msg'].get_payload()[1].get_content_type() == 'text/html'

    html = emails.emails['test']['msg'].get_payload()[1].get_payload(decode=True)

    assert html.count(b'<ol') == 1

    assert b'arabic simple' in html

    assert b'M. Francis Kuntz' in html

    os.mkdir(os.path.join(pub.APP_DIR, 'plop.invalid'))

    tenants = list(pub.__class__.get_tenants())

    assert 'example.net' in tenants

def test_register_cronjobs():

    union = ' UNION '.join(

        ['''SELECT %s FROM %s''' % (', '.join([y[1] for y in common_fields]), x) for x in view_names]

    )

    cur.execute('''CREATE VIEW wcs_all_forms AS %s''' % union)

    sql.migrate()

    for row in range(10):

        for col in range(3):

            assert 'test$element%d$col%d' % (row, col) in form.as_html

    mock_form_submission(req, widget, click='test$add_element')

    widget = TableListRowsWidget('test', columns=['a', 'b', 'c'])

    assert widget.parse() == '1.23;2.34'

    assert '<label' in str(widget.render())

    pub.load_site_options()

    pub.site_options.set('options', 'map-bounds-top-left', '1.23;2.34')

    wscall.slug = 'bye'

    wscall.store()

    assert 'bye' in NamedWsCall.keys()

def test_webservice_substitution_variable(http_requests, pub):

        wscall.call()

    except Exception:

        pass

    wscall.request = {'url': 'http://idp.example.net'}

    try:

        wscall.call()

    except Exception:

        pass

    assert 'signature=' in http_requests.get_last('url')