python - 如果数据库连接失败，如何写入文件

Question

我有下面的Python脚本，它运行得很好，但是我想介绍一些故障安全选项..该故障安全选项是..

1)如果找不到(在此示例中)Michael，我想写入文件ERROR ..

2)如果数据库由于某种原因不允许我连接，我想写入另一个文件CONNECTION_ERROR

这是我的脚本:

#! /usr/bin/python

import pymssql

import sys
sys.path.insert(0, '/opt/mount/safe')
from secrets import password

conn = pymssql.connect(
server="server",
port=port,
user="user",
password=password,
database="database")
conn

cursor = conn.cursor()
cursor.execute("SELECT name, address FROM database WHERE name = 'michael'")
with open('safe/file.txt', 'w') as f:
     for row in cursor.fetchall():
        print ( "Person " + (row[0])),
        print ( "has this address " + (row[1]))
        f.write(str( "Person " + (row[0])))
        f.write("%s\n" % str( " has this address " + (row[1])))
conn.close()

Answer 1

花了我一段时间，但以下内容确实非常好

import sys, pymssql, string, os, calendar, datetime, traceback, socket, platform

try:
        d = datetime.datetime.now()
        log = open("LogFile.txt","a")
        log.write("----------------------------" + "\n")
        log.write("----------------------------" + "\n")
        log.write("Log: " + str(d) + "\n")
        log.write("\n")
# Start process...
        starttime = datetime.datetime.now()
        log.write("Begin process:\n")
        log.write("     Process started at "
        + str(starttime) + "\n")
        log.write("\n")

xxxxxx 

CODE HERE

XXXXXX



        endtime = datetime.datetime.now()
# Process Completed...
        log.write("     Completed successfully in "
        + str(endtime - starttime) + "\n")
        log.write("\n")
        log.close()
except:
        tb = sys.exc_info()[2]
        tbinfo = traceback.format_tb(tb)[0]
# Concatenate information together concerning
# the error into a message string
        pymsg = "PYTHON ERRORS:\nTraceback info:\n" + tbinfo + "\nError Info:\n" + str(sys.exc_info())
# Return python error messages for use in
# script tool or Python Window
        log.write("" + pymsg + "\n")
        log.close()