Making it Pythonic: create a sqlite3 database if it doesn't exist?

python, sqlite

Solution

I think you can do it like this:

import sqlite3
conn = sqlite3.connect('Database/testDB.db')

This should connect to your database and create it in case that it doesn't exist. I'm not sure this is the most pythonic way, but it does use the `sqlite3` module instead of the `sqlite3` command.

Problem

I wrote a Python script which initializes an empty database if it doesn't exist. ``` import os if not os.path.exists('Database'): os.makedirs('Database') os.system('sqlite3 Database/testDB.db ";"') # rest of the script... ``` Can I do this in a more Pythonic fashion, with a try-except, or is this kind of code acceptable?

Original source