On Mon, Aug 24, 2015 at 9:00 PM, Cecil Westerhof wrote:
> On Sunday 23 Aug 2015 16:03 CEST, Chris Angelico wrote:
>
>> On Sun, Aug 23, 2015 at 11:18 PM, Cecil Westerhof wrote:
>>> Also an URL is unique, so I need to check that if it is found, the
>>> values are the same as the ones I wanted to in
On Sunday 23 Aug 2015 16:03 CEST, Chris Angelico wrote:
> On Sun, Aug 23, 2015 at 11:18 PM, Cecil Westerhof wrote:
>> Also an URL is unique, so I need to check that if it is found, the
>> values are the same as the ones I wanted to insert.
>
> And if they aren't? Currently, all you do is print ou
On Mon, Aug 24, 2015 at 2:17 AM, Dennis Lee Bieber
wrote:
> SQLite3 supports the non-standard
>
> INSERT OR REPLACE ...
>
> (or one can do INSERT OR IGNORE; the OR XXX has a number of values that are
> allowed to control behavior... BUT the OR clause only applies if a UNIQU
On Sun, Aug 23, 2015 at 11:18 PM, Cecil Westerhof wrote:
> Also an URL is unique, so I need to check that if it is found, the
> values are the same as the ones I wanted to insert.
And if they aren't? Currently, all you do is print out a message and
continue on; what happens if you get the same UR
I understood that with sqlite3 in Python you can not use prepared
statements. Below the way I solved this.
Also an URL is unique, so I need to check that if it is found, the
values are the same as the ones I wanted to insert.
This is my code.
==
