Package com.openindex.openestate.tool.db

Interface DbAdminHandler

All Known Implementing Classes:

DbAdminHandlerImpl, HSqlDbAdminHandler

public interface DbAdminHandler

DbAdminHandler.

Author:

Andreas Rudolph

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 role)
boolean	hasRole(Connection c, String account, String role)
boolean	isAdmin(Connection c)
boolean	isAdmin(Connection c, String account)
boolean	isEnabled(Connection c)
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)

Method Detail

backupLocalDb

void backupLocalDb(Connection c,
                   File backupArchive)
            throws SQLException

Throws:

SQLException

backupRemoteDb

void backupRemoteDb(Connection c,
                    String dbName)
             throws SQLException

Throws:

SQLException

createAccount

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

Throws:

SQLException

defrag

void defrag(Connection c)
     throws SQLException

Throws:

SQLException

dumpLocalDb

void dumpLocalDb(Connection c,
                 File backupArchive)
          throws SQLException

Throws:

SQLException

getAccounts

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

Throws:

SQLException

getProcedures

String[] getProcedures(Connection c)
                throws SQLException

Throws:

SQLException

getRoles

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

Throws:

SQLException

getSessions

DbSession[] getSessions(Connection c)
                 throws SQLException

Throws:

SQLException

getTables

String[] getTables(Connection c)
            throws SQLException

Throws:

SQLException

getViews

String[] getViews(Connection c)
           throws SQLException

Throws:

SQLException

grantRole

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

Throws:

SQLException

hasRole

boolean hasRole(Connection c,
                String role)
         throws SQLException

Throws:

SQLException

hasRole

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

Throws:

SQLException

isAdmin

boolean isAdmin(Connection c)
         throws SQLException

Throws:

SQLException

isAdmin

boolean isAdmin(Connection c,
                String account)
         throws SQLException

Throws:

SQLException

isEnabled

boolean isEnabled(Connection c)
           throws SQLException

Throws:

SQLException

isEnabled

boolean isEnabled(Connection c,
                  String account)
           throws SQLException

Throws:

SQLException

isLocalDbBackupSupported

boolean isLocalDbBackupSupported()

isLocalDbDumpSupported

boolean isLocalDbDumpSupported()

isRemoteDbBackupSupported

boolean isRemoteDbBackupSupported()

removeAccount

void removeAccount(Connection c,
                   String account)
            throws SQLException

Throws:

SQLException

revokeRole

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

Throws:

SQLException

selectLocalBackupFile

File selectLocalBackupFile(Component parentComponent,
                           File defaultDir)

selectLocalDumpFile

File selectLocalDumpFile(Component parentComponent,
                         File defaultDir)

setAdmin

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

Throws:

SQLException

setEnabled

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

Throws:

SQLException

updateAccount

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

Throws:

SQLException