xyz.cofe.cxconsole.script.sql

Class SqlService

java.lang.Object

xyz.cofe.cxconsole.srvc.AbstractService

xyz.cofe.cxconsole.srvc.StartableService

xyz.cofe.cxconsole.srvc.BaseService

xyz.cofe.cxconsole.script.sql.SqlService

All Implemented Interfaces:

ConsoleService, ServiceEventPublisher, StartService

public class SqlService
extends BaseService

Author:

georgiy

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SqlService.ScriptGeneric

Nested classes/interfaces inherited from class xyz.cofe.cxconsole.srvc.BaseService

BaseService.OnStart, BaseService.OnStop, BaseService.UiAction, BaseService.UiActionBase, BaseService.UiActionField, BaseService.UiActionMethod, BaseService.UiMenu

Field Summary

Fields

Modifier and Type	Field and Description
protected ConnectPool	connectPool
protected TreeTableNodeBasic	connectPoolNode
protected DataTableFactory	dataTableFactory
protected DockingService	dockingService
protected FileDialogService	fileDialogService
protected MapDB2Service	mapDB2Service
protected NotifyService	notifyService
protected ObjectBrowserService	objectBrowserService
protected PropertiesService	propertiesService
protected ScriptDocExecService	scriptDocExecService
protected ScriptService	scriptService
protected SqlEngineFactory	sqlEngineFactory
protected StatusBarService	statusBarService
protected TextService	textService

Fields inherited from class xyz.cofe.cxconsole.srvc.BaseService

actionFieldSet, actionMethodSet, initUiActionsSuccess, MENU_FIELD_NAME, running

Fields inherited from class xyz.cofe.cxconsole.srvc.StartableService

startCallLevel, startStopSync, stopCallLevel

Fields inherited from class xyz.cofe.cxconsole.srvc.AbstractService

serviceEventQueue

Constructor Summary

Constructors

Constructor and Description
SqlService()

Method Summary

Modifier and Type	Method and Description
void	applySqlPerspective()
void	bindDataTable()
void	commit(Connection conn, Reciver<SQLException> onfinish)
boolean	commitable(Connection conn)
DataTableDock	createDataTableDock()
void	exportDataTableXml()
void	exportDataTableXml(File file)
void	exportDataTableXml(File file, DataTableDock dtd)
DataTableDock	findDataTableDock(Long scriptDocumentId, Integer dataTableId)
DataTableDock	getActiveDataTableDock() Возвращает текущий (последий который имеел фокус) документ
ConnectPool	getConnectPool()
TreeTableNodeBasic	getConnectPoolNode()
Map<String,String>	getDataSourceStorage()
DockingService.DockableList<DataTableDock>	getDataTableDockHistory() Возвращает историю переключения фокуса документов
DockingService.DockableList<DataTableDock>	getDataTableDocks() Возвращает список документов, отсортированный в обратном порядке переключения фокуса
DataTableFactory	getDataTableFactory()
DockingService	getDockingService()
FileDialogService	getFileDialogService()
WeakHashMap<BasicDataSource,Long>	getLoadedDataSources()
MapDB2Service	getMapDB2Service()
NotifyService	getNotifyService()
ObjectBrowserService	getObjectBrowserService()
PropertiesService	getPropertiesService()
ScriptDocExecService	getScriptDocExecService()
ScriptService	getScriptService()
protected SqlEngineFactory	getSqlEngineFactory()
StatusBarService	getStatusBarService()
TextService	getTextService()
void	importDataTableXml()
void	importDataTableXml(File file)
void	importDataTableXml(File file, DataTableDock dtd)
protected void	initObjectBrowser(ObjectBrowser ob)
protected void	initSqlEngineStatusBar()
protected void	loadDataSources()
void	onDataTableDockFocused(DataTableDock dtDock)
protected void	registerDataTableFactory(DockingService ds)
protected void	registerInScriptService(ScriptService ss)
SqlService.ScriptGeneric	script()
protected void	shutdown()
protected JComponent	sqlEngineStatBar(TextDocument tdoc)
protected void	starting()

Methods inherited from class xyz.cofe.cxconsole.srvc.BaseService

buttonGroup, getActionFieldSet, getActionMethodSet, getActionsService, getButtonGroup, getMenuService, getStartableMethodsList, getStartableMethodsMap, getStoppableMethodsList, getStoppableMethodsMap, initUiActionError, initUiActions, isRunning, onStart, onStop

Methods inherited from class xyz.cofe.cxconsole.srvc.StartableService

fireStarted, fireStarting, fireStopped, fireStopping, getServiceByStopper, getServiceDependencies, isDetectCycleStart, isDetectCycleStop, onResolvedDependencies, start, stop, stopByDependency

Methods inherited from class xyz.cofe.cxconsole.srvc.AbstractService

addServiceEvent, addServiceListener, addServiceListener, findFirstService, findServices, findServices, findServices, fireServiceEvent, fireServiceEvents, getConsole, getFieldDependencies, getInitDependenciesCallCount, getServiceListeners, getUnresolvedDependencies, hasServiceListener, init, initDependencies, instances, isResolvedDependencies, listeners, onInitServicesEnd, removeServiceListener, resolveDependecy

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface xyz.cofe.cxconsole.ConsoleService

init

Methods inherited from interface xyz.cofe.cxconsole.srvc.ServiceEventPublisher

addServiceEvent, addServiceListener, addServiceListener, fireServiceEvents, getServiceListeners, hasServiceListener, removeServiceListener

Field Detail

connectPool

protected volatile ConnectPool connectPool

mapDB2Service

protected MapDB2Service mapDB2Service

objectBrowserService

protected ObjectBrowserService objectBrowserService

propertiesService

protected PropertiesService propertiesService

notifyService

protected NotifyService notifyService

scriptService

protected ScriptService scriptService

scriptDocExecService

protected ScriptDocExecService scriptDocExecService

dockingService

protected DockingService dockingService

fileDialogService

protected FileDialogService fileDialogService

textService

protected TextService textService

statusBarService

protected StatusBarService statusBarService

sqlEngineFactory

protected SqlEngineFactory sqlEngineFactory

dataTableFactory

protected volatile DataTableFactory dataTableFactory

connectPoolNode

protected volatile TreeTableNodeBasic connectPoolNode

Constructor Detail

SqlService

public SqlService()

Method Detail

getConnectPool

public ConnectPool getConnectPool()

getMapDB2Service

public MapDB2Service getMapDB2Service()

getLoadedDataSources

public WeakHashMap<BasicDataSource,Long> getLoadedDataSources()

loadDataSources

protected void loadDataSources()

getDataSourceStorage

public Map<String,String> getDataSourceStorage()

getObjectBrowserService

public ObjectBrowserService getObjectBrowserService()

getPropertiesService

public PropertiesService getPropertiesService()

getNotifyService

public NotifyService getNotifyService()

getScriptService

public ScriptService getScriptService()

getScriptDocExecService

public ScriptDocExecService getScriptDocExecService()

getDockingService

public DockingService getDockingService()

getFileDialogService

public FileDialogService getFileDialogService()

getTextService

public TextService getTextService()

getStatusBarService

public StatusBarService getStatusBarService()

getSqlEngineFactory

protected SqlEngineFactory getSqlEngineFactory()

registerInScriptService

protected void registerInScriptService(ScriptService ss)

getDataTableFactory

public DataTableFactory getDataTableFactory()

registerDataTableFactory

protected void registerDataTableFactory(DockingService ds)

starting

protected void starting()

shutdown

protected void shutdown()

getConnectPoolNode

public TreeTableNodeBasic getConnectPoolNode()

initObjectBrowser

protected void initObjectBrowser(ObjectBrowser ob)

createDataTableDock

public DataTableDock createDataTableDock()

getDataTableDockHistory

public DockingService.DockableList<DataTableDock> getDataTableDockHistory()

Возвращает историю переключения фокуса документов

Returns:

история

getDataTableDocks

public DockingService.DockableList<DataTableDock> getDataTableDocks()

Возвращает список документов, отсортированный в обратном порядке переключения фокуса

Returns:

список документов

getActiveDataTableDock

public DataTableDock getActiveDataTableDock()

Возвращает текущий (последий который имеел фокус) документ

Returns:

текущий документ или null

findDataTableDock

public DataTableDock findDataTableDock(Long scriptDocumentId,
                                       Integer dataTableId)

onDataTableDockFocused

public void onDataTableDockFocused(DataTableDock dtDock)

exportDataTableXml

public void exportDataTableXml()

importDataTableXml

public void importDataTableXml()

exportDataTableXml

public void exportDataTableXml(File file)

exportDataTableXml

public void exportDataTableXml(File file,
                               DataTableDock dtd)

importDataTableXml

public void importDataTableXml(File file)

importDataTableXml

public void importDataTableXml(File file,
                               DataTableDock dtd)

bindDataTable

public void bindDataTable()

applySqlPerspective

public void applySqlPerspective()

script

public SqlService.ScriptGeneric script()

initSqlEngineStatusBar

protected void initSqlEngineStatusBar()

sqlEngineStatBar

protected JComponent sqlEngineStatBar(TextDocument tdoc)

commitable

public boolean commitable(Connection conn)

commit

public void commit(Connection conn,
                   Reciver<SQLException> onfinish)