From Unreliable Teal, 9 Years ago, written in Plain Text.
Embed
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <jmeterTestPlan version="1.2" properties="2.8" jmeter="2.13 r1665067">
  3.   <hashTree>
  4.     <TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test Plan" enabled="true">
  5.       <stringProp name="TestPlan.comments"></stringProp>
  6.       <boolProp name="TestPlan.functional_mode">false</boolProp>
  7.       <boolProp name="TestPlan.serialize_threadgroups">false</boolProp>
  8.       <elementProp name="TestPlan.user_defined_variables" elementType="Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User Defined Variables" enabled="true">
  9.         <collectionProp name="Arguments.arguments"/>
  10.       </elementProp>
  11.       <stringProp name="TestPlan.user_define_classpath"></stringProp>
  12.     </TestPlan>
  13.     <hashTree>
  14.       <ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" testname="Thread Group" enabled="true">
  15.         <stringProp name="ThreadGroup.on_sample_error">continue</stringProp>
  16.         <elementProp name="ThreadGroup.main_controller" elementType="LoopController" guiclass="LoopControlPanel" testclass="LoopController" testname="Loop Controller" enabled="true">
  17.           <boolProp name="LoopController.continue_forever">false</boolProp>
  18.           <stringProp name="LoopController.loops">500</stringProp>
  19.         </elementProp>
  20.         <stringProp name="ThreadGroup.num_threads">100</stringProp>
  21.         <stringProp name="ThreadGroup.ramp_time">50</stringProp>
  22.         <longProp name="ThreadGroup.start_time">1450393514000</longProp>
  23.         <longProp name="ThreadGroup.end_time">1450393514000</longProp>
  24.         <boolProp name="ThreadGroup.scheduler">false</boolProp>
  25.         <stringProp name="ThreadGroup.duration"></stringProp>
  26.         <stringProp name="ThreadGroup.delay"></stringProp>
  27.       </ThreadGroup>
  28.       <hashTree>
  29.         <JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" testname="JDBC Connection Configuration" enabled="true">
  30.           <boolProp name="autocommit">true</boolProp>
  31.           <stringProp name="checkQuery">Select 1</stringProp>
  32.           <stringProp name="connectionAge">5000</stringProp>
  33.           <stringProp name="dataSource">realizeDBPool</stringProp>
  34.           <stringProp name="dbUrl">jdbc:oracle:thin:@perf-assignments-2.ciynhfhfwckz.us-east-1.rds.amazonaws.com:1521/ORCL</stringProp>
  35.           <stringProp name="driver">oracle.jdbc.OracleDriver</stringProp>
  36.           <boolProp name="keepAlive">true</boolProp>
  37.           <stringProp name="password">realize</stringProp>
  38.           <stringProp name="poolMax">10</stringProp>
  39.           <stringProp name="timeout">10000</stringProp>
  40.           <stringProp name="transactionIsolation">DEFAULT</stringProp>
  41.           <stringProp name="trimInterval">60000</stringProp>
  42.           <stringProp name="username">prod_realize</stringProp>
  43.         </JDBCDataSource>
  44.         <hashTree/>
  45.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="8nbv01j02u639 data set" enabled="true">
  46.           <stringProp name="filename">ID_8nbv01j02u639.csv</stringProp>
  47.           <stringProp name="fileEncoding"></stringProp>
  48.           <stringProp name="variableNames">8nbv01j02u639_class_uuid,8nbv01j02u639_count</stringProp>
  49.           <stringProp name="delimiter">,</stringProp>
  50.           <boolProp name="quotedData">false</boolProp>
  51.           <boolProp name="recycle">true</boolProp>
  52.           <boolProp name="stopThread">false</boolProp>
  53.           <stringProp name="shareMode">shareMode.all</stringProp>
  54.         </CSVDataSet>
  55.         <hashTree/>
  56.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="2mrst3vrnsfwa data set" enabled="true">
  57.           <stringProp name="filename">2mrst3vrnsfwa.csv</stringProp>
  58.           <stringProp name="fileEncoding"></stringProp>
  59.           <stringProp name="variableNames">2mrst3vrnsfwa_class_uuid,2mrst3vrnsfwa_student_uuid</stringProp>
  60.           <stringProp name="delimiter">,</stringProp>
  61.           <boolProp name="quotedData">false</boolProp>
  62.           <boolProp name="recycle">true</boolProp>
  63.           <boolProp name="stopThread">false</boolProp>
  64.           <stringProp name="shareMode">shareMode.all</stringProp>
  65.         </CSVDataSet>
  66.         <hashTree/>
  67.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="71rt9n36fb9w6 data set" enabled="true">
  68.           <stringProp name="filename">ID_71rt9n36fb9w6.csv</stringProp>
  69.           <stringProp name="fileEncoding"></stringProp>
  70.           <stringProp name="variableNames">71rt9n36fb9w6_class_uuid,71rt9n36fb9w6_count</stringProp>
  71.           <stringProp name="delimiter">,</stringProp>
  72.           <boolProp name="quotedData">false</boolProp>
  73.           <boolProp name="recycle">true</boolProp>
  74.           <boolProp name="stopThread">false</boolProp>
  75.           <stringProp name="shareMode">shareMode.all</stringProp>
  76.         </CSVDataSet>
  77.         <hashTree/>
  78.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="a5spx2rt3725d data set" enabled="true">
  79.           <stringProp name="filename">ID_a5spx2rt3725d.csv</stringProp>
  80.           <stringProp name="fileEncoding"></stringProp>
  81.           <stringProp name="variableNames">a5spx2rt3725d_class_uuid,a5spx2rt3725d_student_uuid,a5spx2rt3725d_count</stringProp>
  82.           <stringProp name="delimiter">,</stringProp>
  83.           <boolProp name="quotedData">false</boolProp>
  84.           <boolProp name="recycle">true</boolProp>
  85.           <boolProp name="stopThread">false</boolProp>
  86.           <stringProp name="shareMode">shareMode.all</stringProp>
  87.         </CSVDataSet>
  88.         <hashTree/>
  89.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="8x1pd8k9cmj79 data set" enabled="true">
  90.           <stringProp name="filename">8x1pd8k9cmj79.csv</stringProp>
  91.           <stringProp name="fileEncoding"></stringProp>
  92.           <stringProp name="variableNames">8x1pd8k9cmj79_student_uuid,8x1pd8k9cmj79_item_uuid,8x1pd8k9cmj79_item_version</stringProp>
  93.           <stringProp name="delimiter">,</stringProp>
  94.           <boolProp name="quotedData">false</boolProp>
  95.           <boolProp name="recycle">true</boolProp>
  96.           <boolProp name="stopThread">false</boolProp>
  97.           <stringProp name="shareMode">shareMode.all</stringProp>
  98.         </CSVDataSet>
  99.         <hashTree/>
  100.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="c8rfxarjgkwws data set" enabled="true">
  101.           <stringProp name="filename">c8rfxarjgkwws.csv</stringProp>
  102.           <stringProp name="fileEncoding"></stringProp>
  103.           <stringProp name="variableNames">c8rfxarjgkwws_class_uuid</stringProp>
  104.           <stringProp name="delimiter">,</stringProp>
  105.           <boolProp name="quotedData">false</boolProp>
  106.           <boolProp name="recycle">true</boolProp>
  107.           <boolProp name="stopThread">false</boolProp>
  108.           <stringProp name="shareMode">shareMode.all</stringProp>
  109.         </CSVDataSet>
  110.         <hashTree/>
  111.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="dh7rcygd7hfra data set" enabled="true">
  112.           <stringProp name="filename">ID_dh7rcygd7hfra.csv</stringProp>
  113.           <stringProp name="fileEncoding"></stringProp>
  114.           <stringProp name="variableNames">dh7rcygd7hfra_class_uuid,dh7rcygd7hfra_student_uuid,dh7rcygd7hfra_count</stringProp>
  115.           <stringProp name="delimiter">,</stringProp>
  116.           <boolProp name="quotedData">false</boolProp>
  117.           <boolProp name="recycle">true</boolProp>
  118.           <boolProp name="stopThread">false</boolProp>
  119.           <stringProp name="shareMode">shareMode.all</stringProp>
  120.         </CSVDataSet>
  121.         <hashTree/>
  122.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="a773y4z7bgb50 data set" enabled="true">
  123.           <stringProp name="filename">a773y4z7bgb50.csv</stringProp>
  124.           <stringProp name="fileEncoding"></stringProp>
  125.           <stringProp name="variableNames">a773y4z7bgb50_class_uuid,a773y4z7bgb50_student_uuid</stringProp>
  126.           <stringProp name="delimiter">,</stringProp>
  127.           <boolProp name="quotedData">false</boolProp>
  128.           <boolProp name="recycle">true</boolProp>
  129.           <boolProp name="stopThread">false</boolProp>
  130.           <stringProp name="shareMode">shareMode.all</stringProp>
  131.         </CSVDataSet>
  132.         <hashTree/>
  133.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="3tmh3ps7nq592 data set" enabled="true">
  134.           <stringProp name="filename">3tmh3ps7nq592.csv</stringProp>
  135.           <stringProp name="fileEncoding"></stringProp>
  136.           <stringProp name="variableNames">3tmh3ps7nq592_owner_uuid,3tmh3ps7nq592_item_uuid</stringProp>
  137.           <stringProp name="delimiter">,</stringProp>
  138.           <boolProp name="quotedData">false</boolProp>
  139.           <boolProp name="recycle">true</boolProp>
  140.           <boolProp name="stopThread">false</boolProp>
  141.           <stringProp name="shareMode">shareMode.all</stringProp>
  142.         </CSVDataSet>
  143.         <hashTree/>
  144.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="c0vchfx3ya9u6 data set" enabled="true">
  145.           <stringProp name="filename">c0vchfx3ya9u6.csv</stringProp>
  146.           <stringProp name="fileEncoding"></stringProp>
  147.           <stringProp name="variableNames">c0vchfx3ya9u6_class_uuid</stringProp>
  148.           <stringProp name="delimiter">,</stringProp>
  149.           <boolProp name="quotedData">false</boolProp>
  150.           <boolProp name="recycle">true</boolProp>
  151.           <boolProp name="stopThread">false</boolProp>
  152.           <stringProp name="shareMode">shareMode.all</stringProp>
  153.         </CSVDataSet>
  154.         <hashTree/>
  155.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="cs06fsb03xtw6 data set" enabled="true">
  156.           <stringProp name="filename">ID_cs06fsb03xtw6.csv</stringProp>
  157.           <stringProp name="fileEncoding"></stringProp>
  158.           <stringProp name="variableNames">cs06fsb03xtw6_assignment_id,cs06fsb03xtw6_count</stringProp>
  159.           <stringProp name="delimiter">,</stringProp>
  160.           <boolProp name="quotedData">false</boolProp>
  161.           <boolProp name="recycle">true</boolProp>
  162.           <boolProp name="stopThread">false</boolProp>
  163.           <stringProp name="shareMode">shareMode.all</stringProp>
  164.         </CSVDataSet>
  165.         <hashTree/>
  166.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="2yumq8bw91vv4 data set" enabled="true">
  167.           <stringProp name="filename">ID_2yumq8bw91vv4.csv</stringProp>
  168.           <stringProp name="fileEncoding"></stringProp>
  169.           <stringProp name="variableNames">2yumq8bw91vv4_class_uuid,2yumq8bw91vv4_student_uuid,2yumq8bw91vv4_count</stringProp>
  170.           <stringProp name="delimiter">,</stringProp>
  171.           <boolProp name="quotedData">false</boolProp>
  172.           <boolProp name="recycle">true</boolProp>
  173.           <boolProp name="stopThread">false</boolProp>
  174.           <stringProp name="shareMode">shareMode.all</stringProp>
  175.         </CSVDataSet>
  176.         <hashTree/>
  177.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="773y4z7bgb50 data set" enabled="true">
  178.           <stringProp name="filename">ID_773y4z7bgb50.csv</stringProp>
  179.           <stringProp name="fileEncoding"></stringProp>
  180.           <stringProp name="variableNames">773y4z7bgb50_class_uuid,773y4z7bgb50_student_uuid,773y4z7bgb50_count</stringProp>
  181.           <stringProp name="delimiter">,</stringProp>
  182.           <boolProp name="quotedData">false</boolProp>
  183.           <boolProp name="recycle">true</boolProp>
  184.           <boolProp name="stopThread">false</boolProp>
  185.           <stringProp name="shareMode">shareMode.all</stringProp>
  186.         </CSVDataSet>
  187.         <hashTree/>
  188.         <CSVDataSet guiclass="TestBeanGUI" testclass="CSVDataSet" testname="fjrv8kpqqktkk data set" enabled="true">
  189.           <stringProp name="filename">ID_fjrv8kpqqktkk.csv</stringProp>
  190.           <stringProp name="fileEncoding"></stringProp>
  191.           <stringProp name="variableNames">fjrv8kpqqktkk_assignment_id,fjrv8kpqqktkk_count</stringProp>
  192.           <stringProp name="delimiter">,</stringProp>
  193.           <boolProp name="quotedData">false</boolProp>
  194.           <boolProp name="recycle">true</boolProp>
  195.           <boolProp name="stopThread">false</boolProp>
  196.           <stringProp name="shareMode">shareMode.all</stringProp>
  197.         </CSVDataSet>
  198.         <hashTree/>
  199.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="8nbv01j02u639" enabled="true">
  200.           <stringProp name="dataSource">realizeDBPool</stringProp>
  201.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  202.           <stringProp name="query">SELECT COUNT(*) JMETER_8nbv01j02u639 FROM ASA_USER_ASSIGNMENTS_EV U_A WHERE U_A.CLASS_UUID = ? AND U_A.ITEM_TYPE = &apos;TEST&apos; 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 &gt; SYSDATE-30 AND U_A_D.CREATED_DATE &lt; SYSDATE )</stringProp>
  203.           <stringProp name="queryArguments">${8nbv01j02u639_class_uuid}</stringProp>
  204.           <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
  205.           <stringProp name="variableNames"></stringProp>
  206.           <stringProp name="resultVariable"></stringProp>
  207.           <stringProp name="queryTimeout"></stringProp>
  208.           <stringProp name="resultSetHandler">Store as String</stringProp>
  209.         </JDBCSampler>
  210.         <hashTree/>
  211.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="2mrst3vrnsfwa" enabled="true">
  212.           <stringProp name="dataSource">realizeDBPool</stringProp>
  213.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  214.           <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
  215. </stringProp>
  216.           <stringProp name="queryArguments">${2mrst3vrnsfwa_class_uuid},${2mrst3vrnsfwa_student_uuid}</stringProp>
  217.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  218.           <stringProp name="variableNames"></stringProp>
  219.           <stringProp name="resultVariable"></stringProp>
  220.           <stringProp name="queryTimeout"></stringProp>
  221.           <stringProp name="resultSetHandler">Store as String</stringProp>
  222.         </JDBCSampler>
  223.         <hashTree/>
  224.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="71rt9n36fb9w6" enabled="true">
  225.           <stringProp name="dataSource">realizeDBPool</stringProp>
  226.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  227.           <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
  228. </stringProp>
  229.           <stringProp name="queryArguments">${71rt9n36fb9w6_class_uuid}</stringProp>
  230.           <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
  231.           <stringProp name="variableNames"></stringProp>
  232.           <stringProp name="resultVariable"></stringProp>
  233.           <stringProp name="queryTimeout"></stringProp>
  234.           <stringProp name="resultSetHandler">Store as String</stringProp>
  235.         </JDBCSampler>
  236.         <hashTree/>
  237.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="a5spx2rt3725d" enabled="true">
  238.           <stringProp name="dataSource">realizeDBPool</stringProp>
  239.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  240.           <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
  241. </stringProp>
  242.           <stringProp name="queryArguments">${a5spx2rt3725d_class_uuid},${a5spx2rt3725d_student_uuid}</stringProp>
  243.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  244.           <stringProp name="variableNames"></stringProp>
  245.           <stringProp name="resultVariable"></stringProp>
  246.           <stringProp name="queryTimeout"></stringProp>
  247.           <stringProp name="resultSetHandler">Store as String</stringProp>
  248.         </JDBCSampler>
  249.         <hashTree/>
  250.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="8x1pd8k9cmj79" enabled="true">
  251.           <stringProp name="dataSource">realizeDBPool</stringProp>
  252.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  253.           <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>
  254.           <stringProp name="queryArguments">${8x1pd8k9cmj79_student_uuid},${8x1pd8k9cmj79_item_uuid},${8x1pd8k9cmj79_item_version}</stringProp>
  255.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR,VARCHAR</stringProp>
  256.           <stringProp name="variableNames"></stringProp>
  257.           <stringProp name="resultVariable"></stringProp>
  258.           <stringProp name="queryTimeout"></stringProp>
  259.           <stringProp name="resultSetHandler">Store as String</stringProp>
  260.         </JDBCSampler>
  261.         <hashTree/>
  262.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="c8rfxarjgkwws" enabled="true">
  263.           <stringProp name="dataSource">realizeDBPool</stringProp>
  264.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  265.           <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 &apos;INACTIVE&apos; ELSE &apos;AVAILABLE&apos; 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
  266. </stringProp>
  267.           <stringProp name="queryArguments">${c8rfxarjgkwws_class_uuid}</stringProp>
  268.           <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
  269.           <stringProp name="variableNames"></stringProp>
  270.           <stringProp name="resultVariable"></stringProp>
  271.           <stringProp name="queryTimeout"></stringProp>
  272.           <stringProp name="resultSetHandler">Store as String</stringProp>
  273.         </JDBCSampler>
  274.         <hashTree/>
  275.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="dh7rcygd7hfra" enabled="true">
  276.           <stringProp name="dataSource">realizeDBPool</stringProp>
  277.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  278.           <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
  279. </stringProp>
  280.           <stringProp name="queryArguments">${dh7rcygd7hfra_class_uuid},${dh7rcygd7hfra_student_uuid}</stringProp>
  281.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  282.           <stringProp name="variableNames"></stringProp>
  283.           <stringProp name="resultVariable"></stringProp>
  284.           <stringProp name="queryTimeout"></stringProp>
  285.           <stringProp name="resultSetHandler">Store as String</stringProp>
  286.         </JDBCSampler>
  287.         <hashTree/>
  288.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="a773y4z7bgb50" enabled="true">
  289.           <stringProp name="dataSource">realizeDBPool</stringProp>
  290.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  291.           <stringProp name="query">SELECT DISTINCT EVENTS_ASA_EV.*, ASA_ASSIGNMENTS_EV.*, CASE WHEN ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID IS NOT NULL THEN &apos;INACTIVE&apos; ELSE &apos;AVAILABLE&apos; 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>
  292.           <stringProp name="queryArguments">${a773y4z7bgb50_class_uuid},${a773y4z7bgb50_student_uuid}</stringProp>
  293.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  294.           <stringProp name="variableNames"></stringProp>
  295.           <stringProp name="resultVariable"></stringProp>
  296.           <stringProp name="queryTimeout"></stringProp>
  297.           <stringProp name="resultSetHandler">Store as String</stringProp>
  298.         </JDBCSampler>
  299.         <hashTree/>
  300.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="3tmh3ps7nq592" enabled="true">
  301.           <stringProp name="dataSource">realizeDBPool</stringProp>
  302.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  303.           <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>
  304.           <stringProp name="queryArguments">${3tmh3ps7nq592_owner_uuid},${3tmh3ps7nq592_item_uuid}</stringProp>
  305.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  306.           <stringProp name="variableNames"></stringProp>
  307.           <stringProp name="resultVariable"></stringProp>
  308.           <stringProp name="queryTimeout"></stringProp>
  309.           <stringProp name="resultSetHandler">Store as String</stringProp>
  310.         </JDBCSampler>
  311.         <hashTree/>
  312.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="c0vchfx3ya9u6" enabled="true">
  313.           <stringProp name="dataSource">realizeDBPool</stringProp>
  314.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  315.           <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>
  316.           <stringProp name="queryArguments">${c0vchfx3ya9u6_class_uuid}</stringProp>
  317.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  318.           <stringProp name="variableNames"></stringProp>
  319.           <stringProp name="resultVariable"></stringProp>
  320.           <stringProp name="queryTimeout"></stringProp>
  321.           <stringProp name="resultSetHandler">Store as String</stringProp>
  322.         </JDBCSampler>
  323.         <hashTree/>
  324.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="cs06fsb03xtw6" enabled="true">
  325.           <stringProp name="dataSource">realizeDBPool</stringProp>
  326.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  327.           <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>
  328.           <stringProp name="queryArguments">${cs06fsb03xtw6_assignment_id}</stringProp>
  329.           <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
  330.           <stringProp name="variableNames"></stringProp>
  331.           <stringProp name="resultVariable"></stringProp>
  332.           <stringProp name="queryTimeout"></stringProp>
  333.           <stringProp name="resultSetHandler">Store as String</stringProp>
  334.         </JDBCSampler>
  335.         <hashTree/>
  336.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="2yumq8bw91vv4" enabled="true">
  337.           <stringProp name="dataSource">realizeDBPool</stringProp>
  338.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  339.           <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 &apos;INACTIVE&apos; else &apos;AVAILABLE&apos; end = &apos;AVAILABLE&apos; AND events_asa_ev.start_date &lt;= SYSDATE AND asa_user_assignments_ev.is_deleted = 0) r</stringProp>
  340.           <stringProp name="queryArguments">${2yumq8bw91vv4_class_uuid},${2yumq8bw91vv4_student_uuid}</stringProp>
  341.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  342.           <stringProp name="variableNames"></stringProp>
  343.           <stringProp name="resultVariable"></stringProp>
  344.           <stringProp name="queryTimeout"></stringProp>
  345.           <stringProp name="resultSetHandler">Store as String</stringProp>
  346.         </JDBCSampler>
  347.         <hashTree/>
  348.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="773y4z7bgb50" enabled="true">
  349.           <stringProp name="dataSource">realizeDBPool</stringProp>
  350.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  351.           <stringProp name="query">select distinct events_asa_ev.*, asa_assignments_ev.*, case when asa_hidden_assignments_ev.assignment_id is NOT NULL then &apos;INACTIVE&apos; else &apos;AVAILABLE&apos; 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
  352. </stringProp>
  353.           <stringProp name="queryArguments">${773y4z7bgb50_class_uuid},${773y4z7bgb50_student_uuid}</stringProp>
  354.           <stringProp name="queryArgumentsTypes">VARCHAR,VARCHAR</stringProp>
  355.           <stringProp name="variableNames"></stringProp>
  356.           <stringProp name="resultVariable"></stringProp>
  357.           <stringProp name="queryTimeout"></stringProp>
  358.           <stringProp name="resultSetHandler">Store as String</stringProp>
  359.         </JDBCSampler>
  360.         <hashTree/>
  361.         <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname="fjrv8kpqqktkk" enabled="true">
  362.           <stringProp name="dataSource">realizeDBPool</stringProp>
  363.           <stringProp name="queryType">Prepared Select Statement</stringProp>
  364.           <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
  365. </stringProp>
  366.           <stringProp name="queryArguments">${fjrv8kpqqktkk_assignment_id}</stringProp>
  367.           <stringProp name="queryArgumentsTypes">VARCHAR</stringProp>
  368.           <stringProp name="variableNames"></stringProp>
  369.           <stringProp name="resultVariable"></stringProp>
  370.           <stringProp name="queryTimeout"></stringProp>
  371.           <stringProp name="resultSetHandler">Store as String</stringProp>
  372.         </JDBCSampler>
  373.         <hashTree/>
  374.         <ResultCollector guiclass="ViewResultsFullVisualizer" testclass="ResultCollector" testname="View Results Tree" enabled="true">
  375.           <boolProp name="ResultCollector.error_logging">false</boolProp>
  376.           <objProp>
  377.             <name>saveConfig</name>
  378.             <value class="SampleSaveConfiguration">
  379.               <time>true</time>
  380.               <latency>true</latency>
  381.               <timestamp>true</timestamp>
  382.               <success>true</success>
  383.               <label>true</label>
  384.               <code>true</code>
  385.               <message>true</message>
  386.               <threadName>true</threadName>
  387.               <dataType>true</dataType>
  388.               <encoding>false</encoding>
  389.               <assertions>true</assertions>
  390.               <subresults>true</subresults>
  391.               <responseData>false</responseData>
  392.               <samplerData>false</samplerData>
  393.               <xml>false</xml>
  394.               <fieldNames>false</fieldNames>
  395.               <responseHeaders>false</responseHeaders>
  396.               <requestHeaders>false</requestHeaders>
  397.               <responseDataOnError>false</responseDataOnError>
  398.               <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
  399.               <assertionsResultsToSave>0</assertionsResultsToSave>
  400.               <bytes>true</bytes>
  401.               <threadCounts>true</threadCounts>
  402.             </value>
  403.           </objProp>
  404.           <stringProp name="filename">test.jtl</stringProp>
  405.         </ResultCollector>
  406.         <hashTree/>
  407.         <ResultCollector guiclass="StatVisualizer" testclass="ResultCollector" testname="Aggregate Report" enabled="true">
  408.           <boolProp name="ResultCollector.error_logging">false</boolProp>
  409.           <objProp>
  410.             <name>saveConfig</name>
  411.             <value class="SampleSaveConfiguration">
  412.               <time>true</time>
  413.               <latency>true</latency>
  414.               <timestamp>true</timestamp>
  415.               <success>true</success>
  416.               <label>true</label>
  417.               <code>true</code>
  418.               <message>true</message>
  419.               <threadName>true</threadName>
  420.               <dataType>true</dataType>
  421.               <encoding>false</encoding>
  422.               <assertions>true</assertions>
  423.               <subresults>true</subresults>
  424.               <responseData>false</responseData>
  425.               <samplerData>false</samplerData>
  426.               <xml>false</xml>
  427.               <fieldNames>false</fieldNames>
  428.               <responseHeaders>false</responseHeaders>
  429.               <requestHeaders>false</requestHeaders>
  430.               <responseDataOnError>false</responseDataOnError>
  431.               <saveAssertionResultsFailureMessage>false</saveAssertionResultsFailureMessage>
  432.               <assertionsResultsToSave>0</assertionsResultsToSave>
  433.               <bytes>true</bytes>
  434.               <threadCounts>true</threadCounts>
  435.             </value>
  436.           </objProp>
  437.           <stringProp name="filename"></stringProp>
  438.         </ResultCollector>
  439.         <hashTree/>
  440.       </hashTree>
  441.     </hashTree>
  442.   </hashTree>
  443. </jmeterTestPlan>