Specify whether you want to close the connection: This property indicates how many rows the specified SQL statement affected ( see this example). If needed, you can buffer or verify the table property RowsAffected. If you set the value 0, the Database Engine 3.0 waits indefinitely. Open Connection ->Connection String ->Driver In this case, use Connection Name together with one of the following connection identifiers: Name of the connection that you want to use, if you have already opened a connection. The Module TBox DB Expert module has the following ModuleAttributes: If you run a 32-bit operating system, you can only use 32-bit ODBC connections. If you run a 64-bit operating system, you can use both 32-bit and 64-bit ODBC connections. This Module has the same base functionality, but allows you to use the connections you have defined in the Tosca BI Connection Manager. If you use Tosca BI, Tricentis recommends that you use the BI DB Expert Module from the Tosca BI Modules And Samples.tsu subset. The Module TBox DB Expert module allows you to handle your database statements with a single Module. Therefore, the first data row of the table is row #2. In this case, table steering interprets the table header as row #1. In this example, the Database Engine 3.0 verifies whether the value of the first data row in the column Last name is Sorensen. Specify the cell in a particular column that you want to steer. It does not support ActionModes Input and Insert. The Database Engine 3.0 supports all read-only table steering ActionModes. Specify the cell in a particular row that you want to steer.įor information on how to steer tables, see chapter "Table". For more information, see chapter "Export the result of an SQL Statement into a CSV file". You can export the result of your SQL Statement into a comma separated file. If the statement didn't affect any rows, the value is 0. This property indicates how many rows the specified SQL statement affected. If you set the value to 0, the Database Engine 3.0 waits indefinitely. Time in seconds that the Database Engine 3.0 should wait before it aborts the SQL statement and reports it as failed. The Module TBox DB Run SQL Statement has the following ModuleAttributes: If you specified a different connection with the Module TBox DB Current Connection, then the Module accesses this database instead. It accesses the database of the most recently opened connection. This Module allows you to steer data sets of one or more database tables. It opens the connection with the user credentials of the user sa. It saves the connection as a resource with the name TestDatabase. The Database Engine 3.0 performs the following actions: This example shows how to establish a connection to the database DB_Test. To do so, select the respective value from the Value drop-down menu. Specify whether you are using an SQLite, MSSQL, or generic ODBC database. ID of the user that opens the connection.Ĭonnection string to connect to SQLite, MS SQL, or generic ODBC databases.įor SQLite, the required drivers are part of the Tricentis Tosca standard installation. If you want to connect to SQLite, MS SQL, or generic ODBC databases, use Connection string. If you enter a Connection name that already exists, the Database Engine 3.0 doesn't establish a new connection. By default, the Database Engine 3.0 uses the DSN value as connection name. Name of the connection that you want to open. The Module TBox DB Open Connection has the following ModuleAttributes: The Database Engine 3.0 uses the most recently established connection for your tests.Īlternatively, you can specify a different connection with the Module Current Connection. You can open multiple database connections. The Module TBox DB Open Connection allows you to open a connection to a database. If you use the Database Engine 3.0 Module to open a connection, you must perform your database operations and then close the connection with Database Engine 3.0 Modules. The Database Engine 3.0 does not support mixed TestCases. The folder TBox XEngines ->Database in the Standard subset contains Modules that perform specific tasks for the Database Engine 3.0.
0 Comments
Leave a Reply. |