[sqlite] Troubles matching variable as type TIMESTAMP

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 to

Re: [sqlite] Troubles matching variable as type TIMESTAMP

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 objec

[sqlite] Using IGNORE for complete record match

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] Using IGNORE for complete record match

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 wrote: I want to make sure that I do not insert a new record if ALL of the variables match. I can potentially

Re: [sqlite] Using IGNORE for complete record match

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 wrote: >>>> >>>> I want to make sure that I do not insert a new record if ALL of the >> variables matc