擅长:python、mysql、java
<p>我有点小问题。txt文件太小,无法存储这样的数据,所以我决定使用数据库。但是在我的新代码之后,我收到了一条错误消息:</p>
<pre><code>File "C:\Users\zolka\workspace\LottoAllCombination\LottoCombinations.py", line 34, in <module>
c.execute("INSERT INTO test (word) VALUES (?)", (i,))
sqlite3.InterfaceError: Error binding parameter 0 - probably unsupported type.
from itertools import combinations, groupby
from operator import itemgetter
import sqlite3
data = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35]
def find_consecutive(lst, min_string=5):
for k, g in groupby(enumerate(lst), lambda (i,x):i-x):
num_string = map(itemgetter(1), g)
if len(num_string) >= 5:
yield num_string
con = sqlite3.connect("dictionary.sqlite")
c = con.cursor()
c.execute("CREATE TABLE test (word char(14))")
for i in combinations(data, 7):
if not any(find_consecutive(i, min_string=5)):
c.execute("INSERT INTO test (word) VALUES (?)", (i,))
con.commit()
</code></pre>