Produits Entr'ouvert » w.c.s.

    assert data_class.get(resp.json['data']['id']).status == 'draft'

    resp = get_app(pub).post_json(url, {'meta': {'backoffice-submission': True}, 'data': {},

    assert data_class.get(resp.json['data']['id']).status == 'wf-new'

    assert data_class.get(resp.json['data']['id']).backoffice_submission is True

    assert data_class.get(resp.json['data']['id']).user_id is None

    data_class.wipe()

    # check there's nothing in the sidebar

    assert not 'Channel' in resp.body

    number31.submission_context = {

            'mail_url': 'http://www.example.com/test.pdf',

            'thumbnail_url': 'http://www.example.com/thumbnail.png',

            'user_id': user.id,

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

    assert '%s/%s' % (formdef.url_name, formdata_no) in resp.body

    assert '>#%s' % formdata_no in resp.body

    formdata.store()

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

    assert '>Mail #%s' % formdata_no in resp.body

    formdata.backoffice_submission = True

    formdata.status = 'draft'

    formdata.data = {}

    formdata.store()

    formdata2 = formdef.data_class()()

    formdata2.backoffice_submission = True

    formdata2.status = 'draft'

    formdata2.data = {}

    formdata2.store()

    app = login(get_app(pub))

    formdata = data_class.get(id)

    assert formdata.user_id == '5'

@postgresql

def test_sql_get_missing():

    conn.commit()

    cur.close()

@postgresql

def test_migration_1_tracking_code():

    conn, cur = sql.get_connection_and_cursor()

    sql.migrate()

    assert table_exists(cur, 'tracking_codes')

    assert table_exists(cur, 'wcs_meta')

    conn.commit()

    cur.close()

    sql.migrate()

    assert column_exists_in_table(cur, 'wcs_all_forms', 'formdef_id')

    conn.commit()

    cur.close()

    assert column_exists_in_table(cur, 'formdata_1_tests', 'actions_roles_array')

    assert column_exists_in_table(cur, 'wcs_view_1_tests', 'actions_roles_array')

    assert column_exists_in_table(cur, 'wcs_all_forms', 'actions_roles_array')

    conn.commit()

    cur.close()

            # set receipt_time to make sure all entries are unique.

            formdata.receipt_time = (now + datetime.timedelta(seconds=cnt)).timetuple()

            formdata.status = ['wf-new', 'wf-accepted', 'wf-rejected', 'wf-finished'][(i+j)%4]

            formdata.store()

            cnt += 1

    objects2 = sql.AnyFormData.select([st.Equal('is_at_endpoint', True)])

    assert len(objects2) == len([x for x in objects if x.status in ('wf-rejected', 'wf-finished')])

    # test offset/limit

    objects2 = sql.AnyFormData.select(order_by='receipt_time', limit=10, offset=0)

    assert [(x.formdef_id, x.id) for x in objects2] == [(x.formdef_id, x.id) for x in objects][:10]

            formdata.user_id = user.id

        if json_input.get('context'):

            formdata.submission_context = json_input['context']

        formdata.store()

        if self.formdef.enable_tracking_codes:

            code = get_publisher().tracking_code_class()

        formdata = self.filled

        r = TemplateIO(html=True)

            extra_context = formdata.submission_context or {}

            r += htmltext('<div class="extra-context">')

                r += htmltext('<h3>%s</h3>') % '%s: %s' % (

            if extra_context.get('thumbnail_url'):

                r += htmltext('<p class="thumbnail"><img src="%s" alt=""/></p>'

                        ) % extra_context.get('thumbnail_url')

            for formdata in formdatas:

                r += htmltext('<li class="smallitem">')

                label = ''

                label += _('#%s, %s') % (formdata.id,

                        misc.localstrftime(formdata.receipt_time))

                r += htmltext('<a href="%s/%s">%s</a>') % (

    tracking_code = None

    backoffice_submission = False

    submission_context = None

    workflow_data = None

    workflow_roles = None

            empty &= (self.data.get(key) is None)

        return empty

    def just_created(self):

        self.receipt_time = time.localtime()

        self.status = 'wf-%s' % self.formdef.workflow.possible_status[0].id

        'anonymised', 'workflow_roles', 'workflow_roles_array',

        'concerned_roles_array', 'tracking_code',

        'actions_roles_array', 'backoffice_submission',

    # migrations

    if not 'fts' in existing_fields:

    if not 'submission_context' in existing_fields:

        cur.execute('''ALTER TABLE %s ADD COLUMN submission_context bytea''' % table_name)

    # add new fields

    for field in formdef.fields:

        assert field.id is not None

    view_fields = []

    view_fields.append(("int '%s'" % (formdef.category_id or 0), 'category_id'))

    view_fields.append(("int '%s'" % (formdef.id or 0), 'formdef_id'))

        view_fields.append((field, field))

    return view_fields

        ('tracking_code', 'varchar'),

        ('backoffice_submission', 'boolean'),

        ('submission_context', 'bytea'),

    ]

    def __init__(self, id=None):

                'tracking_code': self.tracking_code,

                'backoffice_submission': self.backoffice_submission,

                'submission_context': self.submission_context,

        }

        if self.receipt_time:

            sql_dict['receipt_time'] = datetime.datetime.fromtimestamp(time.mktime(self.receipt_time)),

    return result

def migrate_global_views(conn, cur):

    cur.execute('''SELECT COUNT(*) FROM information_schema.tables

        migrate_views(conn, cur)

        for formdef in FormDef.select():

            formdef.data_class().rebuild_security()

        # 7: add backoffice_submission to tables and views

        # 8: add submission_context to tables

        # 9: add last_update_time to views

        migrate_views(conn, cur)

    cur.execute('''UPDATE wcs_meta SET value = %s WHERE key = %s''', (