dm_db_delete_observ Function

public function dm_db_delete_observ(db, observ_id) result(rc)

Deletes observation from database. The function expects the SQLite trigger delete_observ_trigger as defined in module dm_sql to be present in the database, in order to delete receivers, requests, and responses automatically.

The function returns the following error codes:

  • E_DB_BIND if value binding failed.
  • E_DB_EXEC if query execution failed (commit).
  • 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_INVALID if observation id is invalid.
  • E_READ_ONLY if database is opened read-only.

Arguments

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

Database type.

character(len=*), intent(in) :: observ_id

Observation id.

Return Value integer


Calls

proc~~dm_db_delete_observ~~CallsGraph proc~dm_db_delete_observ dm_db_delete_observ proc~dm_is_error dm_is_error proc~dm_db_delete_observ->proc~dm_is_error proc~dm_is_ok dm_is_ok proc~dm_db_delete_observ->proc~dm_is_ok sqlite3_bind_text sqlite3_bind_text proc~dm_db_delete_observ->sqlite3_bind_text sqlite3_exec sqlite3_exec proc~dm_db_delete_observ->sqlite3_exec sqlite3_finalize sqlite3_finalize proc~dm_db_delete_observ->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_delete_observ->sqlite3_prepare_v2 sqlite3_step sqlite3_step proc~dm_db_delete_observ->sqlite3_step