Re: [sqlite] Using IGNORE for complete record match

2016-10-21 Thread Rick Kohrs
an existing record compared to that of a >> proposed new record. That help? >> >>> On 10/21/2016 4:49 PM, Simon Slavin wrote: >>>> On 21 Oct 2016, at 10:46pm, Rick Kohrs <rick.ko...@ssec.wisc.edu> wrote: >>>> >>>> I want to make sure that I do

Re: [sqlite] Using IGNORE for complete record match

2016-10-21 Thread Rick Kohrs
All fields would match in an existing record compared to that of a proposed new record. That help? On 10/21/2016 4:49 PM, Simon Slavin wrote: On 21 Oct 2016, at 10:46pm, Rick Kohrs <rick.ko...@ssec.wisc.edu> wrote: I want to make sure that I do not insert a new record if ALL of the var

[sqlite] Using IGNORE for complete record match

2016-10-21 Thread 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,

Re: [sqlite] Troubles matching variable as type TIMESTAMP

2016-10-21 Thread Rick Kohrs
thanks On 10/21/2016 3:04 PM, Keith Medcalf wrote: SQLite does not have a type of "TIMESTAMP". Only TEXT, INTEGER, REAL, and BLOB. They type of the data in the field depends on what you are storing in it. What are you storing in it (you cannot store Python objects, such as a datetime

[sqlite] Troubles matching variable as type TIMESTAMP

2016-10-21 Thread Rick Kohrs
Using Python 3.19. I am reading in a lines from an ever growing log file. Values from each line of the log file are parsed and placed into a database. Each record has a variable of type TIMESTAMP. Multiple records have the same the same value for time stamp. After a line is processed, I need