dm_db_select_observs_by_time Function

public function dm_db_select_observs_by_time(db, observs, node_id, sensor_id, target_id, from, to, limit, stub, nobservs) result(rc)

Uses

  • proc~~dm_db_select_observs_by_time~~UsesGraph proc~dm_db_select_observs_by_time dm_db_select_observs_by_time module~dm_observ dm_observ proc~dm_db_select_observs_by_time->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 time span in observs.

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(observ_type), intent(out), allocatable :: observs(:)

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

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

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

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

Beginning of time span.
character(len=*), intent(in) :: to

End of time span.
integer(kind=i8), intent(in), optional :: limit

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

No 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_time~~CallsGraph proc~dm_db_select_observs_by_time dm_db_select_observs_by_time proc~dm_is_error dm_is_error proc~dm_db_select_observs_by_time->proc~dm_is_error sqlite3_bind_int sqlite3_bind_int proc~dm_db_select_observs_by_time->sqlite3_bind_int sqlite3_bind_int64 sqlite3_bind_int64 proc~dm_db_select_observs_by_time->sqlite3_bind_int64 sqlite3_bind_text sqlite3_bind_text proc~dm_db_select_observs_by_time->sqlite3_bind_text sqlite3_column_double sqlite3_column_double proc~dm_db_select_observs_by_time->sqlite3_column_double sqlite3_column_int sqlite3_column_int proc~dm_db_select_observs_by_time->sqlite3_column_int sqlite3_column_text sqlite3_column_text proc~dm_db_select_observs_by_time->sqlite3_column_text sqlite3_column_type sqlite3_column_type proc~dm_db_select_observs_by_time->sqlite3_column_type sqlite3_finalize sqlite3_finalize proc~dm_db_select_observs_by_time->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_select_observs_by_time->sqlite3_prepare_v2 sqlite3_reset sqlite3_reset proc~dm_db_select_observs_by_time->sqlite3_reset sqlite3_step sqlite3_step proc~dm_db_select_observs_by_time->sqlite3_step