Package com.openindex.openestate.tool.db.hsql

Class HSqlDbAdminHandler

java.lang.Object

com.openindex.openestate.tool.db.DbAdminHandlerImpl

com.openindex.openestate.tool.db.hsql.HSqlDbAdminHandler

All Implemented Interfaces:

DbAdminHandler

public class HSqlDbAdminHandler
extends DbAdminHandlerImpl

HSqlDbAdminHandler.

Author:

Andreas Rudolph

Constructor Summary

Constructors

Constructor	Description
HSqlDbAdminHandler()

Method Summary

Modifier and Type	Method	Description
void	backupLocalDb(Connection c, File backupArchive)
void	backupRemoteDb(Connection c, String dbName)
void	createAccount(Connection c, String account, char[] password)
void	defrag(Connection c)
void	dumpLocalDb(Connection c, File backupArchive)
String[]	getAccounts(Connection c, boolean includeAdmin)
String[]	getProcedures(Connection c)
String[]	getRoles(Connection c, boolean includeAdmin)
DbSession[]	getSessions(Connection c)
String[]	getTables(Connection c)
String[]	getViews(Connection c)
boolean	grantRole(Connection c, String account, String role)
boolean	hasRole(Connection c, String account, String role)
boolean	isAdmin(Connection c, String account)
boolean	isEnabled(Connection c, String account)
boolean	isLocalDbBackupSupported()
boolean	isLocalDbDumpSupported()
boolean	isRemoteDbBackupSupported()
void	removeAccount(Connection c, String account)
boolean	revokeRole(Connection c, String account, String role)
File	selectLocalBackupFile(Component parentComponent, File defaultDir)
File	selectLocalDumpFile(Component parentComponent, File defaultDir)
void	setAdmin(Connection c, String account, boolean isAdmin)
void	setEnabled(Connection c, String account, boolean isEnabled)
void	updateAccount(Connection c, String account, char[] password)

Methods inherited from class com.openindex.openestate.tool.db.DbAdminHandlerImpl

hasRole, isAdmin, isEnabled

Methods inherited from class java.lang.Object

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

Constructor Detail

HSqlDbAdminHandler

public HSqlDbAdminHandler()

Method Detail

backupLocalDb

public final void backupLocalDb(Connection c,
                                File backupArchive)
                         throws SQLException

Specified by:

backupLocalDb in interface DbAdminHandler

Specified by:

backupLocalDb in class DbAdminHandlerImpl

Throws:

SQLException

backupRemoteDb

public final void backupRemoteDb(Connection c,
                                 String dbName)
                          throws SQLException

Specified by:

backupRemoteDb in interface DbAdminHandler

Specified by:

backupRemoteDb in class DbAdminHandlerImpl

Throws:

SQLException

createAccount

public final void createAccount(Connection c,
                                String account,
                                char[] password)
                         throws SQLException

Specified by:

createAccount in interface DbAdminHandler

Specified by:

createAccount in class DbAdminHandlerImpl

Throws:

SQLException

defrag

public final void defrag(Connection c)
                  throws SQLException

Specified by:

defrag in interface DbAdminHandler

Specified by:

defrag in class DbAdminHandlerImpl

Throws:

SQLException

dumpLocalDb

public final void dumpLocalDb(Connection c,
                              File backupArchive)
                       throws SQLException

Specified by:

dumpLocalDb in interface DbAdminHandler

Specified by:

dumpLocalDb in class DbAdminHandlerImpl

Throws:

SQLException

getAccounts

public final String[] getAccounts(Connection c,
                                  boolean includeAdmin)
                           throws SQLException

Specified by:

getAccounts in interface DbAdminHandler

Specified by:

getAccounts in class DbAdminHandlerImpl

Throws:

SQLException

getProcedures

public final String[] getProcedures(Connection c)
                             throws SQLException

Specified by:

getProcedures in interface DbAdminHandler

Specified by:

getProcedures in class DbAdminHandlerImpl

Throws:

SQLException

getRoles

public final String[] getRoles(Connection c,
                               boolean includeAdmin)
                        throws SQLException

Specified by:

getRoles in interface DbAdminHandler

Specified by:

getRoles in class DbAdminHandlerImpl

Throws:

SQLException

getSessions

public final DbSession[] getSessions(Connection c)
                              throws SQLException

Specified by:

getSessions in interface DbAdminHandler

Specified by:

getSessions in class DbAdminHandlerImpl

Throws:

SQLException

getTables

public final String[] getTables(Connection c)
                         throws SQLException

Specified by:

getTables in interface DbAdminHandler

Specified by:

getTables in class DbAdminHandlerImpl

Throws:

SQLException

getViews

public final String[] getViews(Connection c)
                        throws SQLException

Specified by:

getViews in interface DbAdminHandler

Specified by:

getViews in class DbAdminHandlerImpl

Throws:

SQLException

grantRole

public boolean grantRole(Connection c,
                         String account,
                         String role)
                  throws SQLException

Specified by:

grantRole in interface DbAdminHandler

Specified by:

grantRole in class DbAdminHandlerImpl

Throws:

SQLException

hasRole

public final boolean hasRole(Connection c,
                             String account,
                             String role)
                      throws SQLException

Specified by:

hasRole in interface DbAdminHandler

Specified by:

hasRole in class DbAdminHandlerImpl

Throws:

SQLException

isAdmin

public final boolean isAdmin(Connection c,
                             String account)
                      throws SQLException

Specified by:

isAdmin in interface DbAdminHandler

Specified by:

isAdmin in class DbAdminHandlerImpl

Throws:

SQLException

isEnabled

public final boolean isEnabled(Connection c,
                               String account)
                        throws SQLException

Specified by:

isEnabled in interface DbAdminHandler

Specified by:

isEnabled in class DbAdminHandlerImpl

Throws:

SQLException

isLocalDbBackupSupported

public final boolean isLocalDbBackupSupported()

Specified by:

isLocalDbBackupSupported in interface DbAdminHandler

Specified by:

isLocalDbBackupSupported in class DbAdminHandlerImpl

isLocalDbDumpSupported

public boolean isLocalDbDumpSupported()

Specified by:

isLocalDbDumpSupported in interface DbAdminHandler

Specified by:

isLocalDbDumpSupported in class DbAdminHandlerImpl

isRemoteDbBackupSupported

public final boolean isRemoteDbBackupSupported()

Specified by:

isRemoteDbBackupSupported in interface DbAdminHandler

Specified by:

isRemoteDbBackupSupported in class DbAdminHandlerImpl

removeAccount

public final void removeAccount(Connection c,
                                String account)
                         throws SQLException

Specified by:

removeAccount in interface DbAdminHandler

Specified by:

removeAccount in class DbAdminHandlerImpl

Throws:

SQLException

revokeRole

public final boolean revokeRole(Connection c,
                                String account,
                                String role)
                         throws SQLException

Specified by:

revokeRole in interface DbAdminHandler

Specified by:

revokeRole in class DbAdminHandlerImpl

Throws:

SQLException

selectLocalBackupFile

public final File selectLocalBackupFile(Component parentComponent,
                                        File defaultDir)

Specified by:

selectLocalBackupFile in interface DbAdminHandler

Specified by:

selectLocalBackupFile in class DbAdminHandlerImpl

selectLocalDumpFile

public final File selectLocalDumpFile(Component parentComponent,
                                      File defaultDir)

Specified by:

selectLocalDumpFile in interface DbAdminHandler

Specified by:

selectLocalDumpFile in class DbAdminHandlerImpl

setAdmin

public final void setAdmin(Connection c,
                           String account,
                           boolean isAdmin)
                    throws SQLException

Specified by:

setAdmin in interface DbAdminHandler

Specified by:

setAdmin in class DbAdminHandlerImpl

Throws:

SQLException

setEnabled

public final void setEnabled(Connection c,
                             String account,
                             boolean isEnabled)
                      throws SQLException

Specified by:

setEnabled in interface DbAdminHandler

Specified by:

setEnabled in class DbAdminHandlerImpl

Throws:

SQLException

updateAccount

public final void updateAccount(Connection c,
                                String account,
                                char[] password)
                         throws SQLException

Specified by:

updateAccount in interface DbAdminHandler

Specified by:

updateAccount in class DbAdminHandlerImpl

Throws:

SQLException