<p>下面是以时间为文本的示例代码。它又快又脏,所以你可以用它来测试。我会把它转换成时间。时间(). 在</p>
<p>如果startType函数参数的数据类型与数据库startTime数据类型不匹配,这当然也是一个问题,并且不会找到匹配项来更新。在</p>
<pre><code>def updateNameWhereTime(time, name): # time is a floating point from time.time(),
print(time, name)
c.execute("UPDATE Flights SET name=? WHERE startTime=?;", (name, time))
conn.commit()
def insertRows(table, startTime, name):
c.execute("INSERT INTO Flights VALUES ('"+startTime+"', '"+name+"')")
def printTableRows(table):
for row in c.execute("SELECT * FROM "+table):
print row
import sqlite3
conn = sqlite3.connect('example.db')
c = conn.cursor()
c.execute('''DROP TABLE IF EXISTS Flights''')
c.execute('''CREATE TABLE Flights
(startTime text, name text)''')
print "Inserting rows into table"
insertRows('Flights','2015-04-11 10:00','Test 1')
insertRows('Flights','2015-04-11 10:05','Test 2')
insertRows('Flights','2015-04-11 10:10','Test 3')
insertRows('Flights','2015-04-11 10:15','Test 4')
print "Original data in table"
printTableRows('Flights')
print "Updating rows in table"
updateNameWhereTime('2015-04-11 10:05','Test 2 Updated')
updateNameWhereTime('2015-04-11 10:10','Test 3 Updated')
print "Updated rows in table"
printTableRows('Flights')
</code></pre>
<p>以下是生成的输出:</p>
^{pr2}$