必须有更好的方法来做这件事。。我读过瓶子的文档,但它并没有起到多大的帮助。这很管用,但很脏。好像我遗漏了什么。在
@route('/client/new', method="POST")
def add_new_client():
c = db.cursor()
query = """INSERT INTO Clients VALUES(NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"""
try:
r = request.POST
d = r['LastContact'].split('/') # mm/dd/yyyy
try: lastcontact = datetime(int(d[2]), int(d[0]), int(d[1]))
except Exception as e: lastcontact = datetime.now()
try: taxExempt = r['TaxExempt']
except Exception as e: taxExempt = 0
c.execute(query, (r['FirstName'], r['LastName'], r['Address1'], r['Address2'], r['City'], r['State'], r['Zip'],
r['HomePhone'], r['CellPhone'], r['WorkPhone'], r['Email'], r['ContactMethod'], r['ContactTime'],
r['ContactFrequency'], lastcontact, taxExempt, r['TaxID'], r['Notes']))
db.commit()
except Exception as e:
print "ERROR %s" % e
redirect('/client/%d' % c.lastrowid)
c.close()
如果使用^{} ORM,事情看起来会更干净,相关文章:
如果您希望继续混合使用SQL和Python,可以通过使用命名/关键字查询占位符来简化代码,这将允许您将
r
字典传递到查询中:相关问题 更多 >
编程相关推荐