Package com.storedobject.database.postgres

Class Database

java.lang.Object

com.storedobject.core.Database

com.storedobject.database.postgres.Database

public final class Database
extends Database

Constructor Summary

Constructors

Constructor	Description
Database()

Method Summary

Modifier and Type	Method	Description
protected boolean	alterPassword(String user, String oldPassword, String newPassword)	Change the password of the user on the SQL connection.
String	callProc(String name, String param)	Get the SQL statement string to call the stored procedure.
String	columnType(String columnType, int width, int precision)
boolean	createLogin(String user, String password)	Creates a login with the given login name and password.
protected String[]	createSchemaDDL(String schemaName)
String	currentTime()	The SQL column that can bring the current time from the database.
String	databaseSQL(String databaseName)	Part of the SQL string (starting with FROM) that can query details of a database.
protected String	dropDatabaseDDL(String databaseName)
boolean	dropLogin(String user, String password)	Drops a login with the given login name and password.
String	getObjectClassName()	Get the name of the Object class of this database.
String	getSerial(int tag)	Get the SQL statement for generating the next Id for the tag passed.
boolean	isALogin(RawSQL sql, String user)	Check if the username passed is a valid login of the SQL connection passed.
boolean	isALogin(String user, String password)	Checks if the username and password are correct in the current database.
String	modelDatabase()	The name of the model database.
String	name()	The name of the driver.
List<String>	parentTable(String tableName)
protected boolean	resetPassword(String user, String securityPassword, String newPassword)	Reset the password of the user, given the security password.
String	userSQL()	The SQL string that can return the login name of the current user as a column value.

Methods inherited from class com.storedobject.core.Database

changePassword, columnDetails, createDatabase, createDatabaseDDL, createSchema, createTable, currentTimeSQL, databaseExists, dependentConstraints, dropDatabase, ensureMaster, executeSQL, executeSQL, executeSQL, executeSQL, executeSQL, foreignKeyConstraintNames, foreignKeyConstraints, format, formatWithTime, get, getCurrentTime, getSQL, initialPassword, isMaster, lockDatabase, login, maxTime, maxTimeStamp, nanoDigits, schemaExists, securityLogin, tableExists, validateSecurityPassword, viewExists

Methods inherited from class java.lang.Object

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

Constructor Details

Database

public Database()

Method Details

name

public String name()

Description copied from class: Database

The name of the driver. For example, Sybase Adaptive Server Enterprise driver name is "ASE".

Specified by:

name in class Database

Returns:

The database driver name

modelDatabase

public String modelDatabase()

Description copied from class: Database

The name of the model database. Such a concept is there in some database systems.

Specified by:

modelDatabase in class Database

Returns:

The name of the model database. Null string may be returned if such a concept does not exist.

userSQL

public String userSQL()

Description copied from class: Database

The SQL string that can return the login name of the current user as a column value.

Specified by:

userSQL in class Database

Returns:

SQL that can be executed to get the name of the current user.

databaseSQL

public String databaseSQL(String databaseName)

Description copied from class: Database

Part of the SQL string (starting with FROM) that can query details of a database.

Specified by:

databaseSQL in class Database

Parameters:

databaseName - Database name.

Returns:

Part of the SQL string.

isALogin

public boolean isALogin(RawSQL sql,
 String user)

Description copied from class: Database

Check if the username passed is a valid login of the SQL connection passed.

Specified by:

isALogin in class Database

Parameters:

sql - The SQL connection on which the user needs to be verified.

user - The login name.

Returns:

True if the use is a valid login.

isALogin

public boolean isALogin(String user,
 String password)

Description copied from class: Database

Checks if the username and password are correct in the current database.

Specified by:

isALogin in class Database

Parameters:

user - The name of the login to check.

password - The password.

Returns:

True if the login is correct.

createLogin

public boolean createLogin(String user,
 String password)

Description copied from class: Database

Creates a login with the given login name and password.

Specified by:

createLogin in class Database

Parameters:

user - The login name.

password - The security password.

Returns:

True if successfully created.

dropLogin

public boolean dropLogin(String user,
 String password)

Description copied from class: Database

Drops a login with the given login name and password.

Specified by:

dropLogin in class Database

Parameters:

user - The login name.

password - The security password.

Returns:

True if successfully dropped.

alterPassword

protected boolean alterPassword(String user,
 String oldPassword,
 String newPassword)

Description copied from class: Database

Change the password of the user on the SQL connection.

Specified by:

alterPassword in class Database

Parameters:

user - The login name whose password needs to be changed.

oldPassword - Old password.

newPassword - New password.

Returns:

True if the password is successfully changed.

resetPassword

protected boolean resetPassword(String user,
 String securityPassword,
 String newPassword)

Description copied from class: Database

Reset the password of the user, given the security password.

Specified by:

resetPassword in class Database

Parameters:

user - The login name whose password needs to be changed.

securityPassword - The security superuser's password

newPassword - The password for the user.

Returns:

True if the password is successfully changed.

currentTime

public String currentTime()

Description copied from class: Database

The SQL column that can bring the current time from the database. For example, in the case of Sybase Adaptive Server Enterprise, it will return "getdate()".

Specified by:

currentTime in class Database

Returns:

The SQL column that can bring the current time from the database.

getSerial

public String getSerial(int tag)

Description copied from class: Database

Get the SQL statement for generating the next Id for the tag passed.

Specified by:

getSerial in class Database

Parameters:

tag - Tag for which statement is needed.

Returns:

Serial SQL for the tag

callProc

public String callProc(String name,
 String param)

Description copied from class: Database

Get the SQL statement string to call the stored procedure. For example, in the case of Sybase Adaptive Server Enterprise, if a procedure called "AuthorizeTran" needs to be invoked with parameters "25, 345, 23", this method will return "EXEC AuthorizeTran 25, 345, 23".

Specified by:

callProc in class Database

Parameters:

name - The name of the stored procedure.

param - Parameter to the stored procedure.

Returns:

The SQL statement to execute for invoking the stored procedure.

columnType

public String columnType(String columnType,
 int width,
 int precision)

Specified by:

columnType in class Database

dropDatabaseDDL

protected String dropDatabaseDDL(String databaseName)

Specified by:

dropDatabaseDDL in class Database

createSchemaDDL

protected String[] createSchemaDDL(String schemaName)

Specified by:

createSchemaDDL in class Database

getObjectClassName

public String getObjectClassName()

Description copied from class: Database

Get the name of the Object class of this database.

Specified by:

getObjectClassName in class Database

Returns:

Full name of the class

parentTable

public List<String> parentTable(String tableName)

Specified by:

parentTable in class Database