[glom/maemo5] Added a sqlite example just for testing.

From: Murray Cumming <murrayc src gnome org>
To: svn-commits-list gnome org
Cc:
Subject: [glom/maemo5] Added a sqlite example just for testing.
Date: Tue, 6 Oct 2009 16:43:48 +0000 (UTC)
commit 8cb4058d266c38ea52067a4ef9f4f1e1e827ea50
Author: Murray Cumming <murrayc murrayc com>
Date:   Tue Oct 6 18:43:42 2009 +0200

    Added a sqlite example just for testing.

 .../test_sqlite_music/glom_musiccollection21.db    |  Bin 0 -> 15360 bytes
 .../test_sqlite_music/test_sqlite_music.glom       |  378 ++++++++++++++++++++
 2 files changed, 378 insertions(+), 0 deletions(-)
---
diff --git a/examples/sqlite/test_sqlite_music/glom_musiccollection21.db b/examples/sqlite/test_sqlite_music/glom_musiccollection21.db
new file mode 100644
index 0000000..e5fc4aa
Binary files /dev/null and b/examples/sqlite/test_sqlite_music/glom_musiccollection21.db differ
diff --git a/examples/sqlite/test_sqlite_music/test_sqlite_music.glom b/examples/sqlite/test_sqlite_music/test_sqlite_music.glom
new file mode 100644
index 0000000..16433d7
--- /dev/null
+++ b/examples/sqlite/test_sqlite_music/test_sqlite_music.glom
@@ -0,0 +1,378 @@
+<?xml version="1.0"?>
+<glom_document translation_original_locale="en_US" database_title="Music Collection" is_example="false" format_version="4">
+  <connection server="localhost" database="glom_musiccollection21" port="0" self_hosted="true" try_other_ports="true" hosting_mode="sqlite"/>
+  <table name="albums" overview_x="15" overview_y="9" title="Albums">
+    <fields>
+      <field name="album_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Album ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="name" type="Text" title="Name">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="artist_id" type="Number" title="Artist ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="artist" choices_related_field="artist_id" choices_related_second="name"/>
+      </field>
+      <field name="publisher_id" type="Number" title="Publisher ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" choices_related="true" choices_related_relationship="publisher" choices_related_field="publishers_id" choices_related_second="name"/>
+      </field>
+      <field name="year" type="Number" title="Year">
+        <calculation/>
+        <formatting format_decimal_places="2"/>
+      </field>
+    </fields>
+    <relationships>
+      <relationship name="artist" key="artist_id" other_table="artists" other_key="artist_id" title="Artist"/>
+      <relationship name="publisher" key="publisher_id" other_table="publishers" other_key="publishers_id" title="Publisher"/>
+      <relationship name="songs" key="album_id" other_table="songs" other_key="album_id" auto_create="true" allow_edit="true" title="Songs"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="details" parent_table="albums">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_group name="overview" columns_count="2" title="Overview">
+              <trans_set>
+                <trans loc="de_DE" val="Overview"/>
+              </trans_set>
+              <data_layout_item name="album_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+              <data_layout_item name="name" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+            <data_layout_group name="details" columns_count="2" title="Details">
+              <trans_set>
+                <trans loc="de_DE" val="Details"/>
+              </trans_set>
+              <data_layout_group name="artist" title="Artist">
+                <trans_set>
+                  <trans loc="de_DE" val="Artist"/>
+                </trans_set>
+                <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="artist" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="publisher" title="Publisher">
+                <trans_set>
+                  <trans loc="de_DE" val="Publisher"/>
+                </trans_set>
+                <data_layout_item name="publisher_id" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="publisher" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_item name="year" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+              <data_layout_portal relationship="songs">
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_portal>
+              <data_layout_item name="comments" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="list" parent_table="albums">
+        <data_layout_groups>
+          <data_layout_group name="toplevel">
+            <data_layout_item name="album_id" editable="false" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="0"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports>
+      <report name="albums_by_artist" show_table_title="true" title="Albums By Artist">
+        <data_layout_groups>
+          <data_layout_group>
+            <data_layout_item_groupby>
+              <groupby name="artist_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </groupby>
+              <secondary_fields>
+                <data_layout_group>
+                  <data_layout_item name="name" relationship="artist" editable="true" use_default_formatting="true">
+                    <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                    <title_custom use_custom="true" title="Artist Name"/>
+                  </data_layout_item>
+                </data_layout_group>
+              </secondary_fields>
+              <data_layout_item name="name" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+              <data_layout_item name="year" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+            </data_layout_item_groupby>
+          </data_layout_group>
+        </data_layout_groups>
+      </report>
+    </reports>
+    <print_layouts/>
+  </table>
+  <table name="artists" default="true" overview_x="407" overview_y="119" title="Artists">
+    <fields>
+      <field name="artist_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Artist ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      </field>
+      <field name="description" type="Text" title="Description">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="name" type="Text" title="Name">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      </field>
+    </fields>
+    <relationships>
+      <relationship name="albums" key="artist_id" other_table="albums" other_key="artist_id" auto_create="true" allow_edit="true" title="Albums"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="details" parent_table="artists">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_group name="overview" columns_count="2" title="Overview">
+              <trans_set>
+                <trans loc="de_DE" val="Overview"/>
+              </trans_set>
+              <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+              <data_layout_item name="name" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+            <data_layout_group name="details" columns_count="2" title="Details">
+              <trans_set>
+                <trans loc="de_DE" val="Details"/>
+              </trans_set>
+              <data_layout_item name="description" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+              <data_layout_portal relationship="albums">
+                <data_layout_item name="name" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6" column_width="300"/>
+                </data_layout_item>
+                <data_layout_item name="year" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+              </data_layout_portal>
+              <data_layout_item name="comments" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="list" parent_table="artists">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="artist_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+            <data_layout_item name="description" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports/>
+    <print_layouts/>
+  </table>
+  <table name="publishers" overview_x="411" overview_y="235" title="Publishers">
+    <fields>
+      <field name="publishers_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Publisher ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="name" type="Text" title="Name">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      </field>
+    </fields>
+    <relationships>
+      <relationship name="albums" key="publishers_id" other_table="albums" other_key="publisher_id" title="Albums"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="details" parent_table="publishers">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_group name="overview" columns_count="2" title="Overview">
+              <trans_set>
+                <trans loc="de_DE" val="Overview"/>
+              </trans_set>
+              <data_layout_item name="publishers_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+              <data_layout_item name="name" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+            <data_layout_group name="details" title="Details">
+              <trans_set>
+                <trans loc="de_DE" val="Details"/>
+              </trans_set>
+              <data_layout_item name="comments" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+              <data_layout_portal relationship="albums">
+                <data_layout_item name="album_id" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+                <data_layout_item name="name" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="artist" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_portal>
+            </data_layout_group>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="list" parent_table="publishers">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="publishers_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports/>
+    <print_layouts/>
+  </table>
+  <table name="songs" overview_x="407" overview_y="7" title="Songs">
+    <fields>
+      <field name="songs_id" primary_key="true" unique="true" auto_increment="true" type="Number" title="Song ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      </field>
+      <field name="comments" type="Text" title="Comments">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline="true" format_text_multiline_height_lines="6"/>
+      </field>
+      <field name="album_id" type="Number" title="Album ID">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2"/>
+      </field>
+      <field name="name" type="Text" title="Name">
+        <calculation/>
+        <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+      </field>
+    </fields>
+    <relationships>
+      <relationship name="album" key="album_id" other_table="albums" other_key="album_id" title="Album"/>
+    </relationships>
+    <data_layouts>
+      <data_layout name="details" parent_table="songs">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_group name="overview" columns_count="2" title="Overview">
+              <trans_set>
+                <trans loc="de_DE" val="Overview"/>
+              </trans_set>
+              <data_layout_item name="songs_id" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2"/>
+              </data_layout_item>
+              <data_layout_item name="name" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+            <data_layout_group name="details" columns_count="2" title="Details">
+              <trans_set>
+                <trans loc="de_DE" val="Details"/>
+              </trans_set>
+              <data_layout_group name="album" title="Album">
+                <data_layout_item name="album_id" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="album" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_group name="artist" title="Album Artist">
+                <data_layout_item name="artist_id" relationship="album" related_relationship="artist" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2"/>
+                </data_layout_item>
+                <data_layout_item name="name" relationship="album" related_relationship="artist" editable="true" use_default_formatting="true">
+                  <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+                </data_layout_item>
+              </data_layout_group>
+              <data_layout_item name="comments" editable="true" use_default_formatting="true">
+                <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+              </data_layout_item>
+            </data_layout_group>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+      <data_layout name="list" parent_table="songs">
+        <data_layout_groups>
+          <data_layout_group name="main">
+            <data_layout_item name="songs_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+            </data_layout_item>
+            <data_layout_item name="comments" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+            <data_layout_item name="album_id" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2"/>
+            </data_layout_item>
+            <data_layout_item name="name" editable="true" use_default_formatting="true">
+              <formatting format_thousands_separator="true" format_decimal_places="2" format_text_multiline_height_lines="6"/>
+            </data_layout_item>
+          </data_layout_group>
+        </data_layout_groups>
+      </data_layout>
+    </data_layouts>
+    <reports/>
+    <print_layouts/>
+  </table>
+  <groups><!--These are only used when recreating a database from an example file. The actual access-control is on the server, of course.-->
+    <group name="glom_developer" developer="true"/>
+  </groups>
+  <library_modules/></glom_document>
[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]