diff options
author | Minje Ahn <minje.ahn@samsung.com> | 2019-04-17 15:38:23 +0900 |
---|---|---|
committer | Minje ahn <minje.ahn@samsung.com> | 2019-04-17 06:38:04 +0000 |
commit | 9b2d3176f53bdbf0e886e1f86b03cc1e97b61a0d (patch) | |
tree | 8b7c998de7e17f1e44f57e70bd3d5a0ce8196c29 /src/include/common | |
parent | b16d577cfd24eebdf3a62a6872971e0a8a75b918 (diff) | |
download | libmedia-service-9b2d3176f53bdbf0e886e1f86b03cc1e97b61a0d.tar.gz libmedia-service-9b2d3176f53bdbf0e886e1f86b03cc1e97b61a0d.tar.bz2 libmedia-service-9b2d3176f53bdbf0e886e1f86b03cc1e97b61a0d.zip |
Match columns of media with filter keyword
Change-Id: I35daf16607f430225847d390489b0a3e7fc06d3e
Signed-off-by: Minje Ahn <minje.ahn@samsung.com>
Diffstat (limited to 'src/include/common')
-rwxr-xr-x | src/include/common/media-svc-env.h | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/include/common/media-svc-env.h b/src/include/common/media-svc-env.h index d81a713..231f909 100755 --- a/src/include/common/media-svc-env.h +++ b/src/include/common/media-svc-env.h @@ -114,11 +114,11 @@ extern "C" { #define MEDIA_SVC_DB_QUERY_VIEW_MEDIA "CREATE VIEW IF NOT EXISTS %s AS SELECT * from %s;" #define MEDIA_SVC_DB_QUERY_VIEW_PLAYLIST "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM playlist \ LEFT OUTER JOIN playlist_map ON playlist.playlist_id = playlist_map.playlist_id \ - LEFT OUTER JOIN media_view ON (playlist_map.media_uuid = media_view.media_uuid AND media_view.validity=1) \ + LEFT OUTER JOIN media_view ON (playlist_map.media_id = media_view.media_id AND media_view.validity=1) \ LEFT OUTER JOIN (SELECT count(playlist_id) as playlist_media_count, playlist_id FROM playlist_map group by playlist_id) as cnt_tbl ON (cnt_tbl.playlist_id=playlist_map.playlist_id AND media_view.validity=1);" #define MEDIA_SVC_DB_QUERY_VIEW_TAG "CREATE VIEW IF NOT EXISTS %s AS SELECT %s FROM tag \ LEFT OUTER JOIN tag_map ON tag.tag_id=tag_map.tag_id \ - LEFT OUTER JOIN media_view ON (tag_map.media_uuid = media_view.media_uuid AND media_view.validity=1) \ + LEFT OUTER JOIN media_view ON (tag_map.media_id = media_view.media_id AND media_view.validity=1) \ LEFT OUTER JOIN (SELECT count(tag_id) as tag_media_count, tag_id FROM tag_map group by tag_id) as cnt_tbl ON (cnt_tbl.tag_id=tag_map.tag_id AND media_view.validity=1);" #define MEDIA_SVC_DB_QUERY_ALTER_TABLE "ALTER TABLE %s ADD COLUMN %s;" #define MEDIA_SVC_DB_QUERY_DROP_VIEW "DROP VIEW IF EXISTS %s;" |