libgda r3191 - trunk/tests/data-models

[vivien svn gnome org]

Author: vivien
Date: Fri Aug 15 20:07:29 2008
New Revision: 3191
URL: http://svn.gnome.org/viewvc/libgda?rev=3191&view=rev

Log:
Added forgotten files

Added:
   trunk/tests/data-models/pmodel_data_customers.xml
   trunk/tests/data-models/pmodel_data_locations.xml
   trunk/tests/data-models/pmodel_dbstruct.xml

Added: trunk/tests/data-models/pmodel_data_customers.xml
==============================================================================
--- (empty file)
+++ trunk/tests/data-models/pmodel_data_customers.xml	Fri Aug 15 20:07:29 2008
@@ -0,0 +1,45 @@
+<?xml version="1.0"?>
+<gda_array id="EXPORT" name="Exported Data">
+  <gda_array_field id="FI0" name="id" title="id" gdatype="gint" size="-1" scale="-1" pkey="TRUE" unique="TRUE"/>
+  <gda_array_field id="FI1" name="name" title="name" gdatype="gchararray" size="-1" scale="-1"/>
+  <gda_array_field id="FI2" name="default_served_by" title="default_served_by" gdatype="gint" size="-1" scale="-1" nullok="TRUE"/>
+  <gda_array_field id="FI3" name="country" title="country" gdatype="gchararray" size="-1" scale="-1" nullok="TRUE"/>
+  <gda_array_field id="FI4" name="city" title="city" gdatype="gchararray" size="-1" scale="-1" nullok="TRUE"/>
+  <gda_array_data>
+    <gda_array_row>
+      <gda_value>2</gda_value>
+      <gda_value>Ed Lamton</gda_value>
+      <gda_value>4</gda_value>
+      <gda_value>SP</gda_value>
+      <gda_value>MDR</gda_value>
+    </gda_array_row>
+    <gda_array_row>
+      <gda_value>3</gda_value>
+      <gda_value>Lew Bonito</gda_value>
+      <gda_value>1</gda_value>
+      <gda_value>FR</gda_value>
+      <gda_value>TLS</gda_value>
+    </gda_array_row>
+    <gda_array_row>
+      <gda_value>4</gda_value>
+      <gda_value>Mark Lawrencep</gda_value>
+      <gda_value isnull="t"/>
+      <gda_value>SP</gda_value>
+      <gda_value>MDR</gda_value>
+    </gda_array_row>
+    <gda_array_row>
+      <gda_value>9</gda_value>
+      <gda_value>Greg Popoff</gda_value>
+      <gda_value>2</gda_value>
+      <gda_value>SP</gda_value>
+      <gda_value>MDR</gda_value>
+    </gda_array_row>
+    <gda_array_row>
+      <gda_value>10</gda_value>
+      <gda_value>Vladimir Zirkov</gda_value>
+      <gda_value>4</gda_value>
+      <gda_value isnull="t"/>
+      <gda_value isnull="t"/>
+    </gda_array_row>
+  </gda_array_data>
+</gda_array>

Added: trunk/tests/data-models/pmodel_data_locations.xml
==============================================================================
--- (empty file)
+++ trunk/tests/data-models/pmodel_data_locations.xml	Fri Aug 15 20:07:29 2008
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<gda_array id="EXPORT" name="Exported Data">
+  <gda_array_field id="FI0" name="country" title="country" gdatype="gchararray" size="-1" scale="-1" pkey="TRUE" unique="TRUE"/>
+  <gda_array_field id="FI1" name="city" title="city" gdatype="gchararray" size="-1" scale="-1" pkey="TRUE" unique="TRUE"/>
+  <gda_array_field id="FI2" name="shortcut" title="shortcut" gdatype="gchararray" size="-1" scale="-1"/>
+  <gda_array_data>
+    <gda_array_row>
+      <gda_value>FR</gda_value>
+      <gda_value>TLS</gda_value>
+      <gda_value>Toulouse, France</gda_value>
+    </gda_array_row>
+    <gda_array_row>
+      <gda_value>SP</gda_value>
+      <gda_value>MDR</gda_value>
+      <gda_value>Madrid, Spain</gda_value>
+    </gda_array_row>
+  </gda_array_data>
+</gda_array>

Added: trunk/tests/data-models/pmodel_dbstruct.xml
==============================================================================
--- (empty file)
+++ trunk/tests/data-models/pmodel_dbstruct.xml	Fri Aug 15 20:07:29 2008
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+   Tests databases schema
+  -->
+
+
+<schema>
+  <!-- provider specific information 
+       use <replace> to replace something with something else (context can only be "/FIELDS_A/@COLUMN_TYPE" at the moment)
+       use <ignore> to ignore some parts (context can only be "/FKEY_S" or "/FIELDS_A/@COLUMN_PKEY" at the moment)
+       use <symbol> to define a symbolic value
+    -->
+  <specifics>
+    <provider name="PostgreSQL">
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="varchar"/>
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
+      <symbol name="now">now()</symbol>
+    </provider>
+
+    <provider name="MySQL">
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="string" replace_with="text"/>
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
+      <ignore context="/FKEY_S"/>
+      <ignore context="/FIELDS_A/@COLUMN_PKEY"/>
+      <symbol name="now">CURRENT_TIMESTAMP</symbol>
+    </provider>
+
+    <provider name="SQLite">
+      <replace context="/FIELDS_A/@COLUMN_TYPE" expr="gint" replace_with="int"/>
+      <symbol name="now">CURRENT_TIMESTAMP</symbol>
+    </provider>
+  </specifics>
+
+  <!-- customers table -->
+  <table name="customers">
+    <column name="id" type="gint" pkey="TRUE" autoinc="TRUE"/>
+    <column name="name"/>
+    <column name="default_served_by" type="gint" nullok="TRUE"/>
+    <column name="country" nullok="TRUE"/>
+    <column name="city" nullok="TRUE"/>
+    <fkey ref_table="locations">
+      <part column="country"/>
+      <part column="city"/>
+    </fkey>
+  </table>
+  
+  <table name="locations">
+    <column name="country" pkey="TRUE"/>
+    <column name="city" pkey="TRUE"/>
+    <column name="shortcut"/>
+  </table>
+</schema>