|
bool | Open () override |
|
bool | CommitTransaction () override |
|
int | AddNewEpisode (int idShow, CVideoInfoTag &details) |
|
CDateTime | SetPlayCount (const CFileItem &item, int count, const CDateTime &date=CDateTime()) |
| Set the playcount of an item, update last played time Sets the playcount and last played date to a given value. More...
|
|
CDateTime | IncrementPlayCount (const CFileItem &item) |
| Increment the playcount of an item Increments the playcount and updates the last played date. More...
|
|
int | GetPlayCount (const CFileItem &item) |
| Get the playcount of an item. More...
|
|
int | GetPlayCount (const std::string &strFilenameAndPath) |
| Get the playcount of a filename and path. More...
|
|
CDateTime | GetLastPlayed (const std::string &strFilenameAndPath) |
| Get the last played time of a filename and path. More...
|
|
CDateTime | UpdateLastPlayed (const CFileItem &item) |
| Update the last played time of an item Updates the last played date. More...
|
|
bool | GetPlayCounts (const std::string &path, CFileItemList &items) |
| Get the playcount and resume point of a list of items Note that if the resume point is already set on an item, it won't be overridden. More...
|
|
void | UpdateMovieTitle (int idMovie, const std::string &strNewMovieTitle, VideoDbContentType iType=VideoDbContentType::MOVIES) |
|
bool | UpdateVideoSortTitle (int idDb, const std::string &strNewSortTitle, VideoDbContentType iType=VideoDbContentType::MOVIES) |
|
bool | HasMovieInfo (const std::string &strFilenameAndPath) |
|
bool | HasTvShowInfo (const std::string &strFilenameAndPath) |
|
bool | HasEpisodeInfo (const std::string &strFilenameAndPath) |
|
bool | HasMusicVideoInfo (const std::string &strFilenameAndPath) |
|
void | GetFilePathById (int idMovie, std::string &filePath, VideoDbContentType iType) |
|
std::string | GetGenreById (int id) |
|
std::string | GetCountryById (int id) |
|
std::string | GetSetById (int id) |
|
std::string | GetTagById (int id) |
|
std::string | GetPersonById (int id) |
|
std::string | GetStudioById (int id) |
|
std::string | GetTvShowTitleById (int id) |
|
std::string | GetMusicVideoAlbumById (int id) |
|
int | GetTvShowForEpisode (int idEpisode) |
|
int | GetSeasonForEpisode (int idEpisode) |
|
bool | LoadVideoInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int getDetails=VideoDbDetailsAll) |
|
bool | GetMovieInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int idMovie=-1, int getDetails=VideoDbDetailsAll) |
|
bool | GetTvShowInfo (const std::string &strPath, CVideoInfoTag &details, int idTvShow=-1, CFileItem *item=NULL, int getDetails=VideoDbDetailsAll) |
|
bool | GetSeasonInfo (const std::string &path, int season, CVideoInfoTag &details, CFileItem *item) |
|
bool | GetSeasonInfo (int idSeason, CVideoInfoTag &details, CFileItem *item) |
|
bool | GetSeasonInfo (int idSeason, CVideoInfoTag &details, bool allDetails=true) |
|
bool | GetEpisodeBasicInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int idEpisode=-1) |
|
bool | GetEpisodeInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int idEpisode=-1, int getDetails=VideoDbDetailsAll) |
|
bool | GetMusicVideoInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int idMVideo=-1, int getDetails=VideoDbDetailsAll) |
|
bool | GetSetInfo (int idSet, CVideoInfoTag &details, CFileItem *item=nullptr) |
|
bool | GetFileInfo (const std::string &strFilenameAndPath, CVideoInfoTag &details, int idFile=-1) |
|
int | GetPathId (const std::string &strPath) |
|
int | GetTvShowId (const std::string &strPath) |
|
int | GetEpisodeId (const std::string &strFilenameAndPath, int idEpisode=-1, int idSeason=-1) |
|
int | GetSeasonId (int idShow, int season) |
|
void | GetEpisodesByFile (const std::string &strFilenameAndPath, std::vector< CVideoInfoTag > &episodes) |
|
int | SetDetailsForItem (CVideoInfoTag &details, const std::map< std::string, std::string > &artwork) |
|
int | SetDetailsForItem (int id, const MediaType &mediaType, CVideoInfoTag &details, const std::map< std::string, std::string > &artwork) |
|
int | SetDetailsForMovie (CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, int idMovie=-1) |
|
int | SetDetailsForMovieSet (const CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, int idSet=-1) |
|
int | SetDetailsForTvShow (const std::vector< std::pair< std::string, std::string > > &paths, CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, const std::map< int, std::map< std::string, std::string > > &seasonArt, int idTvShow=-1) |
| add a tvshow to the library, setting metadata detail First checks for whether this TV Show is already in the database (based on idTvShow, or via GetMatchingTvShow) and if present adds the paths to the show. If not present, we add a new show and set the show metadata. More...
|
|
bool | UpdateDetailsForTvShow (int idTvShow, CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, const std::map< int, std::map< std::string, std::string > > &seasonArt) |
|
int | SetDetailsForSeason (const CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, int idShow, int idSeason=-1) |
|
int | SetDetailsForEpisode (CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, int idShow, int idEpisode=-1) |
|
int | SetDetailsForMusicVideo (CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, int idMVideo=-1) |
|
void | SetStreamDetailsForFile (const CStreamDetails &details, const std::string &strFileNameAndPath) |
|
void | SetStreamDetailsForFileId (const CStreamDetails &details, int idFile) |
|
bool | SetSingleValue (VideoDbContentType type, int dbId, int dbField, const std::string &strValue) |
|
bool | SetSingleValue (VideoDbContentType type, int dbId, Field dbField, const std::string &strValue) |
|
bool | SetSingleValue (const std::string &table, const std::string &fieldName, const std::string &strValue, const std::string &conditionName="", int conditionValue=-1) |
|
int | UpdateDetailsForMovie (int idMovie, CVideoInfoTag &details, const std::map< std::string, std::string > &artwork, const std::set< std::string > &updatedDetails) |
|
void | DeleteMovie (int idMovie, bool bKeepId=false) |
|
void | DeleteTvShow (int idTvShow, bool bKeepId=false) |
|
void | DeleteTvShow (const std::string &strPath) |
|
void | DeleteSeason (int idSeason, bool bKeepId=false) |
|
void | DeleteEpisode (int idEpisode, bool bKeepId=false) |
|
void | DeleteMusicVideo (int idMusicVideo, bool bKeepId=false) |
|
void | DeleteDetailsForTvShow (int idTvShow) |
|
void | DeleteStreamDetails (int idFile) |
|
void | RemoveContentForPath (const std::string &strPath, CGUIDialogProgress *progress=NULL) |
|
void | UpdateFanart (const CFileItem &item, VideoDbContentType type) |
|
void | DeleteSet (int idSet) |
|
void | DeleteTag (int idTag, VideoDbContentType mediaType) |
|
bool | GetVideoSettings (int idFile, CVideoSettings &settings) |
| Get video settings for the specified file id. More...
|
|
bool | GetVideoSettings (const CFileItem &item, CVideoSettings &settings) |
| Get video settings for the specified file item. More...
|
|
bool | GetVideoSettings (const std::string &filePath, CVideoSettings &settings) |
| Get video settings for the specified file path. More...
|
|
void | SetVideoSettings (const CFileItem &item, const CVideoSettings &settings) |
| Set video settings for the specified file path. More...
|
|
void | SetVideoSettings (int idFile, const CVideoSettings &settings) |
| Set video settings for the specified file path. More...
|
|
void | EraseVideoSettings (const CFileItem &item) |
| Erases video settings for file item. More...
|
|
void | EraseAllVideoSettings () |
| Erases all video settings.
|
|
void | EraseAllVideoSettings (const std::string &path) |
| Erases video settings for files starting with path. More...
|
|
void | EraseAllForPath (const std::string &path) |
| Erases all entries for files starting with path, including the files and path entries. More...
|
|
bool | GetStackTimes (const std::string &filePath, std::vector< uint64_t > ×) |
| GetStackTimes() obtains any saved video times for the stacked file. More...
|
|
void | SetStackTimes (const std::string &filePath, const std::vector< uint64_t > ×) |
| Sets the stack times for a particular video file.
|
|
void | GetBookMarksForFile (const std::string &strFilenameAndPath, VECBOOKMARKS &bookmarks, CBookmark::EType type=CBookmark::STANDARD, bool bAppend=false, long partNumber=0) |
|
void | AddBookMarkToFile (const std::string &strFilenameAndPath, const CBookmark &bookmark, CBookmark::EType type=CBookmark::STANDARD) |
|
bool | GetResumeBookMark (const std::string &strFilenameAndPath, CBookmark &bookmark) |
|
void | DeleteResumeBookMark (const CFileItem &item) |
|
void | ClearBookMarkOfFile (const std::string &strFilenameAndPath, CBookmark &bookmark, CBookmark::EType type=CBookmark::STANDARD) |
|
void | ClearBookMarksOfFile (const std::string &strFilenameAndPath, CBookmark::EType type=CBookmark::STANDARD) |
|
void | ClearBookMarksOfFile (int idFile, CBookmark::EType type=CBookmark::STANDARD) |
|
bool | GetBookMarkForEpisode (const CVideoInfoTag &tag, CBookmark &bookmark) |
|
void | AddBookMarkForEpisode (const CVideoInfoTag &tag, const CBookmark &bookmark) |
|
void | DeleteBookMarkForEpisode (const CVideoInfoTag &tag) |
|
bool | GetResumePoint (CVideoInfoTag &tag) |
|
bool | GetStreamDetails (CFileItem &item) |
|
bool | GetStreamDetails (CVideoInfoTag &tag) const |
|
bool | GetDetailsByTypeAndId (CFileItem &item, VideoDbContentType type, int id) |
|
CVideoInfoTag | GetDetailsByTypeAndId (VideoDbContentType type, int id) |
|
void | SetScraperForPath (const std::string &filePath, const ADDON::ScraperPtr &info, const VIDEO::SScanSettings &settings) |
|
ADDON::ScraperPtr | GetScraperForPath (const std::string &strPath) |
|
ADDON::ScraperPtr | GetScraperForPath (const std::string &strPath, VIDEO::SScanSettings &settings) |
|
ADDON::ScraperPtr | GetScraperForPath (const std::string &strPath, VIDEO::SScanSettings &settings, bool &foundDirectly) |
| Retrieve the scraper and settings we should use for the specified path If the scraper is not set on this particular path, we'll recursively check parent folders. More...
|
|
std::string | GetContentForPath (const std::string &strPath) |
| Retrieve the content type of videos in the given path If content is set on the folder, we return the given content type, except in the case of tvshows, where we first check for whether we have episodes directly in the path (thus return episodes) or whether we've found a scraper directly (shows). Any folders inbetween are treated as seasons (regardless of whether they actually are seasons). Note that any subfolders in movies will be treated as movies. More...
|
|
bool | GetItemsForPath (const std::string &content, const std::string &path, CFileItemList &items) |
| Get videos of the given content type from the given path. More...
|
|
bool | ScraperInUse (const std::string &scraperID) const |
| Check whether a given scraper is in use. More...
|
|
bool | SetPathHash (const std::string &path, const std::string &hash) |
|
bool | GetPathHash (const std::string &path, std::string &hash) |
|
bool | GetPaths (std::set< std::string > &paths) |
|
bool | GetPathsForTvShow (int idShow, std::set< int > &paths) |
|
bool | GetPathsLinkedToTvShow (int idShow, std::vector< std::string > &paths) |
| return the paths linked to a tvshow. More...
|
|
bool | GetSubPaths (const std::string &basepath, std::vector< std::pair< int, std::string > > &subpaths) |
| retrieve subpaths of a given path. Assumes a hierarchical folder structure More...
|
|
bool | GetSourcePath (const std::string &path, std::string &sourcePath) |
|
bool | GetSourcePath (const std::string &path, std::string &sourcePath, VIDEO::SScanSettings &settings) |
|
int | GetMatchingMusicVideo (const std::string &strArtist, const std::string &strAlbum="", const std::string &strTitle="") |
|
void | GetMoviesByActor (const std::string &strActor, CFileItemList &items) |
|
void | GetTvShowsByActor (const std::string &strActor, CFileItemList &items) |
|
void | GetEpisodesByActor (const std::string &strActor, CFileItemList &items) |
|
void | GetMusicVideosByArtist (const std::string &strArtist, CFileItemList &items) |
|
void | GetMusicVideosByAlbum (const std::string &strAlbum, CFileItemList &items) |
|
void | GetMovieGenresByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetTvShowGenresByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMusicVideoGenresByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMovieCountriesByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMusicVideoAlbumsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMovieActorsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetTvShowsActorsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMusicVideoArtistsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMovieDirectorsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetTvShowsDirectorsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMusicVideoDirectorsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMoviesByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetTvShowsByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetEpisodesByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetMusicVideosByName (const std::string &strSearch, CFileItemList &items) |
|
void | GetEpisodesByPlot (const std::string &strSearch, CFileItemList &items) |
|
void | GetMoviesByPlot (const std::string &strSearch, CFileItemList &items) |
|
bool | LinkMovieToTvshow (int idMovie, int idShow, bool bRemove) |
|
bool | IsLinkedToTvshow (int idMovie) |
|
bool | GetLinksToTvShow (int idMovie, std::vector< int > &ids) |
|
bool | GetGenresNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetCountriesNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetStudiosNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetYearsNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter()) |
|
bool | GetActorsNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetDirectorsNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetWritersNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetSetsNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool ignoreSingleMovieSets=false) |
|
bool | GetTagsNav (const std::string &strBaseDir, CFileItemList &items, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetMusicVideoAlbumsNav (const std::string &strBaseDir, CFileItemList &items, int idArtist, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetMoviesNav (const std::string &strBaseDir, CFileItemList &items, int idGenre=-1, int idYear=-1, int idActor=-1, int idDirector=-1, int idStudio=-1, int idCountry=-1, int idSet=-1, int idTag=-1, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetTvShowsNav (const std::string &strBaseDir, CFileItemList &items, int idGenre=-1, int idYear=-1, int idActor=-1, int idDirector=-1, int idStudio=-1, int idTag=-1, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetSeasonsNav (const std::string &strBaseDir, CFileItemList &items, int idActor=-1, int idDirector=-1, int idGenre=-1, int idYear=-1, int idShow=-1, bool getLinkedMovies=true) |
|
bool | GetEpisodesNav (const std::string &strBaseDir, CFileItemList &items, int idGenre=-1, int idYear=-1, int idActor=-1, int idDirector=-1, int idShow=-1, int idSeason=-1, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetMusicVideosNav (const std::string &strBaseDir, CFileItemList &items, int idGenre=-1, int idYear=-1, int idArtist=-1, int idDirector=-1, int idStudio=-1, int idAlbum=-1, int idTag=-1, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetRecentlyAddedMoviesNav (const std::string &strBaseDir, CFileItemList &items, unsigned int limit=0, int getDetails=VideoDbDetailsNone) |
|
bool | GetRecentlyAddedEpisodesNav (const std::string &strBaseDir, CFileItemList &items, unsigned int limit=0, int getDetails=VideoDbDetailsNone) |
|
bool | GetRecentlyAddedMusicVideosNav (const std::string &strBaseDir, CFileItemList &items, unsigned int limit=0, int getDetails=VideoDbDetailsNone) |
|
bool | GetInProgressTvShowsNav (const std::string &strBaseDir, CFileItemList &items, unsigned int limit=0, int getDetails=VideoDbDetailsNone) |
|
bool | HasContent () |
|
bool | HasContent (VideoDbContentType type) |
|
bool | HasSets () const |
|
void | CleanDatabase (CGUIDialogProgressBarHandle *handle=NULL, const std::set< int > &paths=std::set< int >(), bool showProgress=true) |
|
int | AddFile (const std::string &url, const std::string &parentPath="", const CDateTime &dateAdded=CDateTime(), int playcount=0, const CDateTime &lastPlayed=CDateTime()) |
| Add a file to the database, if necessary If the file is already in the database, we simply return its id. More...
|
|
int | AddFile (const CFileItem &item) |
| Add a file to the database, if necessary Works for both videodb:// items and normal fileitems. More...
|
|
int | AddFile (const CVideoInfoTag &details, const std::string &parentPath="") |
| Add a file to the database, if necessary Works for both videodb:// items and normal fileitems. More...
|
|
int | AddPath (const std::string &strPath, const std::string &parentPath="", const CDateTime &dateAdded=CDateTime()) |
| Add a path to the database, if necessary If the path is already in the database, we simply return its id. More...
|
|
void | UpdateFileDateAdded (CVideoInfoTag &details) |
| Updates the dateAdded field in the files table for the file with the given idFile and the given path based on the files modification date. More...
|
|
void | ExportToXML (const std::string &path, bool singleFile=true, bool images=false, bool actorThumbs=false, bool overwrite=false) |
|
void | ExportActorThumbs (const std::string &path, const CVideoInfoTag &tag, bool singleFiles, bool overwrite=false) |
|
void | ImportFromXML (const std::string &path) |
|
void | DumpToDummyFiles (const std::string &path) |
|
bool | ImportArtFromXML (const TiXmlNode *node, std::map< std::string, std::string > &artwork) |
|
bool | GetMoviesByWhere (const std::string &strBaseDir, const Filter &filter, CFileItemList &items, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetSetsByWhere (const std::string &strBaseDir, const Filter &filter, CFileItemList &items, bool ignoreSingleMovieSets=false) |
|
bool | GetTvShowsByWhere (const std::string &strBaseDir, const Filter &filter, CFileItemList &items, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetSeasonsByWhere (const std::string &strBaseDir, const Filter &filter, CFileItemList &items, bool appendFullShowPath=true, const SortDescription &sortDescription=SortDescription()) |
|
bool | GetEpisodesByWhere (const std::string &strBaseDir, const Filter &filter, CFileItemList &items, bool appendFullShowPath=true, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetMusicVideosByWhere (const std::string &baseDir, const Filter &filter, CFileItemList &items, bool checkLocks=true, const SortDescription &sortDescription=SortDescription(), int getDetails=VideoDbDetailsNone) |
|
bool | GetSortedVideos (const MediaType &mediaType, const std::string &strBaseDir, const SortDescription &sortDescription, CFileItemList &items, const Filter &filter=Filter()) |
|
bool | GetItems (const std::string &strBaseDir, CFileItemList &items, const Filter &filter=Filter(), const SortDescription &sortDescription=SortDescription()) |
|
bool | GetItems (const std::string &strBaseDir, const std::string &mediaType, const std::string &itemType, CFileItemList &items, const Filter &filter=Filter(), const SortDescription &sortDescription=SortDescription()) |
|
bool | GetItems (const std::string &strBaseDir, VideoDbContentType mediaType, const std::string &itemType, CFileItemList &items, const Filter &filter=Filter(), const SortDescription &sortDescription=SortDescription()) |
|
std::string | GetItemById (const std::string &itemType, int id) |
|
unsigned int | GetRandomMusicVideoIDs (const std::string &strWhere, std::vector< std::pair< int, int > > &songIDs) |
| Gets music video IDs in random order that match the where clause. More...
|
|
void | SetArtForItem (int mediaId, const MediaType &mediaType, const std::string &artType, const std::string &url) |
|
void | SetArtForItem (int mediaId, const MediaType &mediaType, const std::map< std::string, std::string > &art) |
|
bool | GetArtForItem (int mediaId, const MediaType &mediaType, std::map< std::string, std::string > &art) |
|
std::string | GetArtForItem (int mediaId, const MediaType &mediaType, const std::string &artType) |
|
bool | HasArtForItem (int mediaId, const MediaType &mediaType) |
|
bool | RemoveArtForItem (int mediaId, const MediaType &mediaType, const std::string &artType) |
|
bool | RemoveArtForItem (int mediaId, const MediaType &mediaType, const std::set< std::string > &artTypes) |
|
bool | GetTvShowSeasons (int showId, std::map< int, int > &seasons) |
|
bool | GetTvShowNamedSeasons (int showId, std::map< int, std::string > &seasons) |
|
std::string | GetTvShowNamedSeasonById (int tvshowId, int seasonId) |
| Get the custom named season. More...
|
|
bool | GetTvShowSeasonArt (int mediaId, std::map< int, std::map< std::string, std::string > > &seasonArt) |
|
bool | GetArtTypes (const MediaType &mediaType, std::vector< std::string > &artTypes) |
|
std::vector< std::string > | GetAvailableArtTypesForItem (int mediaId, const MediaType &mediaType) |
| Fetch the distinct types of available-but-unassigned art held in the database for a specific media item. More...
|
|
std::vector< CScraperUrl::SUrlEntry > | GetAvailableArtForItem (int mediaId, const MediaType &mediaType, const std::string &artType) |
| Fetch the list of available-but-unassigned art URLs held in the database for a specific media item and art type. More...
|
|
int | AddTag (const std::string &tag) |
|
void | AddTagToItem (int idItem, int idTag, const std::string &type) |
|
void | RemoveTagFromItem (int idItem, int idTag, const std::string &type) |
|
void | RemoveTagsFromItem (int idItem, const std::string &type) |
|
bool | GetFilter (CDbUrl &videoUrl, Filter &filter, SortDescription &sorting) override |
|
int | AddSeason (int showID, int season, const std::string &name="") |
| Will check if the season exists and if that is not the case add it to the database. More...
|
|
int | AddSet (const std::string &strSet, const std::string &strOverview="") |
|
void | ClearMovieSet (int idMovie) |
|
void | SetMovieSet (int idMovie, int idSet) |
|
bool | SetVideoUserRating (int dbId, int rating, const MediaType &mediaType) |
|
bool | GetUseAllExternalAudioForVideo (const std::string &videoPath) |
|
bool | IsOpen () |
|
virtual void | Close () |
|
bool | Compress (bool bForce=true) |
|
void | Interrupt () |
|
bool | Open (const DatabaseSettings &db) |
|
void | BeginTransaction () |
|
void | RollbackTransaction () |
|
void | CopyDB (const std::string &latestDb) |
|
void | DropAnalytics () |
|
std::string | PrepareSQL (std::string strStmt,...) const |
|
std::string | GetSingleValue (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) |
| Get a single value from a table. More...
|
|
std::string | GetSingleValue (const std::string &query) |
|
std::string | GetSingleValue (const std::string &query, std::unique_ptr< dbiplus::Dataset > &ds) |
| Get a single value from a query on a dataset. More...
|
|
int | GetSingleValueInt (const std::string &strTable, const std::string &strColumn, const std::string &strWhereClause=std::string(), const std::string &strOrderBy=std::string()) |
| Get a single integer value from a table. More...
|
|
int | GetSingleValueInt (const std::string &query) |
|
int | GetSingleValueInt (const std::string &query, std::unique_ptr< dbiplus::Dataset > &ds) |
| Get a single integer value from a query on a dataset. More...
|
|
bool | DeleteValues (const std::string &strTable, const Filter &filter=Filter()) |
| Delete values from a table. More...
|
|
bool | ExecuteQuery (const std::string &strQuery) |
| Execute a query that does not return any result. Note that if BeginMultipleExecute() has been called, the query will be queued until CommitMultipleExecute() is called. More...
|
|
bool | ResultQuery (const std::string &strQuery) const |
| Execute a query that returns a result. More...
|
|
bool | BeginMultipleExecute () |
| Start a multiple execution queue. Any ExecuteQuery() function following this call will be queued rather than executed until CommitMultipleExecute() is performed. NOTE: Queries that rely on any queued execute query will not function as expected during this period! More...
|
|
bool | CommitMultipleExecute () |
| Commit the multiple execution queue to the database. Queries are performed within a transaction, and the transaction is rolled back should any one query fail. More...
|
|
bool | QueueInsertQuery (const std::string &strQuery) |
| Put an INSERT or REPLACE query in the queue. More...
|
|
bool | CommitInsertQueries () |
| Commit all queries in the queue. More...
|
|
size_t | GetInsertQueriesCount () |
| Get the number of INSERT queries in the queue. More...
|
|
bool | QueueDeleteQuery (const std::string &strQuery) |
| Put a DELETE query in the queue. More...
|
|
bool | CommitDeleteQueries () |
| Commit all queued DELETE queries. More...
|
|
size_t | GetDeleteQueriesCount () |
| Get the number of DELETE queries in the queue. More...
|
|
virtual bool | BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl) |
|
virtual bool | BuildSQL (const std::string &strBaseDir, const std::string &strQuery, Filter &filter, std::string &strSQL, CDbUrl &dbUrl, SortDescription &sorting) |
|
bool | Connect (const std::string &dbName, const DatabaseSettings &db, bool create) |
|
|
int | AddNewMovie (CVideoInfoTag &details) |
|
int | AddNewMusicVideo (CVideoInfoTag &details) |
|
int | GetMovieId (const std::string &strFilenameAndPath) |
|
int | GetMusicVideoId (const std::string &strFilenameAndPath) |
|
int | GetFileId (const CFileItem &item) |
| Get the id of this fileitem Works for both videodb:// items and normal fileitems. More...
|
|
int | GetFileId (const CVideoInfoTag &details) |
|
int | GetAndFillFileId (CVideoInfoTag &details) |
| Get the id of the file of this item and store it in the item. More...
|
|
int | GetFileId (const std::string &url) |
| Get the id of a file from path. More...
|
|
int | AddToTable (const std::string &table, const std::string &firstField, const std::string &secondField, const std::string &value) |
|
int | UpdateRatings (int mediaId, const char *mediaType, const RatingMap &values, const std::string &defaultRating) |
|
int | AddRatings (int mediaId, const char *mediaType, const RatingMap &values, const std::string &defaultRating) |
|
int | UpdateUniqueIDs (int mediaId, const char *mediaType, const CVideoInfoTag &details) |
|
int | AddUniqueIDs (int mediaId, const char *mediaType, const CVideoInfoTag &details) |
|
int | AddActor (const std::string &strActor, const std::string &thumbURL, const std::string &thumb="") |
|
int | AddTvShow () |
|
bool | AddPathToTvShow (int idShow, const std::string &path, const std::string &parentPath, const CDateTime &dateAdded=CDateTime()) |
| Adds a path to the tvshow link table. More...
|
|
int | GetMatchingTvShow (const CVideoInfoTag &show) |
| Check whether a show is already in the library. Matches on unique identifier or matching title and premiered date. More...
|
|
void | AddLinkToActor (int mediaId, const char *mediaType, int actorId, const std::string &role, int order) |
|
void | AddToLinkTable (int mediaId, const std::string &mediaType, const std::string &table, int valueId, const char *foreignKey=NULL) |
|
void | RemoveFromLinkTable (int mediaId, const std::string &mediaType, const std::string &table, int valueId, const char *foreignKey=NULL) |
|
void | AddLinksToItem (int mediaId, const std::string &mediaType, const std::string &field, const std::vector< std::string > &values) |
|
void | UpdateLinksToItem (int mediaId, const std::string &mediaType, const std::string &field, const std::vector< std::string > &values) |
|
void | AddActorLinksToItem (int mediaId, const std::string &mediaType, const std::string &field, const std::vector< std::string > &values) |
|
void | UpdateActorLinksToItem (int mediaId, const std::string &mediaType, const std::string &field, const std::vector< std::string > &values) |
|
void | AddCast (int mediaId, const char *mediaType, const std::vector< SActorInfo > &cast) |
|
CVideoInfoTag | GetDetailsForMovie (std::unique_ptr< dbiplus::Dataset > &pDS, int getDetails=VideoDbDetailsNone) |
|
CVideoInfoTag | GetDetailsForMovie (const dbiplus::sql_record *const record, int getDetails=VideoDbDetailsNone) |
|
CVideoInfoTag | GetDetailsForTvShow (std::unique_ptr< dbiplus::Dataset > &pDS, int getDetails=VideoDbDetailsNone, CFileItem *item=NULL) |
|
CVideoInfoTag | GetDetailsForTvShow (const dbiplus::sql_record *const record, int getDetails=VideoDbDetailsNone, CFileItem *item=NULL) |
|
CVideoInfoTag | GetBasicDetailsForEpisode (std::unique_ptr< dbiplus::Dataset > &pDS) |
|
CVideoInfoTag | GetBasicDetailsForEpisode (const dbiplus::sql_record *const record) |
|
CVideoInfoTag | GetDetailsForEpisode (std::unique_ptr< dbiplus::Dataset > &pDS, int getDetails=VideoDbDetailsNone) |
|
CVideoInfoTag | GetDetailsForEpisode (const dbiplus::sql_record *const record, int getDetails=VideoDbDetailsNone) |
|
CVideoInfoTag | GetDetailsForMusicVideo (std::unique_ptr< dbiplus::Dataset > &pDS, int getDetails=VideoDbDetailsNone) |
|
CVideoInfoTag | GetDetailsForMusicVideo (const dbiplus::sql_record *const record, int getDetails=VideoDbDetailsNone) |
|
bool | GetPeopleNav (const std::string &strBaseDir, CFileItemList &items, const char *type, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
bool | GetNavCommon (const std::string &strBaseDir, CFileItemList &items, const char *type, VideoDbContentType idContent=VideoDbContentType::UNKNOWN, const Filter &filter=Filter(), bool countOnly=false) |
|
void | GetCast (int media_id, const std::string &media_type, std::vector< SActorInfo > &cast) |
|
void | GetTags (int media_id, const std::string &media_type, std::vector< std::string > &tags) |
|
void | GetRatings (int media_id, const std::string &media_type, RatingMap &ratings) |
|
void | GetUniqueIDs (int media_id, const std::string &media_type, CVideoInfoTag &details) |
|
void | GetDetailsFromDB (std::unique_ptr< dbiplus::Dataset > &pDS, int min, int max, const SDbTableOffsets *offsets, CVideoInfoTag &details, int idxOffset=2) |
|
void | GetDetailsFromDB (const dbiplus::sql_record *const record, int min, int max, const SDbTableOffsets *offsets, CVideoInfoTag &details, int idxOffset=2) |
|
std::string | GetValueString (const CVideoInfoTag &details, int min, int max, const SDbTableOffsets *offsets) const |
|
void | Split (const std::string &strFileNameAndPath, std::string &strPath, std::string &strFileName) |
|
bool | CreateDatabase () |
| Create database tables and analytics as needed. Calls CreateTables() and CreateAnalytics() on child classes.
|
|
int | GetDBVersion () |
|
bool | BuildSQL (const std::string &strQuery, const Filter &filter, std::string &strSQL) |
|