· 8 years ago · Jun 26, 2018, 12:52 PM
1c.execute(''' CREATE TABLE IF NOT EXISTS CULTURES(ID INTEGER PRIMARY KEY ,CULTURE TEXT UNIQUE)''')
2 culs=[]
3 culture=col[1].text.split(',')
4 for item in culture:
5 if item not in culs and "..."not in item:
6 culs.append(item)
7
8 c.execute("INSERT INTO CULTURES VALUES(null,?)",([item]))
9 Cultu_pk=c.lastrowid