SqlQueryTestStep Class

Runs an SQL Query. This test step is available only in professional version.

Inheritance Hierarchy

SystemObject
  Hummingbird.TestFramework.AutomationAbstractTestItem
    Hummingbird.TestFramework.AutomationTestStepBase
      Hummingbird.TestFramework.AutomationAbstractSqlTestStep
        Hummingbird.TestFramework.AutomationSqlQueryTestStep

Namespace: Hummingbird.TestFramework.Automation
Assembly: Hummingbird.TestFramework.Automation (in Hummingbird.TestFramework.Automation.dll) Version: 1.2.0.0

Syntax

C++

Copy

[DataContractAttribute(Namespace = "http://www.hummingbird-alm.com/testframework/201610")]
[ImageSourceAttribute(ImageSource = "/Images/Icons/database_run.png")]
public class SqlQueryTestStep : AbstractSqlTestStep

<DataContractAttribute(Namespace := "http://www.hummingbird-alm.com/testframework/201610")>
<ImageSourceAttribute(ImageSource := "/Images/Icons/database_run.png")>
Public Class SqlQueryTestStep
	Inherits AbstractSqlTestStep

[DataContractAttribute(Namespace = L"http://www.hummingbird-alm.com/testframework/201610")]
[ImageSourceAttribute(ImageSource = L"/Images/Icons/database_run.png")]
public ref class SqlQueryTestStep : public AbstractSqlTestStep

[<DataContractAttribute(Namespace = "http://www.hummingbird-alm.com/testframework/201610")>]
[<ImageSourceAttribute(ImageSource = "/Images/Icons/database_run.png")>]
type SqlQueryTestStep =  
    class
        inherit AbstractSqlTestStep
    end

The SqlQueryTestStep type exposes the following members.

Constructors

	Name	Description
	SqlQueryTestStep	Initializes a new instance of the SqlQueryTestStep class.

Top

Properties

	Name	Description
	Assertions	Gets or sets the assertions related to the current test step (Inherited from TestStepBase.)
	Context	Gets or sets the test case level Context values. The context is dispatched by the automation engine, and is read-only outside of the Test Cases. (Inherited from AbstractTestItem.)
	CustomVariables	Gets a list of custom variables defined by the user. These variables will be saved with the project. and will be replaced if necessary. CustomVariables are more priority than variables in Variables, if an variable of the same name exists both in CustomVariables and Variables, the value of that in CustomVarialbes will return. (Inherited from AbstractTestItem.)
	DatabaseName	Gets or sets the name of the database. (Inherited from AbstractSqlTestStep.)
	Description	Gets or sets the Description of the current AbstractTestItem (Inherited from AbstractTestItem.)
	DisplayMessage	Gets or sets the information can be shown to the user (Inherited from AbstractTestItem.)
	ElapsedTime	A DateTime object indicates the time when current steps finishes. EndTime is set by the test framework after the Checkpoint method has finishes. If the test step goes wrong, EndTime will be set when the error occurs. (Inherited from AbstractTestItem.)
	EncPassword	Gets or sets the Encrypted password. (Inherited from AbstractSqlTestStep.)
	Id	Gets or sets the unique identifier of the TestCase. (Inherited from AbstractTestItem.)
	Information	Detailed information for diagnostic, debug. Do not call Information.Clear when running the test step, it will be automatically done within the base class. (Inherited from TestStepBase.)
	InformationString	Gets the string representation of Information (Inherited from TestStepBase.)
	IsDisabled	Gets or sets whether the current test item is disabled. (Inherited from AbstractTestItem.)
	IsExpanded	Gets or sets a value indicating whether this item is extended in its Visual Tree. (Inherited from AbstractTestItem.)
	Name	Gets or sets the name of this Test Case (Inherited from AbstractTestItem.)
	OnErrorBehavior	Gets or sets the behavior of Automation Engine when the current test case fails (Inherited from TestStepBase.)
	Password	Gets or sets the password to access to base if User/Password mode is used. This field is not saved directly when saved to files. (Inherited from AbstractSqlTestStep.)
	Profile	Gets the profile. (Inherited from TestStepBase.)
	Progress	Gets or sets the progress of the current test item (Test suite or test case) (Inherited from AbstractTestItem.)
	Project	Gets the AutomationProject object where this Test Step depends on. (Inherited from TestStepBase.)
	Query	Gets or sets the SQL Query that will be executed.
	RelatedMessage	Gets or sets a Message object related to the current test step. (Inherited from TestStepBase.)
	RequestObject	Gets the request object. (Inherited from TestStepBase.)
	RequestText	Gets the Request Text from the related message, if the related message is null or empty, the return value is null. (Inherited from TestStepBase.)
	ResponseObject	Gets the response object. (Inherited from TestStepBase.)
	ResponseText	Gets the response text from the related message, if the related message is null the return value is null (Inherited from TestStepBase.)
	Result	Gets or SQL execution result, according to the resultType. If ResultType is set to Nothing, the property will contains the number of rows affected. If ResultType is set to ScalarValue, the property will contains the returned value. If ResultType is set to Query, the property will contains the returned data in an Array (Inherited from AbstractSqlTestStep.)
	ResultTable	Gets the SQL Query result in DataTable representation. (Inherited from AbstractSqlTestStep.)
	ResultType	Gets or sets the SqlResultType of the current Query or Stored Procedure (Inherited from AbstractSqlTestStep.)
	Server	Gets or sets the server name (FQN, Host name or IP address) (Inherited from AbstractSqlTestStep.)
	SqlAuthenticationMode	Gets or sets the SQL authentication mode. (Inherited from AbstractSqlTestStep.)
	StartTime	A DateTime object indicates the time when current steps starts to run. StartTime is set by the test framework when the Run method has been called. (Inherited from AbstractTestItem.)
	Status	Status of the current test item (TestSuite, TestCase or TestStep). Automation framework will mark Result = Running when entering the current item. If Result has not been changed in Run() and Checkpoint() method, it will be marked as Passed. You must assign Errors, Warning if it happens within Run and Checkpoint method. (Inherited from AbstractTestItem.)
	TestCase	Gets the referenced test case for this test step (Inherited from TestStepBase.)
	ThreadId	Gets the thread identifier. (Inherited from TestStepBase.)
	UserName	Gets or sets the UserName to access to base if User/Password mode is used (Inherited from AbstractSqlTestStep.)
	Variables	Gets or sets the variables in the current test scope (Test Step, Test Case or Test Suite). (Inherited from AbstractTestItem.)

Top

Methods

	Name	Description
	Compare	Compares two objects and returns a value indicating whether one is less than, equal to, or greater than the other. (Inherited from AbstractTestItem.)
	CompareTo	Compares the current instance with another object of the same type and returns an integer that indicates whether the current instance precedes, follows, or occurs in the same position in the sort order as the other object. (Inherited from AbstractTestItem.)
	DeleteItem	Deletes an sub item from the current scope. for Test Case, the item is test Step, For Test Suite, the item is test case, ... (Inherited from TestStepBase.)
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from AbstractTestItem.)
	Dispose(Boolean)	Releases unmanaged and - optionally - managed resources. (Inherited from TestStepBase.)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetConnectionString	Gets the connection string from the current test step settings (Inherited from AbstractSqlTestStep.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	GetVariable	Gets the variable from the given context. (Inherited from AbstractTestItem.)
	GetVariables	Gets All variables available for the current test scope. (Inherited from AbstractTestItem.)
	InitStatus	Initializes the status of the Test Case (Inherited from AbstractTestItem.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	MoveDown	Moves down a test item in its parent items collections (Inherited from AbstractTestItem.)
	MoveToBottom	Moves to bottom a test item in its parent items collections (Inherited from AbstractTestItem.)
	MoveToTop	Moves on top a test item in its parent items collection. (Inherited from AbstractTestItem.)
	MoveUp	Moves up a test item in its parent items collection. (Inherited from AbstractTestItem.)
	OnPropertyChanged	Called when property value has changed. (Inherited from AbstractTestItem.)
	Run	Runs this instance. (Overrides TestStepBaseRun.)
	Run(Int64, TestCase, ListVariable, Profile)	Run current Test step, within the current TestCase. (Inherited from TestStepBase.)
	TestConnectivity	Tests the connectivity from the current settings (Inherited from AbstractSqlTestStep.)
	ToString	Returns a String that represents this instance. (Inherited from TestStepBase.)
	UpdateId	Generates a new Identifier of the current AbstractTestItem and all its sub items. (Inherited from TestStepBase.)

Top

Events

	Name	Description
	PropertyChanged	Occurs when the test case properties has been changed. (Inherited from AbstractTestItem.)

Top

Extension Methods

	Name	Description
	Copy	Deep copy the given TestStep from the original by using serialization. (Defined by ExtensionMethods.)
	ToStringOrXml	Converts any Object to string representation in String or XML format. (Defined by ExtensionMethods.)
	ToXmlString	Converts any Object to string representation in XML format. (Defined by ExtensionMethods.)

Top

Reference

Hummingbird.TestFramework.Automation Namespace

Hummingbird.TestFramework.AutomationAbstractSqlTestStep