- <?xml version="1.0" encoding="UTF-8"?>
- <jmeterTestPlan version="1.2" properties="2.8" jmeter="2.13 r1665067">
- <hashTree>
- <TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true">
- <stringProp name="TestPlan.comments"></stringProp>
- <boolProp name="TestPlan.functional_mode">false</boolProp>
- <boolProp name="TestPlan.serialize_threadgroups">false</boolProp>
- <elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
- <collectionProp name="Arguments.arguments"/>
- </elementProp>
- <stringProp name="TestPlan.user_define_classpath"></stringProp>
- </TestPlan>
- <hashTree>
- <ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="Thread Group" enabled="true">
- <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
- <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
- <boolProp name="LoopController.continue_forever">false</boolProp>
- <stringProp name="LoopController.loops">500</stringProp>
- </elementProp>
- <stringProp name="ThreadGroup.num_threads">100</stringProp>
- <stringProp name="ThreadGroup.ramp_time">50</stringProp>
- <longProp name="ThreadGroup.start_time">1450393514000</longProp>
- <longProp name="ThreadGroup.end_time">1450393514000</longProp>
- <boolProp name="ThreadGroup.scheduler">false</boolProp>
- <stringProp name="ThreadGroup.duration"></stringProp>
- <stringProp name="ThreadGroup.delay"></stringProp>
- </ThreadGroup>
- <hashTree>
- <JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="JDBC Connection Configuration" enabled="true">
- <boolProp name="autocommit">true</boolProp>
- <stringProp name="checkQuery">Select 1</stringProp>
- <stringProp name="connectionAge">5000</stringProp>
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="dbUrl">jdbc:oracle:thin:@perf-assignments-2.ciynhfhfwckz.us-east-1.rds.amazonaws.com:1521/ORCL</stringProp>
- <stringProp name="driver">oracle.jdbc.OracleDriver</stringProp>
- <boolProp name="keepAlive">true</boolProp>
- <stringProp name="password">realize</stringProp>
- <stringProp name="poolMax">10</stringProp>
- <stringProp name="timeout">10000</stringProp>
- <stringProp name="transactionIsolation">DEFAULT</stringProp>
- <stringProp name="trimInterval">60000</stringProp>
- <stringProp name="username">prod_realize</stringProp>
- </JDBCDataSource>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="8nbv01j02u639 data set" enabled="true">
- <stringProp name="filename">ID_8nbv01j02u639.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">8nbv01j02u639_class_uuid,8nbv01j02u639_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="2mrst3vrnsfwa data set" enabled="true">
- <stringProp name="filename">2mrst3vrnsfwa.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">2mrst3vrnsfwa_class_uuid,2mrst3vrnsfwa_student_uuid</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="71rt9n36fb9w6 data set" enabled="true">
- <stringProp name="filename">ID_71rt9n36fb9w6.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">71rt9n36fb9w6_class_uuid,71rt9n36fb9w6_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="a5spx2rt3725d data set" enabled="true">
- <stringProp name="filename">ID_a5spx2rt3725d.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">a5spx2rt3725d_class_uuid,a5spx2rt3725d_student_uuid,a5spx2rt3725d_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="8x1pd8k9cmj79 data set" enabled="true">
- <stringProp name="filename">8x1pd8k9cmj79.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">8x1pd8k9cmj79_student_uuid,8x1pd8k9cmj79_item_uuid,8x1pd8k9cmj79_item_version</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="c8rfxarjgkwws data set" enabled="true">
- <stringProp name="filename">c8rfxarjgkwws.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">c8rfxarjgkwws_class_uuid</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="dh7rcygd7hfra data set" enabled="true">
- <stringProp name="filename">ID_dh7rcygd7hfra.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">dh7rcygd7hfra_class_uuid,dh7rcygd7hfra_student_uuid,dh7rcygd7hfra_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="a773y4z7bgb50 data set" enabled="true">
- <stringProp name="filename">a773y4z7bgb50.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">a773y4z7bgb50_class_uuid,a773y4z7bgb50_student_uuid</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="3tmh3ps7nq592 data set" enabled="true">
- <stringProp name="filename">3tmh3ps7nq592.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">3tmh3ps7nq592_owner_uuid,3tmh3ps7nq592_item_uuid</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="c0vchfx3ya9u6 data set" enabled="true">
- <stringProp name="filename">c0vchfx3ya9u6.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">c0vchfx3ya9u6_class_uuid</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="cs06fsb03xtw6 data set" enabled="true">
- <stringProp name="filename">ID_cs06fsb03xtw6.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">cs06fsb03xtw6_assignment_id,cs06fsb03xtw6_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="2yumq8bw91vv4 data set" enabled="true">
- <stringProp name="filename">ID_2yumq8bw91vv4.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">2yumq8bw91vv4_class_uuid,2yumq8bw91vv4_student_uuid,2yumq8bw91vv4_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="773y4z7bgb50 data set" enabled="true">
- <stringProp name="filename">ID_773y4z7bgb50.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">773y4z7bgb50_class_uuid,773y4z7bgb50_student_uuid,773y4z7bgb50_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="fjrv8kpqqktkk data set" enabled="true">
- <stringProp name="filename">ID_fjrv8kpqqktkk.csv</stringProp>
- <stringProp name="fileEncoding"></stringProp>
- <stringProp name="variableNames">fjrv8kpqqktkk_assignment_id,fjrv8kpqqktkk_count</stringProp>
- <stringProp name="delimiter">,</stringProp>
- <boolProp name="quotedData">false</boolProp>
- <boolProp name="recycle">true</boolProp>
- <boolProp name="stopThread">false</boolProp>
- <stringProp name="shareMode">shareMode.all</stringProp>
- </CSVDataSet>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="8nbv01j02u639" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT COUNT(*) JMETER_8nbv01j02u639 FROM ASA_USER_ASSIGNMENTS_EV U_A WHERE U_A.CLASS_UUID = ? AND U_A.ITEM_TYPE = 'TEST' AND U_A.IS_DELETED = 0 AND EXISTS (SELECT /*+ INDEX(U_A_D UAD_USER_ASSIGNMENT_ID_IDX) */ 1 FROM ASA_USER_ASSIGNMENT_DATA_EV U_A_D WHERE U_A_D.USER_ASSIGNMENT_ID = U_A.USER_ASSIGNMENT_ID AND U_A_D.CREATED_DATE > SYSDATE-30 AND U_A_D.CREATED_DATE < SYSDATE )</stringProp>
- <stringProp name="queryArguments">${8nbv01j02u639_class_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="2mrst3vrnsfwa" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_2mrst3vrnsfwa, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID, AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? AND AUA.STUDENT_UUID = ? ORDER BY AUA.ASSIGNMENT_ID
- </stringProp>
- <stringProp name="queryArguments">${2mrst3vrnsfwa_class_uuid},${2mrst3vrnsfwa_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="71rt9n36fb9w6" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_71rt9n36fb9w6, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID , AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? ORDER BY AUA.ASSIGNMENT_ID
- </stringProp>
- <stringProp name="queryArguments">${71rt9n36fb9w6_class_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="a5spx2rt3725d" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT COUNT(*) AS JMETER_a5spx2rt3725d FROM (SELECT ASAUSERASSIGNMENTS.USER_ASSIGNMENT_ID, ASAHIDDENASSIGNMENTS.CLASS_UUID N_CLASS FROM EVENTS_ASA_EV EVENTSASA JOIN ASA_USER_ASSIGNMENTS_EV ASAUSERASSIGNMENTS ON EVENTSASA.ID = ASAUSERASSIGNMENTS.ASSIGNMENT_ID JOIN ASA_USER_ASSIGMT_LANGUAGES_EV ASAUSERLANGUAGE ON ASAUSERLANGUAGE.USER_ASSIGNMENT_ID = ASAUSERASSIGNMENTS.USER_ASSIGNMENT_ID AND ASAUSERLANGUAGE.ITEM_UUID = EVENTSASA.ITEM_UUID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ASAHIDDENASSIGNMENTS ON ASAHIDDENASSIGNMENTS.CLASS_UUID = ASAUSERASSIGNMENTS.CLASS_UUID AND ASAHIDDENASSIGNMENTS.ASSIGNMENT_ID = ASAUSERASSIGNMENTS.ASSIGNMENT_ID WHERE ASAUSERASSIGNMENTS.CLASS_UUID = ? AND ASAUSERASSIGNMENTS.STUDENT_UUID = ? AND ASAUSERASSIGNMENTS.MARK_COMPLETED = 1 AND ASAUSERASSIGNMENTS.LAST_OPEN_DATE IS NOT NULL AND ASAUSERASSIGNMENTS.IS_DELETED = 0 ) WHERE N_CLASS IS NULL
- </stringProp>
- <stringProp name="queryArguments">${a5spx2rt3725d_class_uuid},${a5spx2rt3725d_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="8x1pd8k9cmj79" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">select assign.*, userassignmentlanguages.user_assignment_id as language_user_assignment_id, userassignmentlanguages.item_uuid as language_item_uuid, userassignmentlanguages.item_version as language_item_version, userassignmentlanguages.is_selected as language_is_selected, userassignmentlanguages.language_locale as language_language_locale from asa_user_assignments_ev assign join asa_user_assigmt_languages_ev userassignmentlanguages on assign.user_assignment_id = userassignmentlanguages.user_assignment_id where assign.student_uuid = ? and assign.is_deleted = 0 and userassignmentlanguages.item_uuid = ? and userassignmentlanguages.item_version = ?</stringProp>
- <stringProp name="queryArguments">${8x1pd8k9cmj79_student_uuid},${8x1pd8k9cmj79_item_uuid},${8x1pd8k9cmj79_item_version}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="c8rfxarjgkwws" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT DISTINCT EVENTS_ASA_EV.ITEM_UUID JMETER_c8rfxarjgkwws, EVENTS_ASA_EV.ITEM_VERSION, EVENTS_ASA_EV.OWNER_UUID, EVENTS_ASA_EV.TITLE, EVENTS_ASA_EV.CREATED_DATE, EVENTS_ASA_EV.START_DATE, EVENTS_ASA_EV.END_DATE, EVENTS_ASA_EV.DESCRIPTION, ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID, ASA_ASSIGNMENTS_EV.HAS_MULTIPLE_LANGUAGE, ASA_ASSIGNMENTS_EV.ALLOW_MULTIPLE_LANGUAGE, ASA_ASSIGNMENTS_EV.HAS_REMEDIATION, ASA_ASSIGNMENTS_EV.ALLOW_REMEDIATION, ASA_ASSIGNMENTS_EV.REMEDIATION_ORIGINAL_ITEM_UUID, ASA_ASSIGNMENTS_EV.ATTACHMENT_URL, ASA_ASSIGNMENTS_EV.ASSIGNMENT_TYPE, CASE WHEN ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID IS NOT NULL THEN 'INACTIVE' ELSE 'AVAILABLE' END HIDE_STATUS FROM EVENTS_ASA_EV JOIN ASA_ASSIGNMENTS_EV ON ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_EV.ID JOIN ASA_USER_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID LEFT JOIN EVENTS_ASA_ASSIGNED_TO_EV ON EVENTS_ASA_ASSIGNED_TO_EV.ID = EVENTS_ASA_EV.ID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ON ASA_HID DEN_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_ASSIGNED_TO_EV.ID AND EVENTS_ASA_ASSIGNED_TO_EV.CLASS_UUID = ASA_HIDDEN_ASSIGNMENTS_EV.CLASS_UUID WHERE EVENTS_ASA_ASSIGNED_TO_EV.CLASS_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.IS_DELETED = 0
- </stringProp>
- <stringProp name="queryArguments">${c8rfxarjgkwws_class_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="dh7rcygd7hfra" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT AUAD.USER_ASSIGNMENT_ID, AUAD.CREATED_DATE, AUAD.SCORE, AUAD.CORRECT_ANSWERS, AUAD.TOTAL_QUESTIONS, AUAD.COMPLETION_STATUS, AUAD.TOTAL_TIME, AUAD.SUCCESS_STATUS, AUAD.SCORE_SOURCE, AUAD.IS_SCORE_SENT FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGNMENT_DATA_EV AUAD ON AUAD.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? AND AUA.STUDENT_UUID = ? ORDER BY AUA.ASSIGNMENT_ID
- </stringProp>
- <stringProp name="queryArguments">${dh7rcygd7hfra_class_uuid},${dh7rcygd7hfra_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="a773y4z7bgb50" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT DISTINCT EVENTS_ASA_EV.*, ASA_ASSIGNMENTS_EV.*, CASE WHEN ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID IS NOT NULL THEN 'INACTIVE' ELSE 'AVAILABLE' END HIDE_STATUS FROM EVENTS_ASA_EV JOIN ASA_ASSIGNMENTS_EV ON ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_EV.ID JOIN ASA_USER_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID AND ASA_USER_ASSIGNMENTS_EV.CLASS_UUID = ASA_HIDDEN_ASSIGNMENTS_EV.CLASS_UUID WHERE ASA_USER_ASSIGNMENTS_EV.CLASS_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.STUDENT_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.IS_DELETED = 0</stringProp>
- <stringProp name="queryArguments">${a773y4z7bgb50_class_uuid},${a773y4z7bgb50_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="3tmh3ps7nq592" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT COUNT(DISTINCT A.ASSIGNMENT_ID) JMETER_3tmh3ps7nq592 FROM EVENTS_ASA_EV EA INNER JOIN ASA_ASSIGNMENTS_EV A ON A.ASSIGNMENT_ID = EA.ID INNER JOIN ASA_USER_ASSIGNMENTS_EV UA ON UA.ASSIGNMENT_ID = A.ASSIGNMENT_ID INNER JOIN ASA_USER_ASSIGMT_LANGUAGES_EV UAL ON UAL.USER_ASSIGNMENT_ID = UA.USER_ASSIGNMENT_ID WHERE EA.OWNER_UUID = ? AND UAL.ITEM_UUID = ? AND UA.IS_DELETED = 0</stringProp>
- <stringProp name="queryArguments">${3tmh3ps7nq592_owner_uuid},${3tmh3ps7nq592_item_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="c0vchfx3ya9u6" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT AUAD.USER_ASSIGNMENT_ID JMETER_c0vchfx3ya9u6, AUAD.CREATED_DATE, AUAD.SCORE, AUAD.CORRECT_ANSWERS, AUAD.TOTAL_QUESTIONS, AUAD.COMPLETION_STATUS, AUAD.TOTAL_TIME, AUAD.SUCCESS_STATUS, AUAD.SCORE_SOURCE, AUAD.IS_SCORE_SENT FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGNMENT_DATA_EV AUAD ON AUAD.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? ORDER BY AUA.ASSIGNMENT_ID</stringProp>
- <stringProp name="queryArguments">${c0vchfx3ya9u6_class_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="cs06fsb03xtw6" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_cs06fsb03xtw6, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID, AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.ASSIGNMENT_ID = :1 ORDER BY AUA.ASSIGNMENT_ID</stringProp>
- <stringProp name="queryArguments">${cs06fsb03xtw6_assignment_id}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="2yumq8bw91vv4" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT coalesce(sum(case when r.last_open_date is null then 1 else 0 end), 0) NOT_STARTED, coalesce(sum(case when r.last_open_date is not null and r.completed = 0 then 1 else 0 end), 0) IN_PROGRESS, coalesce(sum(case when r.last_open_date is not null and r.completed = 1 then 1 else 0 end), 0) COMPLETED from ( SELECT distinct asa_assignments_ev.assignment_id assignment_id, asa_user_assignments_ev.last_open_date last_open_date, asa_user_assignments_ev.mark_completed completed FROM events_asa_ev JOIN asa_assignments_ev on asa_assignments_ev.assignment_id = events_asa_ev.id JOIN asa_user_assignments_ev ON asa_user_assignments_ev.assignment_id = asa_assignments_ev.assignment_id JOIN asa_user_assigmt_languages_ev on asa_user_assignments_ev.user_assignment_id = asa_user_assigmt_languages_ev.user_assignment_id and asa_user_assigmt_languages_ev.item_uuid = events_asa_ev.item_uuid LEFT JOIN asa_user_assignment_data_ev ON asa_user_assignments_ev.user_assignment_id = asa_user_assignment_dat a_ev.user_assignment_id LEFT JOIN asa_hidden_assignments_ev ON asa_user_assignments_ev.assignment_id = asa_hidden_assignments_ev.assignment_id AND asa_user_assignments_ev.class_uuid = asa_hidden_assignments_ev.class_uuid WHERE asa_user_assignments_ev.class_uuid = ? AND asa_user_assignments_ev.student_uuid = ? AND case when asa_hidden_assignments_ev.assignment_id is NOT NULL then 'INACTIVE' else 'AVAILABLE' end = 'AVAILABLE' AND events_asa_ev.start_date <= SYSDATE AND asa_user_assignments_ev.is_deleted = 0) r</stringProp>
- <stringProp name="queryArguments">${2yumq8bw91vv4_class_uuid},${2yumq8bw91vv4_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="773y4z7bgb50" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">select distinct events_asa_ev.*, asa_assignments_ev.*, case when asa_hidden_assignments_ev.assignment_id is NOT NULL then 'INACTIVE' else 'AVAILABLE' end hide_status from events_asa_ev join asa_assignments_ev on asa_assignments_ev.assignment_id = events_asa_ev.id join asa_user_assignments_ev on asa_user_assignments_ev.assignment_id = asa_assignments_ev.assignment_id left join asa_hidden_assignments_ev on asa_user_assignments_ev.assignment_id = asa_hidden_assignments_ev.assignment_id and asa_user_assignments_ev.class_uuid = asa_hidden_assignments_ev.class_uuid where asa_user_assignments_ev.class_uuid = ? and asa_user_assignments_ev.student_uuid = ? and asa_user_assignments_ev.is_deleted = 0
- </stringProp>
- <stringProp name="queryArguments">${773y4z7bgb50_class_uuid},${773y4z7bgb50_student_uuid}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="fjrv8kpqqktkk" enabled="true">
- <stringProp name="dataSource">realizeDBPool</stringProp>
- <stringProp name="queryType">Prepared Select Statement</stringProp>
- <stringProp name="query">SELECT auad.user_assignment_id, auad.created_date, auad.score, auad.correct_answers, auad.total_questions, auad.completion_status, auad.total_time, auad.success_status, auad.score_source, auad.is_score_sent FROM asa_user_assignments_ev aua JOIN asa_user_assignment_data_ev auad ON auad.user_assignment_id = aua.user_assignment_id where aua.is_deleted = 0 and aua.assignment_id = ? ORDER BY aua.assignment_id
- </stringProp>
- <stringProp name="queryArguments">${fjrv8kpqqktkk_assignment_id}</stringProp>
- <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
- <stringProp name="variableNames"></stringProp>
- <stringProp name="resultVariable"></stringProp>
- <stringProp name="queryTimeout"></stringProp>
- <stringProp name="resultSetHandler">Store as String</stringProp>
- </JDBCSampler>
- <hashTree/>
- <ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="true">
- <boolProp name="ResultCollector.error_logging">false</boolProp>
- <objProp>
- <name>saveConfig</name>
- <value class="SampleSaveConfiguration">
- <time>true</time>
- <latency>true</latency>
- <timestamp>true</timestamp>
- <success>true</success>
- <label>true</label>
- <code>true</code>
- <message>true</message>
- <threadName>true</threadName>
- <dataType>true</dataType>
- <encoding>false</encoding>
- <assertions>true</assertions>
- <subresults>true</subresults>
- <responseData>false</responseData>
- <samplerData>false</samplerData>
- <xml>false</xml>
- <fieldNames>false</fieldNames>
- <responseHeaders>false</responseHeaders>
- <requestHeaders>false</requestHeaders>
- <responseDataOnError>false</responseDataOnError>
- <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
- <assertionsResultsToSave>0</assertionsResultsToSave>
- <bytes>true</bytes>
- <threadCounts>true</threadCounts>
- </value>
- </objProp>
- <stringProp name="filename">test.jtl</stringProp>
- </ResultCollector>
- <hashTree/>
- <ResultCollector guiclass="StatVisualizer" testclass="ResultCollector" testname="Aggregate Report" enabled="true">
- <boolProp name="ResultCollector.error_logging">false</boolProp>
- <objProp>
- <name>saveConfig</name>
- <value class="SampleSaveConfiguration">
- <time>true</time>
- <latency>true</latency>
- <timestamp>true</timestamp>
- <success>true</success>
- <label>true</label>
- <code>true</code>
- <message>true</message>
- <threadName>true</threadName>
- <dataType>true</dataType>
- <encoding>false</encoding>
- <assertions>true</assertions>
- <subresults>true</subresults>
- <responseData>false</responseData>
- <samplerData>false</samplerData>
- <xml>false</xml>
- <fieldNames>false</fieldNames>
- <responseHeaders>false</responseHeaders>
- <requestHeaders>false</requestHeaders>
- <responseDataOnError>false</responseDataOnError>
- <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
- <assertionsResultsToSave>0</assertionsResultsToSave>
- <bytes>true</bytes>
- <threadCounts>true</threadCounts>
- </value>
- </objProp>
- <stringProp name="filename"></stringProp>
- </ResultCollector>
- <hashTree/>
- </hashTree>
- </hashTree>
- </hashTree>
- </jmeterTestPlan>
Stikked
