[Tutor] How best to determine if a db exists before trying to open it? [Was: try and file existence]
Steven D'Aprano
steve at pearwood.info
Sun Aug 16 11:46:29 CEST 2015
On Sat, Aug 15, 2015 at 06:24:12PM -0500, boB Stepp wrote:
> db = sqlite3.connect("my_db.db")
>
> 1) This will open the db if it exists already, which is normally what
> I will want. But...
>
> 2) My understanding is that if for whatever reason the db file is not
> found, then the connect statement will create a new instance of the
> db, which is what I normally would not want (Except at the time of
> initial creation).
[...]
> If I am understanding everything so far, I think that my situation
> would be appropriate for using os.path.exists(). Is this correct?
Sure, why not?
If might not be an utterly bullet-proof solution, but it will do the
job for now and you can always revisit it later if needed.
--
Steve
More information about the Tutor
mailing list