Defines a set of database insertions that is expected to result from a page or response. e.g.
<dbInsert dbTable="log" id="userid"/>
This specifies that a single insertion is expected into the log table; the id of the inserted row is assigned ot the variable userid
If multiple insertsions are expected, or if a specific database query is required, use in conjection with the dbInsertRef element. e.g.
<dbInsert dbTable="orders"/> <dbInsertRef id="order1" /> <dbInsertRef id="order2" /> </dbInsert> or <dbInsert dbTable="orders"/> <dbInsertRef id="order1" query="select max(id) from orders"/> <dbInsertRef id="order2" query="select max(id)-1 from orders"/> </dbInsert>
Values can also be extracted from the database using the set element. The difference with dbInsert is that dbInsert is checking all tables for insertions as well as optionally extracting the identifiers of inserted rows.
dbinsertref -- Defines a database insertion that is expected to result from a page or response.
Attribute Value(s) Default Value count
The number of expected insertions.CDATA
A reference to a dbTable elementCDATA
( dbinsertref ) *
definepage -- Used to define the structure of a html page
exec -- Run a datatbase sql command
form -- Specifies that a page or response contains a frameset
frame -- Specifies the contents of a frame.
set -- Set a variable to a value extracted from the database, to a value extracted from the current page.
verify -- Verify the most recently fetched page against a specification.
Top Elements || All Elements || Tree