[sqlite] Using IGNORE for complete record match

[Rick Kohrs]

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