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_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 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_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 proc~dm_is_error dm_is_error proc~dm_db_select_observ_ids->proc~dm_is_error proc~dm_string_is_present dm_string_is_present proc~dm_db_select_observ_ids->proc~dm_string_is_present sqlite3_bind_int64 sqlite3_bind_int64 proc~dm_db_select_observ_ids->sqlite3_bind_int64 sqlite3_bind_text sqlite3_bind_text proc~dm_db_select_observ_ids->sqlite3_bind_text sqlite3_column_int64 sqlite3_column_int64 proc~dm_db_select_observ_ids->sqlite3_column_int64 sqlite3_finalize sqlite3_finalize proc~dm_db_select_observ_ids->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_select_observ_ids->sqlite3_prepare_v2 sqlite3_step sqlite3_step proc~dm_db_select_observ_ids->sqlite3_step