OpenTestSystem.Otx.Extensions.SQL Namespace Reference

Read and write access to SQL databases More...

Namespaces
namespace	Actions
	Lists all ActionRealisation extensions.
namespace	DataTypes
	Data types, see also Core data types.
namespace	Exceptions
	Error handling.
namespace	Terms
	Lists all Terms.
namespace	Variables
	Variable Access.

Classes
class	CheckerRule
	Comprehensive checker rule listing, see also Core checker rules. More...

Detailed Description

Read and write access to SQL databases

The purpose of the OTX SQL Extension is to provide simple actions and terms to handle an access to a OTX SQL Extension database. It allows connections to a database and OTX SQL Extension commands for manipulating the data within the database.

Note

Important: The extension will be independent from a specific data provider. The selection of a specific data provider will covered by the tool specific runtime implementation.

The types of OTX SQL Extension will be mapped to OTX and vice versa as described in the next table.

SQL – OTX Mapping

SQL	OTX
integer	Integer
numeric, decimal	Float
float	Float
real	Float
double	Float
character, char	String
varchar	String
text	String
date	String
time	String
timestamp	String
boolean	Boolean
blod, clod	ByteField
other data types	not spec