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_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_error module~dm_db->module~dm_util iso_c_binding iso_c_binding module~dm_db->iso_c_binding module~dm_db_query dm_db_query module~dm_db->module~dm_db_query module~dm_kind dm_kind module~dm_db->module~dm_kind sqlite3 sqlite3 module~dm_db->sqlite3 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 module~dm_db_query->module~dm_error module~dm_db_query->module~dm_kind iso_fortran_env iso_fortran_env module~dm_kind->iso_fortran_env

Used by

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

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_images(db, sync, transfer) result(rc)

Creates images table in given database. Adds syncs table if argument sync is .true., and transfers table if argument transfer is .true..

Read more…

Arguments

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

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

Add table sync_logs.
logical, intent(in), optional :: transfer

Add table transfers.

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_create_sync_images(db) result(rc)

Creates image synchronisation table.

Read more…

Arguments

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

Database type.

Return Value integer

public function dm_db_table_create_sync_logs(db) result(rc)

Creates log synchronisation table.

Read more…

Arguments

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

Database type.

Return Value integer

public function dm_db_table_create_sync_observs(db) result(rc)

Creates observation synchronisation tables (nodes, sensors, targets, observations).

Read more…

Arguments

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

Database type.

Return Value integer

public function dm_db_table_create_transfers(db) result(rc)

Creates transfers 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_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 beats table.

Arguments

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

Database type.

Return Value logical

public function dm_db_table_has_images(db) result(has)

Returns .true. if database contains images table.

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 logs table.

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 (nodes, sensors, targets, observs, receivers, requests, responses).

Arguments

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

Database type.

Return Value logical

public function dm_db_table_has_sync_images(db) result(has)

Returns .true. if database contains image synchronisation tables.

Arguments

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

Database type.

Return Value logical

public function dm_db_table_has_sync_logs(db) result(has)

Returns .true. if database contains log synchronisation tables.

Arguments

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

Database type.

Return Value logical

public function dm_db_table_has_sync_observs(db) result(has)

Returns .true. if database contains observation synchronisation tables.

Arguments

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

Database type.

Return Value logical

public function dm_db_table_has_transfers(db) result(has)

Returns .true. if database contains transfers table.

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