Miscellaneous

initialize_database(; file_name::String="deardiary.db")

Initializes the database by creating the necessary tables.

get_database()::Union{SQLite.DB,Nothing}

Returns a SQLite database connection. If the database has not been initialized, it returns nothing.

Returns

A SQLite.DB object, or nothing if the database is not initialized.

close_database()

Closes the database connection if it is open.

@enum Status IN_PROGRESS = 1 STOPPED = 2 FINISHED = 3

An enumeration representing the status of an experiment.

IN_PROGRESS::Status

An enumeration value representing an experiment that is currently in progress.

STOPPED::Status

An enumeration value representing an experiment that has been stopped.

FINISHED::Status

An enumeration value representing an experiment that has finished.

UpsertResult

A marker abstract type for the result of an upsert operation.

Created

A marker type indicating that a record was successfully created.

Updated <: UpsertResult

A marker type indicating that a record was successfully updated.

Duplicate <: UpsertResult

A marker type indicating that a record already exists.

Unprocessable <: UpsertResult

A marker type indicating that a record violates a constraint and cannot be processed.

Error <: UpsertResult

A marker type indicating that an error occurred while creating or updating a record.