def display_sql(cursor,title,header,padd):
col_names = [cn[0].upper() for cn in cursor.description]
rows = cursor.fetchall()
sqlr = prettytable.PrettyTable()
sqlr.header = header
sqlr.padding_width = padd
sqlr.hrules = prettytable.ALL
sqlr.vrules = prettytable.ALL
sqlr.title = title
row_id = -1
for name in col_names:
row_id += 1
sqlr.add_column(name, [row[row_id] for row in rows])
return sqlr
# MCE Version Header
评论列表
文章目录