[issue18892] sqlite3, valued records not persisted, default ones are
New submission from Heijink: In the end I tracked down the behaviour with the attached program behaviour with an initially empty table: 7 : insert two records with values in the columns two records show up, # 1,2 as expected 9 : show al records none whereas two are to be expected 8 : add records with default values two records show up # 1,2 as expected in an empty table 7 two records # 3,4 record numbers as expected, but where are records 1,2? (ABC) 9 the default records are present #1,2 the previous valued records 3,4 not unexpected, but identical to first behaviour issuing 7 8 4 records show up # 1-4 record numbers as expected when valued records are not present 0 : I quit to summarize: It is not possible to store records in the database with valued columns. Records with default values can be stored and retrieved, they are the ones that are persistent Additional strange behaviour is that after adding valued records (3,4) also the already present records with default values (1,2) should have shown show up, remark (ABC). -- components: Demos and Tools files: dump.py messages: 196617 nosy: debewerker priority: normal severity: normal status: open title: sqlite3, valued records not persisted, default ones are type: behavior versions: Python 3.2 Added file: http://bugs.python.org/file31531/dump.py ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue18892] sqlite3, valued records not persisted, default ones are
R. David Murray added the comment: What happens if you actually call commit()? -- nosy: +r.david.murray ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue18892] sqlite3, valued records not persisted, default ones are
Heijink added the comment: your suggestion is a bit to cryptic for me - you mean intermediate messages from Python: there are none - you mean to change a command in another format newbie with programming experience drop me a program line / show three records where one is your alternative -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue18892] sqlite3, valued records not persisted, default ones are
Peter Otten added the comment: David means you should replace the line conn.commit in your script which does not invoke the method with conn.commit() Side note: as long as you are a newbie it is a good idea to ask on the python mailing list first before adding a report to the bug tracker. -- nosy: +peter.otten ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue18892] sqlite3, valued records not persisted, default ones are
R. David Murray added the comment: Sorry, I didn't mean to be cryptic. Yes, Peter has figured out what I was trying to say. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
[issue18892] sqlite3, valued records not persisted, default ones are
Heijink added the comment: that did the trick, my confidence is restored. sorry to have bothered you, I could have found in myself, by comparing differences. Just staring blind after many attempts. I did look in the list, but could not find an issue that matched my description of the problem. I closed the subject -- status: open - closed ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com