dm_db_select_observ_ids Function

public function dm_db_select_observ_ids(db, ids, node_id, sensor_id, target_id, from, to, desc, limit, nids) result(rc)

Uses

  • proc~~dm_db_select_observ_ids~~UsesGraph proc~dm_db_select_observ_ids dm_db_select_observ_ids module~dm_observ dm_observ proc~dm_db_select_observ_ids->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 observation ids in ids, with optional node id, sensor id, target id, from, to. By default, ids are returned ordered by ascending observation timestamp, unless desc is passed and .true.. The maximum number of ids may be passed in limit.

The total number of ids is returned in optional argument nids, which may be greater than limit.

The function returns the following error codes:

  • E_ALLOC if memory allocation failed.
  • E_INVALID if the database returned an invalid id.
  • 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.
character(len=ID_LEN), intent(out), allocatable :: ids(:)

Returned observation ids.
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 :: from

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

End of time span.
logical, intent(in), optional :: desc

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

Max. number of observations.
integer(kind=i8), intent(out), optional :: nids

Total number of observation ids (may be greater than limit).

Return Value integer


Calls

proc~~dm_db_select_observ_ids~~CallsGraph proc~dm_db_select_observ_ids dm_db_select_observ_ids interface~dm_db_bind dm_db_bind proc~dm_db_select_observ_ids->interface~dm_db_bind interface~dm_db_column dm_db_column proc~dm_db_select_observ_ids->interface~dm_db_column proc~dm_db_finalize dm_db_finalize proc~dm_db_select_observ_ids->proc~dm_db_finalize proc~dm_db_prepare dm_db_prepare proc~dm_db_select_observ_ids->proc~dm_db_prepare proc~dm_db_query_add_text dm_db_query_add_text proc~dm_db_select_observ_ids->proc~dm_db_query_add_text proc~dm_db_query_build dm_db_query_build proc~dm_db_select_observ_ids->proc~dm_db_query_build proc~dm_db_query_destroy dm_db_query_destroy proc~dm_db_select_observ_ids->proc~dm_db_query_destroy proc~dm_db_query_set_limit dm_db_query_set_limit proc~dm_db_select_observ_ids->proc~dm_db_query_set_limit proc~dm_db_query_set_order dm_db_query_set_order proc~dm_db_select_observ_ids->proc~dm_db_query_set_order proc~dm_db_step dm_db_step proc~dm_db_select_observ_ids->proc~dm_db_step proc~dm_is_error dm_is_error proc~dm_db_select_observ_ids->proc~dm_is_error sqlite3_finalize sqlite3_finalize proc~dm_db_finalize->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_prepare->sqlite3_prepare_v2 interface~dm_present dm_present proc~dm_db_query_add_text->interface~dm_present sqlite3_step sqlite3_step proc~dm_db_step->sqlite3_step