Method | Description | |
---|---|---|
AddCard ( string name, string devicePath, TvDatabase.Server server ) : TvDatabase.Card | ||
AddChannelToGroup ( TvDatabase.Channel channel, TvDatabase.ChannelGroup group ) : void | ||
AddChannelToGroup ( TvDatabase.Channel channel, string groupName ) : void | ||
AddChannelToRadioGroup ( TvDatabase.Channel channel, TvDatabase.RadioChannelGroup group ) : void | ||
AddChannelToRadioGroup ( TvDatabase.Channel channel, string groupName ) : void |
Add a radio channel to radio group by name
|
|
AddNewChannel ( string name, int channelNumber ) : TvDatabase.Channel | ||
AddSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule | ||
AddTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel ) : TvDatabase.TuningDetail | ||
AddWebStreamTuningDetails ( TvDatabase.Channel channel, string url, int bitrate ) : TvDatabase.TuningDetail | ||
CreateGroup ( string groupName ) : TvDatabase.ChannelGroup | ||
DeleteCard ( TvDatabase.Card card ) : void | ||
DeleteChannel ( TvDatabase.Channel channel ) : void | ||
EscapeSQLString ( string original ) : string | ||
GetAllRadioChannels ( ) : IList |
||
GetCardByDevicePath ( string path ) : TvDatabase.Card | ||
GetCardByName ( string name ) : TvDatabase.Card | ||
GetChannel ( int idChannel ) : TvDatabase.Channel | ||
GetChannelByTuningDetail ( int networkId, int transportId, int serviceId ) : TvDatabase.Channel | ||
GetChannelType ( TvLibrary.Channels.DVBBaseChannel channel ) : int | ||
GetChannelsByName ( string name ) : IList |
||
GetChannelsInGroup ( TvDatabase.ChannelGroup group ) : IList |
||
GetConflictingSchedules ( TvDatabase.Schedule rec, List |
||
GetDateTimeString ( ) : string | ||
GetGenres ( ) : List |
||
GetGroupByName ( string aGroupName ) : TvDatabase.ChannelGroup | ||
GetGroupByName ( string aGroupName, int aSortOrder ) : TvDatabase.ChannelGroup | ||
GetLinkagesForChannel ( TvDatabase.Channel channel ) : IList |
||
GetMpGenres ( ) : List |
Returns a list of MediaPortal genres.
|
|
GetNewestProgramForChannel ( int idChannel ) : System.DateTime | ||
GetNowAndNext ( List |
||
GetOnairNow ( ) : IList |
||
GetProgramExists ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList |
||
GetProgramGenres ( ) : List |
||
GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime ) : IList |
||
GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList |
||
GetPrograms ( System.DateTime startTime, System.DateTime endTime ) : IList |
||
GetProgramsByTitle ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime, string title ) : IList |
||
GetProgramsByTitle ( System.DateTime startTime, System.DateTime endTime, string title ) : IList |
||
GetProgramsForAllChannels ( System.DateTime startTime, System.DateTime endTime, List |
||
GetRadioChannelGroupByName ( string name ) : TvDatabase.RadioChannelGroup | ||
GetRadioGuideChannelsForGroup ( int groupID ) : List |
Gets a list of radio channels sorted by their group
|
|
GetRecordingByFileName ( string fileName ) : TvDatabase.Recording | ||
GetRecordingTimes ( TvDatabase.Schedule rec ) : List |
||
GetRecordingTimes ( TvDatabase.Schedule rec, int days ) : List |
||
GetSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule | ||
GetSetting ( string tagName ) : TvDatabase.Setting |
gets a value from the database table "Setting"
|
|
GetSetting ( string tagName, string defaultValue ) : TvDatabase.Setting |
gets a value from the database table "Setting"
|
|
GetSofwareEncodersAudio ( ) : IList |
||
GetSofwareEncodersVideo ( ) : IList |
||
GetTVGuideChannelsForGroup ( int groupID ) : List |
Gets a list of tv channels sorted by their group
|
|
GetTuningChannel ( TvDatabase.TuningDetail detail ) : IChannel | ||
GetTuningChannelByType ( TvDatabase.Channel channel, int channelType ) : IChannel | ||
GetTuningChannelsByDbChannel ( TvDatabase.Channel channel ) : List |
||
GetTuningDetail ( TvLibrary.Channels.DVBBaseChannel channel ) : TvDatabase.TuningDetail | ||
GetTuningDetail ( String url, int channelType ) : TvDatabase.TuningDetail | ||
GetTuningDetail ( int networkId, int serviceId, int channelType ) : TvDatabase.TuningDetail | ||
GetTuningDetail ( int networkId, int transportId, int serviceId, int channelType ) : TvDatabase.TuningDetail | ||
GetTuningDetailsByName ( string name, int channelType ) : IList |
||
InsertPrograms ( List |
Batch inserts programs - intended for faster EPG import. You must make sure before that there are no duplicates (e.g. delete all program data of the current channel). Also you MUST provide a true copy of "aProgramList". If you update it's reference in your own code the values will get overwritten (possibly before they are written to disk)! Inserts are queued to be performed in the background. Each batch of inserts is executed in a single transaction. You may also optionally specify to delete either all existing programs in the same channel(s) as the programs to be inserted (DeleteBeforeImportOption.ProgramsOnSameChannel), or existing programs that would otherwise overlap new programs (DeleteBeforeImportOption.OverlappingPrograms), or none (DeleteBeforeImportOption.None). The deletion is also performed in the same transaction as the inserts so that EPG will not be at any time empty. After all insert have completed and the background thread is idle for 60 seconds, the program states are automatically updated to reflect the changes. |
|
InsertPrograms ( List |
Batch inserts programs - intended for faster EPG import. You must make sure before that there are no duplicates (e.g. delete all program data of the current channel). Also you MUST provide a true copy of "aProgramList". If you update it's reference in your own code the values will get overwritten (possibly before they are written to disk)!
|
|
IsChannelMappedToCard ( TvDatabase.Channel dbChannel, TvDatabase.Card card, bool forEpg ) : bool | ||
ListAllEnabledCardsOrderedByPriority ( ) : IList |
||
MapChannelToCard ( TvDatabase.Card card, TvDatabase.Channel channel, bool epgOnly ) : TvDatabase.ChannelMap | ||
OptimizeMySql ( string aTable ) : void |
Checks a MySQL table for corruption and optimizes / compacts it. Use this after lots of insert / delete operations.
|
|
RemoveAllPrograms ( int idChannel ) : void | ||
RemoveOldPrograms ( ) : void | ||
RemoveOldPrograms ( int idChannel ) : void | ||
SaveMpGenres ( List |
Save the specified list of MediaPortal genres to the database.
|
|
SearchMinimalPrograms ( System.DateTime startTime, System.DateTime endTime, string programName, TvDatabase.Channel channel ) : IList |
||
SearchPrograms ( string searchCriteria ) : IList |
||
SearchPrograms ( string searchCriteria, ChannelType channelType ) : IList |
||
SearchProgramsByDescription ( string searchCriteria ) : IList |
||
SearchProgramsByDescription ( string searchCriteria, ChannelType channelType ) : IList |
||
SearchProgramsPerGenre ( string currentGenre, string searchCriteria ) : IList |
||
SearchProgramsPerGenre ( string currentGenre, string searchCriteria, ChannelType channelType ) : IList |
||
SetLogLevel ( ) : void |
Set the log level
|
|
UpdateTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel, TvDatabase.TuningDetail detail ) : TvDatabase.TuningDetail | ||
WaitForInsertPrograms ( ) : void | ||
WaitForInsertPrograms ( int millisecondsTimeout ) : void | ||
isSameTransponder ( TvDatabase.Schedule schedule1, TvDatabase.Schedule schedule2 ) : bool |
checks if 2 schedules have a common Transponder depending on tuningdetails of their respective channels
|
Method | Description | |
---|---|---|
AddNewChannel ( string name ) : TvDatabase.Channel | ||
AssignSchedulesToCard ( TvDatabase.Schedule schedule, List |
||
BuildCommandTextMiniGuide ( string aProvider, ICollection |
||
BuildEpgSelect ( IEnumerable |
||
BuildNowNextFromDataSet ( |
||
ExecuteDeleteProgramsMySqlCommand ( IEnumerable |
||
ExecuteDeleteProgramsMySqlCommand ( IEnumerable |
||
ExecuteDeleteProgramsSqlServerCommand ( IEnumerable |
||
ExecuteDeleteProgramsSqlServerCommand ( IEnumerable |
||
ExecuteInsertProgramsMySqlCommand ( IEnumerable |
||
ExecuteInsertProgramsSqlServerCommand ( IEnumerable |
||
FileNotExistsString ( String fileName ) : String |
Checks if a file doesnt exist and then returns the filename preceded by a CRLF combination. If the file does exist a empty string is returned.
|
|
FillProgramMapFromDataSet ( |
||
GetDefaultMpGenreNames ( ) : IList |
||
InsertProgramsMySql ( ImportParams aImportParam ) : void | ||
InsertProgramsSqlServer ( ImportParams aImportParam ) : void | ||
InsertProgramsThreadStart ( ) : void | ||
checkGentleFiles ( ) : void |
Checks several files that are needed for using the gentle framework for the database. If some files are not present in the working folder an System.IO.FileNotFoundException exception is thrown
|
public AddCard ( string name, string devicePath, TvDatabase.Server server ) : TvDatabase.Card | ||
name | string | |
devicePath | string | |
server | TvDatabase.Server | |
return | TvDatabase.Card |
public AddChannelToGroup ( TvDatabase.Channel channel, TvDatabase.ChannelGroup group ) : void | ||
channel | TvDatabase.Channel | |
group | TvDatabase.ChannelGroup | |
return | void |
public AddChannelToGroup ( TvDatabase.Channel channel, string groupName ) : void | ||
channel | TvDatabase.Channel | |
groupName | string | |
return | void |
public AddChannelToRadioGroup ( TvDatabase.Channel channel, TvDatabase.RadioChannelGroup group ) : void | ||
channel | TvDatabase.Channel | |
group | TvDatabase.RadioChannelGroup | |
return | void |
public AddChannelToRadioGroup ( TvDatabase.Channel channel, string groupName ) : void | ||
channel | TvDatabase.Channel | channel to add |
groupName | string | target group name |
return | void |
public AddNewChannel ( string name, int channelNumber ) : TvDatabase.Channel | ||
name | string | |
channelNumber | int | |
return | TvDatabase.Channel |
public AddSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule | ||
idChannel | int | |
programName | string | |
startTime | System.DateTime | |
endTime | System.DateTime | |
scheduleType | int | |
return | TvDatabase.Schedule |
public AddTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel ) : TvDatabase.TuningDetail | ||
channel | TvDatabase.Channel | |
tvChannel | IChannel | |
return | TvDatabase.TuningDetail |
public AddWebStreamTuningDetails ( TvDatabase.Channel channel, string url, int bitrate ) : TvDatabase.TuningDetail | ||
channel | TvDatabase.Channel | |
url | string | |
bitrate | int | |
return | TvDatabase.TuningDetail |
public CreateGroup ( string groupName ) : TvDatabase.ChannelGroup | ||
groupName | string | |
return | TvDatabase.ChannelGroup |
public DeleteCard ( TvDatabase.Card card ) : void | ||
card | TvDatabase.Card | |
return | void |
public DeleteChannel ( TvDatabase.Channel channel ) : void | ||
channel | TvDatabase.Channel | |
return | void |
public EscapeSQLString ( string original ) : string | ||
original | string | |
return | string |
public GetCardByDevicePath ( string path ) : TvDatabase.Card | ||
path | string | |
return | TvDatabase.Card |
public GetCardByName ( string name ) : TvDatabase.Card | ||
name | string | |
return | TvDatabase.Card |
public GetChannel ( int idChannel ) : TvDatabase.Channel | ||
idChannel | int | |
return | TvDatabase.Channel |
public GetChannelByTuningDetail ( int networkId, int transportId, int serviceId ) : TvDatabase.Channel | ||
networkId | int | |
transportId | int | |
serviceId | int | |
return | TvDatabase.Channel |
public static GetChannelType ( TvLibrary.Channels.DVBBaseChannel channel ) : int | ||
channel | TvLibrary.Channels.DVBBaseChannel | |
return | int |
public GetChannelsByName ( string name ) : IList |
||
name | string | |
return | IList |
public GetChannelsInGroup ( TvDatabase.ChannelGroup group ) : IList |
||
group | TvDatabase.ChannelGroup | |
return | IList |
public GetConflictingSchedules ( TvDatabase.Schedule rec, List |
||
rec | TvDatabase.Schedule | |
conflictingSchedules | List |
|
notViewableSchedules | List |
|
return | void |
public GetGroupByName ( string aGroupName ) : TvDatabase.ChannelGroup | ||
aGroupName | string | |
return | TvDatabase.ChannelGroup |
public GetGroupByName ( string aGroupName, int aSortOrder ) : TvDatabase.ChannelGroup | ||
aGroupName | string | |
aSortOrder | int | |
return | TvDatabase.ChannelGroup |
public GetLinkagesForChannel ( TvDatabase.Channel channel ) : IList |
||
channel | TvDatabase.Channel | |
return | IList |
public GetNewestProgramForChannel ( int idChannel ) : System.DateTime | ||
idChannel | int | |
return | System.DateTime |
public GetNowAndNext ( List |
||
aEpgChannelList | List |
|
return | NowAndNext>.Dictionary |
public GetProgramExists ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList |
||
channel | TvDatabase.Channel | |
startTime | System.DateTime | |
endTime | System.DateTime | |
return | IList |
public GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime ) : IList |
||
channel | TvDatabase.Channel | |
startTime | System.DateTime | |
return | IList |
public GetPrograms ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime ) : IList |
||
channel | TvDatabase.Channel | |
startTime | System.DateTime | |
endTime | System.DateTime | |
return | IList |
public GetPrograms ( System.DateTime startTime, System.DateTime endTime ) : IList |
||
startTime | System.DateTime | |
endTime | System.DateTime | |
return | IList |
public GetProgramsByTitle ( TvDatabase.Channel channel, System.DateTime startTime, System.DateTime endTime, string title ) : IList |
||
channel | TvDatabase.Channel | |
startTime | System.DateTime | |
endTime | System.DateTime | |
title | string | |
return | IList |
public GetProgramsByTitle ( System.DateTime startTime, System.DateTime endTime, string title ) : IList |
||
startTime | System.DateTime | |
endTime | System.DateTime | |
title | string | |
return | IList |
public GetProgramsForAllChannels ( System.DateTime startTime, System.DateTime endTime, List |
||
startTime | System.DateTime | |
endTime | System.DateTime | |
channelList | List |
|
return | List |
public GetRadioChannelGroupByName ( string name ) : TvDatabase.RadioChannelGroup | ||
name | string | |
return | TvDatabase.RadioChannelGroup |
public GetRadioGuideChannelsForGroup ( int groupID ) : List |
||
groupID | int | |
return | List |
public GetRecordingByFileName ( string fileName ) : TvDatabase.Recording | ||
fileName | string | |
return | TvDatabase.Recording |
public GetRecordingTimes ( TvDatabase.Schedule rec ) : List |
||
rec | TvDatabase.Schedule | |
return | List |
public GetRecordingTimes ( TvDatabase.Schedule rec, int days ) : List |
||
rec | TvDatabase.Schedule | |
days | int | |
return | List |
public GetSchedule ( int idChannel, string programName, System.DateTime startTime, System.DateTime endTime, int scheduleType ) : TvDatabase.Schedule | ||
idChannel | int | |
programName | string | |
startTime | System.DateTime | |
endTime | System.DateTime | |
scheduleType | int | |
return | TvDatabase.Schedule |
public GetSetting ( string tagName ) : TvDatabase.Setting | ||
tagName | string | |
return | TvDatabase.Setting |
public GetSetting ( string tagName, string defaultValue ) : TvDatabase.Setting | ||
tagName | string | |
defaultValue | string | |
return | TvDatabase.Setting |
public GetTVGuideChannelsForGroup ( int groupID ) : List |
||
groupID | int | |
return | List |
public GetTuningChannel ( TvDatabase.TuningDetail detail ) : IChannel | ||
detail | TvDatabase.TuningDetail | |
return | IChannel |
public GetTuningChannelByType ( TvDatabase.Channel channel, int channelType ) : IChannel | ||
channel | TvDatabase.Channel | |
channelType | int | |
return | IChannel |
public GetTuningChannelsByDbChannel ( TvDatabase.Channel channel ) : List |
||
channel | TvDatabase.Channel | |
return | List |
public GetTuningDetail ( TvLibrary.Channels.DVBBaseChannel channel ) : TvDatabase.TuningDetail | ||
channel | TvLibrary.Channels.DVBBaseChannel | |
return | TvDatabase.TuningDetail |
public GetTuningDetail ( String url, int channelType ) : TvDatabase.TuningDetail | ||
url | String | |
channelType | int | |
return | TvDatabase.TuningDetail |
public GetTuningDetail ( int networkId, int serviceId, int channelType ) : TvDatabase.TuningDetail | ||
networkId | int | |
serviceId | int | |
channelType | int | |
return | TvDatabase.TuningDetail |
public GetTuningDetail ( int networkId, int transportId, int serviceId, int channelType ) : TvDatabase.TuningDetail | ||
networkId | int | |
transportId | int | |
serviceId | int | |
channelType | int | |
return | TvDatabase.TuningDetail |
public GetTuningDetailsByName ( string name, int channelType ) : IList |
||
name | string | |
channelType | int | |
return | IList |
public InsertPrograms ( List |
||
aProgramList | List |
A list of persistable gentle.NET Program objects mapping to the Programs table |
progamsToDelete | DeleteBeforeImportOption | Flag specifying which existing programs to delete before the insert |
aThreadPriority | ThreadPriority | Use "Lowest" for Background imports allowing LiveTV, AboveNormal for full speed |
return | int |
public InsertPrograms ( List |
||
aProgramList | List |
A list of persistable gentle.NET Program objects mapping to the Programs table |
aThreadPriority | ThreadPriority | Use "Lowest" for Background imports allowing LiveTV, AboveNormal for full speed |
return | int |
public IsChannelMappedToCard ( TvDatabase.Channel dbChannel, TvDatabase.Card card, bool forEpg ) : bool | ||
dbChannel | TvDatabase.Channel | |
card | TvDatabase.Card | |
forEpg | bool | |
return | bool |
public ListAllEnabledCardsOrderedByPriority ( ) : IList |
||
return | IList |
public MapChannelToCard ( TvDatabase.Card card, TvDatabase.Channel channel, bool epgOnly ) : TvDatabase.ChannelMap | ||
card | TvDatabase.Card | |
channel | TvDatabase.Channel | |
epgOnly | bool | |
return | TvDatabase.ChannelMap |
public OptimizeMySql ( string aTable ) : void | ||
aTable | string | The table which should be optimized. During the check process it will be locked. |
return | void |
public RemoveAllPrograms ( int idChannel ) : void | ||
idChannel | int | |
return | void |
public RemoveOldPrograms ( int idChannel ) : void | ||
idChannel | int | |
return | void |
public SaveMpGenres ( List |
||
mpGenres | List |
A list of MediaPortal genre objects |
return | void |
public SearchMinimalPrograms ( System.DateTime startTime, System.DateTime endTime, string programName, TvDatabase.Channel channel ) : IList |
||
startTime | System.DateTime | |
endTime | System.DateTime | |
programName | string | |
channel | TvDatabase.Channel | |
return | IList |
public SearchPrograms ( string searchCriteria ) : IList |
||
searchCriteria | string | |
return | IList |
public SearchPrograms ( string searchCriteria, ChannelType channelType ) : IList |
||
searchCriteria | string | |
channelType | ChannelType | |
return | IList |
public SearchProgramsByDescription ( string searchCriteria ) : IList |
||
searchCriteria | string | |
return | IList |
public SearchProgramsByDescription ( string searchCriteria, ChannelType channelType ) : IList |
||
searchCriteria | string | |
channelType | ChannelType | |
return | IList |
public SearchProgramsPerGenre ( string currentGenre, string searchCriteria ) : IList |
||
currentGenre | string | |
searchCriteria | string | |
return | IList |
public SearchProgramsPerGenre ( string currentGenre, string searchCriteria, ChannelType channelType ) : IList |
||
currentGenre | string | |
searchCriteria | string | |
channelType | ChannelType | |
return | IList |
public UpdateTuningDetails ( TvDatabase.Channel channel, IChannel tvChannel, TvDatabase.TuningDetail detail ) : TvDatabase.TuningDetail | ||
channel | TvDatabase.Channel | |
tvChannel | IChannel | |
detail | TvDatabase.TuningDetail | |
return | TvDatabase.TuningDetail |
public WaitForInsertPrograms ( int millisecondsTimeout ) : void | ||
millisecondsTimeout | int | |
return | void |
public isSameTransponder ( TvDatabase.Schedule schedule1, TvDatabase.Schedule schedule2 ) : bool | ||
schedule1 | TvDatabase.Schedule | |
schedule2 | TvDatabase.Schedule | |
return | bool |