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.

Called by

interface~~dm_db_query_where~~CalledByGraph interface~dm_db_query_where 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_json_beat dm_db_select_json_beat proc~dm_db_select_json_beat->interface~dm_db_query_where proc~dm_db_select_json_log dm_db_select_json_log proc~dm_db_select_json_log->interface~dm_db_query_where proc~dm_db_select_json_node dm_db_select_json_node proc~dm_db_select_json_node->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.