Re: pysqlite Digest, Vol 24, Issue 7

Hi Dennis


>         Note... using \ line continuations is not common in Python. Use a
> triple quote string instead... Oh, and open (, {, [ also automatically
> continue...
>

Thanx noted!


>         Note that, if "id" is a primary key, it needs to be unique and
> NON-NULL -- so that "where s.id is null" clause should always fail,
> shouldn't it? OR... let me ramble a bit... The left join means all
> "import" records are included, with nulls for non-matching statement
> data... ...you are trying to only insert "import" records that don't
> have a "statement" record with the same date/value/account?

Yes, I'm trying to do a delta based on what I got vs what I have.
Also the import table does not have two of the statement colmns hence
the two null's at the end.
Can you recommend a better way?

>         So... how many records do you /have/ in "statements" already? (I
> don't want to imagine something that maxed out 2^63 records...)

1500+ records.

Thanks

Marinus