Tables

korus.database.backend.sqlite.tables.create_annotation_table(conn)

Create annotation table according to Korus schema.

TODO: Change tentative_label_id type from INTEGER to JSON ? (to allow for lists)

Or add another column named label_list_id (or similar)

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_deployment_table(conn)

Create deployment table according to Korus schema.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_field_table(conn, parent_table_name)

Create table for storing custom fields.

The table is named _{parent_table_name}_field

Args:

conn: sqlite3.Connection

Database connection

parent_table_name: str

Name of the parent table

korus.database.backend.sqlite.tables.create_file_job_relation_table(conn)

Create file-job relation table according to Korus schema.

Also creates an index on (job_id) for faster querying.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_file_table(conn)

Create file table according to Korus schema.

Also creates an index on (deployment_id, filename) for faster querying.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_granularity_table(conn)

Create granularity table according to Korus schema.

Also adds entries for the standard Korus granularities: unit, window, file, batch, encounter

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_job_table(conn)

Create job table according to Korus schema.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_label_table(conn)

Create label table according to Korus schema.

Also creates an index on (taxonomy_id, sound_source_tag, sound_type_tag) for faster querying.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_storage_table(conn)

Create data-storage table according to Korus schema.

@address can be an IP address or a URL

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_tables(conn)

Create all tables

korus.database.backend.sqlite.tables.create_tag_table(conn)

Create tag table according to Korus schema.

Also adds an entry for auto-generated negatives.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.create_taxonomy_table(conn)

Create taxonomy table according to Korus schema.

Args:

conn: sqlite3.Connection

Database connection

korus.database.backend.sqlite.tables.field_table_name(parent_table_name: str)

korus.database.backend.sqlite.tables.is_field_table(table_name)