Newer
Older
sqlmarker / STINK_student_records / Test_classes / Result / STINK_student_records_Fixture_Result.xml.in
<dataset>
  <table name="person">
    <column>person_id</column>
    <column>surname</column>
    <column>other_names</column>
    <column>contact_phone</column>
    <column>contact_address</column>
    <column>email</column>
    <column>username</column>
    <row>
      <value>1234567</value>
      <value>Dyson</value>
      <value>Sang Russell</value>
      <value>02139414116</value>
      <value>74 Patmos Avenue</value>
      <value>sang.dyson@stink.ac.nz</value>
      <value>dyssa123</value>
    </row>
    <row>
      <value>1234569</value>
      <value>Kwak</value>
      <value>Patricia Helen</value>
      <value>02137254888</value>
      <value>28 Cherry Drive</value>
      <value>pat.kwak@stink.ac.nz</value>
      <value>kwapa999</value>
    </row>
    <row>
      <value>1234568</value>
      <value>Soto</value>
      <value>Teresa Stephanie</value>
      <value>02737076169</value>
      <value>21 Elwyn Crescent</value>
      <value>sotte123@stink.ac.nz</value>
      <value>sotte123</value>
    </row>
    <row>
      <value>1234570</value>
      <value>Reed</value>
      <value>John Clifford</value>
      <value>02136507402</value>
      <value>45 Pine Hill Road</value>
      <value>reejo282@stink.ac.nz</value>
      <value>reejo282</value>
    </row>
    <row>
      <value>1234571</value>
      <value>Barajas</value>
      <value>Charles William</value>
      <value>02232104933</value>
      <value>34 Scobie Road</value>
      <value>barch087@stink.ac.nz</value>
      <value>barch087</value>
    </row>
  </table>
  <table name="student">
    <column>student_id</column>
    <column>home_phone</column>
    <column>home_address</column>
    <column>international</column>
    <column>supervisor_id</column>
    <row>
      <value>1234568</value>
      <value>+16461234567</value>
      <value>Los Angeles</value>
      <value>##TRUE_VALUE##</value>
      <value />
    </row>
    <row>
      <value>1234570</value>
      <value>02136507402</value>
      <value>45 Pine Hill Road</value>
      <value>##FALSE_VALUE##</value>
      <value />
    </row>
    <row>
      <value>1234571</value>
      <value>02232104933</value>
      <value>34 Scobie Road</value>
      <value>##FALSE_VALUE##</value>
      <value />
    </row>
  </table>
  <table name="paper">
    <column>paper_code</column>
    <column>title</column>
    <column>description</column>
    <column>points</column>
    <column>period</column>
    <row>
      <value>ACCT112</value>
      <value>Introduction to Accounting</value>
      <value>A whole lotta text going on.</value>
      <value>18</value>
      <value>S1</value>
    </row>
    <row>
      <value>BSNS106</value>
      <value>Information and Communication in Organisations</value>
      <value>A whole lotta text going on.</value>
      <value>18</value>
      <value>S1</value>
    </row>
    <row>
      <value>COMP160</value>
      <value>General Programming</value>
      <value>A whole lotta text going on.</value>
      <value>18</value>
      <value>SS</value>
    </row>
    <row>
      <value>INFO214</value>
      <value>Business ICT Infrstructure</value>
      <value>A whole lotta text going on.</value>
      <value>18</value>
      <value>S2</value>
    </row>
    <row>
      <value>INFO321</value>
      <value>Enterprise Data Management</value>
      <value>A whole lotta text going on.</value>
      <value>18</value>
      <value>S2</value>
    </row>
  </table>
  <table name="assessment">
    <column>assessment_id</column>
    <column>assessment_year</column>
    <column>name</column>
    <column>description</column>
    <column>type</column>
    <column>release</column>
    <column>weight</column>
    <column>maximum_mark</column>
    <column>paper_code</column>
    <row>
      <value>1234567890</value>
      <value>2012</value>
      <value>Assignment 1</value>
      <value>Database Implementation</value>
      <value>A</value>
      <value>##FALSE_VALUE##</value>
      <value>10</value>
      <value>100</value>
      <value>INFO214</value>
    </row>
    <row>
      <value>1234567891</value>
      <value>2012</value>
      <value>Practical Test</value>
      <value>A nasty, nasty test.</value>
      <value>T</value>
      <value>##FALSE_VALUE##</value>
      <value>10</value>
      <value>100</value>
      <value>INFO214</value>
    </row>
    <row>
      <value>1234567892</value>
      <value>2012</value>
      <value>Final Examination</value>
      <value>Ooh, scary...</value>
      <value>X</value>
      <value>##TRUE_VALUE##</value>
      <value>50</value>
      <value>100</value>
      <value>INFO321</value>
    </row>
  </table>
  <table name="enrolment">
    <column>enrolment_id</column>
    <column>description</column>
    <column>year_enrolled</column>
    <column>comments</column>
    <column>student_id</column>
    <column>paper_code</column>
    <row>
      <value>1234567890</value>
      <value>Some random description.</value>
      <value>2012</value>
      <value />
      <value>1234568</value>
      <value>INFO214</value>
    </row>
    <row>
      <value>1234567891</value>
      <value>Some random description.</value>
      <value>2012</value>
      <value />
      <value>1234570</value>
      <value>INFO214</value>
    </row>
    <row>
      <value>1234567892</value>
      <value>Some random description.</value>
      <value>2012</value>
      <value />
      <value>1234571</value>
      <value>INFO214</value>
    </row>
    <row>
      <value>1234567893</value>
      <value>Some random description.</value>
      <value>2013</value>
      <value />
      <value>1234570</value>
      <value>INFO321</value>
    </row>
    <row>
      <value>1234567894</value>
      <value>Some random description.</value>
      <value>2012</value>
      <value />
      <value>1234571</value>
      <value>INFO321</value>
    </row>
  </table>
  <table name="result">
    <column>assessment_id</column>
    <column>enrolment_id</column>
    <column>raw_mark</column>
    <column>weighted_mark</column>
    <column>percentage_mark</column>
    <row>
      <value>1234567890</value>
      <value>1234567890</value>
      <value>50</value>
      <value>5</value>
      <value>50</value>
    </row>
    <row>
      <value>1234567890</value>
      <value>1234567891</value>
      <value>67</value>
      <value>6.7</value>
      <value>67</value>
    </row>
    <row>
      <value>1234567892</value>
      <value>1234567894</value>
      <value>83</value>
      <value>41.5</value>
      <value>83</value>
    </row>
  </table>
</dataset>