Produits Entr'ouvert » w.c.s.

        conn, cur = get_connection_and_cursor()

    table_name = get_formdef_table_name(formdef)

    cur.execute(

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

                                    formdata_id integer REFERENCES %s (id) ON DELETE CASCADE)'''

            % (table_name, table_name)

        )

    cur.execute(

        '''SELECT column_name FROM information_schema.columns

        # them even if not asked to.

        redo_views(conn, cur, formdef, rebuild_global_views=rebuild_global_views)

    if own_conn:

        conn.commit()

        cur.close()

                '%(create_index)s %(table_name)s_%(attr)s_idx ON %(table_name)s (%(attr)s)'

                % {'create_index': create_index, 'table_name': table_name, 'attr': attr}

            )

@guard_postgres

            value = str(value)

        if '%s_array' % index in [x[0] for x in cls._table_static_fields]:

                cls._table_name,

                index,

            )

# latest migration, number + description (description is not used

# programmaticaly but will make sure git conflicts if two migrations are

# separately added with the same number)

def migrate_global_views(conn, cur):

        # 51: add index on formdata blockdef fields

        # 55: update full text normalisation (switch to unidecode)

        set_reindex('formdata', 'needed', conn=conn, cur=cur)

        from wcs.carddef import CardDef

        from wcs.formdef import FormDef

        # 35: add indexes on formdata(receipt_time) and formdata(anonymised)

        # 36: add index on formdata(user_id)

        # 45 & 46: add index on formdata(status)

        for formdef in FormDef.select() + CardDef.select():

            do_formdef_indexes(formdef, created=False, conn=conn, cur=cur)

    if sql_level < 32: