mendevi.database.create

Initialize the SQL database.

Functions

create_database(filename)	Create a new SQL database to store all video informations.
is_sqlite(file)	Test if the provided path is an sqlite3 database.

Details

mendevi.database.create.create_database(filename: str | bytes | Path) → None

Create a new SQL database to store all video informations.

Parameters

filenamepathlike

The path of the new database to be created.

Examples

>>> import os, tempfile
>>> from mendevi.database.create import create_database
>>> create_database(database := tempfile.mktemp(suffix=".sqlite"))
>>> os.remove(database)
>>>

mendevi.database.create.is_sqlite(file: str | bytes | Path) → bool

Test if the provided path is an sqlite3 database.

Examples

>>> import os, pathlib, tempfile
>>> from mendevi.database.create import create_database, is_sqlite
>>> database = pathlib.Path(tempfile.mktemp())
>>> is_sqlite(database)
False
>>> create_database(database)
>>> is_sqlite(database)
True
>>> os.remove(database)
>>>