dm_db_query_where Interface

public interface dm_db_query_where

Generic subroutine to add WHERE values to query. The procedures do not validate that values have been added only once. The function is prone to SQL injections. Only pass parametrised strings!

Called by

interface~~dm_db_query_where~~CalledByGraph interface~dm_db_query_where dm_db_query_where proc~dm_db_json_select_beat dm_db_json_select_beat proc~dm_db_json_select_beat->interface~dm_db_query_where proc~dm_db_json_select_log dm_db_json_select_log proc~dm_db_json_select_log->interface~dm_db_query_where proc~dm_db_json_select_node dm_db_json_select_node proc~dm_db_json_select_node->interface~dm_db_query_where proc~dm_db_select_beat dm_db_select_beat proc~dm_db_select_beat->interface~dm_db_query_where proc~dm_db_select_image dm_db_select_image proc~dm_db_select_image->interface~dm_db_query_where proc~dm_db_select_log dm_db_select_log proc~dm_db_select_log->interface~dm_db_query_where proc~dm_db_select_node dm_db_select_node proc~dm_db_select_node->interface~dm_db_query_where proc~dm_db_select_observ dm_db_select_observ proc~dm_db_select_observ->interface~dm_db_query_where proc~dm_db_select_observ_ids dm_db_select_observ_ids proc~dm_db_select_observ_ids->interface~dm_db_query_where proc~dm_db_select_observ_views dm_db_select_observ_views proc~dm_db_select_observ_views->interface~dm_db_query_where proc~dm_db_select_observs_by_id dm_db_select_observs_by_id proc~dm_db_select_observs_by_id->interface~dm_db_query_where proc~dm_db_select_observs_by_id->proc~dm_db_select_observ proc~dm_db_select_sensor dm_db_select_sensor proc~dm_db_select_sensor->interface~dm_db_query_where proc~dm_db_select_target dm_db_select_target proc~dm_db_select_target->interface~dm_db_query_where proc~dm_db_select_transfer dm_db_select_transfer proc~dm_db_select_transfer->interface~dm_db_query_where proc~dm_db_update_transfer dm_db_update_transfer proc~dm_db_update_transfer->interface~dm_db_query_where interface~dm_db_select dm_db_select interface~dm_db_select->proc~dm_db_select_beat interface~dm_db_select->proc~dm_db_select_image interface~dm_db_select->proc~dm_db_select_log interface~dm_db_select->proc~dm_db_select_node interface~dm_db_select->proc~dm_db_select_observ interface~dm_db_select->proc~dm_db_select_sensor interface~dm_db_select->proc~dm_db_select_target interface~dm_db_select->proc~dm_db_select_transfer

Module Procedures

private subroutine db_query_where_double(db_query, param, value, error)

Adds double precision WHERE parameter to query. Returns E_LIMIT in error if parameter limit has been reached.

Arguments

Type IntentOptional Attributes Name
type(db_query_type), intent(inout) :: db_query

Database query type.
character(len=*), intent(in) :: param

Query parameter.
real(kind=r8), intent(in) :: value

Query parameter value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_where_int(db_query, param, value, error)

Adds 32-bit integer WHERE parameter to query. Returns E_LIMIT if parameter limit has been reached.

Arguments

Type IntentOptional Attributes Name
type(db_query_type), intent(inout) :: db_query

Database query type.
character(len=*), intent(in) :: param

Query parameter.
integer(kind=i4), intent(in) :: value

Query parameter value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_where_int64(db_query, param, value, error)

Adds 64-bit integer WHERE parameter to query. Returns E_LIMIT if parameter limit has been reached.

Arguments

Type IntentOptional Attributes Name
type(db_query_type), intent(inout) :: db_query

Database query type.
character(len=*), intent(in) :: param

Query parameter.
integer(kind=i8), intent(in) :: value

Query parameter value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_where_text(db_query, param, value, empty, error)

Adds text parameter to WHERE query. Returns E_LIMIT if parameter limit has been reached. Empty strings and strings containing only white-space characters are ignored, unless argument empty is set to .true..

Arguments

Type IntentOptional Attributes Name
type(db_query_type), intent(inout) :: db_query

Database query type.
character(len=*), intent(in) :: param

Query parameter.
character(len=*), intent(in) :: value

Query parameter value.
logical, intent(in), optional :: empty

Add empty string.
integer, intent(out), optional :: error

Error code.