Auto schema/examples

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