Values not being added to SQLite Database through Python

Question

I'm using Python to create a registration system that adds values into an SQLite database. With my code I don't get any errors when ran but the data isn't added into the table.

import sqlite3 as db #Import the SQLite module as db
import smtplib as mail #Importing the send email library as mail
from email.mime.text import MIMEText #Importing the text component of the mail library


#Getting the user to input the their data
username = raw_input("What would you like your username to be? ")
email = raw_input("What is your email address? ")
firstName = raw_input("What is your first name? ")
surname = raw_input("What is your surname? ")
age = raw_input("How old are you? ")
password = raw_input("What is your password?") #Encryption method will be added later
int(age) #Changing the age variable into an integer so it can be inputted into the database

#DB part
conn = db.connect('apollo.db') #Connecting to the database
cursor = conn.cursor()
cursor.execute("INSERT INTO users VALUES(?, ?, ?, ?, ?, ?)",
            (username, email, firstName, surname, age, password)) #Inserting the user's data into the table

conn.close() #Closing the connection

pbacterio · Accepted Answer · 2014-02-28 15:25:19Z

3

You need to commit() the changes.

answered Feb 28, 2014 at 15:25

pbacterio

1,1726 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sirac · Accepted Answer · 2014-02-28 15:28:03Z

0

Like pbacterio already answered, you have to commit your changes by calling cursor.commit(), so any actions that were buffered (in another file, if i remember correctly) will be written in your database file.

answered Feb 28, 2014 at 15:28

Sirac

6934 silver badges19 bronze badges

Comments

codename_subho · Accepted Answer · 2014-02-28 15:33:11Z

0

Also use

age= int(age)

int(age) returns integer value but you need to store back.

answered Feb 28, 2014 at 15:33

codename_subho

4768 silver badges22 bronze badges

Collectives™ on Stack Overflow

Values not being added to SQLite Database through Python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related