Newer
Older
sqlmarker / UsedCars / Test_classes / Sales / UsedCars_Fixture_Sales.xml.in
<dataset>
  <table name="staff">
    <column>staff_id</column>
    <column>firstname</column>
    <column>lastname</column>
    <column>address</column>
    <column>phone</column>
    <column>date_hired</column>
    <column>date_of_birth</column>
    <row>
      <value>4567</value>
      <value>Sang</value>
      <value>Dyson</value>
      <value>74 Patmos Avenue</value>
      <value>02139414116</value>
      <value>05-DEC-2008</value>
      <value>17-JUN-1979</value>
    </row>
    <row>
      <value>4569</value>
      <value>Patricia</value>
      <value>Kwak</value>
      <value>28 Cherry Drive</value>
      <value>02137254888</value>
      <value>23-APR-2012</value>
      <value>08-AUG-1967</value>
    </row>
    <row>
      <value>4568</value>
      <value>Teresa</value>
      <value>Soto</value>
      <value>21 Elwyn Crescent</value>
      <value>02737076169</value>
      <value>04-APR-2005</value>
      <value>25-DEC-1986</value>
    </row>
    <row>
      <value>4570</value>
      <value>John</value>
      <value>Reed</value>
      <value>45 Pine Hill Road</value>
      <value>02136507402</value>
      <value>13-AUG-2013</value>
      <value>21-MAY-1985</value>
    </row>
    <row>
      <value>4571</value>
      <value>Charles</value>
      <value>Barajas</value>
      <value>34 Scobie Road</value>
      <value>02232104933</value>
      <value>09-NOV-2001</value>
      <value>15-SEP-1964</value>
    </row>
  </table>
  <table name="sales">
    <column>staff_id</column>
    <column>on_commission</column>
    <column>commission_rate</column>
    <column>gross_earnings</column>
    <row>
      <value>4567</value>
      <value>##TRUE_VALUE##</value>
      <value>0.15</value>
      <value>12345.67</value>
    </row>
    <row>
      <value>4569</value>
      <value>##FALSE_VALUE##</value>
      <value>0</value>
      <value>12345.67</value>
    </row>
  </table>
</dataset>