mpserviceplugins/mpxsqlitedbhgplugin/inc/mpxdbpluginqueries.h
changeset 38 b93f525c9244
parent 35 fdb31ab341af
child 47 4cc1412daed0
equal deleted inserted replaced
37:eb79a7c355bf 38:b93f525c9244
   268     L"Corrupt INTEGER DEFAULT 0,"
   268     L"Corrupt INTEGER DEFAULT 0,"
   269     L"SaveDeletedRecordCount INTEGER DEFAULT 0)");
   269     L"SaveDeletedRecordCount INTEGER DEFAULT 0)");
   270 _LIT(KAuxiliaryDropTable,"DROP TABLE Auxiliary");
   270 _LIT(KAuxiliaryDropTable,"DROP TABLE Auxiliary");
   271 _LIT(KAuxiliaryCheckTable, "SELECT Id,Version,TimeRefreshed,TimeSynced,Corrupt,SaveDeletedRecordCount FROM AUXILIARY");
   271 _LIT(KAuxiliaryCheckTable, "SELECT Id,Version,TimeRefreshed,TimeSynced,Corrupt,SaveDeletedRecordCount FROM AUXILIARY");
   272 #ifdef ABSTRACTAUDIOALBUM_INCLUDED
   272 #ifdef ABSTRACTAUDIOALBUM_INCLUDED
   273 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.5.0',%u)");
   273 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.6.0',%u)");
   274 #else
   274 #else
   275 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.4.0',%u)");
   275 _LIT(KQueryAuxiliaryInsert, "INSERT INTO Auxiliary(Id,Version,Corrupt) VALUES(0,'6.6.1',%u)");
   276 #endif // ABSTRACTAUDIOALBUM_INCLUDED
   276 #endif // ABSTRACTAUDIOALBUM_INCLUDED
   277 _LIT(KQueryAuxiliarySetTime, "UPDATE :dbname.Auxiliary SET TimeRefreshed='%S', Corrupt=0");
   277 _LIT(KQueryAuxiliarySetTime, "UPDATE :dbname.Auxiliary SET TimeRefreshed='%S', Corrupt=0");
   278 _LIT(KQueryAuxiliaryGetTime, "SELECT TimeRefreshed FROM :dbname.Auxiliary");
   278 _LIT(KQueryAuxiliaryGetTime, "SELECT TimeRefreshed FROM :dbname.Auxiliary");
   279 _LIT(KQueryAuxiliarySetCorrupt, "UPDATE :dbname.Auxiliary SET Corrupt=%u");
   279 _LIT(KQueryAuxiliarySetCorrupt, "UPDATE :dbname.Auxiliary SET Corrupt=%u");
   280 _LIT(KQueryAuxiliaryGetCorrupt, "SELECT Corrupt FROM :dbname.Auxiliary");
   280 _LIT(KQueryAuxiliaryGetCorrupt, "SELECT Corrupt FROM :dbname.Auxiliary");
   425 
   425 
   426 // == Album table queries ==========================================
   426 // == Album table queries ==========================================
   427 //
   427 //
   428 _LIT(KAlbumCreateTable,"CREATE TABLE Album("
   428 _LIT(KAlbumCreateTable,"CREATE TABLE Album("
   429     L"UniqueId INTEGER PRIMARY KEY,"
   429     L"UniqueId INTEGER PRIMARY KEY,"
       
   430     L"ArtistName TEXT COLLATE NOCASE,"
   430     L"Name TEXT COLLATE NOCASE,"
   431     L"Name TEXT COLLATE NOCASE,"
   431     L"SongCount INTEGER,"
   432     L"SongCount INTEGER,"
   432     L"Artist INTEGER,"
   433 	L"Art TEXT)");
   433     L"Art TEXT)");
   434 
   434 
   435 _LIT(KAlbumCheckTable,"SELECT UniqueId,ArtistName,Name,SongCount,Art FROM Album");
   435 _LIT(KAlbumCheckTable,"SELECT UniqueId,Name,SongCount,Artist,Art FROM Album");
   436 
   436 
   437 _LIT(KQueryAlbumInsert, "INSERT INTO :dbname.Album(UniqueId,ArtistName,Name,SongCount,Art) VALUES(%u,'%S','%S',%u,'%S')");
   437 _LIT(KQueryAlbumInsert, "INSERT INTO :dbname.Album(UniqueId,Name,SongCount,Artist,Art) VALUES(%u,'%S',%u,%u,'%S')");
       
   438 _LIT(KQueryAlbumUpdate, "UPDATE :dbname.Album SET %S WHERE UniqueId=%u");
   438 _LIT(KQueryAlbumUpdate, "UPDATE :dbname.Album SET %S WHERE UniqueId=%u");
   439 
   439 
   440 _LIT(KQueryAlbumItem, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId AND UniqueId=%u");
   440 _LIT(KQueryAlbumItem, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId AND UniqueId=%u");
   441 _LIT(KQueryAlbumAll, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId ORDER BY 2");
   441 _LIT(KQueryAlbumAll, "SELECT Album.* FROM :dbname.Album ORDER BY Name");
   442 _LIT(KQueryAlbumAllMediaWall, "SELECT Album.*,Artist.Name FROM :dbname.Album,:dbname.Artist WHERE Album.Artist=Artist.UniqueId ORDER BY 6");
   442 _LIT(KQueryAlbumAllMediaWall, "SELECT Album.* FROM :dbname.Album ORDER BY ArtistName");
       
   443 _LIT(KCriterionArtistName, "ArtistName='%S'");
       
   444 _LIT(KCriterionArt, "Art='%S'");
       
   445 
   443 // == Artist table queries ==========================================
   446 // == Artist table queries ==========================================
   444 //
   447 //
   445 _LIT(KArtistCreateTable,"CREATE TABLE Artist("
   448 _LIT(KArtistCreateTable,"CREATE TABLE Artist("
   446     L"UniqueId INTEGER PRIMARY KEY,"
   449     L"UniqueId INTEGER PRIMARY KEY,"
   447     L"Name TEXT COLLATE NOCASE,"
   450     L"Name TEXT COLLATE NOCASE,"