SQLite not saving data between uses

by

You did not commit your changes into the DB. When you discard the connection, the transaction will be rolled back. This works

import sqlite3 as sq
connection = sq.connect("test.db")
cursor = connection.cursor()
cursor.execute("DROP TABLE IF EXISTS test")
cursor.execute("CREATE TABLE test (st TEXT)")
cursor.execute("INSERT INTO test VALUES ('testing')")
connection.commit() # !!!

cursor.execute("SELECT * FROM test")
print(cursor.fetchall())
cursor.close()
connection.close()  # rolls back changes without .commit()

connection2 = sq.connect("test.db")
cursor2 = connection2.cursor()
cursor2.execute("SELECT * FROM test")
print(cursor2.fetchall())

More Related Contents:

  1. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  2. Python 3 sqlite parameterized SQL-query
  3. How can I convert a .py to .exe for Python?
  4. Best way to convert string to bytes in Python 3?
  5. How to replace NaNs by preceding or next values in pandas DataFrame?
  6. How can I make a for-loop pyramid more concise in Python? [duplicate]
  7. Multiprocessing causes Python to crash and gives an error may have been in progress in another thread when fork() was called
  8. Schrödinger’s variable: the __class__ cell magically appears if you’re checking for its presence?
  9. Integer File Descriptor “0” in open()
  10. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  11. How to put comments in Django templates?
  12. How to annotate function that takes a tuple of variable length? (variadic tuple type annotation)
  13. How to delete a table in SQLAlchemy?
  14. How to check the existence of a row in SQLite with Python?
  15. Customizing the order of legends in plotly
  16. Set encoding in Python 3 CGI scripts
  17. ImportError: cannot import name ‘_ColumnEntity’ from ‘sqlalchemy.orm.query’
  18. How to write List of lists in csv file in python [duplicate]
  19. sqlite3.OperationalError: no such column – but I’m not asking for a column?
  20. Get file path from askopenfilename function in Tkinter
  21. Change Icon For Tkinter Messagebox
  22. Side-effects in Python map (Python “do” block) [duplicate]
  23. Python Pandas – Lookup a variable column depending on another column’s value
  24. With “args” vs without “args” to pass arguments to a thread in Python
  25. How to make print() output UTF-8 in Python 3.0?
  26. Discord.py get user object from id/tag
  27. Static variable in Python?
  28. find a word on a website and get its page link
  29. Sending multiple files through a TCP socket
  30. Subprocess check_output returned non-zero exit status 1

Leave a Comment