• 홈
• MediaPortal
• Video
• Database
• VideoDatabaseSqlLite

C# 클래스 MediaPortal.Video.Database.VideoDatabaseSqlLite

파일 보기 프로젝트 열기: MediaPortal/MediaPortal-1

공개 프로퍼티들

프로퍼티	타입	설명
m_db	SQLite.NET.SQLiteClient

공개 메소드들

메소드	설명
AddActor ( string strActorImdbId, string strActorName ) : int
AddActorInfoMovie ( int idActor, MediaPortal.Video.Database.IMDBActor movie ) : void
AddActorToMovie ( int lMovieId, int lActorId, string role ) : void
AddBookMarkToMovie ( string strFilenameAndPath, float fTime ) : void
AddCollection ( string strCollection1 ) : int
AddCollectionDescription ( string movieCollection, string description ) : void
AddCollectionToMovie ( int lMovieId, int lCollectionId ) : void
AddFile ( int lMovieId, int lPathId, string strFileName ) : int
AddGenre ( string strGenre1 ) : int
AddGenreToMovie ( int lMovieId, int lGenreId ) : void
AddMovie ( string strFilenameAndPath, bool bHassubtitles ) : int
AddMovieFile ( string strFile ) : int
AddPath ( string strPath ) : int
AddUserGroup ( string userGroup ) : int
AddUserGroupDescription ( string userGroup, string description ) : void
AddUserGroupRuleByGroupId ( int groupId, string rule ) : void
AddUserGroupRuleByGroupName ( string groupName, string rule ) : void
AddUserGroupToMovie ( int lMovieId, int lUserGroupId ) : void
CheckActorImdbId ( string id ) : bool
CheckMovieImdbId ( string id ) : bool
ClearBookMarksOfMovie ( string strFilenameAndPath ) : void
DeleteActor ( string actorImdbId ) : void
DeleteActorFromMovie ( int movieId, int actorId ) : void
DeleteCollection ( string collection ) : void
DeleteEmptyCollections ( ) : void
DeleteFile ( int iFileId ) : void
DeleteGenre ( string genre ) : void
DeleteMovie ( string strFilenameAndPath ) : void
DeleteMovieInfo ( string strFileNameAndPath ) : void
DeleteMovieInfoById ( long lMovieId ) : void
DeleteMovieStopTime ( int iFileId ) : void
DeleteUserGroup ( string userGroup ) : void
Dispose ( ) : void
ExecuteRuleSQL ( string strSql, string fieldName, bool &error, string &errorMessage ) : ArrayList
ExecuteSQL ( string strSql, bool &error, string &errorMessage ) : void
FlushTransactionsToDisk ( ) : void
GetActorByName ( string strActorName, ArrayList actors ) : void
GetActorImdbId ( int idActor ) : string
GetActorInfo ( int idActor ) : MediaPortal.Video.Database.IMDBActor
GetActorNameById ( int actorId ) : string
GetActors ( ArrayList actors ) : void
GetActorsByMovieID ( int idMovie, ArrayList &actorsByMovieID ) : void
GetBookMarksForMovie ( string strFilenameAndPath, ArrayList &bookmarks ) : void
GetCollectionById ( int collectionId ) : string
GetCollectionDescriptionById ( int collectionId ) : string
GetCollectionId ( string movieCollection ) : int
GetCollections ( ArrayList collections ) : void
GetCollectionsForMovie ( int lMovieId ) : string
GetDVDLabel ( string strFile ) : string
GetFile ( string strFilenameAndPath, int &lPathId, int &lMovieId, bool bExact ) : int
GetFileId ( string strFilenameAndPath ) : int
GetFilesForMovie ( int lMovieId, ArrayList &files ) : void
GetGenreById ( int genreId ) : string
GetGenres ( ArrayList genres ) : void
GetGenresForMovie ( int lMovieId ) : string
GetIndexByFilter ( string sql, bool filterNonWordChar, ArrayList &movieList ) : void
GetMovieCollectionWatchedStatus ( int collection, int &percent ) : bool
GetMovieCollectionWatchedStatus ( string collection, int &percent ) : bool
GetMovieCollections ( int lMovieId, ArrayList movieCollections ) : void
GetMovieDuration ( int iMovieId ) : int
GetMovieGenres ( int lMovieId, ArrayList movieGenres ) : void
GetMovieId ( string strFilenameAndPath ) : int
GetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : int
GetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
GetMovieStopTime ( int iFileId ) : int
GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData ) : int	Deprecated Method (this one will not use the new Blu-ray Title mode resume)
GetMovieStopTimeAndResumeData ( int iFileId, byte &resumeData, int bdtitle ) : int
GetMovieTitlesByActor ( int actorId ) : string
GetMovieTitlesByCollection ( string strCollection ) : string
GetMovieTitlesByDirector ( int directorId ) : string
GetMovieTitlesByGenre ( string strGenre ) : string
GetMovieTitlesByIndex ( string sql ) : string
GetMovieTitlesByUserGroup ( int idGroup ) : string
GetMovieTitlesByYear ( string strYear ) : string
GetMovieUserGroups ( int movieId, ArrayList userGroups ) : void
GetMovieWatchedStatus ( int idMovie, int &percent, int &timesWatched ) : bool
GetMovies ( ArrayList &movies ) : void
GetMoviesByActor ( string strActor1, ArrayList &movies ) : void
GetMoviesByCollection ( string strCollection1, ArrayList &movies ) : void
GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable ) : void	Deprecated Method (use GetMoviesByFilter with Movie Collection)
GetMoviesByFilter ( string sql, ArrayList &movies, bool actorTable, bool movieinfoTable, bool genreTable, bool usergroupTable, bool collectionTable ) : void
GetMoviesByGenre ( string strGenre1, ArrayList &movies ) : void
GetMoviesByPath ( string strPath1, ArrayList &movies ) : void
GetMoviesByUserGroup ( string strUserGroup, ArrayList &movies ) : void
GetMoviesByYear ( string strYear, ArrayList &movies ) : void
GetPath ( string strPath ) : int
GetRandomMoviesByActor ( string strActor1, ArrayList &movies, int limit ) : void
GetRandomMoviesByCollection ( string strCollection1, ArrayList &movies, int limit ) : void
GetRandomMoviesByGenre ( string strGenre1, ArrayList &movies, int limit ) : void
GetRandomMoviesByPath ( string strPath1, ArrayList &movies, int limit ) : void
GetRandomMoviesByUserGroup ( string strUserGroup, ArrayList &movies, int limit ) : void
GetRandomMoviesByYear ( string strYear, ArrayList &movies, int limit ) : void
GetResults ( string sql ) : SQLite.NET.SQLiteResultSet
GetRoleByMovieAndActorId ( int lMovieId, int lActorId ) : string
GetTitleBDId ( int iFileId, byte &resumeData ) : int
GetUserGroupById ( int groupId ) : string
GetUserGroupDescriptionById ( int groupId ) : string
GetUserGroupId ( string userGroup ) : int
GetUserGroupRule ( string group ) : string
GetUserGroupWatchedStatus ( int group, int &percent ) : bool
GetUserGroupWatchedStatus ( string group, int &percent ) : bool
GetUserGroups ( ArrayList userGroups ) : void
GetUserGroupsForMovie ( int lMovieId ) : string
GetUserRatingForMovie ( int lMovieId ) : int
GetUserRatingForMovie ( string lIMDBNumber ) : int
GetVideoDuration ( int iFileId ) : int
GetVideoFiles ( string path, ArrayList &availableFiles ) : void
GetVideoFilesMediaInfo ( string strFilenameAndPath, MediaPortal.Video.Database.VideoFilesMediaInfo &mediaInfo, bool refresh ) : void
GetYears ( ArrayList years ) : void
HasMediaInfo ( string fileName ) : bool
HasMovieInfo ( string strFilenameAndPath ) : bool
HasSubtitle ( string strFilenameAndPath ) : bool
ImportNfo ( string nfoFile, bool skipExisting, bool refreshdbOnly ) : void
ImportNfoUsingVideoFile ( string videoFile, bool skipExisting, bool refreshdbOnly ) : void
IsVideoThumbBlacklisted ( string path ) : bool
MakeNfo ( int movieId ) : bool
MovieWatchedCountIncrease ( int idMovie ) : void	Increase times watched by 1
RemoveActorInfoMovie ( int actorId ) : void
RemoveActorsForMovie ( int lMovieId ) : void
RemoveAllVideoThumbBlacklistEntries ( ) : void
RemoveCollectionFromMovie ( int lMovieId, int lCollectionId ) : void
RemoveCollectionsForMovie ( int lMovieId ) : void
RemoveExpiredVideoThumbBlacklistEntries ( ) : void
RemoveFilesForMovie ( int lMovieId ) : void
RemoveGenresForMovie ( int lMovieId ) : void
RemoveUserGroupFromMovie ( int lMovieId, int lUserGroupId ) : void
RemoveUserGroupRule ( string groupName ) : void
RemoveUserGroupsForMovie ( int lMovieId ) : void
RevertFlushTransactionsToDisk ( ) : void
SetActorInfo ( int idActor, MediaPortal.Video.Database.IMDBActor actor ) : void
SetDVDLabel ( int lMovieId, string strDVDLabel1 ) : void
SetDateWatched ( IMDBMovie details ) : void
SetFanartURL ( int lMovieId, string fanartURL ) : void
SetMovieDuration ( int iMovieId, int duration ) : void
SetMovieInfo ( string strFilenameAndPath, IMDBMovie &details ) : void
SetMovieInfoById ( int lMovieId, IMDBMovie &details ) : void
SetMovieInfoById ( int lMovieId, IMDBMovie &details, bool updateTimeStamp ) : void
SetMovieStopTime ( int iFileId, int stoptime ) : void
SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData ) : void	Deprecated Method (this one will not use the new Blu-ray Title mode resume)
SetMovieStopTimeAndResumeData ( int iFileId, int stoptime, byte resumeData, int bdtitle ) : void
SetMovieWatchedCount ( int movieId, int watchedCount ) : void
SetMovieWatchedStatus ( int idMovie, bool watched, int percent ) : void
SetThumbURL ( int lMovieId, string thumbURL ) : void
SetUserRatingForMovie ( int lMovieId, int lUserRating ) : void
SetVideoDuration ( int iFileId, int duration ) : void
SetWatched ( IMDBMovie details ) : void
UpdateCDLabel ( IMDBMovie movieDetails, string CDlabel ) : void
VideoDatabaseSqlLite ( ) : System
VideoThumbBlacklist ( string path, System.DateTime expiresOn ) : int
VideoThumbRemoveFromBlacklist ( string path ) : bool

비공개 메소드들

메소드	설명
CheckActorByName ( string strActorName ) : int
CheckMediaInfo ( string file, string fullPathFilename, int pathID, int fileID, bool refresh ) : void
CreateCovers ( string titleExt, string coverImage, IMDBMovie movie ) : void
CreateTables ( ) : void
CreateXmlNode ( XmlNode mainNode, XmlDocument doc, string element, string innerTxt ) : void
DeleteMoviesInFolder ( string strPath ) : void
DeleteSingleMovie ( string strFilenameAndPath ) : void
FromHexString ( string s ) : byte[]
GetFileId ( int movieId ) : int
GetMovie ( string strFilenameAndPath, bool bExact ) : int
GetVideoFilesMediaInfo ( int movieId, MediaPortal.Video.Database.VideoFilesMediaInfo &mediaInfo ) : void
MovieDuration ( ArrayList files ) : int
Open ( ) : void
SetLatestMovieProperties ( ) : void
SetMovieDetails ( IMDBMovie &details, int iRow, SQLite.NET.SQLiteResultSet results ) : void
ToHexString ( byte bytes ) : string
UpgradeDatabase ( ) : void

메소드 상세

프로퍼티 상세