我正在制作一个scrabblecheat计划
下面是一些例子,我在下面的代码中使用SQLite来创建一个简单的数据库来存储我的单词.
但它告诉我我无法重新创建数据库表.
如何在检查中是否已经有一个名为spwords的表,然后跳过尝试创建它?
错误:
(, OperationalError('table spwords already exists',), None)
代码:
def load_db(data_list):
# create database/connection string/table
conn = sqlite.connect("sowpods.db")
#cursor = conn.cursor()
# create a table
tb_create = """CREATE TABLE spwords
(sp_word text, word_len int, word_alpha text, word_score int)
"""
conn.execute(tb_create) #
conn.commit()
# Fill the table
conn.executemany("insert into spwords(sp_word, word_len, word_alpha, word_score) values (?,?,?,?)", data_list)
conn.commit()
# Print the table contents
for row in conn.execute("select sp_word, word_len, word_alpha, word_score from spwords"):
print (row)
if conn:
conn.close()