| Name | Type | Default | Description |
| select-all | string | |
Defines a SQL query that bulk loads cache entries from a database.
You can use an asterisk operator in the SELECT clause.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".
Columns that this query returns must match the columns that the 'select-single' query returns.
Columns must also match Protobuf schema for composite keys and values exactly.
|
| select-single | string | |
Defines a SQL query that loads cache entries from a database.
You can use an asterisk operator in the SELECT clause.
You must include every field from the key schema as a named parameter, for example "FOO = :bar".
Columns that this query returns must match the columns that the 'select-all' query returns.
Columns must also match Protobuf schema for composite keys and values exactly.
|
| delete-all | string | |
Defines a SQL query to clear the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".
|
| delete-single | string | |
Defines a SQL query to delete specific entries from the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You must include every field from the key schema as a named parameter, for example "FOO = :bar".
|
| upsert | string | |
Defines a SQL query to modify entries in the cache.
This attribute is required if you configure the SQL cache store to allow modifications to the database.
You must include every field from the key and value schema as a named parameter, for example "FOO = :bar".
|
| size | string | |
Defines a SQL query to count the number of entries in the cache.
You can use parameters only if you explicitly define them in the statement, for example "WHERE FOO = 'BAR'"".
|