system_status.py 文件源码

def _get_table(table, silence_columns = []):
    "Returns all rows from a cursor as a dict"

    cursor = connection.cursor()
    cursor.execute("SELECT * FROM %s;" % table)
    desc = cursor.description

    select_columns = []
    columns = [col[0] for col in desc]
    for i, col_name in enumerate(columns):
        if col_name not in silence_columns:
            select_columns.append(i)

    return {
        'columns': [columns[i] for i in select_columns],
        'rows': [
            [row[i] for i in select_columns] for row in cursor.fetchall()
        ]
    }