打印警告-sqlalchemy

Question

我正在使用sqlalchemy将数据帧上传到AWS RDS Mysql。下面是我的代码，我也想显示警告(特别是数据截断(。

def load_data(translog,input_size):
try:
print("Creating connection")
engine = create_engine("mysql+mysqlconnector://<username>:<pwd>@XXXXXXX.rds.amazonaws.com/XXXX",
poolclass=NullPool)
with engine.connect() as connection:
translog.to_sql(con=connection,name='transtry',if_exists='append', index=False)
connection.close()
except Exception as e:
#except mysql.connector.Error as error:
print("Failed to insert record into Transaction table {}".format(e))
engine.dispose()
print("MySQL connection is closed")

Answer 1

您可以使用python记录器模块，它是内置的，并将其设置为stdout输出。

参考：https://docs.python.org/3/howto/logging.html