diff options
| author | CrystalP <crystalp@kodi.tv> | 2023-12-06 20:32:00 -0500 |
|---|---|---|
| committer | CrystalP <crystalp@kodi.tv> | 2023-12-07 21:03:25 -0500 |
| commit | db28c267dc12efcd962586ad0c460b8b2af3fa55 (patch) | |
| tree | f51004699bae17d5fcf51396a393d988738d96c3 | |
| parent | 91bfec1b8ffd438961328c0fd7a9001cb575e210 (diff) | |
[VideoDB] cosmetic - reindent the query to make Jenkins happy
| -rw-r--r-- | xbmc/video/VideoDatabase.cpp | 74 |
1 files changed, 37 insertions, 37 deletions
diff --git a/xbmc/video/VideoDatabase.cpp b/xbmc/video/VideoDatabase.cpp index e56ff201d6..a8e460d84d 100644 --- a/xbmc/video/VideoDatabase.cpp +++ b/xbmc/video/VideoDatabase.cpp @@ -549,43 +549,43 @@ void CVideoDatabase::CreateViews() CLog::Log(LOGINFO, "create movie_view"); std::string movieview = PrepareSQL("CREATE VIEW movie_view AS SELECT" - " movie.*," - " sets.strSet AS strSet," - " sets.strOverview AS strSetOverview," - " files.strFileName AS strFileName," - " path.strPath AS strPath," - " files.playCount AS playCount," - " files.lastPlayed AS lastPlayed, " - " files.dateAdded AS dateAdded, " - " bookmark.timeInSeconds AS resumeTimeInSeconds, " - " bookmark.totalTimeInSeconds AS totalTimeInSeconds, " - " bookmark.playerState AS playerState, " - " rating.rating AS rating, " - " rating.votes AS votes, " - " rating.rating_type AS rating_type, " - " uniqueid.value AS uniqueid_value, " - " uniqueid.type AS uniqueid_type, " - " EXISTS( " - " SELECT 1 " - " FROM videoversion vv " - " WHERE vv.idMedia = movie.idMovie " - " AND vv.mediaType = 'movie' " - " AND vv.idFile <> movie.idFile " - " ) AS hasVideoVersions " - "FROM movie" - " LEFT JOIN sets ON" - " sets.idSet = movie.idSet" - " JOIN files ON" - " files.idFile=movie.idFile" - " JOIN path ON" - " path.idPath=files.idPath" - " LEFT JOIN bookmark ON" - " bookmark.idFile=movie.idFile AND bookmark.type=1" - " LEFT JOIN rating ON" - " rating.rating_id=movie.c%02d" - " LEFT JOIN uniqueid ON" - " uniqueid.uniqueid_id=movie.c%02d", - VIDEODB_ID_RATING_ID, VIDEODB_ID_IDENT_ID); + " movie.*," + " sets.strSet AS strSet," + " sets.strOverview AS strSetOverview," + " files.strFileName AS strFileName," + " path.strPath AS strPath," + " files.playCount AS playCount," + " files.lastPlayed AS lastPlayed, " + " files.dateAdded AS dateAdded, " + " bookmark.timeInSeconds AS resumeTimeInSeconds, " + " bookmark.totalTimeInSeconds AS totalTimeInSeconds, " + " bookmark.playerState AS playerState, " + " rating.rating AS rating, " + " rating.votes AS votes, " + " rating.rating_type AS rating_type, " + " uniqueid.value AS uniqueid_value, " + " uniqueid.type AS uniqueid_type, " + " EXISTS( " + " SELECT 1 " + " FROM videoversion vv " + " WHERE vv.idMedia = movie.idMovie " + " AND vv.mediaType = 'movie' " + " AND vv.idFile <> movie.idFile " + " ) AS hasVideoVersions " + "FROM movie" + " LEFT JOIN sets ON" + " sets.idSet = movie.idSet" + " JOIN files ON" + " files.idFile=movie.idFile" + " JOIN path ON" + " path.idPath=files.idPath" + " LEFT JOIN bookmark ON" + " bookmark.idFile=movie.idFile AND bookmark.type=1" + " LEFT JOIN rating ON" + " rating.rating_id=movie.c%02d" + " LEFT JOIN uniqueid ON" + " uniqueid.uniqueid_id=movie.c%02d", + VIDEODB_ID_RATING_ID, VIDEODB_ID_IDENT_ID); m_pDS->exec(movieview); } |