TestComplete - Study Note 3 - Script
We can record a script or convert a keyword test to script or write a script directly. The former is much simpler.
For general test, Keyword test is enough. But when we need to verify the data changes in database after the user do some operation on UI, we must use script to connect database. Keyword test will not meet such requirement.
1. Query:
var datauserid;
var connstr="Provider=MSDASQL.1;Password=*****;Persist Security Info=True;User ID=xx;Data Source=xx;Initial Catalog=xx";
var Qry;
Qry=ADO.CreateADOQuery();
Qry.ConnectionString=connstr;
Qry.SQL = "SELECT * FROM datauser WHERE firstname='xx' AND lastname='xx' AND loginUsername='xxxx'";
// Call procedure
//Qry.SQL = "call p_xxxxxxCounts("+campaignid+")";
// Execute the query
Qry.Open();
Qry.First();
while (! Qry.EOF)
{
Log.Checkpoint("The checkpoint passed. "+ "The user '"+Qry.FieldByName("firstname").Value + " "+ Qry.FieldByName("lastname").Value+"' was added successfully in database");
Log.Message("The datauserid is "+Qry.FieldByName("datauserid").Value);
datauserid = Qry.FieldByName("datauserid").Value;
Qry.Next();
};
// Closes the query
Qry.Close();
if(null==datauserid)
Log.Error("The checkpoint failed. "+"No such user 'limei li' was added in database");
else{...}
2. Execute UID
var conn;
conn=ADO.CreateADOConnection();
conn.ConnectionString=connstr;
// Suppress the login dialog box
conn.LoginPrompt = false;
conn.open();
conn.Execute_("delete FROM xxx WHERE datauserid="+datauserid); //sub table
conn.Execute_("delete from xxxx where datauserid="+datauserid); //main table
conn.Close();
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步