vu脚本疑惑

yg_82 发表于 2004-7-29 16:20:32

如下脚本：
#include <VU.h>
{

push Timeout_scale = 200; /* Set timeouts to 200% of maximum response time */
push Think_def = "LR";
Min_tmout = 120000; /* Set minimum Timeout_val to 2 minutes */
push Timeout_val = Min_tmout;

DP1 = datapool_open("yyy1");
datapool_fetch(DP1);

XornDB = sqlserverattach("XornDB", "XornDB", "oracle8.1");

{ INFO SERVER "XornDB"="192.168.10.8"; } /*1*/

set Server_connection = XornDB;

push Think_avg = 0;
sessid_1 = sqlsessionbegin ["yyy1001"] "Xorn", LOOKUP_PWD;

sqlsessioncontrol ["yyy1002"] sessid_1, CURSESSID;

#if 0
IS_VALID=0
#endif
set Think_avg = 344;

stmtid_1_id = sqldeclare_cursor["yyy1003"] "", "SELECT MAIN_CODE, NAME, IS_VALID, MEMO FROM CODE WHERE (IS_VALID <> "
+ datapool_value(DP1, "IS_VALID")+
" )";

datapool为自动产生。
上面这句话是什么意思：
sessid_1 = sqlsessionbegin ["yyy1001"] "Xorn", LOOKUP_PWD;

这句话中的数据又是从什么地方来？
stmtid_1_id = sqldeclare_cursor["yyy1003"] "", "SELECT MAIN_CODE, NAME, IS_VALID, MEMO FROM CODE WHERE (IS_VALID <> "
+ datapool_value(DP1, "IS_VALID")+
" )";
我找了datapool中的项，不存在"IS_VALID"啊

pcl2004_27 发表于 2004-7-29 16:56:25

sqlsessionbegin 命令id ,登陆用户,密码
LOOKUP_PWD 是参数，它可以自动查找密码

IS_VALID找不到，你打开datapool information下边看看，列名写得很明显

应该在你的脚本下边还有
DATAPOOL_CONFIG datapool_name flags
{

directive, "col_name" [,"data_type" [,"data_value"]];
...
directive, "col_name" [,"data_type" [,"data_value"]];
}

上边你对照下，应该就知道了！

yg_82 发表于 2004-7-29 17:05:59

thanks very much.
我是个初学者，在你的帮助下收获很大。

yg_82 发表于 2004-7-29 17:12:27

下面是全部脚本，没你说的那东西啊！

/*
   ->-> Session File Information <-<-
   Created: Thu Jul 29 12:12:47 2004
      Name: E:\²âÊÔ\TestDatastore\DefaultTestScriptDatastore\TMS_Sessions\ygq729.wch
      Type: Rational Robot - API
            (with Oracle OCI)
            (with Winsock1 Data)
*/

#include <VU.h>
{

push Timeout_scale = 200; /* Set timeouts to 200% of maximum response time */
push Think_def = "LR";
Min_tmout = 120000;    /* Set minimum Timeout_val to 2 minutes       */
push Timeout_val = Min_tmout;

DP1 = datapool_open("yyy1");
datapool_fetch(DP1);

XornDB = sqlserverattach("XornDB", "XornDB", "oracle8.1");

{ INFO SERVER "XornDB"="192.168.10.8"; } /*1*/

set Server_connection = XornDB;

push Think_avg = 0;
sessid_1 = sqlsessionbegin ["yyy1001"] "Xorn", LOOKUP_PWD;

sqlsessioncontrol ["yyy1002"] sessid_1, CURSESSID;

#if 0
IS_VALID=0
#endif
set Think_avg = 344;

stmtid_1_id = sqldeclare_cursor["yyy1003"] "", "SELECT MAIN_CODE, NAME, IS_VALID, MEMO FROM CODE WHERE (IS_VALID <> "
+ datapool_value(DP1, "IS_VALID")+
" )";

set Think_avg = 0;

sqlopen_cursor ["yyy1004"] stmtid_1_id;

set Think_avg = 79;
push CS_blocksize = 134;

sqlfetch_cursor ["yyy1005"] stmtid_1_id, ALL_ROWS;

set Think_avg = 156;

sqlfree_cursor( stmtid_1_id );

#if 0
IS_VALID=0
#endif
set Think_avg = 78;

stmtid_1_id = sqldeclare_cursor["yyy1006"] "", "SELECT CODE_ITEM_ID, "
"MAIN_CODE, NAME, IS_VALID, MEMO, ORDINAL_NO FROM CODE_ITEM WHERE "
"(IS_VALID <> "
+ datapool_value(DP1, "IS_VALID")+
" )";

set Think_avg = 0;

sqlopen_cursor ["yyy1007"] stmtid_1_id;

set Think_avg = 31;
set CS_blocksize = 111;

sqlfetch_cursor ["yyy1008"] stmtid_1_id, ALL_ROWS;

set Think_avg = 172;

sqlfree_cursor( stmtid_1_id );

sqlserverdetach(XornDB);

pop ;

pop CS_blocksize;

}

DATAPOOL_CONFIG "yyy1"OVERRIDE DP_NOWRAP DP_SEQUENTIAL DP_SHARED
{
   EXCLUDE, "IS_VALID", "string", "0";
}

另外，你说的datapool information是tools->manage->datapools->edit吗？
但是我没有找到啊

yg_82 发表于 2004-7-30 11:21:43

找到了，谢谢

页: [1]

51Testing软件测试论坛 's Archiver

vu脚本疑惑

下面是全部脚本，没你说的那东西啊！