dm_db_select_observs_by_id Function

public function dm_db_select_observs_by_id(db, observs, after_id, before_id, 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_id is the id of the observation after which the range starts, before_id 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

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

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_db_query_where dm_db_query_where proc~dm_db_select_observs_by_id->interface~dm_db_query_where 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_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_btoa dm_btoa proc~dm_db_query_build->proc~dm_btoa proc~dm_db_select_observ->interface~dm_db_bind proc~dm_db_select_observ->interface~dm_db_column proc~dm_db_select_observ->interface~dm_db_query_where 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_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