Mercurial Mercurial > oss > FCL > sf > mw > imghandling / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
imagehandlingutilities/thumbnailmanager/thumbnailserver/inc/thumbnailsql.h
changeset 14 2edacbf5d3f9
parent 0 2014ca87e772
child 15 7197e789b953
equal deleted inserted replaced
1:235a7fc86938 14:2edacbf5d3f9 
    51         "Modified LARGEINT);");
 
    51         "Modified LARGEINT);");
 
    52         
    52         
    53 _LIT8( KThumbnailCreateInfoDataTable, "CREATE TABLE ThumbnailInfoData ("
 
    53 _LIT8( KThumbnailCreateInfoDataTable, "CREATE TABLE ThumbnailInfoData ("
 
    54         // If Thumbnail is stored in SQL then Data is NOT NULL
 
    54         // If Thumbnail is stored in SQL then Data is NOT NULL
 
    55         "Data BLOB);");
 
    55         "Data BLOB);");
 
    56 		
       
    57 //Create index for speedup DB searches 
       
    58 _LIT8( KThumbnailCreateInfoTableIndex1, "CREATE INDEX idx1 ON ThumbnailInfo(Path, Size);");
 
       
    59 _LIT8( KThumbnailCreateInfoTableIndex2, "CREATE INDEX idx2 ON ThumbnailInfo(TNId, Size);");
 
       
    60 
    56 
    61 //temp table is identical to actual main table except it's not persistent
 
    57 //temp table is identical to actual main table except it's not persistent
 
    62 _LIT8( KThumbnailCreateTempInfoTable, "CREATE TEMP TABLE TempThumbnailInfo ("
 
    58 _LIT8( KThumbnailCreateTempInfoTable, "CREATE TEMP TABLE TempThumbnailInfo ("
 
    63         "Path TEXT COLLATE NOCASE,"
 
    59         "Path TEXT COLLATE NOCASE,"
 
    64         "TNId INTEGER,"
 
    60         "TNId INTEGER,"
 
    83 _LIT8( KThumbnailVersionTable, "CREATE TABLE ThumbnailVersion ("
 
    79 _LIT8( KThumbnailVersionTable, "CREATE TABLE ThumbnailVersion ("
 
    84         "Major INTEGER,"
 
    80         "Major INTEGER,"
 
    85         "Minor INTEGER,"
 
    81         "Minor INTEGER,"
 
    86         "IMEI TEXT COLLATE NOCASE);");
 
    82         "IMEI TEXT COLLATE NOCASE);");
 
    87 
    83 
       
    84 // deleted thumbs table
 
       
    85 _LIT8( KThumbnailDeletedTable, "CREATE TABLE ThumbnailDeleted ("
 
       
    86         // Assosiacted object in file system
 
       
    87         "Path TEXT UNIQUE COLLATE NOCASE);");
 
       
    88 
       
    89 //Create index for speedup DB searches 
       
    90 _LIT8( KThumbnailCreateInfoTableIndex1, "CREATE INDEX idx1 ON ThumbnailInfo(Path, Size);");
 
       
    91 _LIT8( KThumbnailCreateDeletedTableIndex, "CREATE INDEX idx4 ON ThumbnailDeleted(Path);");
 
       
    92 
    88 _LIT8( KThumbnailMoveFromTempInfoToMainTable, "INSERT INTO ThumbnailInfo SELECT * FROM TempThumbnailInfo;");
 
    93 _LIT8( KThumbnailMoveFromTempInfoToMainTable, "INSERT INTO ThumbnailInfo SELECT * FROM TempThumbnailInfo;");
 
    89 _LIT8( KThumbnailMoveFromTempDataToMainTable, "INSERT INTO ThumbnailInfoData SELECT * FROM TempThumbnailInfoData;");
 
    94 _LIT8( KThumbnailMoveFromTempDataToMainTable, "INSERT INTO ThumbnailInfoData SELECT * FROM TempThumbnailInfoData;");
 
    90 
    95 
    91 _LIT8( KThumbnailDeleteFromTempInfoTable, "DELETE FROM TempThumbnailInfo;");
 
    96 _LIT8( KThumbnailDeleteFromTempInfoTable, "DELETE FROM TempThumbnailInfo;");
 
    92 _LIT8( KThumbnailDeleteFromTempDataTable, "DELETE FROM TempThumbnailInfoData;");
 
    97 _LIT8( KThumbnailDeleteFromTempDataTable, "DELETE FROM TempThumbnailInfoData;");
 
   102 _LIT8( KThumbnailBeginTransaction, "BEGIN TRANSACTION;" );
 
   107 _LIT8( KThumbnailBeginTransaction, "BEGIN TRANSACTION;" );
 
   103 _LIT8( KThumbnailCommitTransaction, "COMMIT;" );
 
   108 _LIT8( KThumbnailCommitTransaction, "COMMIT;" );
 
   104 _LIT8( KThumbnailRollbackTransaction, "ROLLBACK;" );
 
   109 _LIT8( KThumbnailRollbackTransaction, "ROLLBACK;" );
 
   105 
   110 
   106 _LIT8( KThumbnailInsertThumbnailInfoByPathAndId, "INSERT INTO TempThumbnailInfo "
 
   111 _LIT8( KThumbnailInsertThumbnailInfoByPathAndId, "INSERT INTO TempThumbnailInfo "
 
   107     "(Path,TNId,Size,Format,Width,Height,OrigWidth,OrigHeight,Flags,Orientation,ThumbFromPath,Modified) ""VALUES "
 
   112     "(Path,Size,Format,Width,Height,OrigWidth,OrigHeight,Flags,Orientation,ThumbFromPath,Modified) ""VALUES "
 
   108     "(:Path,:TNId,:Size,:Format,:Width,:Height,:OrigWidth,:OrigHeight,:Flags,:Orient,:ThumbFromPath,:Modified);" );
 
   113     "(:Path,:Size,:Format,:Width,:Height,:OrigWidth,:OrigHeight,:Flags,:Orient,:ThumbFromPath,:Modified);" );
 
   109 
   114 
   110 _LIT8( KThumbnailInsertTempThumbnailInfoData, "INSERT INTO TempThumbnailInfoData (Data) VALUES (:Data);" );
 
   115 _LIT8( KThumbnailInsertTempThumbnailInfoData, "INSERT INTO TempThumbnailInfoData (Data) VALUES (:Data);" );
 
   111 
   116 
   112 _LIT8( KThumbnailSelectSizeByPath, "SELECT Size, TNId FROM ThumbnailInfo WHERE Path = :Path ORDER BY Size DESC;" );
 
   117 _LIT8( KThumbnailSelectSizeByPath, "SELECT Size FROM ThumbnailInfo "
 
   113 
   118         "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted "
 
   114 _LIT8( KThumbnailSelectTempSizeByPath, "SELECT Size, TNId FROM TempThumbnailInfo WHERE Path = :Path ORDER BY Size DESC;" );
 
   119         "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) "
 
   115 
   120         "AND Path = :Path ORDER BY Size DESC;" );
 
   116 _LIT8( KThumbnailSelectById, "SELECT * "
 
   121 
   117         "FROM ThumbnailInfo "
 
   122 _LIT8( KThumbnailSelectTempSizeByPath, "SELECT Size FROM TempThumbnailInfo WHERE Path = :Path ORDER BY Size DESC;" );
 
   118         "JOIN ThumbnailInfoData "
 
       
   119         "ON ThumbnailInfo.RowID = ThumbnailInfoData.RowID "
 
       
   120         "WHERE TNId = :TNId" );
 
       
   121 
       
   122 _LIT8( KThumbnailSelectTempById, "SELECT * "
 
       
   123         "FROM TempThumbnailInfo "
 
       
   124         "JOIN TempThumbnailInfoData "
 
       
   125         "ON TempThumbnailInfo.RowID = TempThumbnailInfoData.RowID "
 
       
   126         "WHERE TNId = :TNId" );
 
       
   127 
   123 
   128 //query by Path
 
   124 //query by Path
 
   129 _LIT8( KThumbnailSelectInfoByPath, "SELECT ThumbnailInfo.Format, ThumbnailInfoData.Data, ThumbnailInfo.Width, ThumbnailInfo.Height, ThumbnailInfo.Flags "
 
   125 _LIT8( KThumbnailSelectInfoByPath, "SELECT ThumbnailInfo.Format, ThumbnailInfoData.Data, ThumbnailInfo.Width, ThumbnailInfo.Height, ThumbnailInfo.Flags "
 
   130         "FROM ThumbnailInfo "
 
   126         "FROM ThumbnailInfo "
 
   131         "JOIN ThumbnailInfoData "
 
   127         "JOIN ThumbnailInfoData "
 
   132         "ON ThumbnailInfo.RowID = ThumbnailInfoData.RowID "
 
   128         "ON ThumbnailInfo.RowID = ThumbnailInfoData.RowID "
 
   133         "WHERE ThumbnailInfo.Path = :Path AND ThumbnailInfo.Size = :Size;");
 
   129         "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted "
 
       
   130         "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) " 
       
   131         "AND ThumbnailInfo.Path = :Path AND ThumbnailInfo.Size = :Size;");
 
   134 
   132 
   135 _LIT8( KThumbnailSelectTempInfoByPath, "SELECT TempThumbnailInfo.Format, TempThumbnailInfoData.Data, TempThumbnailInfo.Width, TempThumbnailInfo.Height, TempThumbnailInfo.Flags "
 
   133 _LIT8( KThumbnailSelectTempInfoByPath, "SELECT TempThumbnailInfo.Format, TempThumbnailInfoData.Data, TempThumbnailInfo.Width, TempThumbnailInfo.Height, TempThumbnailInfo.Flags "
 
   136         "FROM TempThumbnailInfo "
 
   134         "FROM TempThumbnailInfo "
 
   137         "JOIN TempThumbnailInfoData "
 
   135         "JOIN TempThumbnailInfoData "
 
   138         "ON TempThumbnailInfo.RowID = TempThumbnailInfoData.RowID "
 
   136         "ON TempThumbnailInfo.RowID = TempThumbnailInfoData.RowID "
 
   139         "WHERE TempThumbnailInfo.Path = :Path AND TempThumbnailInfo.Size = :Size;");
 
   137         "WHERE TempThumbnailInfo.Path = :Path AND TempThumbnailInfo.Size = :Size;");
 
   140 
   138 
   141 //query by Id
 
       
   142 _LIT8( KThumbnailSelectInfoById, "SELECT ThumbnailInfo.Format, ThumbnailInfoData.Data, ThumbnailInfo.Width, ThumbnailInfo.Height, ThumbnailInfo.Flags "
 
       
   143         "FROM ThumbnailInfo "
 
       
   144         "JOIN ThumbnailInfoData "
 
       
   145         "ON ThumbnailInfo.RowID = ThumbnailInfoData.RowID "
 
       
   146         "WHERE TNId = :TNId AND Size = :Size;" );
 
       
   147 
       
   148 _LIT8( KThumbnailSelectTempInfoById, "SELECT TempThumbnailInfo.Format, TempThumbnailInfoData.Data, TempThumbnailInfo.Width, TempThumbnailInfo.Height, TempThumbnailInfo.Flags "
 
       
   149         "FROM TempThumbnailInfo "
 
       
   150         "JOIN TempThumbnailInfoData "
 
       
   151         "ON TempThumbnailInfo.RowID = TempThumbnailInfoData.RowID "
 
       
   152         "WHERE TNId = :TNId AND Size = :Size;" );
 
       
   153 		
       
   154 //query by Idv2
 
       
   155 _LIT8( KThumbnailSelectInfoByIdv2, "SELECT ThumbnailInfo.Format, ThumbnailInfoData.Data, ThumbnailInfo.Width, ThumbnailInfo.Height, ThumbnailInfo.Flags "
 
       
   156         "FROM ThumbnailInfo "
 
       
   157         "JOIN ThumbnailInfoData "
 
       
   158         "ON ThumbnailInfo.RowID = ThumbnailInfoData.RowID "
 
       
   159         "WHERE TNId = :TNId AND (Size = :SizeImage OR Size = :SizeVideo OR Size = :SizeAudio);" );
 
       
   160 
       
   161 _LIT8( KThumbnailSelectTempInfoByIdv2, "SELECT TempThumbnailInfo.Format, TempThumbnailInfoData.Data, TempThumbnailInfo.Width, TempThumbnailInfo.Height, TempThumbnailInfo.Flags "
 
       
   162         "FROM TempThumbnailInfo "
 
       
   163         "JOIN TempThumbnailInfoData "
 
       
   164         "ON TempThumbnailInfo.RowID = TempThumbnailInfoData.RowID "
 
       
   165         "WHERE TNId = :TNId AND (Size = :SizeImage OR Size = :SizeVideo OR Size = :SizeAudio);" );		
       
   166 
   139 
   167 _LIT8( KThumbnailSelectSettings, "SELECT Version FROM ThumbnailSettings;" );
 
   140 _LIT8( KThumbnailSelectSettings, "SELECT Version FROM ThumbnailSettings;" );
 
   168 
   141 
   169 //qyery Path by ID
 
       
   170 _LIT8( KThumbnailSelectPathByID, "SELECT Path FROM ThumbnailInfo WHERE TNId = :TNId;"  );
 
       
   171 _LIT8( KThumbnailSelectTempPathByID, "SELECT Path FROM TempThumbnailInfo WHERE TNId = :TNId;");
 
       
   172 
       
   173 //query Path and Modified by ID
 
       
   174 _LIT8( KThumbnailSelectPathModifiedByID, "SELECT Path, Modified FROM ThumbnailInfo WHERE TNId = :TNId;"  );
 
       
   175 _LIT8( KThumbnailSelectTempPathModifiedByID, "SELECT Path, Modified FROM TempThumbnailInfo WHERE TNId = :TNId;");
 
       
   176 
   142 
   177 _LIT( KThumbnailSqlParamData, ":Data" );
 
   143 _LIT( KThumbnailSqlParamData, ":Data" );
 
   178 _LIT( KThumbnailSqlParamFlags, ":Flags" );
 
   144 _LIT( KThumbnailSqlParamFlags, ":Flags" );
 
   179 _LIT( KThumbnailSqlParamPath, ":Path" );
 
   145 _LIT( KThumbnailSqlParamPath, ":Path" );
 
   180 _LIT( KThumbnailSqlParamWidth, ":Width" );
 
   146 _LIT( KThumbnailSqlParamWidth, ":Width" );
 
   181 _LIT( KThumbnailSqlParamHeight, ":Height" );
 
   147 _LIT( KThumbnailSqlParamHeight, ":Height" );
 
   182 _LIT( KThumbnailSqlParamOriginalWidth, ":OrigWidth" );
 
   148 _LIT( KThumbnailSqlParamOriginalWidth, ":OrigWidth" );
 
   183 _LIT( KThumbnailSqlParamOriginalHeight, ":OrigHeight" );
 
   149 _LIT( KThumbnailSqlParamOriginalHeight, ":OrigHeight" );
 
   184 _LIT( KThumbnailSqlParamFormat, ":Format" );
 
   150 _LIT( KThumbnailSqlParamFormat, ":Format" );
 
   185 _LIT( KThumbnailSqlParamId, ":TNId" );
 
       
   186 _LIT( KThumbnailSqlParamSize, ":Size" );
 
   151 _LIT( KThumbnailSqlParamSize, ":Size" );
 
   187 _LIT( KThumbnailSqlParamTNPath, ":TNPath" );
 
   152 _LIT( KThumbnailSqlParamTNPath, ":TNPath" );
 
   188 _LIT( KThumbnailSqlParamMajor, ":Major" );
 
   153 _LIT( KThumbnailSqlParamMajor, ":Major" );
 
   189 _LIT( KThumbnailSqlParamMinor, ":Minor" );
 
   154 _LIT( KThumbnailSqlParamMinor, ":Minor" );
 
   190 _LIT( KThumbnailSqlParamImei, ":IMEI" );
 
   155 _LIT( KThumbnailSqlParamImei, ":IMEI" );
 
   194 _LIT( KThumbnailSqlParamRowID, ":RowID" );
 
   159 _LIT( KThumbnailSqlParamRowID, ":RowID" );
 
   195 _LIT( KThumbnailSqlParamOrientation, ":Orient" );
 
   160 _LIT( KThumbnailSqlParamOrientation, ":Orient" );
 
   196 _LIT( KThumbnailSqlParamThumbFromPath, ":ThumbFromPath" );
 
   161 _LIT( KThumbnailSqlParamThumbFromPath, ":ThumbFromPath" );
 
   197 _LIT( KThumbnailSqlParamModified, ":Modified" );
 
   162 _LIT( KThumbnailSqlParamModified, ":Modified" );
 
   198 _LIT( KThumbnailSqlParamFlag, ":Flag" );
 
   163 _LIT( KThumbnailSqlParamFlag, ":Flag" );
 
       
   164 _LIT( KThumbnailSqlParamLimit, ":Limit" );
 
   199 
   165 
   200 //Delete by path
 
   166 //Delete by path
 
   201 _LIT8( KThumbnailSqlSelectRowIDInfoByPath, "SELECT ThumbnailInfo.RowID FROM ThumbnailInfo WHERE Path = :Path;" );
 
   167 _LIT8( KThumbnailSqlSelectRowIDInfoByPath, "SELECT ThumbnailInfo.RowID FROM ThumbnailInfo WHERE Path = :Path;" );
 
   202 _LIT8( KThumbnailSqlDeleteInfoByPath, "DELETE FROM ThumbnailInfo WHERE ThumbnailInfo.RowID = :RowID;" );
 
   168 _LIT8( KThumbnailSqlDeleteInfoByPath, "DELETE FROM ThumbnailInfo WHERE ThumbnailInfo.RowID = :RowID;" );
 
   203 _LIT8( KThumbnailSqlDeleteInfoDataByPath, "DELETE FROM ThumbnailInfoData WHERE ThumbnailInfoData.RowID = :RowID;" );
 
   169 _LIT8( KThumbnailSqlDeleteInfoDataByPath, "DELETE FROM ThumbnailInfoData WHERE ThumbnailInfoData.RowID = :RowID;" );
 
   204 _LIT8( KTempThumbnailSqlSelectRowIDInfoByPath, "SELECT TempThumbnailInfo.RowID FROM TempThumbnailInfo WHERE Path = :Path LIMIT 1;" );
 
   170 _LIT8( KTempThumbnailSqlSelectRowIDInfoByPath, "SELECT TempThumbnailInfo.RowID FROM TempThumbnailInfo WHERE Path = :Path LIMIT 1;" );
 
   205 _LIT8( KTempThumbnailSqlDeleteInfoByPath, "DELETE FROM TempThumbnailInfo WHERE TempThumbnailInfo.RowID = :RowID;" );
 
   171 _LIT8( KTempThumbnailSqlDeleteInfoByPath, "DELETE FROM TempThumbnailInfo WHERE TempThumbnailInfo.RowID = :RowID;" );
 
   206 _LIT8( KTempThumbnailSqlDeleteInfoDataByPath, "DELETE FROM TempThumbnailInfoData WHERE TempThumbnailInfoData.RowID = :RowID;" );
 
   172 _LIT8( KTempThumbnailSqlDeleteInfoDataByPath, "DELETE FROM TempThumbnailInfoData WHERE TempThumbnailInfoData.RowID = :RowID;" );
 
   207 
   173 
   208 
   174 
   209 //Delete by ID
 
   175 // insert to deleted
 
   210 _LIT8( KThumbnailSqlSelectRowIDInfoByID, "SELECT ThumbnailInfo.RowID FROM ThumbnailInfo WHERE TNId = :TNId;" );
 
   176 _LIT8( KThumbnailSqlInsertDeleted, "INSERT INTO ThumbnailDeleted (Path) VALUES (:Path);" );
 
   211 _LIT8( KThumbnailSqlDeleteInfoByID, "DELETE FROM ThumbnailInfo WHERE ThumbnailInfo.RowID = :RowID;" );
 
   177 _LIT8 ( KThumbnailSqlFindDeleted, "SELECT * FROM ThumbnailDeleted WHERE Path = :Path;" );
 
   212 _LIT8( KThumbnailSqlDeleteInfoDataByID, "DELETE FROM ThumbnailInfoData WHERE ThumbnailInfoData.RowID = :RowID;" );
 
   178 
   213 _LIT8( KTempThumbnailSqlSelectRowIDInfoByID, "SELECT TempThumbnailInfo.RowID FROM TempThumbnailInfo WHERE TNId = :TNId LIMIT 1;" );
 
   179 // delete marked
 
   214 _LIT8( KTempThumbnailSqlDeleteInfoByID, "DELETE FROM TempThumbnailInfo WHERE TempThumbnailInfo.RowID = :RowID;" );
 
   180 _LIT8( KThumbnailSqlSelectMarked, "SELECT ThumbnailInfo.RowID FROM ThumbnailInfo "
 
   215 _LIT8( KTempThumbnailSqlDeleteInfoDataByID, "DELETE FROM TempThumbnailInfoData WHERE TempThumbnailInfoData.RowID = :RowID;" );
 
   181         "WHERE EXISTS (SELECT Path FROM ThumbnailDeleted "
 
   216 
   182         "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) LIMIT :Limit;" );
 
   217 
   183 _LIT8( KThumbnailSqlDeleteInfoByRowID, "DELETE FROM ThumbnailInfo WHERE ThumbnailInfo.RowID = :RowID;" );
 
   218 //Update path by Id
 
   184 _LIT8( KThumbnailSqlDeleteInfoDataByRowID, "DELETE FROM ThumbnailInfoData WHERE ThumbnailInfoData.RowID = :RowID;" );
 
   219 _LIT8( KTempThumbnailSqlUpdateById, "UPDATE TempThumbnailInfo SET Path = :Path WHERE TNId = :TNId" );
 
   185 _LIT8( KThumbnailSqlDeleteFromDeleted, "DELETE FROM ThumbnailDeleted "
 
   220 _LIT8( KThumbnailSqlUpdateById, "UPDATE ThumbnailInfo SET Path = :Path WHERE TNId = :TNId" );
 
   186         "WHERE NOT EXISTS (SELECT Path FROM ThumbnailInfo "
 
       
   187         "WHERE ThumbnailDeleted.Path = ThumbnailInfo.Path);" );
 
       
   188 
   221 
   189 
   222 //version commands
 
   190 //version commands
 
   223 _LIT8( KThumbnailInsertToVersion, "INSERT INTO ThumbnailVersion (IMEI, Minor, Major) VALUES (:IMEI, :Minor,:Major);" );
 
   191 _LIT8( KThumbnailInsertToVersion, "INSERT INTO ThumbnailVersion (IMEI, Minor, Major) VALUES (:IMEI, :Minor,:Major);" );
 
   224 _LIT8( KThumbnailSelectFromVersion, "SELECT * FROM ThumbnailVersion LIMIT 1" );
 
   192 _LIT8( KThumbnailSelectFromVersion, "SELECT * FROM ThumbnailVersion LIMIT 1" );
 
   225 
   193 
   228 _LIT8( KThumbnailResetIDs, "UPDATE ThumbnailInfo SET TNId = NULL WHERE TNId NOT NULL" );
 
   196 _LIT8( KThumbnailResetIDs, "UPDATE ThumbnailInfo SET TNId = NULL WHERE TNId NOT NULL" );
 
   229 
   197 
   230 //update IMEI
 
   198 //update IMEI
 
   231 _LIT8( KThumbnailUpdateIMEI, "UPDATE ThumbnailVersion SET IMEI = :IMEI" );
 
   199 _LIT8( KThumbnailUpdateIMEI, "UPDATE ThumbnailVersion SET IMEI = :IMEI" );
 
   232 
   200 
   233 //update ID by Path
 
       
   234 _LIT8( KTempThumbnailUpdateIdByPath, "UPDATE TempThumbnailInfo SET TNId = :TNId WHERE Path = :Path" );
 
       
   235 _LIT8( KThumbnailUpdateIdByPath, "UPDATE ThumbnailInfo SET TNId = :TNId WHERE Path = :Path" );
 
       
   236 
       
   237 //qyery Modification timestamp by ID
 
       
   238 _LIT8( KThumbnailSelectModifiedByID, "SELECT Modified FROM ThumbnailInfo WHERE TNId = :TNId AND ThumbFromPath = 1 LIMIT 1"  );
 
       
   239 _LIT8( KThumbnailSelectTempModifiedByID, "SELECT Modified FROM TempThumbnailInfo WHERE TNId = :TNId AND ThumbFromPath = 1 LIMIT 1");
 
       
   240 
       
   241 //query Modification timestamp by path
 
   201 //query Modification timestamp by path
 
   242 _LIT8( KThumbnailSelectModifiedByPath, "SELECT Modified FROM ThumbnailInfo WHERE Path = :Path"  );
 
   202 _LIT8( KThumbnailSelectModifiedByPath, "SELECT Modified FROM ThumbnailInfo WHERE Path = :Path"  );
 
   243 _LIT8( KThumbnailSelectTempModifiedByPath, "SELECT Modified FROM TempThumbnailInfo WHERE Path = :Path");
 
   203 _LIT8( KThumbnailSelectTempModifiedByPath, "SELECT Modified FROM TempThumbnailInfo WHERE Path = :Path");
 
   244 
   204 
   245 // query possible duplicates
 
   205 // query possible duplicates
 
   246 _LIT8 ( KTempFindDuplicate, "SELECT Path FROM TempThumbnailInfo WHERE Size = :Size AND (TNId = :TNId OR Path = :Path);" );
 
   206 _LIT8 ( KTempFindDuplicate, "SELECT Path FROM TempThumbnailInfo WHERE Path = :Path AND Size = :Size;" );
 
   247 _LIT8 ( KFindDuplicate, "SELECT Path FROM ThumbnailInfo WHERE Size = :Size AND (TNId = :TNId OR Path = :Path);" );
 
   207 _LIT8 ( KFindDuplicate, "SELECT Path FROM ThumbnailInfo WHERE Path = :Path AND Size = :Size;" );
 
   248 
   208 
   249 // check rowIDs
 
   209 // check rowIDs
 
   250 _LIT8 ( KGetInfoRowID, "SELECT MAX (ThumbnailInfo.rowID) FROM ThumbnailInfo" );
 
   210 _LIT8 ( KGetInfoRowID, "SELECT MAX (ThumbnailInfo.rowID) FROM ThumbnailInfo" );
 
   251 _LIT8 ( KGetDataRowID, "SELECT MAX (ThumbnailInfoData.rowID) FROM ThumbnailInfoData" );
 
   211 _LIT8 ( KGetDataRowID, "SELECT MAX (ThumbnailInfoData.rowID) FROM ThumbnailInfoData" );
 
   252 
   212 
   253 //remove KThumbnailDbFlagBlacklisted flag
 
   213 //remove KThumbnailDbFlagBlacklisted flag
 
   254 _LIT8( KThumbnailRemoveBlacklistedFlag, "UPDATE ThumbnailInfo SET Flags = Flags & ~:Flag WHERE Flags & :Flag" );
 
   214 _LIT8( KThumbnailTouchBlacklistedRows, "UPDATE ThumbnailInfo SET Modified = 0 WHERE Flags & :Flag" );
 
       
   215 
       
   216 // existence check
 
       
   217 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo "
 
       
   218         "WHERE NOT EXISTS (SELECT Path FROM ThumbnailDeleted "
 
       
   219         "WHERE ThumbnailInfo.Path = ThumbnailDeleted.Path) "
 
       
   220         "AND ThumbnailInfo.RowID > :RowID ORDER BY ThumbnailInfo.RowID ASC LIMIT :Limit;" );
 
   255 
   221 
   256 #endif // THUMBNAILSQL_H
 
   222 #endif // THUMBNAILSQL_H
FCL/sf/mw/imghandling