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_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 unix unix module~dm_time->unix module~dm_util->module~dm_error module~dm_util->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_STEP if step execution 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 interface~dm_db_bind dm_db_bind proc~dm_db_select_observs_by_id->interface~dm_db_bind interface~dm_db_column dm_db_column proc~dm_db_select_observs_by_id->interface~dm_db_column interface~dm_present dm_present proc~dm_db_select_observs_by_id->interface~dm_present proc~dm_db_column_is_float dm_db_column_is_float proc~dm_db_select_observs_by_id->proc~dm_db_column_is_float proc~dm_db_column_is_integer dm_db_column_is_integer proc~dm_db_select_observs_by_id->proc~dm_db_column_is_integer proc~dm_db_column_is_text dm_db_column_is_text proc~dm_db_select_observs_by_id->proc~dm_db_column_is_text proc~dm_db_finalize dm_db_finalize proc~dm_db_select_observs_by_id->proc~dm_db_finalize proc~dm_db_prepare dm_db_prepare proc~dm_db_select_observs_by_id->proc~dm_db_prepare proc~dm_db_query_add_text dm_db_query_add_text proc~dm_db_select_observs_by_id->proc~dm_db_query_add_text proc~dm_db_query_build dm_db_query_build proc~dm_db_select_observs_by_id->proc~dm_db_query_build proc~dm_db_query_destroy dm_db_query_destroy proc~dm_db_select_observs_by_id->proc~dm_db_query_destroy proc~dm_db_query_set_limit dm_db_query_set_limit proc~dm_db_select_observs_by_id->proc~dm_db_query_set_limit proc~dm_db_query_set_order dm_db_query_set_order proc~dm_db_select_observs_by_id->proc~dm_db_query_set_order proc~dm_db_select_observ dm_db_select_observ proc~dm_db_select_observs_by_id->proc~dm_db_select_observ proc~dm_db_step dm_db_step proc~dm_db_select_observs_by_id->proc~dm_db_step proc~dm_db_stmt_is_prepared dm_db_stmt_is_prepared proc~dm_db_select_observs_by_id->proc~dm_db_stmt_is_prepared proc~dm_is_error dm_is_error proc~dm_db_select_observs_by_id->proc~dm_is_error sqlite3_reset sqlite3_reset proc~dm_db_select_observs_by_id->sqlite3_reset sqlite3_column_type sqlite3_column_type proc~dm_db_column_is_float->sqlite3_column_type proc~dm_db_column_is_integer->sqlite3_column_type proc~dm_db_column_is_text->sqlite3_column_type sqlite3_finalize sqlite3_finalize proc~dm_db_finalize->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_prepare->sqlite3_prepare_v2 proc~dm_db_query_add_text->interface~dm_present proc~dm_db_select_observ->interface~dm_db_bind proc~dm_db_select_observ->interface~dm_db_column proc~dm_db_select_observ->proc~dm_db_column_is_float proc~dm_db_select_observ->proc~dm_db_column_is_integer proc~dm_db_select_observ->proc~dm_db_column_is_text proc~dm_db_select_observ->proc~dm_db_finalize proc~dm_db_select_observ->proc~dm_db_prepare proc~dm_db_select_observ->proc~dm_db_query_add_text proc~dm_db_select_observ->proc~dm_db_query_build proc~dm_db_select_observ->proc~dm_db_query_destroy proc~dm_db_select_observ->proc~dm_db_step proc~dm_db_select_observ->proc~dm_db_stmt_is_prepared proc~dm_db_select_observ->proc~dm_is_error proc~dm_db_select_observ->sqlite3_reset sqlite3_step sqlite3_step proc~dm_db_step->sqlite3_step