dm_db_insert_observs Function

public function dm_db_insert_observs(db, observs, transaction, validate) result(rc)

Uses

  • proc~~dm_db_insert_observs~~UsesGraph proc~dm_db_insert_observs dm_db_insert_observs module~dm_observ dm_observ proc~dm_db_insert_observs->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

Adds array of observations to database. A transaction is used unless transaction is .false.. The observation data is validated by default.

The function returns the following error codes:

  • E_DB if statement reset failed.
  • E_DB_BIND if value binding failed.
  • E_DB_EXEC if execution of transaction statement failed.
  • E_DB_PREPARE if statement preparation failed.
  • E_DB_ROLLBACK if transaction rollback failed.
  • E_DB_STEP if step execution failed or no write permission.
  • E_DB_TRANSACTION if transaction failed.
  • E_EMPTY if array observs is empty.
  • E_INVALID if an element in observs is invalid.
  • E_READ_ONLY if database is opened read-only.

Arguments

Type IntentOptional Attributes Name
type(db_type), intent(inout) :: db

Database type.
type(observ_type), intent(inout) :: observs(:)

Observation type array.
logical, intent(in), optional :: transaction

Use SQL transaction.
logical, intent(in), optional :: validate

Validate observations.

Return Value integer


Calls

proc~~dm_db_insert_observs~~CallsGraph proc~dm_db_insert_observs dm_db_insert_observs interface~dm_present dm_present proc~dm_db_insert_observs->interface~dm_present proc~dm_db_begin dm_db_begin proc~dm_db_insert_observs->proc~dm_db_begin proc~dm_db_commit dm_db_commit proc~dm_db_insert_observs->proc~dm_db_commit proc~dm_db_finalize dm_db_finalize proc~dm_db_insert_observs->proc~dm_db_finalize proc~dm_db_insert_observ dm_db_insert_observ proc~dm_db_insert_observs->proc~dm_db_insert_observ proc~dm_db_is_read_only dm_db_is_read_only proc~dm_db_insert_observs->proc~dm_db_is_read_only proc~dm_db_rollback dm_db_rollback proc~dm_db_insert_observs->proc~dm_db_rollback proc~dm_is_error dm_is_error proc~dm_db_insert_observs->proc~dm_is_error proc~dm_is_ok dm_is_ok proc~dm_db_insert_observs->proc~dm_is_ok proc~dm_db_begin->interface~dm_present proc~dm_db_begin->proc~dm_is_error proc~dm_db_exec dm_db_exec proc~dm_db_begin->proc~dm_db_exec proc~dm_db_commit->proc~dm_db_exec sqlite3_finalize sqlite3_finalize proc~dm_db_finalize->sqlite3_finalize proc~dm_db_insert_observ->interface~dm_present proc~dm_db_insert_observ->proc~dm_db_finalize proc~dm_db_insert_observ->proc~dm_db_is_read_only proc~dm_db_insert_observ->proc~dm_db_rollback proc~dm_db_insert_observ->proc~dm_is_error interface~dm_db_bind dm_db_bind proc~dm_db_insert_observ->interface~dm_db_bind proc~dm_db_error dm_db_error proc~dm_db_insert_observ->proc~dm_db_error proc~dm_db_is_prepared dm_db_is_prepared proc~dm_db_insert_observ->proc~dm_db_is_prepared proc~dm_db_prepare dm_db_prepare proc~dm_db_insert_observ->proc~dm_db_prepare proc~dm_db_release dm_db_release proc~dm_db_insert_observ->proc~dm_db_release proc~dm_db_reset dm_db_reset proc~dm_db_insert_observ->proc~dm_db_reset proc~dm_db_save_point dm_db_save_point proc~dm_db_insert_observ->proc~dm_db_save_point proc~dm_db_step dm_db_step proc~dm_db_insert_observ->proc~dm_db_step proc~dm_id_is_valid dm_id_is_valid proc~dm_db_insert_observ->proc~dm_id_is_valid proc~dm_observ_is_valid dm_observ_is_valid proc~dm_db_insert_observ->proc~dm_observ_is_valid proc~dm_db_rollback->proc~dm_is_error proc~dm_db_rollback->proc~dm_db_exec sqlite3_errcode sqlite3_errcode proc~dm_db_error->sqlite3_errcode sqlite3_exec sqlite3_exec proc~dm_db_exec->sqlite3_exec sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_prepare->sqlite3_prepare_v2 proc~dm_db_release->proc~dm_db_exec sqlite3_reset sqlite3_reset proc~dm_db_reset->sqlite3_reset proc~dm_db_save_point->proc~dm_db_exec sqlite3_step sqlite3_step proc~dm_db_step->sqlite3_step proc~dm_id_is_valid->interface~dm_present proc~dm_observ_is_valid->interface~dm_present proc~dm_observ_is_valid->proc~dm_id_is_valid proc~dm_error_is_valid dm_error_is_valid proc~dm_observ_is_valid->proc~dm_error_is_valid proc~dm_request_is_valid dm_request_is_valid proc~dm_observ_is_valid->proc~dm_request_is_valid proc~dm_string_is_printable dm_string_is_printable proc~dm_observ_is_valid->proc~dm_string_is_printable proc~dm_time_is_valid dm_time_is_valid proc~dm_observ_is_valid->proc~dm_time_is_valid proc~dm_uuid4_is_valid dm_uuid4_is_valid proc~dm_observ_is_valid->proc~dm_uuid4_is_valid proc~dm_request_is_valid->interface~dm_present proc~dm_request_is_valid->proc~dm_id_is_valid proc~dm_request_is_valid->proc~dm_error_is_valid proc~dm_request_is_valid->proc~dm_string_is_printable proc~dm_request_is_valid->proc~dm_time_is_valid proc~dm_response_is_valid dm_response_is_valid proc~dm_request_is_valid->proc~dm_response_is_valid proc~dm_ascii_is_printable dm_ascii_is_printable proc~dm_string_is_printable->proc~dm_ascii_is_printable proc~dm_time_is_valid->interface~dm_present proc~dm_ascii_is_digit dm_ascii_is_digit proc~dm_time_is_valid->proc~dm_ascii_is_digit proc~dm_response_is_valid->proc~dm_id_is_valid proc~dm_response_is_valid->proc~dm_error_is_valid proc~dm_response_is_valid->proc~dm_string_is_printable proc~dm_response_type_is_valid dm_response_type_is_valid proc~dm_response_is_valid->proc~dm_response_type_is_valid

Called by

proc~~dm_db_insert_observs~~CalledByGraph proc~dm_db_insert_observs dm_db_insert_observs interface~dm_db_insert dm_db_insert interface~dm_db_insert->proc~dm_db_insert_observs