On 18 November 2016 at 15:10, Sankar Das <[email protected]> wrote:
> Hi,
>
> Thanks for the reply. Yes I am able to capture it.
>
> But my query is "SELECT STATUS,COUNT(*) FROM MYTABLE WHERE CREATIONTIME >
> TRUNC(SYSDATE) GROUP BY STATUS"
>
> So I have two columns here ID_# and WF_# and the rows will increase and
> decrease according to the sysdate.
ID_# and WF_# are not columns.
They are row counts, i.e. the number of ID_1,...ID_n and WF_1,...WF_n variables
>
> I want to do like this,
>
> If column1_row1_ ID_1 = Waiting and column2_row1_WF_1 > 25, than fail the
> sampler "Failure = true".
>
> But the rows values are changing according to sysdate.
>
> so want to capture all the rows value
You already have the values in the variables ID_1...ID_n and WF_1...WF_n
And the counts are in ID_# and WF_#
> and compare them on run time and make
> the sampler "failure true or false".
>
You wrote "Above code is working when I know the number of rows for a particular
column. "
I provided details on how to extract the row count.
And you can get the value of a variable using vars.get(varname) where
varname is a string containing the variable name.
BeanShell is basically Java, so you can loop through values of n from
1 to ID_# and pick out the values:
for (int i=1; i<vars.get("WF_#"); i++) {
id = vars.get("ID_"+i);
wf = vars.get("WF_"+i);
// do your checks
}
[Not tried this. You may need to use sprintf("ID_%i",i) to create the
variable name.]
>
>
>
> On Fri, Nov 18, 2016 at 4:48 PM, sebb <[email protected]> wrote:
>
>> On 18 November 2016 at 14:15, Sankar Das <[email protected]>
>> wrote:
>> > Hello Everyone,
>> >
>> > Getting two columns from a jdbc sampler i.e ID and WF. Trying to fail
>> it,
>> > if it exceeds than the predefined variables by using beanshell.
>> > Below is the sample code.
>> >
>> > String myValue1 = vars.get("WF_1");
>> > String myValue2 = vars.get("WF_2");
>> > if(!myValue1.equals ("3")){
>> > log.info("myValue1 =" + myValue1);
>> > Failure = true;
>> > FailureMessage = " The database value should be " + myValue1 + ".";
>> > }
>> > else if(!myValue2.equals ("5")){
>> > //log something
>> > Failure = true;
>> > log.info("myValue2 =" + myValue2);
>> > FailureMessage = " The database value should be " + myValue2 + ".";
>> >
>> > else {
>> > //can be log something?
>> > Failure = false;
>> >
>> >
>> > }
>> > Above code is working when I know the number of rows for a particular
>> > column. If the rows values are dynamic and increasing or decreasing
>> > according to sysdate than how to compare them with the predefined and
>> fail
>> > the sampler.
>> >
>> > Please help!
>>
>> As per http://jmeter.apache.org/usermanual/component_
>> reference.html#JDBC_Request
>>
>> the number of rows is stored in the variables
>>
>> ID_# and WF_#
>>
>> > Thanks!
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
