DatabaseProvider methods
Last updated
Was this helpful?
version 0.x
Last updated
Was this helpful?
Clears the cache for the query identified by the given cacheKeyNamingOptions
cacheKeyNamingOptions An optional hash array with the cache key naming options.
overrideCacheProviderName If specified, the cache provider with this name will be used instead of the one in the Database configuration key cacheProviderName.
Returns: True if the cache could be cleared successfully, false otherwise.
Executes a previously prepared query with the given parameters.
prepareResult The prepare result as returned by the method.
parameters A hash array with the variables to be applied to the prepared result, in the same order as they are stated in the original SQL statement, where each item in the array is a hash array with the following keys:
type One of the available , like DATABASE_FIELD_TYPE_INTEGER
value The value of the variable.
Prepares a query so it can be later executed as a prepared query with the method.
sql The SQL statement to prepare to be queried to the database, where all the variables are replaced by question marks.
Returns: A hash array with the following keys:
sql The passed SQL statement.
statement A provider-specific statement object if the query has been prepared correctly, false otherwise.
Prepares and executes a prepared query
sql The prepared SQL statement.
Prepares and executes a prepared query implementing a caching mechanism. If the query results are stored in the cache, it retrieves them. If not in cache, it performs the query and stores the results in cache.
sql The SQL statement.
cacheTtl The TTL for the cache results. If not specified, the Database configuration key cacheDefaultTtl is used.
overrideCacheProviderName If specified, the cache provider with this name will be used instead of the one in the Database configuration key cacheProviderName.
isStoreInCacheWhenNoResults Whether to store results in the cache when the query returned no rows or not.
Performs a query to the database.
query The SQL query string
setup An optional hash array with setup options.
Performs a query to the database implementing a caching mechanism. If the query results are stored in the cache, it retrieves them. If not in cache, it performs the query and stores the results in cache.
query The SQL statement.
cacheTtl The TTL for the cache results. If not specified, the Database configuration key cacheDefaultTtl is used.
overrideCacheProviderName If specified, the cache provider with this name will be used instead of the one in the Database configuration key cacheProviderName.
isStoreInCacheWhenNoResults Whether to store results in the cache when the query returned no rows or not.
parameters A hash array with the variables to be applied to the prepared SQL statement, in the same order as they are stated in the SQL, with the same structure as in the method.
setup Optional hash array with options, same specification as
Returns: A object if the query was executed correctly, false otherwise.
parameters A hash array with the variables to be applied to the prepared SQL statement, in the same order as they are stated in the SQL, with the same structure as in the method.
cacheKeyNamingOptions An optional hash array with the cache key naming options.
setup Optional setup keys, as specified in
cacheKeyNamingOptions An optional hash array with the cache key naming options.
setup Optional setup keys, as specified in .
Returns: A provider-specific object if the query was executed or retrieved from cache successfully, false otherwise.