| changeset 1 | 8118492f1bdf |
| parent 0 | ff3acec5bc43 |
| 0:ff3acec5bc43 | 1:8118492f1bdf |
|---|---|
64 _LIT(KQueryPodcastDeleteUpdate, "UPDATE :dbname.Podcast SET Deleted=1 WHERE UniqueId=%u"); |
64 _LIT(KQueryPodcastDeleteUpdate, "UPDATE :dbname.Podcast SET Deleted=1 WHERE UniqueId=%u"); |
65 _LIT(KQueryPodcastDeleteForCategory, "UPDATE :dbname.Podcast SET Deleted=0 WHERE %S=%u"); |
65 _LIT(KQueryPodcastDeleteForCategory, "UPDATE :dbname.Podcast SET Deleted=0 WHERE %S=%u"); |
66 _LIT(KQueryPodcastCleanup, "DELETE FROM :dbname.Podcast WHERE Deleted=1"); |
66 _LIT(KQueryPodcastCleanup, "DELETE FROM :dbname.Podcast WHERE Deleted=1"); |
67 |
67 |
68 _LIT(KQueryPodcastGetTitle, "SELECT Title FROM :dbname.Podcast WHERE Deleted=0 AND UniqueId=%u"); |
68 _LIT(KQueryPodcastGetTitle, "SELECT Title FROM :dbname.Podcast WHERE Deleted=0 AND UniqueId=%u"); |
69 _LIT(KQueryPodcastVolume, "SELECT VolumeId FROM :dbname.Podcast WHERE Deleted=0 AND UniqueId=%u"); |
69 _LIT(KQueryPodcastVolume, "SELECT VolumeId FROM :dbname.Podcast WHERE UniqueId=%u"); |
70 _LIT(KQueryPodcastAllVolumeIds, "SELECT VolumeId FROM :dbname.Podcast WHERE Deleted=0"); |
70 _LIT(KQueryPodcastAllVolumeIds, "SELECT VolumeId FROM :dbname.Podcast WHERE Deleted=0"); |
71 |
71 |
72 // LTAN-79N8ND/EVXG-7FABHC: temporary fix. Symbian 9.4 SQLite cannot resolve column number correctly, |
72 // LTAN-79N8ND/EVXG-7FABHC: temporary fix. Symbian 9.4 SQLite cannot resolve column number correctly, |
73 // Use column number instead of column name for ORDER BY, needed when FROM uses more than 1 table |
73 // Use column number instead of column name for ORDER BY, needed when FROM uses more than 1 table |
74 // calculate column number from SELECT fields, first field is column 1 (not 0) |
74 // calculate column number from SELECT fields, first field is column 1 (not 0) |
92 // As far as performance goes, the queries that only return five fields are a little faster than |
92 // As far as performance goes, the queries that only return five fields are a little faster than |
93 // the ones that return *, for example, for a * query that takes 2.1 seconds the equivalent |
93 // the ones that return *, for example, for a * query that takes 2.1 seconds the equivalent |
94 // optimized query is faster by more than 100ms. |
94 // optimized query is faster by more than 100ms. |
95 |
95 |
96 // categories included |
96 // categories included |
97 _LIT(KQueryPodcastGetEpisode, "SELECT Podcast.*,Artist.Name,Album.Name,Genre.Name,Composer.Name FROM :dbname.Podcast,:dbname.Artist,:dbname.Album,:dbname.Genre,:dbname.Composer WHERE Podcast.Deleted=0 AND Podcast.UniqueId=%u AND Podcast.Album=Album.UniqueId AND Podcast.Artist=Artist.UniqueId AND Podcast.Genre=Genre.UniqueId AND Podcast.Composer=Composer.UniqueId"); |
97 _LIT(KQueryPodcastGetEpisode, "SELECT Podcast.*,Artist.Name,Album.Name,Genre.Name,Composer.Name FROM :dbname.Podcast,:dbname.Artist,:dbname.Album,:dbname.Genre,:dbname.Composer WHERE Podcast.UniqueId=%u AND Podcast.Album=Album.UniqueId AND Podcast.Artist=Artist.UniqueId AND Podcast.Genre=Genre.UniqueId AND Podcast.Composer=Composer.UniqueId"); |
98 |
98 |
99 // LTAN-79N8ND/EVXG-7FABHC: temporary fix. Symbian 9.4 SQLite cannot resolve column number correctly, |
99 // LTAN-79N8ND/EVXG-7FABHC: temporary fix. Symbian 9.4 SQLite cannot resolve column number correctly, |
100 // Use column number instead of column name for ORDER BY, needed when FROM uses more than 1 table |
100 // Use column number instead of column name for ORDER BY, needed when FROM uses more than 1 table |
101 // calculate column number from SELECT fields, first field is column 1 (not 0) |
101 // calculate column number from SELECT fields, first field is column 1 (not 0) |
102 /* |
102 /* |