输出非常杂乱

2024-06-16 13:35:29 发布

您现在位置:Python中文网/ 问答频道 /正文

output is like 我使用可美化的python以表格形式显示了来自数据库的结果。但结果是无组织的。你知道吗

try:
    connection = mysql.connector.connect(host='localhost',
                                 database='testdb',
                                 user='root',
                                 password='Pooja@123')
    cur= connection.cursor()
    sql = "select ip,ports,services from output where date=now()"
    number_of_rows = cur.execute(sql)
    table=BeautifulTable()
    table.set_style(BeautifulTable.STYLE_DOTTED)
    table.column_headers=["ip","ports","services"]
    table.column_alignments['ip'] = BeautifulTable.ALIGN_LEFT
    table.column_alignments['ports'] = BeautifulTable.ALIGN_LEFT
    table.column_alignments['services'] = BeautifulTable.ALIGN_RIGHT

    row=cur.fetchall()
    for r in row:
        table.append_row(r)

    print(table)

Tags: ipoutputsqlisservicetablecolumnports