I want to make sure that I do not insert a new record if ALL of the
variables match. I can potentially have 3 systems writing to the same
database and I don't want duplicate records
sqlCommand = """
CREATE TABLE himawari_db (
dateTime TEXT,
filename TEXT,
satID TEXT,
year INT,
month INT,
day INT,
hour INT,
minute INT,
band INT,
coverage TEXT,
region INT,
segment INT,
server TEXT);"""
try:
satDB.execute(sqlCommand)
try:
dbConnect.commit()
INSERT or IGNORE does not seem to be working as expected.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users