tracker r2627 - in branches/turtle: . data/db



Author: ifrade
Date: Mon Dec  1 15:11:00 2008
New Revision: 2627
URL: http://svn.gnome.org/viewvc/tracker?rev=2627&view=rev

Log:
Retrieve service type of the files to backup

Modified:
   branches/turtle/ChangeLog
   branches/turtle/data/db/sqlite-stored-procs.sql

Modified: branches/turtle/data/db/sqlite-stored-procs.sql
==============================================================================
--- branches/turtle/data/db/sqlite-stored-procs.sql	(original)
+++ branches/turtle/data/db/sqlite-stored-procs.sql	Mon Dec  1 15:11:00 2008
@@ -62,7 +62,7 @@
 /*
  * Metadata/MIME queries
  */
-GetEmbeddedMetadataBackup      SELECT S.Path || '/' || S.Name, F.MetadataID, F.MetadataDisplay From Services S, ServiceMetadata F WHERE (S.ID == F.ServiceID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0)) UNION SELECT S.Path || '/' || S.Name, F.MetadataID, F.MetadataValue From Services S, ServiceNumericMetadata F WHERE (S.ID == F.ServiceID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0)) UNION SELECT S.Path || '/' || S.Name, F.MetadataID, F.MetadataValue From Services S, ServiceKeywordMetadata F WHERE (S.ID == F.ServiceID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0));
+GetEmbeddedMetadataBackup      SELECT S.Path || '/' || S.Name, T.TypeName, F.MetadataID, F.MetadataDisplay From Services S, ServiceMetadata F, ServiceTypes T WHERE (S.ID == F.ServiceID) AND (S.ServiceTypeID == T.TypeID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0)) UNION SELECT S.Path || '/' || S.Name, T.TypeName, F.MetadataID, upper(F.MetadataValue) From Services S, ServiceNumericMetadata F, ServiceTypes T WHERE (S.ID == F.ServiceID) AND (S.ServiceTypeID == T.TypeID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0)) UNION SELECT S.Path || '/' || S.Name, T.Typename, F.MetadataID, F.MetadataValue From Services S, ServiceKeywordMetadata F, ServiceTypes T WHERE (S.ID == F.ServiceID) AND (S.ServiceTypeID == T.TypeID) AND (F.MetadataID IN (SELECT ID From MetadataTypes WHERE Embedded = 0));
 GetAllMetadata                 SELECT MetadataID, MetadataDisplay FROM ServiceMetadata WHERE ServiceID = ? UNION SELECT MetadataID, MetadataValue FROM ServiceKeywordMetadata WHERE ServiceID = ? UNION SELECT MetadataID, upper(MetadataValue) FROM ServiceNumericMetadata WHERE ServiceID = ?;
 GetMetadata                    SELECT MetaDataDisplay FROM ServiceMetaData WHERE ServiceID = ? AND MetaDataID = ?;
 GetMetadataAliases             SELECT DISTINCT M.MetaName, M.ID FROM MetaDataTypes M, MetaDataChildren C WHERE M.ID = C.ChildID AND C.MetaDataID = ?; 



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]