CODEWITHSUNDEEP
pythonsqlite
user3475851
user3475851

Reputation: 11

SQLite-Manager on Firefox and Python

I have written a small test application using SQLite with Python 3.3:

import sqlite3

MDB = sqlite3.connect('D:\MDB.db')              # create the db object
cursor = MDB.cursor()                           # assign a cursor

 cursor.execute('''CREATE TABLE IF NOT EXISTS section (
                   Code        INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
                   Description TEXT )
                ''')

 cursor.execute('''DELETE FROM section''')      # delete contents for reruns

 cursor.execute('''INSERT INTO section
                   (Description)
                   VALUES (?)
                ''', ('Abdul, Paula',))

 cursor.execute('''INSERT INTO section
                   (Description)
                   VALUES (?)
                ''', ('ABWH',))


print('Results:\n')
cursor.execute('''SELECT * FROM section''')
selection = cursor.fetchall()
for row in selection:
    print('\t', row)

The SELECT statement shows the results expected (seeming to indicate that the row exists), but if I connect to the database with SQLite-Manager, the table exists but is empty, and if I try the same query with another script connected to the database, nothing is returned. Can anyone please explain what I am doing wrong?

Upvotes: 1

Views: 428

Answers (1)

cdonts
cdonts

Reputation: 9599

You're not saving changes (calling MDB.commit).

Upvotes: 1

Related Questions