Python, Sqlite not saving results on the file

This seems to work alright for me ("In database" increases on each run):

import random, sqlite3

conn = sqlite3.connect("people.db")
cursor = conn.cursor()

sql = 'create table if not exists people (id integer, name VARCHAR(255))'
cursor.execute(sql)

for x in xrange(5):
    cursor.execute('insert into people VALUES (?, "test")', (random.randint(1, 10000),))
conn.commit()

cursor.execute("select count(*) from people")
print "In database:", cursor.fetchone()[0]

BINGO ! people! I Had the same problem. One of thr reasons where very simple. I`am using debian linux, error was

Unable to open database "people.db": file is encrypted or is not a database

database file was in the same dir than my python script connect line was
conn = sqlite3.connect('./testcases.db')

I changed this

conn = sqlite3.connect('testcases.db')

! No dot and slash. Error Fixed. All works

If someone think it is usefull, you`re welcome