equal
deleted
inserted
replaced
92 |
92 |
93 // parameters |
93 // parameters |
94 _LIT( KThumbnailSqlParamData, ":Data" ); |
94 _LIT( KThumbnailSqlParamData, ":Data" ); |
95 _LIT( KThumbnailSqlParamFlags, ":Flags" ); |
95 _LIT( KThumbnailSqlParamFlags, ":Flags" ); |
96 _LIT( KThumbnailSqlParamPath, ":Path" ); |
96 _LIT( KThumbnailSqlParamPath, ":Path" ); |
|
97 _LIT( KThumbnailSqlParamNewPath, ":NewPath" ); |
97 _LIT( KThumbnailSqlParamWidth, ":Width" ); |
98 _LIT( KThumbnailSqlParamWidth, ":Width" ); |
98 _LIT( KThumbnailSqlParamHeight, ":Height" ); |
99 _LIT( KThumbnailSqlParamHeight, ":Height" ); |
99 _LIT( KThumbnailSqlParamOriginalWidth, ":OrigWidth" ); |
100 _LIT( KThumbnailSqlParamOriginalWidth, ":OrigWidth" ); |
100 _LIT( KThumbnailSqlParamOriginalHeight, ":OrigHeight" ); |
101 _LIT( KThumbnailSqlParamOriginalHeight, ":OrigHeight" ); |
101 _LIT( KThumbnailSqlParamFormat, ":Format" ); |
102 _LIT( KThumbnailSqlParamFormat, ":Format" ); |
197 |
198 |
198 _LIT8( KThumbnailSqlDeleteFromDeleted, "DELETE FROM ThumbnailDeleted " |
199 _LIT8( KThumbnailSqlDeleteFromDeleted, "DELETE FROM ThumbnailDeleted " |
199 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailInfo " |
200 "WHERE NOT EXISTS (SELECT Path FROM ThumbnailInfo " |
200 "WHERE ThumbnailDeleted.Path = ThumbnailInfo.Path);" ); |
201 "WHERE ThumbnailDeleted.Path = ThumbnailInfo.Path);" ); |
201 |
202 |
|
203 // rename thumb |
|
204 _LIT8( KThumbnailRename, "UPDATE ThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
|
205 _LIT8( KThumbnailTempRename, "UPDATE TempThumbnailInfo SET Path = :NewPath WHERE Path = :Path;" ); |
|
206 |
202 // reset blacklisted |
207 // reset blacklisted |
203 _LIT8( KThumbnailTouchBlacklistedRows, "UPDATE ThumbnailInfo SET Modified = 0 WHERE Flags & :Flag" ); |
208 _LIT8( KThumbnailTouchBlacklistedRows, "UPDATE ThumbnailInfo SET Modified = 0 WHERE Flags & :Flag" ); |
204 |
209 |
205 // existence check |
210 // existence check |
206 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |
211 _LIT8( KThumbnailSelectAllPaths, "SELECT ThumbnailInfo.RowID,Path FROM ThumbnailInfo " |