dm_db_json Module

Database JSON functions.


Uses

  • module~~dm_db_json~~UsesGraph module~dm_db_json dm_db_json module~dm_db dm_db module~dm_db_json->module~dm_db module~dm_db_count dm_db_count module~dm_db_json->module~dm_db_count module~dm_db_query dm_db_query module~dm_db_json->module~dm_db_query module~dm_db_row dm_db_row module~dm_db_json->module~dm_db_row module~dm_error dm_error module~dm_db_json->module~dm_error module~dm_kind dm_kind module~dm_db_json->module~dm_kind module~dm_sql dm_sql module~dm_db_json->module~dm_sql module~dm_db->module~dm_db_query module~dm_db->module~dm_error module~dm_db->module~dm_kind iso_c_binding iso_c_binding module~dm_db->iso_c_binding module~dm_util dm_util module~dm_db->module~dm_util sqlite3 sqlite3 module~dm_db->sqlite3 module~dm_db_count->module~dm_db module~dm_db_count->module~dm_error module~dm_db_count->module~dm_kind module~dm_db_count->module~dm_sql module~dm_db_query->module~dm_error module~dm_db_query->module~dm_kind module~dm_db_row->module~dm_db module~dm_db_row->module~dm_error module~dm_db_row->module~dm_util module~dm_error->module~dm_kind module~dm_ascii dm_ascii module~dm_error->module~dm_ascii iso_fortran_env iso_fortran_env module~dm_kind->iso_fortran_env module~dm_sql->module~dm_ascii module~dm_util->module~dm_error module~dm_util->module~dm_kind

Used by

  • module~~dm_db_json~~UsedByGraph module~dm_db_json dm_db_json module~dmpack dmpack module~dmpack->module~dm_db_json

Interfaces

public interface dm_db_json_select_beats

Generic JSON logs select function.

  • private function db_json_select_beats_array(db, strings, limit, nbeats) result(rc)

    Returns beats in JSON format in allocatable string type array strings.

    If no beats have been found, the array will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_ALLOC if memory allocation failed.
    • E_DB_BIND if value binding failed.
    • E_DB_NO_ROWS if no rows are returned.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(string_type), intent(out), allocatable :: strings(:)

    Returned JSON array.
    integer(kind=i8), intent(in), optional :: limit

    Max. number of beats.
    integer(kind=i8), intent(out), optional :: nbeats

    Number of beats.

    Return Value integer

  • private function db_json_select_beats_iter(db, db_stmt, json, limit, validate) result(rc)

    Iterator function that returns beats in JSON format in allocatable string json. The statement db_stmt must be finalised once finished.

    If no beats have been found, the string will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_DB_BIND if value binding failed.
    • E_DB_DONE if statement finished.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(db_stmt_type), intent(inout) :: db_stmt

    Database statement type.
    character(len=:), intent(out), allocatable :: json

    Returned JSON.
    integer(kind=i8), intent(in), optional :: limit

    Max. number of beats.
    logical, intent(in), optional :: validate

    Validate column types.

    Return Value integer

public interface dm_db_json_select_logs

Generic JSON logs select function.

  • private function db_json_select_logs_array(db, strings, node_id, sensor_id, target_id, source, from, to, min_level, max_level, error, desc, limit, nlogs) result(rc)

    Returns logs in JSON format in allocatable string type array strings.

    If no logs have been found, the array will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_ALLOC if memory allocation failed.
    • E_DB_BIND if value binding failed.
    • E_DB_FINALIZE if statement finalisation failed.
    • E_DB_NO_ROWS if no rows are returned.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(string_type), intent(out), allocatable :: strings(:)

    Returned JSON array.
    character(len=*), intent(in), optional :: node_id

    Node id.
    character(len=*), intent(in), optional :: sensor_id

    Sensor id.
    character(len=*), intent(in), optional :: target_id

    Target id.
    character(len=*), intent(in), optional :: source

    Source name.
    character(len=*), intent(in), optional :: from

    Begin of time range.
    character(len=*), intent(in), optional :: to

    End of time range.
    integer, intent(in), optional :: min_level

    Minimum log level.
    integer, intent(in), optional :: max_level

    Maximum log level.
    integer, intent(in), optional :: error

    Error code.
    logical, intent(in), optional :: desc

    Descending order.
    integer(kind=i8), intent(in), optional :: limit

    Max. numbers of logs.
    integer(kind=i8), intent(out), optional :: nlogs

    Number of logs.

    Return Value integer

  • private function db_json_select_logs_iter(db, db_stmt, json, node_id, sensor_id, target_id, source, from, to, min_level, max_level, error, desc, limit, validate) result(rc)

    Iterator function that returns logs in JSON format in allocatable character json. The statement db_stmt must be finalised once finished.

    If no logs have been found, the string will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_DB_BIND if value binding failed.
    • E_DB_DONE if statement finished.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(db_stmt_type), intent(inout) :: db_stmt

    Database statement type.
    character(len=:), intent(out), allocatable :: json

    Returned JSON.
    character(len=*), intent(in), optional :: node_id

    Node id.
    character(len=*), intent(in), optional :: sensor_id

    Sensor id.
    character(len=*), intent(in), optional :: target_id

    Target id.
    character(len=*), intent(in), optional :: source

    Source name.
    character(len=*), intent(in), optional :: from

    Begin of time range.
    character(len=*), intent(in), optional :: to

    End of time range.
    integer, intent(in), optional :: min_level

    Minimum log level.
    integer, intent(in), optional :: max_level

    Maximum log level.
    integer, intent(in), optional :: error

    Error code.
    logical, intent(in), optional :: desc

    Descending order.
    integer(kind=i8), intent(in), optional :: limit

    Max. numbers of logs.
    logical, intent(in), optional :: validate

    Validate column types.

    Return Value integer

public interface dm_db_json_select_nodes

Generic JSON nodes select function.

  • private function db_json_select_nodes_array(db, strings, limit, nnodes) result(rc)

    Returns nodes in JSON format in allocatable string type array strings.

    If no nodes have been found, the array will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_ALLOC if memory allocation failed.
    • E_DB_BIND if value binding failed.
    • E_DB_NO_ROWS if no rows are returned.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(string_type), intent(out), allocatable :: strings(:)

    Returned JSON array.
    integer(kind=i8), intent(in), optional :: limit

    Max. number of nodes.
    integer(kind=i8), intent(out), optional :: nnodes

    Number of nodes.

    Return Value integer

  • private function db_json_select_nodes_iter(db, db_stmt, json, limit, validate) result(rc)

    Iterator function that returns nodes in JSON format in allocatable string json. The statement db_stmt must be finalised once finished.

    If no nodes have been found, the string will be empty, and the function returns E_DB_NO_ROWS.

    The function returns the following error codes:

    • E_DB_BIND if value binding failed.
    • E_DB_DONE if statement finished.
    • E_DB_PREPARE if statement preparation failed.
    • E_DB_TYPE if returned columns are unexpected.

    Arguments

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

    Database type.
    type(db_stmt_type), intent(inout) :: db_stmt

    Database statement type.
    character(len=:), intent(out), allocatable :: json

    Returned JSON.
    integer(kind=i8), intent(in), optional :: limit

    Max. number of nodes.
    logical, intent(in), optional :: validate

    Validate column types.

    Return Value integer


Functions

public function dm_db_json_select_beat(db, json, node_id) result(rc)

Returns heartbeat associated with given node id as allocatable character json in JSON format.

Read more…

Arguments

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

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

Returned JSON.
character(len=*), intent(in) :: node_id

Node id.

Return Value integer

public function dm_db_json_select_log(db, json, log_id) result(rc)

Returns log associated with given id as allocatable character in JSON format in json. If no log has been found, the string will be empty and the function returns E_DB_NO_ROWS.

Read more…

Arguments

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

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

Returned JSON.
character(len=*), intent(in) :: log_id

Log id.

Return Value integer

public function dm_db_json_select_node(db, json, node_id) result(rc)

Returns node associated with given node id as allocatable character json in JSON format.

Read more…

Arguments

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

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

Returned JSON.
character(len=*), intent(in) :: node_id

Node id.

Return Value integer