db

func ConnectDB ¶

func ConnectDB() (*sql.DB, string, error)

ConnectDB opens a connection to a SQLite database. It returns a pointer to the sql.DB object and an error if any occurs.

func FileExists ¶

func FileExists(filePath string) bool

FileExists This function checks if a file exists, if it does returns true. Otherwise it returns false.

func IsSetup ¶

func IsSetup(db *sql.DB) bool

IsSetup checks if the database has been set up.

1. Returns false if the tasks table does not exist
2. Returns true if the tasks table exists

func ResetDB ¶

func ResetDB(db *sql.DB) error

ResetDB drops all tables and recreates them.

func SetupDB ¶

func SetupDB(db *sql.DB) error

SetupDB Setup the Initial DB Schema

1. Creates the areas and tasks tables if they do not exist
2. Returns an error if any occurs
3. Uses transactions for safety
4. Uses prepared statements for better performance