Revision: 41795
http://brlcad.svn.sourceforge.net/brlcad/?rev=41795&view=rev
Author: davidloman
Date: 2010-12-23 18:51:24 +0000 (Thu, 23 Dec 2010)
Log Message:
-----------
Check in a notes file and a sample SQLite db file.
Added Paths:
-----------
rt^3/trunk/src/other/sqlite_3_7_4/SQLiteAndGSNotes.txt
rt^3/trunk/src/other/sqlite_3_7_4/repo.db
Added: rt^3/trunk/src/other/sqlite_3_7_4/SQLiteAndGSNotes.txt
===================================================================
--- rt^3/trunk/src/other/sqlite_3_7_4/SQLiteAndGSNotes.txt
(rev 0)
+++ rt^3/trunk/src/other/sqlite_3_7_4/SQLiteAndGSNotes.txt 2010-12-23
18:51:24 UTC (rev 41795)
@@ -0,0 +1,6 @@
+Getting tag names from a Group of tags:
+SELECT t2.name FROM tags AS t1, tags AS t2, group_elements AS ge WHERE
t1.id=ge.grpid AND t2.id=ge.tagid AND t1.name="platform type"
+
+Getting RepoObject Paths from a Group of Tags:
+SELECT t2.name, ro.path FROM tags AS t1, tags AS t2, group_elements AS ge,
repoobjs AS ro, repoobjtags AS rot WHERE ro.id=rot.repoobjid AND
rot.tagid=t2.id AND t1.id=ge.grpid AND t2.id=ge.tagid AND t1.name="service"
+
Property changes on: rt^3/trunk/src/other/sqlite_3_7_4/SQLiteAndGSNotes.txt
___________________________________________________________________
Added: svn:mime-type
+ text/plain
Added: svn:eol-style
+ native
Added: rt^3/trunk/src/other/sqlite_3_7_4/repo.db
===================================================================
(Binary files differ)
Property changes on: rt^3/trunk/src/other/sqlite_3_7_4/repo.db
___________________________________________________________________
Added: svn:mime-type
+ application/octet-stream
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
BRL-CAD Source Commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/brlcad-commits
