OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation Interface Reference

Allows users to implement their own Sql extension. More...

Public Member Functions
void	CloseConnection (IConnection connection)
	Closes the current connection More...
void	CreateConnection (IRuntimeContext runtimeContext, IConnection connection, string connectionString)
	Open a connection More...
void	ExecuteQuery (IConnection connection, IResultSet resultSet, string statement)
	Executes the given SQL statement More...
int	ExecuteUpdate (IConnection connection, string statement)
	Executes the given SQL statement More...
bool	GetResultValueAsBoolean (IResultSet resultSet, object column)
	Get the value form ResultSet as Boolean type More...
ByteField	GetResultValueAsByteField (IResultSet resultSet, object column)
	Get the value form ResultSet as ByteField type More...
double	GetResultValueAsFloat (IResultSet resultSet, object column)
	Get the value form ResultSet as Float type More...
int	GetResultValueAsInteger (IResultSet resultSet, object column)
	Get the value form ResultSet as Integer type More...
string	GetResultValueAsString (IResultSet resultSet, object column)
	Get the value form ResultSet as String type More...
bool	NextResult (IResultSet resultSet)
	Move the cursor forward one row More...

Detailed Description

Allows users to implement their own Sql extension.

Member Function Documentation

CloseConnection()

void OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.CloseConnection

(

IConnection

connection

)

Closes the current connection

Parameters

connection

Represents a connection instance.

CreateConnection()

void OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.CreateConnection	(	IRuntimeContext	runtimeContext,
		IConnection	connection,
		string	connectionString
	)

Open a connection

Parameters

runtimeContext	The related runtime context.
connection	Represents a connection instance.
connectionString	Specifies the location of the data source that is required for the connection. Connection string used to create the connection that pass for creation of command variable.The connection string includes the source database nameand other parameters needed to establish the initial connection.

ExecuteQuery()

void OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.ExecuteQuery	(	IConnection	connection,
		IResultSet	resultSet,
		string	statement
	)

Executes the given SQL statement

Parameters

connection	Represents a connection instance.
resultSet	Represents a ResultSet instance.
statement	SQL statement

ExecuteUpdate()

int OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.ExecuteUpdate	(	IConnection	connection,
		string	statement
	)

Executes the given SQL statement

Parameters

connection	Represents a connection instance.
statement	SQL statement, which may be an INSERT, UPDATE or DELETE statement or an statement that returns nothing, such as an OTX SQL Extension DDL statement.

Returns

Returns the row count for OTX SQL Extension Data Manipulation statements or 0 for OTX SQL Extension statements that return nothing

GetResultValueAsBoolean()

bool OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.GetResultValueAsBoolean	(	IResultSet	resultSet,
		object	column
	)

Get the value form ResultSet as Boolean type

Parameters

resultSet	This element represents the ResultSet from which the value of the current row shall be read
column	This element represents the column from which the value shall be read. A column can be accessed via name or via index.Therefore the data type of the column property shall be String (name) or Integer (index)

Returns

Boolean value

GetResultValueAsByteField()

ByteField OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.GetResultValueAsByteField	(	IResultSet	resultSet,
		object	column
	)

Get the value form ResultSet as ByteField type

Parameters

resultSet	This element represents the ResultSet from which the value of the current row shall be read
column	This element represents the column from which the value shall be read. A column can be accessed via name or via index.Therefore the data type of the column property shall be String (name) or Integer (index)

Returns

Bytefield value

GetResultValueAsFloat()

double OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.GetResultValueAsFloat	(	IResultSet	resultSet,
		object	column
	)

Get the value form ResultSet as Float type

Parameters

resultSet	This element represents the ResultSet from which the value of the current row shall be read
column	This element represents the column from which the value shall be read. A column can be accessed via name or via index.Therefore the data type of the column property shall be String (name) or Integer (index)

Returns

Float value

GetResultValueAsInteger()

int OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.GetResultValueAsInteger	(	IResultSet	resultSet,
		object	column
	)

Get the value form ResultSet as Integer type

Parameters

resultSet	This element represents the ResultSet from which the value of the current row shall be read
column	This element represents the column from which the value shall be read. A column can be accessed via name or via index.Therefore the data type of the column property shall be String (name) or Integer (index)

Returns

Integer value

GetResultValueAsString()

string OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.GetResultValueAsString	(	IResultSet	resultSet,
		object	column
	)

Get the value form ResultSet as String type

Parameters

resultSet	This element represents the ResultSet from which the value of the current row shall be read
column	This element represents the column from which the value shall be read. A column can be accessed via name or via index.Therefore the data type of the column property shall be String (name) or Integer (index)

Returns

String value

NextResult()

bool OpenTestSystem.Otx.Runtime.Api.Custom.ISqlImplementation.NextResult

(

IResultSet

resultSet

)

Move the cursor forward one row

Parameters

resultSet

This element represents the result set from which the next row shall be selected.

Returns

Can next result

---

The documentation for this interface was generated from the following file:

• ISqlImplementation.cs