Package edu.uiuc.ncsa.qdl.extensions.database

Class QDLDB

java.lang.Object

edu.uiuc.ncsa.qdl.extensions.database.QDLDB

All Implemented Interfaces:

QDLModuleMetaClass, Serializable

public class QDLDB
extends Object
implements QDLModuleMetaClass

Created by Jeff Gaynor
on 5/5/22 at 7:11 AM

See Also:

Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
class	QDLDB.Connect
class	QDLDB.Execute
class	QDLDB.Read
class	QDLDB.SQLTypes
class	QDLDB.Update

Field Summary

Fields

Modifier and Type	Field	Description
static String	CONNECT_COMMAND
static String	DERBY_TYPE
static String	DYNAMODB_TYPE
static String	EXECUTE_COMMAND
static String	MARIADB_TYPE
static String	MYSQL_TYPE
static String	POSTGRES_TYPE
static String	QUERY_COMMAND
static String	TYPE_ARG
static String	TYPE_VAR_NAME
static String	UPDATE_COMMAND

Constructor Summary

Constructors

Constructor	Description
QDLDB()

Method Summary

Modifier and Type	Method	Description
void	deserializeFromJSON(net.sf.json.JSONObject json)
protected void	destroyConnection(edu.uiuc.ncsa.security.storage.sql.ConnectionRecord c)
Object	doSQLExecute(Object[] objects, String name)	Used for both create and delete.
protected List<String>	getArgStatement()
void	releaseConnection(edu.uiuc.ncsa.security.storage.sql.ConnectionRecord c)
net.sf.json.JSONObject	serializeToJSON()	Send back a serialization of state for this object.
protected Object	sqlConvert(Object obj)	Converts a generic object to a QDL object.

Methods inherited from class java.lang.Object

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

Field Detail

CONNECT_COMMAND

public static String CONNECT_COMMAND

MYSQL_TYPE

public static final String MYSQL_TYPE

See Also:

Constant Field Values

MARIADB_TYPE

public static final String MARIADB_TYPE

See Also:

Constant Field Values

POSTGRES_TYPE

public static final String POSTGRES_TYPE

See Also:

Constant Field Values

DYNAMODB_TYPE

public static final String DYNAMODB_TYPE

See Also:

Constant Field Values

DERBY_TYPE

public static final String DERBY_TYPE

See Also:

Constant Field Values

TYPE_ARG

public static final String TYPE_ARG

See Also:

Constant Field Values

QUERY_COMMAND

public static final String QUERY_COMMAND

See Also:

Constant Field Values

UPDATE_COMMAND

public static String UPDATE_COMMAND

EXECUTE_COMMAND

public static String EXECUTE_COMMAND

TYPE_VAR_NAME

public static String TYPE_VAR_NAME

Constructor Detail

QDLDB

public QDLDB()

Method Detail

sqlConvert

protected Object sqlConvert(Object obj)

Converts a generic object to a QDL object.

Parameters:

obj -

Returns:

releaseConnection

public void releaseConnection(edu.uiuc.ncsa.security.storage.sql.ConnectionRecord c)

destroyConnection

protected void destroyConnection(edu.uiuc.ncsa.security.storage.sql.ConnectionRecord c)

doSQLExecute

public Object doSQLExecute(Object[] objects,
                           String name)

Used for both create and delete.

Parameters:

objects -

name -

Returns:

getArgStatement

protected List<String> getArgStatement()

serializeToJSON

public net.sf.json.JSONObject serializeToJSON()

Description copied from interface: QDLModuleMetaClass

Send back a serialization of state for this object. This allows for the state you choose to be serialized and then reloaded.

NOTE

There is no canonical form for this. Set it how you will and deserialize it accordingly.

Specified by:

serializeToJSON in interface QDLModuleMetaClass

Returns:

deserializeFromJSON

public void deserializeFromJSON(net.sf.json.JSONObject json)

Specified by:

deserializeFromJSON in interface QDLModuleMetaClass