db_query_type Derived Type

type, public :: db_query_type

Database query with SET values (for SQL UPDATE), WHERE parameters, LIMIT, and ORDER BY. Do not modify this derived type directly!


Inherits

type~~db_query_type~~InheritsGraph type~db_query_type db_query_type type~db_query_param_type db_query_param_type type~db_query_type->type~db_query_param_type params, updates

Components

Type Visibility Attributes Name Initial
character(len=:), public, allocatable :: sql

SQL base query.
character(len=:), public, allocatable :: order_by

ORDER BY clause.
logical, public :: order_desc = .false.

ASC or DESC order.
integer(kind=i8), public :: limit = 0_i8

Row limit.
integer, public :: nparams = 0

Current WHERE parameter array size.
integer, public :: nupdates = 0

Current SET parameter array size.
type(db_query_param_type), public :: params(DB_QUERY_NPARAMS)

WHERE parameter array.
type(db_query_param_type), public :: updates(DB_QUERY_NPARAMS)

SET parameter array.