railo.runtime.type.scope.storage.db
Interface SQLExecutor

All Known Implementing Classes:
Ansi92, MSSQL, MySQL, SQLExecutorSupport

public interface SQLExecutor


Method Summary
 void clean(Config config, DatasourceConnection dc, int type, StorageScopeEngine engine, DatasourceStorageScopeCleaner cleaner, StorageScopeListener listener, Log log)
           
 void delete(Config config, String cfid, String applicationName, DatasourceConnection dc, int type, Log log)
          deletes the data in the datasource for a specific user (CFID), if there is no data for this user nothing is happeing
 Query select(Config config, String cfid, String applicationName, DatasourceConnection dc, int type, Log log, boolean createTableIfNotExist)
          does a select statement on the datasource to get data
 void update(Config config, String cfid, String applicationName, DatasourceConnection dc, int type, Struct data, long timeSpan, Log log)
          updates the data in the datasource for a specific user (CFID), if the data not exist, a new record is created
 

Method Detail

select

Query select(Config config,
             String cfid,
             String applicationName,
             DatasourceConnection dc,
             int type,
             Log log,
             boolean createTableIfNotExist)
             throws PageException,
                    SQLException
does a select statement on the datasource to get data

Parameters:
config - Config of the current context
cfid - CFID of the current user
applicationName - name of the current application context
dc - Datasource Connection to use
type - storage type (Scope.SCOPE_CLIENT,Scope.SCOPE_SESSION)
log -
createTableIfNotExist - do create the table if not existing
Returns:
data matching criteria
Throws:
PageException
SQLException

update

void update(Config config,
            String cfid,
            String applicationName,
            DatasourceConnection dc,
            int type,
            Struct data,
            long timeSpan,
            Log log)
            throws PageException,
                   SQLException
updates the data in the datasource for a specific user (CFID), if the data not exist, a new record is created

Parameters:
config - Config of the current context
cfid - CFID of the current user
applicationName - name of the current application context
dc - Datasource Connection to use
type - storage type (Scope.SCOPE_CLIENT,Scope.SCOPE_SESSION)
data - data to store
timeSpan - timespan in millis
log -
Throws:
PageException
SQLException

delete

void delete(Config config,
            String cfid,
            String applicationName,
            DatasourceConnection dc,
            int type,
            Log log)
            throws PageException,
                   SQLException
deletes the data in the datasource for a specific user (CFID), if there is no data for this user nothing is happeing

Parameters:
config - Config of the current context
cfid - CFID of the current user
applicationName - name of the current application context
dc - Datasource Connection to use
type - storage type (Scope.SCOPE_CLIENT,Scope.SCOPE_SESSION)
log -
Throws:
PageException
SQLException

clean

void clean(Config config,
           DatasourceConnection dc,
           int type,
           StorageScopeEngine engine,
           DatasourceStorageScopeCleaner cleaner,
           StorageScopeListener listener,
           Log log)
           throws PageException,
                  SQLException
Throws:
PageException
SQLException


Copyright © 2012 Railo