Hack Forums
[Python] python sqlite3 inserting null values when not allowed - Printable Version

+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Software Development (https://hackforums.net/forumdisplay.php?fid=118)
+---- Thread: [Python] python sqlite3 inserting null values when not allowed (/showthread.php?tid=5407330)



python sqlite3 inserting null values when not allowed - datguy.dev - Sep 16, 2016

Greetings,
I've been playing around with sqlite in python. I have this issue where I need the primary key to increment (sql side only). It keeps inserting null values there even if I specify to not allow null. :D
Anyone have success with this? I've googled and found a few suggestions; no luck. It always has the same results. I also get the same results if I slam the insert function in my script or if I take it nice and slow. I must be doing something wrong.

connection method:
connect = sqlite3.connect(sqlFile, isolation_level=None)

[Image: SL0xQm4.png]



* - █BORNE█ - Sep 16, 2016

defu x deuf python

enjoy


* - datguy.dev - Sep 16, 2016

(Sep 16, 2016 11:24 AM)█BORNE█ Wrote:  defu x deuf python

enjoy

Mind explaining what you mean by defu x deuf? Never heard that before. Are you saying its shit?


Though it would be great, I dropped the autoincrement. My functions aren't calling those queries anymore so I'm just marking this solved.