import sqlite3
conn = sqlite3.connect(r"D:\aaa.db")
Is there a way to automatically create the db file if it doesn't already exist when I connect to it?
-
Are you asking how SQLite3 works when it creates a new, empty database?S.Lott– S.Lott2010-02-03 03:08:13 +00:00Commented Feb 3, 2010 at 3:08
-
so you want to check if the db is there if not create it?Euclid– Euclid2010-02-03 03:09:59 +00:00Commented Feb 3, 2010 at 3:09
Add a comment
|
6 Answers
The code you give does create 'D:\\aaa.db' if it doesn't exist.
Comments
If it isn't created automatically, make sure that you have the directory permissions correct
Comments
As it was already mentioned, your code should work if you have permissions to write for this path. However, it is important that directory must exist. If you make call for non-existing folder:
conn = sqlite3.connect(r"D:\Some new non-existing folder\aaa.db")
It will not work, you will have
sqlite3.OperationalError: unable to open database file.
The same is for relative paths:
1) conn = sqlite3.connect(r"aaa.db")
2) conn = sqlite3.connect(r"Some new folder\aaa.db")
First will always work, because you are working in already existing directory and second will not work if you do not create te folder beforehand.
Comments
Pretty sure .connect will create the file if it doesn't exist.
Comments
import sqlite3
conn=sqlite3.connect('xx.db')
print "Database created and opened succesfully"
Comments
.connect should create a new database file on the fly, given sub-directories do exist, and you have adequate permissioning.
1 Comment
cfi
While the answer is correct imho it doesn't add any value: It's all been said before