python实现sql代码格式化_从Python执行SQL：格式化结果

import sys

import arcpy

try:

arcpy.env.workspace = sys.path[0]

egdb_conn = arcpy.ArcSDESQLExecute(r"Database Connections\Connection1.sde")

--> sql_statement = """SELECT * FROM USER1.A_TEST_TABLE"""

sql_statement_list = sql_statement.split(";")

print("+++++++++++++++++++++++++++++++++++++++++++++\n")

# For each SQL statement passed in, execute it.

for sql in sql_statement_list:

print(sql)

try:

egdb_return = egdb_conn.execute(sql)

except Exception as err:

print(err)

egdb_return = False

if isinstance(egdb_return, list):

for row in egdb_return:

print(row)

print("+++++++++++++++++++++++++++++++++++++++++++++\n")

else:

if egdb_return == True:

print("SQL statement: {0} ran successfully.".format(sql))

else:

print("SQL statement: {0} FAILED.".format(sql))

print("+++++++++++++++++++++++++++++++++++++++++++++\n")

except Exception as err:

print(err)

脚本工作正常，但输出有点难以阅读：

^{pr2}$

如果结果集可以以更传统的表格格式输出，那会很有帮助。像这样的东西会很棒的(虽然我没有嫁给这个确切的布局)：OBJECTID ID TYPE COST

1 1 APPLE 0.01

2 2 PEAR 0.02

3 3 BANANA 0.03

4 4 MANGO 0.04

5 5 ORANGE 0.05

6 6 BLUEBERRY 0.06

7 7 STRAWBERRY 0.07

8 8 RASPBERRY 0.08

9 9 KIWI 0.09

10 10 PINEAPPLE 1.00

我该怎么做？我不知道如何格式化这些值，因为它们在一个列表中。我不太担心将COST格式化为货币；我可以在SQL中这样做。在