Auto schema/examples

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

This page is for examples of check functions:

Check if cul_user column on cu_log table has default value of 0

    default = db.get_columns('cu_log')['cul_user']['COLUMN_DEFAULT']
    return str(default) == '0'

The same as above but only on enwiktionary

    default = db.get_columns('cu_log', 'enwiktionary')['cul_user']['COLUMN_DEFAULT']
    return str(default) == '0'

If revsrc_user column on revsrc table is unsigned (on enwikivoyage only)

    column = db.get_columns('revsrc', 'enwikivoyage')['revsrc_user']
    return 'unsigned' in column['COLUMN_TYPE'].lower()

If cul_user index exists on cu_log table

    return 'cul_user' not in db.get_indexes('cu_log')

Same as above but only on frwikisource

    return 'cul_user' not in db.get_indexes('cu_log', 'frwikisource')

Whether cul_user index on cu_log table is unique

    return db.get_indexes('cu_log')['cul_user']['unique']

If column cul_actor exists in cul_user index on cu_log table

    return 'cul_actor' in db.get_indexes('cu_log')['cul_user']['columns']

If column ft_title exists in flaggedtemplates but skip wikis that don't have flaggedtemplates table

    columns = db.get_columns('flaggedtemplates')
    if not columns:
        return True
    return 'ft_title' not in columns