dm_db_query_update Interface

public interface dm_db_query_update

Generic subroutine to add SET values to UPDATE 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_update~~CalledByGraph interface~dm_db_query_update dm_db_query_update proc~dm_db_update_transfer dm_db_update_transfer proc~dm_db_update_transfer->interface~dm_db_query_update

Module Procedures

private subroutine db_query_update_double(dbq, column, value, error)

Adds double precision SET 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) :: dbq

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

Column name.
real(kind=r8), intent(in) :: value

New column value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_update_int(dbq, column, value, error)

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

Arguments

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

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

Column name.
integer(kind=i4), intent(in) :: value

New column value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_update_int64(dbq, column, value, error)

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

Arguments

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

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

Column name.
integer(kind=i8), intent(in) :: value

New column value.
integer, intent(out), optional :: error

Error code.

private subroutine db_query_update_text(dbq, column, value, error)

Adds text parameter to SET query. Returns E_LIMIT if parameter limit has been reached.

Arguments

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

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

Column name.
character(len=*), intent(in) :: value

New column value.
integer, intent(out), optional :: error

Error code.