dm_db_insert Interface

public interface dm_db_insert

Generic database insert function.

Calls

interface~~dm_db_insert~~CallsGraph interface~dm_db_insert dm_db_insert proc~dm_db_insert_beat dm_db_insert_beat interface~dm_db_insert->proc~dm_db_insert_beat proc~dm_db_insert_beats dm_db_insert_beats interface~dm_db_insert->proc~dm_db_insert_beats proc~dm_db_insert_log dm_db_insert_log interface~dm_db_insert->proc~dm_db_insert_log proc~dm_db_insert_node dm_db_insert_node interface~dm_db_insert->proc~dm_db_insert_node proc~dm_db_insert_observ dm_db_insert_observ interface~dm_db_insert->proc~dm_db_insert_observ proc~dm_db_insert_observs dm_db_insert_observs interface~dm_db_insert->proc~dm_db_insert_observs proc~dm_db_insert_sensor dm_db_insert_sensor interface~dm_db_insert->proc~dm_db_insert_sensor proc~dm_db_insert_target dm_db_insert_target interface~dm_db_insert->proc~dm_db_insert_target proc~dm_beat_valid dm_beat_valid proc~dm_db_insert_beat->proc~dm_beat_valid sqlite3_bind_int sqlite3_bind_int proc~dm_db_insert_beat->sqlite3_bind_int sqlite3_bind_text sqlite3_bind_text proc~dm_db_insert_beat->sqlite3_bind_text sqlite3_finalize sqlite3_finalize proc~dm_db_insert_beat->sqlite3_finalize sqlite3_prepare_v2 sqlite3_prepare_v2 proc~dm_db_insert_beat->sqlite3_prepare_v2 sqlite3_reset sqlite3_reset proc~dm_db_insert_beat->sqlite3_reset sqlite3_step sqlite3_step proc~dm_db_insert_beat->sqlite3_step proc~dm_db_insert_beats->proc~dm_db_insert_beat proc~dm_db_finalize dm_db_finalize proc~dm_db_insert_beats->proc~dm_db_finalize proc~dm_is_error dm_is_error proc~dm_db_insert_beats->proc~dm_is_error proc~dm_is_ok dm_is_ok proc~dm_db_insert_beats->proc~dm_is_ok sqlite3_exec sqlite3_exec proc~dm_db_insert_beats->sqlite3_exec interface~dm_log_valid dm_log_valid proc~dm_db_insert_log->interface~dm_log_valid proc~dm_db_insert_log->sqlite3_bind_int proc~dm_db_insert_log->sqlite3_bind_text proc~dm_db_insert_log->sqlite3_finalize proc~dm_db_insert_log->sqlite3_prepare_v2 proc~dm_db_insert_log->sqlite3_step proc~dm_node_valid dm_node_valid proc~dm_db_insert_node->proc~dm_node_valid sqlite3_bind_double sqlite3_bind_double proc~dm_db_insert_node->sqlite3_bind_double proc~dm_db_insert_node->sqlite3_bind_text proc~dm_db_insert_node->sqlite3_finalize proc~dm_db_insert_node->sqlite3_prepare_v2 proc~dm_db_insert_node->sqlite3_step proc~dm_db_error dm_db_error proc~dm_db_insert_observ->proc~dm_db_error proc~dm_id_valid dm_id_valid proc~dm_db_insert_observ->proc~dm_id_valid proc~dm_db_insert_observ->proc~dm_is_error proc~dm_observ_valid dm_observ_valid proc~dm_db_insert_observ->proc~dm_observ_valid proc~dm_db_insert_observ->sqlite3_bind_double proc~dm_db_insert_observ->sqlite3_bind_int proc~dm_db_insert_observ->sqlite3_bind_text proc~dm_db_insert_observ->sqlite3_exec proc~dm_db_insert_observ->sqlite3_finalize proc~dm_db_insert_observ->sqlite3_prepare_v2 proc~dm_db_insert_observ->sqlite3_reset proc~dm_db_insert_observ->sqlite3_step proc~dm_db_insert_observs->proc~dm_db_insert_observ proc~dm_db_insert_observs->proc~dm_db_finalize proc~dm_db_insert_observs->proc~dm_is_error proc~dm_db_insert_observs->proc~dm_is_ok proc~dm_db_insert_observs->sqlite3_exec proc~dm_sensor_valid dm_sensor_valid proc~dm_db_insert_sensor->proc~dm_sensor_valid proc~dm_db_insert_sensor->sqlite3_bind_double proc~dm_db_insert_sensor->sqlite3_bind_int proc~dm_db_insert_sensor->sqlite3_bind_text proc~dm_db_insert_sensor->sqlite3_finalize proc~dm_db_insert_sensor->sqlite3_prepare_v2 proc~dm_db_insert_sensor->sqlite3_step proc~dm_target_valid dm_target_valid proc~dm_db_insert_target->proc~dm_target_valid proc~dm_db_insert_target->sqlite3_bind_double proc~dm_db_insert_target->sqlite3_bind_int proc~dm_db_insert_target->sqlite3_bind_text proc~dm_db_insert_target->sqlite3_finalize proc~dm_db_insert_target->sqlite3_prepare_v2 proc~dm_db_insert_target->sqlite3_step proc~dm_beat_valid->proc~dm_id_valid proc~dm_string_is_printable dm_string_is_printable proc~dm_beat_valid->proc~dm_string_is_printable proc~dm_time_valid dm_time_valid proc~dm_beat_valid->proc~dm_time_valid sqlite3_errcode sqlite3_errcode proc~dm_db_error->sqlite3_errcode proc~dm_db_finalize->sqlite3_finalize proc~dm_node_valid->proc~dm_id_valid proc~dm_observ_valid->proc~dm_id_valid proc~dm_error_valid dm_error_valid proc~dm_observ_valid->proc~dm_error_valid proc~dm_request_valid dm_request_valid proc~dm_observ_valid->proc~dm_request_valid proc~dm_observ_valid->proc~dm_time_valid proc~dm_uuid4_valid dm_uuid4_valid proc~dm_observ_valid->proc~dm_uuid4_valid proc~dm_sensor_valid->proc~dm_id_valid proc~dm_sensor_type_valid dm_sensor_type_valid proc~dm_sensor_valid->proc~dm_sensor_type_valid proc~dm_target_valid->proc~dm_id_valid proc~dm_target_state_valid dm_target_state_valid proc~dm_target_valid->proc~dm_target_state_valid proc~dm_request_valid->proc~dm_id_valid proc~dm_request_valid->proc~dm_error_valid proc~dm_request_valid->proc~dm_string_is_printable proc~dm_request_valid->proc~dm_time_valid proc~dm_response_valid dm_response_valid proc~dm_request_valid->proc~dm_response_valid proc~dm_ascii_is_printable dm_ascii_is_printable proc~dm_string_is_printable->proc~dm_ascii_is_printable proc~dm_ascii_is_digit dm_ascii_is_digit proc~dm_time_valid->proc~dm_ascii_is_digit proc~dm_response_valid->proc~dm_id_valid proc~dm_response_valid->proc~dm_error_valid proc~dm_response_type_valid dm_response_type_valid proc~dm_response_valid->proc~dm_response_type_valid

Module Procedures

public function dm_db_insert_beat(db, beat, db_stmt, validate) result(rc)

Adds the given heartbeat to database. The beat data is validated by default.

Read more…

Arguments

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

Database type.
type(beat_type), intent(inout) :: beat

Beat to insert.
type(db_stmt_type), intent(inout), optional :: db_stmt

Database statement type.
logical, intent(in), optional :: validate

Validate beat.

Return Value integer

public function dm_db_insert_beats(db, beats, transaction, validate) result(rc)

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

Read more…

Arguments

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

Database type.
type(beat_type), intent(inout) :: beats(:)

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

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

Validate beats.

Return Value integer

public function dm_db_insert_log(db, log, validate) result(rc)

Adds the given log to database. The log data is validated by default.

Read more…

Arguments

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

Database type.
type(log_type), intent(inout) :: log

Log message to insert.
logical, intent(in), optional :: validate

Validate log.

Return Value integer

public function dm_db_insert_node(db, node, validate) result(rc)

Adds the given node to database. The node data is validated by default.

Read more…

Arguments

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

Database type.
type(node_type), intent(inout) :: node

Node to insert.
logical, intent(in), optional :: validate

Validate node.

Return Value integer

public function dm_db_insert_observ(db, observ, db_stmt, validate) result(rc)

Adds single observation to database, including receivers, requests, and responses. If the insert query fails, the transaction will be rolled back, i.e., no part of the observation is written to the database on error. The observation data is validated by default.

Read more…

Arguments

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

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

Observation type.
type(db_stmt_type), intent(inout), optional :: db_stmt

Database statement type.
logical, intent(in), optional :: validate

Validate observation.

Return Value integer

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

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

Read more…

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

public function dm_db_insert_sensor(db, sensor, validate) result(rc)

Adds given sensor to database. The sensor data is validated by default.

Read more…

Arguments

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

Database type.
type(sensor_type), intent(inout) :: sensor

Sensor to insert.
logical, intent(in), optional :: validate

Validate sensor.

Return Value integer

public function dm_db_insert_target(db, target, validate) result(rc)

Adds given target to database. The target data is validated by default.

Read more…

Arguments

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

Database type.
type(target_type), intent(inout) :: target

Target to insert.
logical, intent(in), optional :: validate

Validate target.

Return Value integer