dm_db_select_observs_by_id Function

public function dm_db_select_observs_by_id(db, observs, after, before, limit, stub, nobservs) result(rc)

Uses

  • proc~~dm_db_select_observs_by_id~~UsesGraph proc~dm_db_select_observs_by_id dm_db_select_observs_by_id module~dm_observ dm_observ proc~dm_db_select_observs_by_id->module~dm_observ module~dm_error dm_error module~dm_observ->module~dm_error module~dm_id dm_id module~dm_observ->module~dm_id module~dm_kind dm_kind module~dm_observ->module~dm_kind module~dm_node dm_node module~dm_observ->module~dm_node module~dm_request dm_request module~dm_observ->module~dm_request module~dm_response dm_response module~dm_observ->module~dm_response module~dm_sensor dm_sensor module~dm_observ->module~dm_sensor module~dm_target dm_target module~dm_observ->module~dm_target module~dm_time dm_time module~dm_observ->module~dm_time module~dm_util dm_util module~dm_observ->module~dm_util module~dm_uuid dm_uuid module~dm_observ->module~dm_uuid 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_node->module~dm_id module~dm_node->module~dm_kind module~dm_request->module~dm_error module~dm_request->module~dm_id module~dm_request->module~dm_kind module~dm_request->module~dm_response module~dm_request->module~dm_time module~dm_request->module~dm_util module~dm_string dm_string module~dm_request->module~dm_string module~dm_response->module~dm_error module~dm_response->module~dm_id module~dm_response->module~dm_kind module~dm_response->module~dm_util module~dm_sensor->module~dm_id module~dm_sensor->module~dm_kind module~dm_sensor->module~dm_node module~dm_target->module~dm_id module~dm_target->module~dm_kind module~dm_target->module~dm_util module~dm_time->module~dm_error module~dm_time->module~dm_kind module~dm_time->module~dm_util module~dm_util->module~dm_error module~dm_util->module~dm_kind module~dm_string->module~dm_error module~dm_string->module~dm_kind

Returns observations of a given id range in observs. The argument after is the id of the observation after which the range starts, before the id of the observation that limits the range.

The function returns the following error codes:

  • E_ALLOC if memory allocation failed.
  • E_INVALID if observations of given ids are not related.
  • 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(observ_type), intent(out), allocatable :: observs(:)

Returned observation data.
character(len=*), intent(in) :: after

Id of observation with timestamp before first of range.
character(len=*), intent(in), optional :: before

Id of observation with timestamp after last of range.
integer(kind=i8), intent(in), optional :: limit

Max. number of observations.
logical, intent(in), optional :: stub

Without receivers, requests, responses.
integer(kind=i8), intent(out), optional :: nobservs

Total number of observations (may be greater than limit).

Return Value integer


Calls

proc~~dm_db_select_observs_by_id~~CallsGraph proc~dm_db_select_observs_by_id dm_db_select_observs_by_id proc~dm_db_select_observ dm_db_select_observ proc~dm_db_select_observs_by_id->proc~dm_db_select_observ proc~dm_is_error dm_is_error proc~dm_db_select_observs_by_id->proc~dm_is_error sqlite3_bind_int sqlite3_bind_int proc~dm_db_select_observs_by_id->sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_int64 proc~dm_db_select_observs_by_id->sqlite3_bind_int64 sqlite3_bind_text sqlite3_bind_text proc~dm_db_select_observs_by_id->sqlite3_bind_text sqlite3_column_double sqlite3_column_double proc~dm_db_select_observs_by_id->sqlite3_column_double sqlite3_column_int sqlite3_column_int proc~dm_db_select_observs_by_id->sqlite3_column_int sqlite3_column_text sqlite3_column_text proc~dm_db_select_observs_by_id->sqlite3_column_text sqlite3_column_type sqlite3_column_type proc~dm_db_select_observs_by_id->sqlite3_column_type sqlite3_finalize sqlite3_finalize proc~dm_db_select_observs_by_id->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_select_observs_by_id->sqlite3_prepare_v2 sqlite3_reset sqlite3_reset proc~dm_db_select_observs_by_id->sqlite3_reset sqlite3_step sqlite3_step proc~dm_db_select_observs_by_id->sqlite3_step proc~dm_db_select_observ->proc~dm_is_error proc~dm_db_select_observ->sqlite3_bind_int proc~dm_db_select_observ->sqlite3_bind_text proc~dm_db_select_observ->sqlite3_column_double proc~dm_db_select_observ->sqlite3_column_int proc~dm_db_select_observ->sqlite3_column_text proc~dm_db_select_observ->sqlite3_column_type proc~dm_db_select_observ->sqlite3_finalize proc~dm_db_select_observ->sqlite3_prepare_v2 proc~dm_db_select_observ->sqlite3_reset proc~dm_db_select_observ->sqlite3_step