[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue] r6902 - in trunk/gnue-appserver/samples/testing: . joins
|
From: |
johannes |
|
Subject: |
[gnue] r6902 - in trunk/gnue-appserver/samples/testing: . joins |
|
Date: |
Fri, 14 Jan 2005 02:37:56 -0600 (CST) |
Author: johannes
Date: 2005-01-14 02:37:55 -0600 (Fri, 14 Jan 2005)
New Revision: 6902
Added:
trunk/gnue-appserver/samples/testing/joins/
trunk/gnue-appserver/samples/testing/joins/joins.py
trunk/gnue-appserver/samples/testing/joins/sample.gsd
trunk/gnue-appserver/samples/testing/joins/struct.gcd
trunk/gnue-appserver/samples/testing/joins/struct.gld
Log:
Added testcase for joins
Property changes on: trunk/gnue-appserver/samples/testing/joins
___________________________________________________________________
Name: svn:ignore
+ *.pyc
Added: trunk/gnue-appserver/samples/testing/joins/joins.py
===================================================================
--- trunk/gnue-appserver/samples/testing/joins/joins.py 2005-01-14 08:34:49 UTC
(rev 6901)
+++ trunk/gnue-appserver/samples/testing/joins/joins.py 2005-01-14 08:37:55 UTC
(rev 6902)
@@ -0,0 +1,66 @@
+# GNU Enterprise Application Server - Testing unit - Joins
+#
+# Copyright 2003-2004 Free Software Foundation
+#
+# This file is part of GNU Enterprise.
+#
+# GNU Enterprise is free software; you can redistribute it
+# and/or modify it under the terms of the GNU General Public
+# License as published by the Free Software Foundation; either
+# version 2, or (at your option) any later version.
+#
+# GNU Enterprise is distributed in the hope that it will be
+# useful, but WITHOUT ANY WARRANTY; without even the implied
+# warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR
+# PURPOSE. See the GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public
+# License along with program; see the file COPYING. If not,
+# write to the Free Software Foundation, Inc., 59 Temple Place
+# - Suite 330, Boston, MA 02111-1307, USA.
+#
+# $Id$
+
+import sys
+from gnue.appserver.language import App
+
+
+if __name__ == "__main__":
+ app = App.App ()
+
+ print "Requesting new session ..."
+ session = app.newSession ('test', 'test')
+
+ session.setcontext ('test')
+
+ print "Checking customers ..."
+ customers = session.find ('customer', [], [],
+ ['test_name', 'test_country.address_name'])
+
+ for guy in customers:
+ print "Guy:", guy.name, guy.country.address_name
+
+ print "Invoices ..."
+
+ invoices = session.find ('invoice', [], [],
+ ['test_number', 'test_customer.test_name',
+ 'test_customer.test_country.address_name'])
+
+ for inv in invoices:
+ print "-" * 70
+ print "Invoice :", inv.number
+ print " Customer:", inv.customer.name
+ print " Country :", inv.customer.country.address_name
+
+ print "=" * 70
+ print "line items ..."
+ items = session.find ('lineitem', [], [],
+ ['test_invoice.test_number', 'test_position',
+ 'test_item.test_description',
+ 'test_item.test_group.test_name'])
+
+ for line in items:
+ print "Invoice : %10s / %s" % (line.invoice.number, line.position)
+ print " Item :", line.item.description
+ print " Group:", line.item.group.name
+
Property changes on: trunk/gnue-appserver/samples/testing/joins/joins.py
___________________________________________________________________
Name: svn:keywords
+ Id
Added: trunk/gnue-appserver/samples/testing/joins/sample.gsd
===================================================================
--- trunk/gnue-appserver/samples/testing/joins/sample.gsd 2005-01-14
08:34:49 UTC (rev 6901)
+++ trunk/gnue-appserver/samples/testing/joins/sample.gsd 2005-01-14
08:37:55 UTC (rev 6902)
@@ -0,0 +1,1560 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<schema author="gnue-gsdgen" title="Appserver Data Dump" version="1.0">
+ <data>
+ <tabledata name="test_itemgroup_dump" tablename="test_itemgroup">
+ <definition>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ <column field="test_code" type="string(8)"/>
+ <column field="test_name" type="string(35)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:41:20.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">61734295048615410439014217213588</value>
+ <value field="gnue_modifydate">2005-01-13 16:41:45.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">100</value>
+ <value field="test_name">TV Sets</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:41:28.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">92809220132957835061992065715886</value>
+ <value field="gnue_modifydate">2005-01-13 16:41:45.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">110</value>
+ <value field="test_name">Trash</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:41:37.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">12128762210949564941053942227249</value>
+ <value field="gnue_modifydate">2005-01-13 16:41:45.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">120</value>
+ <value field="test_name">Great Stuff</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="address_country_dump" tablename="address_country">
+ <definition>
+ <column field="address_code" type="string(8)"/>
+ <column field="address_name" type="string(35)"/>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="address_code">AF</value>
+ <value field="address_name">Afghanistan</value>
+ <value field="gnue_id">00000000000000000000002000000001</value>
+ </row>
+ <row>
+ <value field="address_code">AX</value>
+ <value field="address_name">Aland Islands</value>
+ <value field="gnue_id">00000000000000000000002000000002</value>
+ </row>
+ <row>
+ <value field="address_code">AL</value>
+ <value field="address_name">Albania</value>
+ <value field="gnue_id">00000000000000000000002000000003</value>
+ </row>
+ <row>
+ <value field="address_code">DZ</value>
+ <value field="address_name">Algeria</value>
+ <value field="gnue_id">00000000000000000000002000000004</value>
+ </row>
+ <row>
+ <value field="address_code">AS</value>
+ <value field="address_name">American Samoa</value>
+ <value field="gnue_id">00000000000000000000002000000005</value>
+ </row>
+ <row>
+ <value field="address_code">AD</value>
+ <value field="address_name">Andorra</value>
+ <value field="gnue_id">00000000000000000000002000000006</value>
+ </row>
+ <row>
+ <value field="address_code">AO</value>
+ <value field="address_name">Angola</value>
+ <value field="gnue_id">00000000000000000000002000000007</value>
+ </row>
+ <row>
+ <value field="address_code">AI</value>
+ <value field="address_name">Anguilla</value>
+ <value field="gnue_id">00000000000000000000002000000008</value>
+ </row>
+ <row>
+ <value field="address_code">AQ</value>
+ <value field="address_name">Antarctica</value>
+ <value field="gnue_id">00000000000000000000002000000009</value>
+ </row>
+ <row>
+ <value field="address_code">AG</value>
+ <value field="address_name">Antigua And Barbuda</value>
+ <value field="gnue_id">0000000000000000000000200000000A</value>
+ </row>
+ <row>
+ <value field="address_code">AR</value>
+ <value field="address_name">Argentina</value>
+ <value field="gnue_id">0000000000000000000000200000000B</value>
+ </row>
+ <row>
+ <value field="address_code">AM</value>
+ <value field="address_name">Armenia</value>
+ <value field="gnue_id">0000000000000000000000200000000C</value>
+ </row>
+ <row>
+ <value field="address_code">AW</value>
+ <value field="address_name">Aruba</value>
+ <value field="gnue_id">0000000000000000000000200000000D</value>
+ </row>
+ <row>
+ <value field="address_code">AU</value>
+ <value field="address_name">Australia</value>
+ <value field="gnue_id">0000000000000000000000200000000E</value>
+ </row>
+ <row>
+ <value field="address_code">AT</value>
+ <value field="address_name">Austria</value>
+ <value field="gnue_id">0000000000000000000000200000000F</value>
+ </row>
+ <row>
+ <value field="address_code">AZ</value>
+ <value field="address_name">Azerbaijan</value>
+ <value field="gnue_id">00000000000000000000002000000010</value>
+ </row>
+ <row>
+ <value field="address_code">BS</value>
+ <value field="address_name">Bahamas</value>
+ <value field="gnue_id">00000000000000000000002000000011</value>
+ </row>
+ <row>
+ <value field="address_code">BH</value>
+ <value field="address_name">Bahrain</value>
+ <value field="gnue_id">00000000000000000000002000000012</value>
+ </row>
+ <row>
+ <value field="address_code">BD</value>
+ <value field="address_name">Bangladesh</value>
+ <value field="gnue_id">00000000000000000000002000000013</value>
+ </row>
+ <row>
+ <value field="address_code">BB</value>
+ <value field="address_name">Barbados</value>
+ <value field="gnue_id">00000000000000000000002000000014</value>
+ </row>
+ <row>
+ <value field="address_code">BY</value>
+ <value field="address_name">Belarus</value>
+ <value field="gnue_id">00000000000000000000002000000015</value>
+ </row>
+ <row>
+ <value field="address_code">BE</value>
+ <value field="address_name">Belgium</value>
+ <value field="gnue_id">00000000000000000000002000000016</value>
+ </row>
+ <row>
+ <value field="address_code">BZ</value>
+ <value field="address_name">Belize</value>
+ <value field="gnue_id">00000000000000000000002000000017</value>
+ </row>
+ <row>
+ <value field="address_code">BJ</value>
+ <value field="address_name">Benin</value>
+ <value field="gnue_id">00000000000000000000002000000018</value>
+ </row>
+ <row>
+ <value field="address_code">BM</value>
+ <value field="address_name">Bermuda</value>
+ <value field="gnue_id">00000000000000000000002000000019</value>
+ </row>
+ <row>
+ <value field="address_code">BT</value>
+ <value field="address_name">Bhutan</value>
+ <value field="gnue_id">0000000000000000000000200000001A</value>
+ </row>
+ <row>
+ <value field="address_code">BO</value>
+ <value field="address_name">Bolivia</value>
+ <value field="gnue_id">0000000000000000000000200000001B</value>
+ </row>
+ <row>
+ <value field="address_code">BA</value>
+ <value field="address_name">Bosnia And Herzegovina</value>
+ <value field="gnue_id">0000000000000000000000200000001C</value>
+ </row>
+ <row>
+ <value field="address_code">BW</value>
+ <value field="address_name">Botswana</value>
+ <value field="gnue_id">0000000000000000000000200000001D</value>
+ </row>
+ <row>
+ <value field="address_code">BV</value>
+ <value field="address_name">Bouvet Island</value>
+ <value field="gnue_id">0000000000000000000000200000001E</value>
+ </row>
+ <row>
+ <value field="address_code">BR</value>
+ <value field="address_name">Brazil</value>
+ <value field="gnue_id">0000000000000000000000200000001F</value>
+ </row>
+ <row>
+ <value field="address_code">IO</value>
+ <value field="address_name">British Indian Ocean Territory</value>
+ <value field="gnue_id">00000000000000000000002000000020</value>
+ </row>
+ <row>
+ <value field="address_code">BN</value>
+ <value field="address_name">Brunei Darussalam</value>
+ <value field="gnue_id">00000000000000000000002000000021</value>
+ </row>
+ <row>
+ <value field="address_code">BG</value>
+ <value field="address_name">Bulgaria</value>
+ <value field="gnue_id">00000000000000000000002000000022</value>
+ </row>
+ <row>
+ <value field="address_code">BF</value>
+ <value field="address_name">Burkina Faso</value>
+ <value field="gnue_id">00000000000000000000002000000023</value>
+ </row>
+ <row>
+ <value field="address_code">BI</value>
+ <value field="address_name">Burundi</value>
+ <value field="gnue_id">00000000000000000000002000000024</value>
+ </row>
+ <row>
+ <value field="address_code">KH</value>
+ <value field="address_name">Cambodia</value>
+ <value field="gnue_id">00000000000000000000002000000025</value>
+ </row>
+ <row>
+ <value field="address_code">CM</value>
+ <value field="address_name">Cameroon</value>
+ <value field="gnue_id">00000000000000000000002000000026</value>
+ </row>
+ <row>
+ <value field="address_code">CA</value>
+ <value field="address_name">Canada</value>
+ <value field="gnue_id">00000000000000000000002000000027</value>
+ </row>
+ <row>
+ <value field="address_code">CV</value>
+ <value field="address_name">Cape Verde</value>
+ <value field="gnue_id">00000000000000000000002000000028</value>
+ </row>
+ <row>
+ <value field="address_code">KY</value>
+ <value field="address_name">Cayman Islands</value>
+ <value field="gnue_id">00000000000000000000002000000029</value>
+ </row>
+ <row>
+ <value field="address_code">CF</value>
+ <value field="address_name">Central African Republic</value>
+ <value field="gnue_id">0000000000000000000000200000002A</value>
+ </row>
+ <row>
+ <value field="address_code">TD</value>
+ <value field="address_name">Chad</value>
+ <value field="gnue_id">0000000000000000000000200000002B</value>
+ </row>
+ <row>
+ <value field="address_code">CL</value>
+ <value field="address_name">Chile</value>
+ <value field="gnue_id">0000000000000000000000200000002C</value>
+ </row>
+ <row>
+ <value field="address_code">CN</value>
+ <value field="address_name">China</value>
+ <value field="gnue_id">0000000000000000000000200000002D</value>
+ </row>
+ <row>
+ <value field="address_code">CX</value>
+ <value field="address_name">Christmas Island</value>
+ <value field="gnue_id">0000000000000000000000200000002E</value>
+ </row>
+ <row>
+ <value field="address_code">CC</value>
+ <value field="address_name">Cocos (Keeling) Islands</value>
+ <value field="gnue_id">0000000000000000000000200000002F</value>
+ </row>
+ <row>
+ <value field="address_code">CO</value>
+ <value field="address_name">Colombia</value>
+ <value field="gnue_id">00000000000000000000002000000030</value>
+ </row>
+ <row>
+ <value field="address_code">KM</value>
+ <value field="address_name">Comoros</value>
+ <value field="gnue_id">00000000000000000000002000000031</value>
+ </row>
+ <row>
+ <value field="address_code">CG</value>
+ <value field="address_name">Congo</value>
+ <value field="gnue_id">00000000000000000000002000000032</value>
+ </row>
+ <row>
+ <value field="address_code">CD</value>
+ <value field="address_name">Congo, The Democratic Republic Of
T</value>
+ <value field="gnue_id">00000000000000000000002000000033</value>
+ </row>
+ <row>
+ <value field="address_code">CK</value>
+ <value field="address_name">Cook Islands</value>
+ <value field="gnue_id">00000000000000000000002000000034</value>
+ </row>
+ <row>
+ <value field="address_code">CR</value>
+ <value field="address_name">Costa Rica</value>
+ <value field="gnue_id">00000000000000000000002000000035</value>
+ </row>
+ <row>
+ <value field="address_code">CI</value>
+ <value field="address_name">Cote D'Ivoire</value>
+ <value field="gnue_id">00000000000000000000002000000036</value>
+ </row>
+ <row>
+ <value field="address_code">HR</value>
+ <value field="address_name">Croatia</value>
+ <value field="gnue_id">00000000000000000000002000000037</value>
+ </row>
+ <row>
+ <value field="address_code">CU</value>
+ <value field="address_name">Cuba</value>
+ <value field="gnue_id">00000000000000000000002000000038</value>
+ </row>
+ <row>
+ <value field="address_code">CY</value>
+ <value field="address_name">Cyprus</value>
+ <value field="gnue_id">00000000000000000000002000000039</value>
+ </row>
+ <row>
+ <value field="address_code">CZ</value>
+ <value field="address_name">Czech Republic</value>
+ <value field="gnue_id">0000000000000000000000200000003A</value>
+ </row>
+ <row>
+ <value field="address_code">DK</value>
+ <value field="address_name">Denmark</value>
+ <value field="gnue_id">0000000000000000000000200000003B</value>
+ </row>
+ <row>
+ <value field="address_code">DJ</value>
+ <value field="address_name">Djibouti</value>
+ <value field="gnue_id">0000000000000000000000200000003C</value>
+ </row>
+ <row>
+ <value field="address_code">DM</value>
+ <value field="address_name">Dominica</value>
+ <value field="gnue_id">0000000000000000000000200000003D</value>
+ </row>
+ <row>
+ <value field="address_code">DO</value>
+ <value field="address_name">Dominican Republic</value>
+ <value field="gnue_id">0000000000000000000000200000003E</value>
+ </row>
+ <row>
+ <value field="address_code">EC</value>
+ <value field="address_name">Ecuador</value>
+ <value field="gnue_id">0000000000000000000000200000003F</value>
+ </row>
+ <row>
+ <value field="address_code">EG</value>
+ <value field="address_name">Egypt</value>
+ <value field="gnue_id">00000000000000000000002000000040</value>
+ </row>
+ <row>
+ <value field="address_code">SV</value>
+ <value field="address_name">El Salvador</value>
+ <value field="gnue_id">00000000000000000000002000000041</value>
+ </row>
+ <row>
+ <value field="address_code">GQ</value>
+ <value field="address_name">Equatorial Guinea</value>
+ <value field="gnue_id">00000000000000000000002000000042</value>
+ </row>
+ <row>
+ <value field="address_code">ER</value>
+ <value field="address_name">Eritrea</value>
+ <value field="gnue_id">00000000000000000000002000000043</value>
+ </row>
+ <row>
+ <value field="address_code">EE</value>
+ <value field="address_name">Estonia</value>
+ <value field="gnue_id">00000000000000000000002000000044</value>
+ </row>
+ <row>
+ <value field="address_code">ET</value>
+ <value field="address_name">Ethiopia</value>
+ <value field="gnue_id">00000000000000000000002000000045</value>
+ </row>
+ <row>
+ <value field="address_code">FK</value>
+ <value field="address_name">Falkland Islands (Malvinas)</value>
+ <value field="gnue_id">00000000000000000000002000000046</value>
+ </row>
+ <row>
+ <value field="address_code">FO</value>
+ <value field="address_name">Faroe Islands</value>
+ <value field="gnue_id">00000000000000000000002000000047</value>
+ </row>
+ <row>
+ <value field="address_code">FJ</value>
+ <value field="address_name">Fiji</value>
+ <value field="gnue_id">00000000000000000000002000000048</value>
+ </row>
+ <row>
+ <value field="address_code">FI</value>
+ <value field="address_name">Finland</value>
+ <value field="gnue_id">00000000000000000000002000000049</value>
+ </row>
+ <row>
+ <value field="address_code">FR</value>
+ <value field="address_name">France</value>
+ <value field="gnue_id">0000000000000000000000200000004A</value>
+ </row>
+ <row>
+ <value field="address_code">GF</value>
+ <value field="address_name">French Guiana</value>
+ <value field="gnue_id">0000000000000000000000200000004B</value>
+ </row>
+ <row>
+ <value field="address_code">PF</value>
+ <value field="address_name">French Polynesia</value>
+ <value field="gnue_id">0000000000000000000000200000004C</value>
+ </row>
+ <row>
+ <value field="address_code">TF</value>
+ <value field="address_name">French Southern Territories</value>
+ <value field="gnue_id">0000000000000000000000200000004D</value>
+ </row>
+ <row>
+ <value field="address_code">GA</value>
+ <value field="address_name">Gabon</value>
+ <value field="gnue_id">0000000000000000000000200000004E</value>
+ </row>
+ <row>
+ <value field="address_code">GM</value>
+ <value field="address_name">Gambia</value>
+ <value field="gnue_id">0000000000000000000000200000004F</value>
+ </row>
+ <row>
+ <value field="address_code">GE</value>
+ <value field="address_name">Georgia</value>
+ <value field="gnue_id">00000000000000000000002000000050</value>
+ </row>
+ <row>
+ <value field="address_code">DE</value>
+ <value field="address_name">Germany</value>
+ <value field="gnue_id">00000000000000000000002000000051</value>
+ </row>
+ <row>
+ <value field="address_code">GH</value>
+ <value field="address_name">Ghana</value>
+ <value field="gnue_id">00000000000000000000002000000052</value>
+ </row>
+ <row>
+ <value field="address_code">GI</value>
+ <value field="address_name">Gibraltar</value>
+ <value field="gnue_id">00000000000000000000002000000053</value>
+ </row>
+ <row>
+ <value field="address_code">GR</value>
+ <value field="address_name">Greece</value>
+ <value field="gnue_id">00000000000000000000002000000054</value>
+ </row>
+ <row>
+ <value field="address_code">GL</value>
+ <value field="address_name">Greenland</value>
+ <value field="gnue_id">00000000000000000000002000000055</value>
+ </row>
+ <row>
+ <value field="address_code">GD</value>
+ <value field="address_name">Grenada</value>
+ <value field="gnue_id">00000000000000000000002000000056</value>
+ </row>
+ <row>
+ <value field="address_code">GP</value>
+ <value field="address_name">Guadeloupe</value>
+ <value field="gnue_id">00000000000000000000002000000057</value>
+ </row>
+ <row>
+ <value field="address_code">GU</value>
+ <value field="address_name">Guam</value>
+ <value field="gnue_id">00000000000000000000002000000058</value>
+ </row>
+ <row>
+ <value field="address_code">GT</value>
+ <value field="address_name">Guatemala</value>
+ <value field="gnue_id">00000000000000000000002000000059</value>
+ </row>
+ <row>
+ <value field="address_code">GN</value>
+ <value field="address_name">Guinea</value>
+ <value field="gnue_id">0000000000000000000000200000005A</value>
+ </row>
+ <row>
+ <value field="address_code">GW</value>
+ <value field="address_name">Guinea-Bissau</value>
+ <value field="gnue_id">0000000000000000000000200000005B</value>
+ </row>
+ <row>
+ <value field="address_code">GY</value>
+ <value field="address_name">Guyana</value>
+ <value field="gnue_id">0000000000000000000000200000005C</value>
+ </row>
+ <row>
+ <value field="address_code">HT</value>
+ <value field="address_name">Haiti</value>
+ <value field="gnue_id">0000000000000000000000200000005D</value>
+ </row>
+ <row>
+ <value field="address_code">HM</value>
+ <value field="address_name">Heard Island And Mcdonald Islands</value>
+ <value field="gnue_id">0000000000000000000000200000005E</value>
+ </row>
+ <row>
+ <value field="address_code">VA</value>
+ <value field="address_name">Holy See (Vatican City State)</value>
+ <value field="gnue_id">0000000000000000000000200000005F</value>
+ </row>
+ <row>
+ <value field="address_code">HN</value>
+ <value field="address_name">Honduras</value>
+ <value field="gnue_id">00000000000000000000002000000060</value>
+ </row>
+ <row>
+ <value field="address_code">HK</value>
+ <value field="address_name">Hong Kong</value>
+ <value field="gnue_id">00000000000000000000002000000061</value>
+ </row>
+ <row>
+ <value field="address_code">HU</value>
+ <value field="address_name">Hungary</value>
+ <value field="gnue_id">00000000000000000000002000000062</value>
+ </row>
+ <row>
+ <value field="address_code">IS</value>
+ <value field="address_name">Iceland</value>
+ <value field="gnue_id">00000000000000000000002000000063</value>
+ </row>
+ <row>
+ <value field="address_code">IN</value>
+ <value field="address_name">India</value>
+ <value field="gnue_id">00000000000000000000002000000064</value>
+ </row>
+ <row>
+ <value field="address_code">ID</value>
+ <value field="address_name">Indonesia</value>
+ <value field="gnue_id">00000000000000000000002000000065</value>
+ </row>
+ <row>
+ <value field="address_code">IR</value>
+ <value field="address_name">Iran, Islamic Republic Of</value>
+ <value field="gnue_id">00000000000000000000002000000066</value>
+ </row>
+ <row>
+ <value field="address_code">IQ</value>
+ <value field="address_name">Iraq</value>
+ <value field="gnue_id">00000000000000000000002000000067</value>
+ </row>
+ <row>
+ <value field="address_code">IE</value>
+ <value field="address_name">Ireland</value>
+ <value field="gnue_id">00000000000000000000002000000068</value>
+ </row>
+ <row>
+ <value field="address_code">IL</value>
+ <value field="address_name">Israel</value>
+ <value field="gnue_id">00000000000000000000002000000069</value>
+ </row>
+ <row>
+ <value field="address_code">IT</value>
+ <value field="address_name">Italy</value>
+ <value field="gnue_id">0000000000000000000000200000006A</value>
+ </row>
+ <row>
+ <value field="address_code">JM</value>
+ <value field="address_name">Jamaica</value>
+ <value field="gnue_id">0000000000000000000000200000006B</value>
+ </row>
+ <row>
+ <value field="address_code">JP</value>
+ <value field="address_name">Japan</value>
+ <value field="gnue_id">0000000000000000000000200000006C</value>
+ </row>
+ <row>
+ <value field="address_code">JO</value>
+ <value field="address_name">Jordan</value>
+ <value field="gnue_id">0000000000000000000000200000006D</value>
+ </row>
+ <row>
+ <value field="address_code">KZ</value>
+ <value field="address_name">Kazakhstan</value>
+ <value field="gnue_id">0000000000000000000000200000006E</value>
+ </row>
+ <row>
+ <value field="address_code">KE</value>
+ <value field="address_name">Kenya</value>
+ <value field="gnue_id">0000000000000000000000200000006F</value>
+ </row>
+ <row>
+ <value field="address_code">KI</value>
+ <value field="address_name">Kiribati</value>
+ <value field="gnue_id">00000000000000000000002000000070</value>
+ </row>
+ <row>
+ <value field="address_code">KP</value>
+ <value field="address_name">Korea, Democratic People's
Republic</value>
+ <value field="gnue_id">00000000000000000000002000000071</value>
+ </row>
+ <row>
+ <value field="address_code">KR</value>
+ <value field="address_name">Korea, Republic Of</value>
+ <value field="gnue_id">00000000000000000000002000000072</value>
+ </row>
+ <row>
+ <value field="address_code">KW</value>
+ <value field="address_name">Kuwait</value>
+ <value field="gnue_id">00000000000000000000002000000073</value>
+ </row>
+ <row>
+ <value field="address_code">KG</value>
+ <value field="address_name">Kyrgyzstan</value>
+ <value field="gnue_id">00000000000000000000002000000074</value>
+ </row>
+ <row>
+ <value field="address_code">LA</value>
+ <value field="address_name">Lao People's Democratic Republic</value>
+ <value field="gnue_id">00000000000000000000002000000075</value>
+ </row>
+ <row>
+ <value field="address_code">LV</value>
+ <value field="address_name">Latvia</value>
+ <value field="gnue_id">00000000000000000000002000000076</value>
+ </row>
+ <row>
+ <value field="address_code">LB</value>
+ <value field="address_name">Lebanon</value>
+ <value field="gnue_id">00000000000000000000002000000077</value>
+ </row>
+ <row>
+ <value field="address_code">LS</value>
+ <value field="address_name">Lesotho</value>
+ <value field="gnue_id">00000000000000000000002000000078</value>
+ </row>
+ <row>
+ <value field="address_code">LR</value>
+ <value field="address_name">Liberia</value>
+ <value field="gnue_id">00000000000000000000002000000079</value>
+ </row>
+ <row>
+ <value field="address_code">LY</value>
+ <value field="address_name">Libyan Arab Jamahiriya</value>
+ <value field="gnue_id">0000000000000000000000200000007A</value>
+ </row>
+ <row>
+ <value field="address_code">LI</value>
+ <value field="address_name">Liechtenstein</value>
+ <value field="gnue_id">0000000000000000000000200000007B</value>
+ </row>
+ <row>
+ <value field="address_code">LT</value>
+ <value field="address_name">Lithuania</value>
+ <value field="gnue_id">0000000000000000000000200000007C</value>
+ </row>
+ <row>
+ <value field="address_code">LU</value>
+ <value field="address_name">Luxembourg</value>
+ <value field="gnue_id">0000000000000000000000200000007D</value>
+ </row>
+ <row>
+ <value field="address_code">MO</value>
+ <value field="address_name">Macao</value>
+ <value field="gnue_id">0000000000000000000000200000007E</value>
+ </row>
+ <row>
+ <value field="address_code">MK</value>
+ <value field="address_name">Macedonia, The Former Yugoslav
Repu</value>
+ <value field="gnue_id">0000000000000000000000200000007F</value>
+ </row>
+ <row>
+ <value field="address_code">MG</value>
+ <value field="address_name">Madagascar</value>
+ <value field="gnue_id">00000000000000000000002000000080</value>
+ </row>
+ <row>
+ <value field="address_code">MW</value>
+ <value field="address_name">Malawi</value>
+ <value field="gnue_id">00000000000000000000002000000081</value>
+ </row>
+ <row>
+ <value field="address_code">MY</value>
+ <value field="address_name">Malaysia</value>
+ <value field="gnue_id">00000000000000000000002000000082</value>
+ </row>
+ <row>
+ <value field="address_code">MV</value>
+ <value field="address_name">Maldives</value>
+ <value field="gnue_id">00000000000000000000002000000083</value>
+ </row>
+ <row>
+ <value field="address_code">ML</value>
+ <value field="address_name">Mali</value>
+ <value field="gnue_id">00000000000000000000002000000084</value>
+ </row>
+ <row>
+ <value field="address_code">MT</value>
+ <value field="address_name">Malta</value>
+ <value field="gnue_id">00000000000000000000002000000085</value>
+ </row>
+ <row>
+ <value field="address_code">MH</value>
+ <value field="address_name">Marshall Islands</value>
+ <value field="gnue_id">00000000000000000000002000000086</value>
+ </row>
+ <row>
+ <value field="address_code">MQ</value>
+ <value field="address_name">Martinique</value>
+ <value field="gnue_id">00000000000000000000002000000087</value>
+ </row>
+ <row>
+ <value field="address_code">MR</value>
+ <value field="address_name">Mauritania</value>
+ <value field="gnue_id">00000000000000000000002000000088</value>
+ </row>
+ <row>
+ <value field="address_code">MU</value>
+ <value field="address_name">Mauritius</value>
+ <value field="gnue_id">00000000000000000000002000000089</value>
+ </row>
+ <row>
+ <value field="address_code">YT</value>
+ <value field="address_name">Mayotte</value>
+ <value field="gnue_id">0000000000000000000000200000008A</value>
+ </row>
+ <row>
+ <value field="address_code">MX</value>
+ <value field="address_name">Mexico</value>
+ <value field="gnue_id">0000000000000000000000200000008B</value>
+ </row>
+ <row>
+ <value field="address_code">FM</value>
+ <value field="address_name">Micronesia, Federated States Of</value>
+ <value field="gnue_id">0000000000000000000000200000008C</value>
+ </row>
+ <row>
+ <value field="address_code">MD</value>
+ <value field="address_name">Moldova, Republic Of</value>
+ <value field="gnue_id">0000000000000000000000200000008D</value>
+ </row>
+ <row>
+ <value field="address_code">MC</value>
+ <value field="address_name">Monaco</value>
+ <value field="gnue_id">0000000000000000000000200000008E</value>
+ </row>
+ <row>
+ <value field="address_code">MN</value>
+ <value field="address_name">Mongolia</value>
+ <value field="gnue_id">0000000000000000000000200000008F</value>
+ </row>
+ <row>
+ <value field="address_code">MS</value>
+ <value field="address_name">Montserrat</value>
+ <value field="gnue_id">00000000000000000000002000000090</value>
+ </row>
+ <row>
+ <value field="address_code">MA</value>
+ <value field="address_name">Morocco</value>
+ <value field="gnue_id">00000000000000000000002000000091</value>
+ </row>
+ <row>
+ <value field="address_code">MZ</value>
+ <value field="address_name">Mozambique</value>
+ <value field="gnue_id">00000000000000000000002000000092</value>
+ </row>
+ <row>
+ <value field="address_code">MM</value>
+ <value field="address_name">Myanmar</value>
+ <value field="gnue_id">00000000000000000000002000000093</value>
+ </row>
+ <row>
+ <value field="address_code">NA</value>
+ <value field="address_name">Namibia</value>
+ <value field="gnue_id">00000000000000000000002000000094</value>
+ </row>
+ <row>
+ <value field="address_code">NR</value>
+ <value field="address_name">Nauru</value>
+ <value field="gnue_id">00000000000000000000002000000095</value>
+ </row>
+ <row>
+ <value field="address_code">NP</value>
+ <value field="address_name">Nepal</value>
+ <value field="gnue_id">00000000000000000000002000000096</value>
+ </row>
+ <row>
+ <value field="address_code">NL</value>
+ <value field="address_name">Netherlands</value>
+ <value field="gnue_id">00000000000000000000002000000097</value>
+ </row>
+ <row>
+ <value field="address_code">AN</value>
+ <value field="address_name">Netherlands Antilles</value>
+ <value field="gnue_id">00000000000000000000002000000098</value>
+ </row>
+ <row>
+ <value field="address_code">NC</value>
+ <value field="address_name">New Caledonia</value>
+ <value field="gnue_id">00000000000000000000002000000099</value>
+ </row>
+ <row>
+ <value field="address_code">NZ</value>
+ <value field="address_name">New Zealand</value>
+ <value field="gnue_id">0000000000000000000000200000009A</value>
+ </row>
+ <row>
+ <value field="address_code">NI</value>
+ <value field="address_name">Nicaragua</value>
+ <value field="gnue_id">0000000000000000000000200000009B</value>
+ </row>
+ <row>
+ <value field="address_code">NE</value>
+ <value field="address_name">Niger</value>
+ <value field="gnue_id">0000000000000000000000200000009C</value>
+ </row>
+ <row>
+ <value field="address_code">NG</value>
+ <value field="address_name">Nigeria</value>
+ <value field="gnue_id">0000000000000000000000200000009D</value>
+ </row>
+ <row>
+ <value field="address_code">NU</value>
+ <value field="address_name">Niue</value>
+ <value field="gnue_id">0000000000000000000000200000009E</value>
+ </row>
+ <row>
+ <value field="address_code">NF</value>
+ <value field="address_name">Norfolk Island</value>
+ <value field="gnue_id">0000000000000000000000200000009F</value>
+ </row>
+ <row>
+ <value field="address_code">MP</value>
+ <value field="address_name">Northern Mariana Islands</value>
+ <value field="gnue_id">000000000000000000000020000000A0</value>
+ </row>
+ <row>
+ <value field="address_code">NO</value>
+ <value field="address_name">Norway</value>
+ <value field="gnue_id">000000000000000000000020000000A1</value>
+ </row>
+ <row>
+ <value field="address_code">OM</value>
+ <value field="address_name">Oman</value>
+ <value field="gnue_id">000000000000000000000020000000A2</value>
+ </row>
+ <row>
+ <value field="address_code">PK</value>
+ <value field="address_name">Pakistan</value>
+ <value field="gnue_id">000000000000000000000020000000A3</value>
+ </row>
+ <row>
+ <value field="address_code">PW</value>
+ <value field="address_name">Palau</value>
+ <value field="gnue_id">000000000000000000000020000000A4</value>
+ </row>
+ <row>
+ <value field="address_code">PS</value>
+ <value field="address_name">Palestinian Territory, Occupied</value>
+ <value field="gnue_id">000000000000000000000020000000A5</value>
+ </row>
+ <row>
+ <value field="address_code">PA</value>
+ <value field="address_name">Panama</value>
+ <value field="gnue_id">000000000000000000000020000000A6</value>
+ </row>
+ <row>
+ <value field="address_code">PG</value>
+ <value field="address_name">Papua New Guinea</value>
+ <value field="gnue_id">000000000000000000000020000000A7</value>
+ </row>
+ <row>
+ <value field="address_code">PY</value>
+ <value field="address_name">Paraguay</value>
+ <value field="gnue_id">000000000000000000000020000000A8</value>
+ </row>
+ <row>
+ <value field="address_code">PE</value>
+ <value field="address_name">Peru</value>
+ <value field="gnue_id">000000000000000000000020000000A9</value>
+ </row>
+ <row>
+ <value field="address_code">PH</value>
+ <value field="address_name">Philippines</value>
+ <value field="gnue_id">000000000000000000000020000000AA</value>
+ </row>
+ <row>
+ <value field="address_code">PN</value>
+ <value field="address_name">Pitcairn</value>
+ <value field="gnue_id">000000000000000000000020000000AB</value>
+ </row>
+ <row>
+ <value field="address_code">PL</value>
+ <value field="address_name">Poland</value>
+ <value field="gnue_id">000000000000000000000020000000AC</value>
+ </row>
+ <row>
+ <value field="address_code">PT</value>
+ <value field="address_name">Portugal</value>
+ <value field="gnue_id">000000000000000000000020000000AD</value>
+ </row>
+ <row>
+ <value field="address_code">PR</value>
+ <value field="address_name">Puerto Rico</value>
+ <value field="gnue_id">000000000000000000000020000000AE</value>
+ </row>
+ <row>
+ <value field="address_code">QA</value>
+ <value field="address_name">Qatar</value>
+ <value field="gnue_id">000000000000000000000020000000AF</value>
+ </row>
+ <row>
+ <value field="address_code">RE</value>
+ <value field="address_name">Reunion</value>
+ <value field="gnue_id">000000000000000000000020000000B0</value>
+ </row>
+ <row>
+ <value field="address_code">RO</value>
+ <value field="address_name">Romania</value>
+ <value field="gnue_id">000000000000000000000020000000B1</value>
+ </row>
+ <row>
+ <value field="address_code">RU</value>
+ <value field="address_name">Russian Federation</value>
+ <value field="gnue_id">000000000000000000000020000000B2</value>
+ </row>
+ <row>
+ <value field="address_code">RW</value>
+ <value field="address_name">Rwanda</value>
+ <value field="gnue_id">000000000000000000000020000000B3</value>
+ </row>
+ <row>
+ <value field="address_code">SH</value>
+ <value field="address_name">Saint Helena</value>
+ <value field="gnue_id">000000000000000000000020000000B4</value>
+ </row>
+ <row>
+ <value field="address_code">KN</value>
+ <value field="address_name">Saint Kitts And Nevis</value>
+ <value field="gnue_id">000000000000000000000020000000B5</value>
+ </row>
+ <row>
+ <value field="address_code">LC</value>
+ <value field="address_name">Saint Lucia</value>
+ <value field="gnue_id">000000000000000000000020000000B6</value>
+ </row>
+ <row>
+ <value field="address_code">PM</value>
+ <value field="address_name">Saint Pierre And Miquelon</value>
+ <value field="gnue_id">000000000000000000000020000000B7</value>
+ </row>
+ <row>
+ <value field="address_code">VC</value>
+ <value field="address_name">Saint Vincent And The Grenadines</value>
+ <value field="gnue_id">000000000000000000000020000000B8</value>
+ </row>
+ <row>
+ <value field="address_code">WS</value>
+ <value field="address_name">Samoa</value>
+ <value field="gnue_id">000000000000000000000020000000B9</value>
+ </row>
+ <row>
+ <value field="address_code">SM</value>
+ <value field="address_name">San Marino</value>
+ <value field="gnue_id">000000000000000000000020000000BA</value>
+ </row>
+ <row>
+ <value field="address_code">ST</value>
+ <value field="address_name">Sao Tome And Principe</value>
+ <value field="gnue_id">000000000000000000000020000000BB</value>
+ </row>
+ <row>
+ <value field="address_code">SA</value>
+ <value field="address_name">Saudi Arabia</value>
+ <value field="gnue_id">000000000000000000000020000000BC</value>
+ </row>
+ <row>
+ <value field="address_code">SN</value>
+ <value field="address_name">Senegal</value>
+ <value field="gnue_id">000000000000000000000020000000BD</value>
+ </row>
+ <row>
+ <value field="address_code">CS</value>
+ <value field="address_name">Serbia And Montenegro</value>
+ <value field="gnue_id">000000000000000000000020000000BE</value>
+ </row>
+ <row>
+ <value field="address_code">SC</value>
+ <value field="address_name">Seychelles</value>
+ <value field="gnue_id">000000000000000000000020000000BF</value>
+ </row>
+ <row>
+ <value field="address_code">SL</value>
+ <value field="address_name">Sierra Leone</value>
+ <value field="gnue_id">000000000000000000000020000000C0</value>
+ </row>
+ <row>
+ <value field="address_code">SG</value>
+ <value field="address_name">Singapore</value>
+ <value field="gnue_id">000000000000000000000020000000C1</value>
+ </row>
+ <row>
+ <value field="address_code">SK</value>
+ <value field="address_name">Slovakia</value>
+ <value field="gnue_id">000000000000000000000020000000C2</value>
+ </row>
+ <row>
+ <value field="address_code">SI</value>
+ <value field="address_name">Slovenia</value>
+ <value field="gnue_id">000000000000000000000020000000C3</value>
+ </row>
+ <row>
+ <value field="address_code">SB</value>
+ <value field="address_name">Solomon Islands</value>
+ <value field="gnue_id">000000000000000000000020000000C4</value>
+ </row>
+ <row>
+ <value field="address_code">SO</value>
+ <value field="address_name">Somalia</value>
+ <value field="gnue_id">000000000000000000000020000000C5</value>
+ </row>
+ <row>
+ <value field="address_code">ZA</value>
+ <value field="address_name">South Africa</value>
+ <value field="gnue_id">000000000000000000000020000000C6</value>
+ </row>
+ <row>
+ <value field="address_code">GS</value>
+ <value field="address_name">South Georgia And The South
Sandwic</value>
+ <value field="gnue_id">000000000000000000000020000000C7</value>
+ </row>
+ <row>
+ <value field="address_code">ES</value>
+ <value field="address_name">Spain</value>
+ <value field="gnue_id">000000000000000000000020000000C8</value>
+ </row>
+ <row>
+ <value field="address_code">LK</value>
+ <value field="address_name">Sri Lanka</value>
+ <value field="gnue_id">000000000000000000000020000000C9</value>
+ </row>
+ <row>
+ <value field="address_code">SD</value>
+ <value field="address_name">Sudan</value>
+ <value field="gnue_id">000000000000000000000020000000CA</value>
+ </row>
+ <row>
+ <value field="address_code">SR</value>
+ <value field="address_name">Suriname</value>
+ <value field="gnue_id">000000000000000000000020000000CB</value>
+ </row>
+ <row>
+ <value field="address_code">SJ</value>
+ <value field="address_name">Svalbard And Jan Mayen</value>
+ <value field="gnue_id">000000000000000000000020000000CC</value>
+ </row>
+ <row>
+ <value field="address_code">SZ</value>
+ <value field="address_name">Swaziland</value>
+ <value field="gnue_id">000000000000000000000020000000CD</value>
+ </row>
+ <row>
+ <value field="address_code">SE</value>
+ <value field="address_name">Sweden</value>
+ <value field="gnue_id">000000000000000000000020000000CE</value>
+ </row>
+ <row>
+ <value field="address_code">CH</value>
+ <value field="address_name">Switzerland</value>
+ <value field="gnue_id">000000000000000000000020000000CF</value>
+ </row>
+ <row>
+ <value field="address_code">SY</value>
+ <value field="address_name">Syrian Arab Republic</value>
+ <value field="gnue_id">000000000000000000000020000000D0</value>
+ </row>
+ <row>
+ <value field="address_code">TW</value>
+ <value field="address_name">Taiwan, Province Of China</value>
+ <value field="gnue_id">000000000000000000000020000000D1</value>
+ </row>
+ <row>
+ <value field="address_code">TJ</value>
+ <value field="address_name">Tajikistan</value>
+ <value field="gnue_id">000000000000000000000020000000D2</value>
+ </row>
+ <row>
+ <value field="address_code">TZ</value>
+ <value field="address_name">Tanzania, United Republic Of</value>
+ <value field="gnue_id">000000000000000000000020000000D3</value>
+ </row>
+ <row>
+ <value field="address_code">TH</value>
+ <value field="address_name">Thailand</value>
+ <value field="gnue_id">000000000000000000000020000000D4</value>
+ </row>
+ <row>
+ <value field="address_code">TL</value>
+ <value field="address_name">Timor-Leste</value>
+ <value field="gnue_id">000000000000000000000020000000D5</value>
+ </row>
+ <row>
+ <value field="address_code">TG</value>
+ <value field="address_name">Togo</value>
+ <value field="gnue_id">000000000000000000000020000000D6</value>
+ </row>
+ <row>
+ <value field="address_code">TK</value>
+ <value field="address_name">Tokelau</value>
+ <value field="gnue_id">000000000000000000000020000000D7</value>
+ </row>
+ <row>
+ <value field="address_code">TO</value>
+ <value field="address_name">Tonga</value>
+ <value field="gnue_id">000000000000000000000020000000D8</value>
+ </row>
+ <row>
+ <value field="address_code">TT</value>
+ <value field="address_name">Trinidad And Tobago</value>
+ <value field="gnue_id">000000000000000000000020000000D9</value>
+ </row>
+ <row>
+ <value field="address_code">TN</value>
+ <value field="address_name">Tunisia</value>
+ <value field="gnue_id">000000000000000000000020000000DA</value>
+ </row>
+ <row>
+ <value field="address_code">TR</value>
+ <value field="address_name">Turkey</value>
+ <value field="gnue_id">000000000000000000000020000000DB</value>
+ </row>
+ <row>
+ <value field="address_code">TM</value>
+ <value field="address_name">Turkmenistan</value>
+ <value field="gnue_id">000000000000000000000020000000DC</value>
+ </row>
+ <row>
+ <value field="address_code">TC</value>
+ <value field="address_name">Turks And Caicos Islands</value>
+ <value field="gnue_id">000000000000000000000020000000DD</value>
+ </row>
+ <row>
+ <value field="address_code">TV</value>
+ <value field="address_name">Tuvalu</value>
+ <value field="gnue_id">000000000000000000000020000000DE</value>
+ </row>
+ <row>
+ <value field="address_code">UG</value>
+ <value field="address_name">Uganda</value>
+ <value field="gnue_id">000000000000000000000020000000DF</value>
+ </row>
+ <row>
+ <value field="address_code">UA</value>
+ <value field="address_name">Ukraine</value>
+ <value field="gnue_id">000000000000000000000020000000E0</value>
+ </row>
+ <row>
+ <value field="address_code">AE</value>
+ <value field="address_name">United Arab Emirates</value>
+ <value field="gnue_id">000000000000000000000020000000E1</value>
+ </row>
+ <row>
+ <value field="address_code">GB</value>
+ <value field="address_name">United Kingdom</value>
+ <value field="gnue_id">000000000000000000000020000000E2</value>
+ </row>
+ <row>
+ <value field="address_code">US</value>
+ <value field="address_name">United States</value>
+ <value field="gnue_id">000000000000000000000020000000E3</value>
+ </row>
+ <row>
+ <value field="address_code">UM</value>
+ <value field="address_name">United States Minor Outlying
Island</value>
+ <value field="gnue_id">000000000000000000000020000000E4</value>
+ </row>
+ <row>
+ <value field="address_code">UY</value>
+ <value field="address_name">Uruguay</value>
+ <value field="gnue_id">000000000000000000000020000000E5</value>
+ </row>
+ <row>
+ <value field="address_code">UZ</value>
+ <value field="address_name">Uzbekistan</value>
+ <value field="gnue_id">000000000000000000000020000000E6</value>
+ </row>
+ <row>
+ <value field="address_code">VU</value>
+ <value field="address_name">Vanuatu</value>
+ <value field="gnue_id">000000000000000000000020000000E7</value>
+ </row>
+ <row>
+ <value field="address_code">VE</value>
+ <value field="address_name">Venezuela</value>
+ <value field="gnue_id">000000000000000000000020000000E8</value>
+ </row>
+ <row>
+ <value field="address_code">VN</value>
+ <value field="address_name">Viet Nam</value>
+ <value field="gnue_id">000000000000000000000020000000E9</value>
+ </row>
+ <row>
+ <value field="address_code">VG</value>
+ <value field="address_name">Virgin Islands, British</value>
+ <value field="gnue_id">000000000000000000000020000000EA</value>
+ </row>
+ <row>
+ <value field="address_code">VI</value>
+ <value field="address_name">Virgin Islands, U.S.</value>
+ <value field="gnue_id">000000000000000000000020000000EB</value>
+ </row>
+ <row>
+ <value field="address_code">WF</value>
+ <value field="address_name">Wallis And Futuna</value>
+ <value field="gnue_id">000000000000000000000020000000EC</value>
+ </row>
+ <row>
+ <value field="address_code">EH</value>
+ <value field="address_name">Western Sahara</value>
+ <value field="gnue_id">000000000000000000000020000000ED</value>
+ </row>
+ <row>
+ <value field="address_code">YE</value>
+ <value field="address_name">Yemen</value>
+ <value field="gnue_id">000000000000000000000020000000EE</value>
+ </row>
+ <row>
+ <value field="address_code">ZM</value>
+ <value field="address_name">Zambia</value>
+ <value field="gnue_id">000000000000000000000020000000EF</value>
+ </row>
+ <row>
+ <value field="address_code">ZW</value>
+ <value field="address_name">Zimbabwe</value>
+ <value field="gnue_id">000000000000000000000020000000F0</value>
+ </row>
+ <row>
+ <value field="address_code">XA</value>
+ <value field="address_name">Joe tries it again</value>
+ <value field="gnue_createdate">2005-01-13 14:37:16.19</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">02112857897615857603186174920940</value>
+ <value field="gnue_modifydate">2005-01-13 14:37:33.25</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XJ</value>
+ <value field="address_name">Joes test 2</value>
+ <value field="gnue_createdate">2005-01-09 11:17:22.10</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">81073611306266233906677539842164</value>
+ <value field="gnue_modifydate">2005-01-09 11:17:29.73</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XK</value>
+ <value field="address_name">Next test</value>
+ <value field="gnue_createdate">2005-01-09 11:22:23.05</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">02532670860276434687643914784026</value>
+ <value field="gnue_modifydate">2005-01-09 11:22:38.46</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XL</value>
+ <value field="address_name">next testing check</value>
+ <value field="gnue_createdate">2005-01-09 11:31:58.52</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">38990705227218666484068581516032</value>
+ <value field="gnue_modifydate">2005-01-09 11:32:13.84</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XM</value>
+ <value field="address_name">gfradf</value>
+ <value field="gnue_createdate">2005-01-09 11:37:56.07</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">53100597821755495446128930733833</value>
+ <value field="gnue_modifydate">2005-01-09 11:38:12.81</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XN</value>
+ <value field="address_name">Maybe this one</value>
+ <value field="gnue_createdate">2005-01-09 11:51:34.43</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">28691923253927099912618105099031</value>
+ <value field="gnue_modifydate">2005-01-09 11:51:50.28</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XN</value>
+ <value field="address_name">Let's try this one</value>
+ <value field="gnue_createdate">2005-01-09 11:52:14.36</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">59091349654704054625178797407118</value>
+ <value field="gnue_modifydate">2005-01-09 11:52:26.51</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XO</value>
+ <value field="address_name">Freak show</value>
+ <value field="gnue_createdate">2005-01-09 12:12:47.53</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">63650994614436084811251138198880</value>
+ <value field="gnue_modifydate">2005-01-09 12:13:07.76</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XX</value>
+ <value field="address_name">Shit</value>
+ <value field="gnue_createdate">2005-01-09 13:30:49.10</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">65500910120337357159327012988783</value>
+ <value field="gnue_modifydate">2005-01-09 13:30:58.02</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XX</value>
+ <value field="address_name">Shjit 2</value>
+ <value field="gnue_createdate">2005-01-09 13:31:57.81</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">88248387718419463131922078067760</value>
+ <value field="gnue_modifydate">2005-01-09 13:32:09.92</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XY</value>
+ <value field="address_name">Z-Fred</value>
+ <value field="gnue_createdate">2005-01-09 14:37:36.46</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">07060415145100491658783891167748</value>
+ <value field="gnue_modifydate">2005-01-09 14:37:44.43</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XZ</value>
+ <value field="address_name">Y-Fred</value>
+ <value field="gnue_createdate">2005-01-09 14:37:57.96</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">04111413612787338847912318918834</value>
+ <value field="gnue_modifydate">2005-01-09 14:38:10.66</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ <row>
+ <value field="address_code">XZ</value>
+ <value field="address_name">Fred die Sau</value>
+ <value field="gnue_createdate">2005-01-09 14:42:53.96</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">03547006021057818088568322049328</value>
+ <value field="gnue_modifydate">2005-01-09 14:43:05.79</value>
+ <value field="gnue_modifyuser"></value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="test_customer_dump" tablename="test_customer">
+ <definition>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ <column field="test_country" type="string(32)"/>
+ <column field="test_name" type="string(35)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:40:51.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">52950870997649992115360813272027</value>
+ <value field="gnue_modifydate">2005-01-13 16:40:59.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_country">0000000000000000000000200000000F</value>
+ <value field="test_name">Foobar</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:41:07.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">13735629977745092955019210084834</value>
+ <value field="gnue_modifydate">2005-01-13 16:41:10.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_name">Nobody</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="test_item_dump" tablename="test_item">
+ <definition>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ <column field="test_code" type="string(35)"/>
+ <column field="test_description" type="string(70)"/>
+ <column field="test_group" type="string(32)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:41:59.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">56457004688566912295714220302111</value>
+ <value field="gnue_modifydate">2005-01-13 16:52:03.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">G1</value>
+ <value field="test_description">This is a great TV-Set</value>
+ <value field="test_group">61734295048615410439014217213588</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:52:06.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">26170469599492056501811405158885</value>
+ <value field="gnue_modifydate">2005-01-13 16:52:17.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">G2</value>
+ <value field="test_description">Another usefull tool</value>
+ <value field="test_group">12128762210949564941053942227249</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:52:20.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">59944463121906265724992934125990</value>
+ <value field="gnue_modifydate">2005-01-13 16:52:31.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_code">Bad</value>
+ <value field="test_description">This item has no group
assigned</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="test_invoice_dump" tablename="test_invoice">
+ <definition>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ <column field="test_customer" type="string(32)"/>
+ <column field="test_description" type="string(35)"/>
+ <column field="test_number" type="number(6)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:52:46.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">27998096160177534797956359095199</value>
+ <value field="gnue_modifydate">2005-01-13 16:53:35.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_customer">52950870997649992115360813272027</value>
+ <value field="test_description">A good invoice</value>
+ <value field="test_number">4711</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:53:02.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">04248403804719333663169307382634</value>
+ <value field="gnue_modifydate">2005-01-13 16:53:35.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_customer">13735629977745092955019210084834</value>
+ <value field="test_description">A bad invoice</value>
+ <value field="test_number">815</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:53:16.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">24949342224821879515816329455468</value>
+ <value field="gnue_modifydate">2005-01-13 16:53:35.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_customer">13735629977745092955019210084834</value>
+ <value field="test_description">An ugly invoice</value>
+ <value field="test_number">666</value>
+ </row>
+ </rows>
+ </tabledata>
+ <tabledata name="test_lineitem_dump" tablename="test_lineitem">
+ <definition>
+ <column field="gnue_createdate" type="datetime"/>
+ <column field="gnue_createuser" type="string(8)"/>
+ <column field="gnue_id" key="Y" type="string(32)"/>
+ <column field="gnue_modifydate" type="datetime"/>
+ <column field="gnue_modifyuser" type="string(8)"/>
+ <column field="test_invoice" type="string(32)"/>
+ <column field="test_item" type="string(32)"/>
+ <column field="test_position" type="number(5)"/>
+ <column field="test_quantity" type="number(7.2)"/>
+ </definition>
+ <rows>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:55:58.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">01459255894664617112615288461641</value>
+ <value field="gnue_modifydate">2005-01-13 16:56:10.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_invoice">27998096160177534797956359095199</value>
+ <value field="test_item">56457004688566912295714220302111</value>
+ <value field="test_position">1</value>
+ <value field="test_quantity">3.0</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:56:13.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">59497331384096237825031634311211</value>
+ <value field="gnue_modifydate">2005-01-13 16:56:23.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_invoice">27998096160177534797956359095199</value>
+ <value field="test_item">26170469599492056501811405158885</value>
+ <value field="test_position">2</value>
+ <value field="test_quantity">4.0</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:56:24.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">47819173297968013404558810839798</value>
+ <value field="gnue_modifydate">2005-01-13 16:56:33.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_invoice">04248403804719333663169307382634</value>
+ <value field="test_item">56457004688566912295714220302111</value>
+ <value field="test_position">1</value>
+ <value field="test_quantity">1.0</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:56:35.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">36537151298459010505716302915899</value>
+ <value field="gnue_modifydate">2005-01-13 16:56:44.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_invoice">04248403804719333663169307382634</value>
+ <value field="test_item">59944463121906265724992934125990</value>
+ <value field="test_position">2</value>
+ <value field="test_quantity">5.0</value>
+ </row>
+ <row>
+ <value field="gnue_createdate">2005-01-13 16:56:46.00</value>
+ <value field="gnue_createuser"></value>
+ <value field="gnue_id">48469706096664212764959449406893</value>
+ <value field="gnue_modifydate">2005-01-13 16:56:52.00</value>
+ <value field="gnue_modifyuser"></value>
+ <value field="test_invoice">24949342224821879515816329455468</value>
+ <value field="test_position">1</value>
+ </row>
+ </rows>
+ </tabledata>
+ </data>
+</schema>
Added: trunk/gnue-appserver/samples/testing/joins/struct.gcd
===================================================================
--- trunk/gnue-appserver/samples/testing/joins/struct.gcd 2005-01-14
08:34:49 UTC (rev 6901)
+++ trunk/gnue-appserver/samples/testing/joins/struct.gcd 2005-01-14
08:37:55 UTC (rev 6902)
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<module name="test">
+
+ <class name="customer">
+ <property name="name" type="string(35)" nullable="False" />
+ <property name="country" type="address_country" />
+ </class>
+
+ <class name="itemgroup">
+ <property name="code" type="string(8)" nullable="False" />
+ <property name="name" type="string(35)" nullable="False" />
+ </class>
+
+ <class name="item" >
+ <property name="code" type="string(35)" nullable="False" />
+ <property name="description" type="string(70)" nullable="False" />
+ <property name="group" type="test_itemgroup" />
+ </class>
+
+ <class name="invoice" >
+ <property name="number" type="number(6)" nullable="False" />
+ <property name="customer" type="test_customer" />
+ <property name="description" type="string(35)" />
+ </class>
+
+ <class name="lineitem" >
+ <property name="invoice" type="test_invoice" nullable="False" />
+ <property name="position" type="number(5)" />
+ <property name="item" type="test_item" />
+ <property name="quantity" type="number(7,2)" />
+ </class>
+
+</module>
+
Added: trunk/gnue-appserver/samples/testing/joins/struct.gld
===================================================================
--- trunk/gnue-appserver/samples/testing/joins/struct.gld 2005-01-14
08:34:49 UTC (rev 6901)
+++ trunk/gnue-appserver/samples/testing/joins/struct.gld 2005-01-14
08:37:55 UTC (rev 6902)
@@ -0,0 +1,35 @@
+<?xml version="1.0" encoding="UTF-8"?>
+
+<module name="test" language="C">
+
+ <class name="customer">
+ <property name="name" pos="100" search="100" label="Customer"/>
+ <property name="country" pos="200" label="Country" />
+ </class>
+
+ <class name="itemgroup">
+ <property name="code" pos="100" search="100" label="Code" />
+ <property name="name" pos="200" search="200" label="Name" />
+ </class>
+
+ <class name="item" >
+ <property name="code" pos="100" search="100" label="Code" />
+ <property name="description" pos="200" search="200" label="Description" />
+ <property name="group" pos="300" label="Itemgroup" />
+ </class>
+
+ <class name="invoice" >
+ <property name="number" pos="100" search="100" label="Number" />
+ <property name="customer" pos="200" label="Customer" />
+ <property name="description" pos="300" search="200" label="Description" />
+ </class>
+
+ <class name="lineitem" >
+ <property name="invoice" pos="100" search="100" label="Invoice" />
+ <property name="position" pos="200" search="200" label="Position" />
+ <property name="item" pos="300" search="300" label="Item" />
+ <property name="quantity" pos="400" label="Quantity" />
+ </class>
+
+</module>
+
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue] r6902 - in trunk/gnue-appserver/samples/testing: . joins,
johannes <=