dm_db_table Module

Database table access module.


Uses

  • module~~dm_db_table~~UsesGraph module~dm_db_table dm_db_table module~dm_db dm_db module~dm_db_table->module~dm_db module~dm_db_query dm_db_query module~dm_db_table->module~dm_db_query module~dm_db_stmt dm_db_stmt module~dm_db_table->module~dm_db_stmt module~dm_error dm_error module~dm_db_table->module~dm_error module~dm_sql dm_sql module~dm_db_table->module~dm_sql module~dm_util dm_util module~dm_db_table->module~dm_util module~dm_db->module~dm_db_query module~dm_db->module~dm_db_stmt module~dm_db->module~dm_error module~dm_db->module~dm_sql module~dm_db->module~dm_util iso_c_binding iso_c_binding module~dm_db->iso_c_binding module~dm_id dm_id module~dm_db->module~dm_id module~dm_kind dm_kind module~dm_db->module~dm_kind module~dm_string dm_string module~dm_db->module~dm_string module~dm_time dm_time module~dm_db->module~dm_time module~dm_uuid dm_uuid module~dm_db->module~dm_uuid sqlite3 sqlite3 module~dm_db->sqlite3 module~dm_db_query->module~dm_db_stmt module~dm_db_query->module~dm_error module~dm_db_query->module~dm_kind module~dm_db_stmt->iso_c_binding module~dm_ascii dm_ascii module~dm_error->module~dm_ascii module~dm_error->module~dm_kind module~dm_sql->module~dm_ascii module~dm_util->module~dm_error module~dm_util->module~dm_kind iso_fortran_env iso_fortran_env module~dm_kind->iso_fortran_env module~dm_string->module~dm_error module~dm_string->module~dm_kind module~dm_time->module~dm_error module~dm_time->module~dm_util module~dm_time->module~dm_kind unix unix module~dm_time->unix

Used by

  • module~~dm_db_table~~UsedByGraph module~dm_db_table dm_db_table module~dmpack dmpack module~dmpack->module~dm_db_table

Functions

public function dm_db_table_create_beats(db) result(rc)

Creates beats table in given database.

Read more…

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

Return Value integer

public function dm_db_table_create_logs(db, sync) result(rc)

Creates logs table in given database.

Read more…

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.
logical, intent(in), optional :: sync

Create synchronisation tables.

Return Value integer

public function dm_db_table_create_observs(db, sync) result(rc)

Initialises a connected SQLite 3 database by creating all necessary tables if they do not exist already. The function also creates additional indices and triggers on the tables.

Read more…

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.
logical, intent(in), optional :: sync

Create synchronisation tables.

Return Value integer

public function dm_db_table_has(db, table) result(has)

Returns .true. if given table exists in database.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.
integer, intent(in) :: table

Table enumerator.

Return Value logical

public function dm_db_table_has_beats(db) result(has)

Returns .true. if database contains observation tables.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

Return Value logical

public function dm_db_table_has_logs(db) result(has)

Returns .true. if database contains observation tables.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

Return Value logical

public function dm_db_table_has_observs(db) result(has)

Returns .true. if database contains observation tables.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.

Return Value logical

public function dm_db_table_select(db, tables) result(rc)

Returns an array containing the names of all tables in the given database.

Read more…

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.
character(len=SQL_TABLE_NAME_LEN), intent(out), allocatable :: tables(:)

Array of tables.

Return Value integer