JavaScript API Ver. 0.94

getInstance

public static RydeenScript getInstance()

Returns:

ext.lib.sql.SqlConnection implements java.sql.Connection

getConnection

public Returns getConnection(String dataSourceName)

Parameters:

dataSourceName: Target data source name.

Returns:

ext.lib.sql.SqlConnection implements java.sql.Connection

executeSelect

public SqlResultSet executeSelect(SqlConnection conn, String query)

Parameters:

conn: Connection.

query: Select query.

Returns:

ext.lib.sql.SqlResultSet implements java.sql.ResultSet

executeUpdate

public int executeUpdate(SqlConnection conn, String query)

Parameters:

conn: Connection.

query: Upadte query.

Returns:

Number of updated records.

existTable

public boolean existTable(SqlConnection conn, String tableName)

Parameters:

conn: Connection.

tableName: Table name.

Returns:

true If the table name exists; false otherwise.

dropTable

public int dropTable(SqlConnection conn, String tableName)

Parameters:

conn: Connection.

tableName: Table name.

Returns:

Number of updated records.

truncateTable

public int truncateTable(SqlConnection conn, String tableName)

Parameters:

conn: Connection.

tableName: Table name.

Returns:

Number of updated records.

createModel

public MmdModel createModel(SqlConnection conn, String tableName)

Parameters:

conn: Connection.

tableName: Table name.

Returns:

ext.base.mmd.MmdMode

createModel

public MmdModel createModel(SqlResultSet rs, String tableName)

Parameters:

rs: SqlResultSet

tableName: Table name.

Returns:

ext.base.mmd.MmdMode

convertMode

public MmdModel convertModel(SqlContext srcSqlContext, MmdModel srcTableModel, SqlContext dstSqlContext)

Parameters:

srcSqlContext: SqlContext of source.

srcTableMode: MmdMode of source.

dstSqlContext: SqlContext of destination.

Returns:

ext.base.mmd.MmdMode

createCreateTableQuery

public String createCreateTableQuery(SqlContext sqlContext, MmdModel mmdModel. boolean includePrimaryKey)

Parameters:

srcSqlContext: SqlContext.

mmdModel: MmdMode

includePrimaryKey: If true, include the primary key.

Returns:

Create table query.

copyResultSet

public int copyResultSet(SqlResultSet rs, SqlConnection dstConn, MmdModel mmdModel)

Parameters:

rs: SqlResultSet

destConn: Destination connection.

mmdModel: MmdMode

Returns:

Number of inserted records.

getTableNameList

public List<String> getTableNameList(SqlConnection conn, String namePattern)

Parameters:

conn: Data source connection.

namePattern: Regular expression. If null is specified, all will be targeted.

Returns:

java.util.List<String>

getViewNameList

public List<String> getViewNameList(SqlConnection conn, String namePattern)

Parameters:

conn: Data source connection.

namePattern: Regular expression. If null is specified, all will be targeted.

Returns:

java.util.List<String>