Python Sqlite3- Python shell can create and edit databases but why can't a .py file create or access any database

Question

import sqlite3
db=sqlite3.connect('new.db')
cursor=db.cursor()
cursor.execute('''CREATE TABLE hello(id INTEGER PRIMARY KEY,
Message_type, time_sent, time_received, response)''')

The above program when executed from the python shell will execute and create a database by the said name but when i run the same program from a .py file,it won't create any table or database

How do you know that it didn't create the table? Does it produce an error message? — Robᵩ
– Robᵩ, Commented Jul 21, 2016 at 14:26
Because i manually check it by a database browser.-dbbrowser for sqlite — lotrgandalf
– lotrgandalf, Commented Jul 21, 2016 at 14:28
What happens if you add db.commit() and db.close() in the script? — Kyle
– Kyle, Commented Jul 21, 2016 at 15:56

Rolf of Saxony · Accepted Answer · 2016-07-21 14:41:01Z

1

import sqlite3
from os.path import expanduser
db_dir = expanduser("~")
db=sqlite3.connect(db_dir+'/new.db')
cursor=db.cursor()
cursor.execute('''CREATE TABLE hello(id INTEGER PRIMARY KEY,
Message_type, time_sent, time_received, response)''')

Now look in your home directory for new.db

answered Jul 21, 2016 at 14:41

Rolf of Saxony

22.6k5 gold badges43 silver badges61 bronze badges

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

3 Comments

lotrgandalf Over a year ago

The code that your provided me with created the database but its read only ,i cannot make any changes to it. Is there a way to make it read/write by any user?

Rolf of Saxony Over a year ago

That is probably because it is in your $HOME directory. Make db_dir equal to somewhere to which everyone else has access. /home/public or something.

lotrgandalf Over a year ago

I fixed it by some basic linux command that changes ownership of the created database.

Robᵩ · Accepted Answer · 2016-07-21 14:29:21Z

0

I suppose that the .py file did create the database file, but you aren't looking for the database file at the correct location. Add this to the end of your program:

print(os.path.join(os.getcwd(), 'new.db'))

Whatever it prints, look there for your database file.

answered Jul 21, 2016 at 14:29

Robᵩ

170k20 gold badges251 silver badges323 bronze badges

3 Comments

lotrgandalf Over a year ago

Does the python shell and .py file save .db files in different directories?

Robᵩ Over a year ago

That depends upon how they are each invoked. Since you don't specify how you invoke either, this seems like a possibility.

lotrgandalf Over a year ago

I tried your suggestion. However the data base is not in the location returned by the os.path command.

Collectives™ on Stack Overflow

Python Sqlite3- Python shell can create and edit databases but why can't a .py file create or access any database

2 Answers 2

3 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related