#include <mythdbcon.h>
Myth & database connections Rule #1: Never use QSqlQuery or QSqlDatabase directly. Rule #2: Never use QSqlQuery or QSqlDatabase directly. Rule #3: Use MSqlQuery for all DB stuff.
MSqlQuery is tied to a connection pool in MythContext. DB connections are automatically set up by creating an MSqlQuery object. Use the helper functions to create an MSqlQuery object e.g. MSqlQuery query(MSqlQuery::InitCon()); The MSqlQuery object gets exclusive access to the connection for its lifetime. The connection is automatically returned when the MSqlQuery object is destroyed.
Note: Due to a bug in some Qt/MySql combinations, QSqlDatabase connections will crash if closed and reopend - so we never close them and keep them in a pool.
Definition at line 99 of file mythdbcon.h.
Public Member Functions | |
| MSqlQuery (const MSqlQueryInfo &qi) | |
| Get DB connection from pool. | |
| ~MSqlQuery () | |
| Returns conneciton to pool. | |
| bool | isConnected (void) |
| Only updated once during object creation. | |
| bool | exec (void) |
| This is needed since we define exec(const QString &query). | |
| bool | exec (const QString &query) |
| Wrap QSqlQuery::exec(const QString &query) so we can display SQL. | |
| bool | prepare (const QString &query) |
| QSqlQuery::prepare() is not thread safe in Qt <= 3.3.2. | |
| void | bindValues (MSqlBindings &bindings) |
| Add all the bindings in the passed in bindings. | |
| QVariant | lastInsertId () |
| Return the id of the last inserted row. | |
Static Public Member Functions | |
| static bool | testDBConnection () |
| Checks DB connection + login (login info via Mythcontext). | |
| static MSqlQueryInfo | InitCon () |
| Only use this in combination with MSqlQuery constructor. | |
| static MSqlQueryInfo | SchedCon () |
| Returns dedicated connection. (Required for using temporary SQL tables.). | |
| static MSqlQueryInfo | DDCon () |
| Returns dedicated connection. (Required for using temporary SQL tables.). | |
Private Attributes | |
| MSqlDatabase * | m_db |
| bool | m_isConnected |
| bool | m_returnConnection |
| MSqlQuery::MSqlQuery | ( | const MSqlQueryInfo & | qi | ) |
| MSqlQuery::~MSqlQuery | ( | ) |
| bool MSqlQuery::isConnected | ( | void | ) | [inline] |
Only updated once during object creation.
Definition at line 108 of file mythdbcon.h.
Referenced by DBUtil::BackupDB(), ChannelBase::CheckChannel(), UPnpCDSVideo::CreateItems(), UPnpCDSExtension::CreateItems(), HouseKeeper::flushLogs(), UPnpCDSExtension::GetCount(), UPnpCDSExtension::GetDistinctCount(), getGlobalSetting(), MythXML::GetHosts(), MythMainWindow::GetKey(), MythXML::GetKeys(), MythXML::GetMusic(), MythXML::GetSetting(), MythContext::GetSetting(), LogViewer::getSetting(), MythContext::GetSettingOnHost(), DBUtil::GetTables(), MythXML::GetVideo(), TV::Init(), MythDbSettings1::MythDbSettings1(), UPnpCDSExtension::ProcessContainer(), UPnpCDSVideo::ProcessItem(), UPnpCDSExtension::ProcessItem(), UPnpCDSExtension::ProcessKey(), MythMainWindow::RegisterJump(), MythMainWindow::RegisterKey(), HouseKeeper::RunHouseKeeping(), MythContext::SaveSettingOnHost(), setGlobalSetting(), TVRec::ShouldSwitchToAnotherCard(), testDBConnection(), HouseKeeper::updateLastrun(), and HouseKeeper::wantToRun().
| bool MSqlQuery::exec | ( | void | ) | [inline] |
This is needed since we define exec(const QString &query).
Definition at line 111 of file mythdbcon.h.
Referenced by FileAssociationsImp::add(), MultiValueImp::add(), SingleValueImp::add(), DBEvent::AddAuthority(), FileScanner::AddFileToDB(), ProgramInfo::AddHistory(), addMyselfToDirectory(), Scheduler::AddNewRecords(), Scheduler::AddNotListed(), ProfileGroup::allowedGroupName(), LiveTVChain::AppendNewProgram(), ChannelRecPriority::applyChannelRecPriorityChange(), ProgramInfo::ApplyRecordPlayGroupChange(), ProgramInfo::ApplyRecordRecGroupChange(), ProgramInfo::ApplyRecordRecID(), ProgramInfo::ApplyRecordRecTitleChange(), ProgramInfo::ApplyTranscoderProfileChange(), DBUtil::BackupDB(), Bookmarks::Bookmarks(), BookmarksConfig::BookmarksConfig(), InputGroupMap::Build(), UPnpMedia::buildFileList(), UPnpMedia::BuildMediaMap(), MoviesUI::buildMovieDataTree(), Scheduler::BuildNewRecordsQueries(), MoviesUI::buildTheaterDataTree(), DVDTranscodeThread::buildTranscodeCommandLine(), ProfileGroupEditor::callDelete(), VideoSourceEditor::cardTypesInclude(), ChannelWizard::cardTypesInclude(), change_program(), TV::ChangeChannel(), JobQueue::ChangeJobArgs(), JobQueue::ChangeJobCmds(), JobQueue::ChangeJobComment(), JobQueue::ChangeJobFlags(), JobQueue::ChangeJobHost(), JobQueue::ChangeJobStatus(), chanid_available(), ChannelEditor::channelIconImport(), DDStructureParser::characters(), StorageGroup::CheckAllStorageGroupDirs(), ImportIconsWizard::checkAndDownload(), ChannelBase::CheckChannel(), TVRec::CheckChannelPrefix(), checkChannelPresets(), checkHandlers(), checkStoragePaths(), CustomPriority::checkSyntax(), CustomEdit::checkSyntax(), chooseQueue(), FileScanner::cleanDB(), HouseKeeper::CleanupAllOldInUsePrograms(), CleanupMyOldInUsePrograms(), HouseKeeper::CleanupMyOldRecordings(), JobQueue::CleanupOldJobsInQueue(), HouseKeeper::CleanupOrphanedLivetvChains(), HouseKeeper::CleanupProgramListings(), HouseKeeper::CleanupRecordedTables(), GameHandler::clearAllGameData(), clearArchiveTable(), EITCache::ClearChannelLocks(), ProgramData::clearDataByChannel(), ProgramData::clearDataBySource(), ProgramInfo::ClearMarkupMap(), ProgramInfo::ClearPositionMap(), StatusBox::clicked(), clone_capturecard(), clone_cardinputs(), KeyBindings::CommitAction(), KeyBindings::CommitJumppoint(), CompleteJob(), convert_diseqc_db(), GalleryUtil::Copy(), ChannelWizard::countCardtypes(), DataDirectProcessor::CreateATempTable(), DiSEqCDevDevice::CreateById(), ChannelUtil::CreateChannel(), CardUtil::CreateInputGroup(), UPnpCDSVideo::CreateItems(), UPnpCDSExtension::CreateItems(), CardInput::CreateNewInputGroup(), VideoDisplayProfile::CreateProfile(), VideoDisplayProfile::CreateProfileGroup(), CustomEdit::CustomEdit(), CustomPriority::CustomPriority(), DataDirectProcessor::DataDirectProgramUpdate(), ProgramRecPriority::deactivate(), commDetector2::debugDirectory(), MythGamePlayerEditor::del(), ChannelEditor::del(), TransportListEditor::Delete(), GalleryUtil::Delete(), delete_in_db(), delete_program(), CardUtil::DeleteAllCards(), JobQueue::DeleteAllJobs(), SourceUtil::DeleteAllSources(), CardUtil::DeleteCard(), SmartPlaylistEditor::deleteCategory(), ChannelEditor::deleteChannels(), CustomPriority::deleteClicked(), VideoDisplayProfile::DeleteDB(), ProgramInfo::DeleteHistory(), CardUtil::DeleteInput(), PreviousList::deleteItem(), JobQueue::DeleteJob(), ProgLister::deleteKeyword(), CardUtil::DeleteOrphanInputs(), PlaylistsContainer::deletePlaylist(), VideoDisplayProfile::DeleteProfileGroup(), VideoDisplayProfile::DeleteProfiles(), LiveTVChain::DeleteProgram(), SmartPlaylistEditor::deleteSmartPlaylist(), SourceUtil::DeleteSource(), Ripper::deleteTrack(), CallRecord::deleteYourselfFromDB(), DirEntry::deleteYourselfFromDB(), LiveTVChain::DestroyChain(), DVDTitle::determineInputID(), DisplayRecGroup(), StorageGroupListEditor::doDelete(), StorageGroupEditor::doDelete(), PlayGroupEditor::doDelete(), MainServer::DoDeleteInDB(), StatusBox::doListingsStatus(), StatusBox::doLogEntries(), DoOldVideoDatabaseSchemaUpgrade(), MythburnWizard::doRemoveArchiveItem(), StatusBox::doScheduleStatus(), JobQueue::DoTranscodeThread(), StatusBox::doTunerStatus(), doUpgradeTVDatabaseSchema(), MetadataImp::dropFromDB(), Metadata::dumpToDatabase(), CaptureCardEditor::edit(), ProgramRecPriority::edit(), ChannelRecPriority::edit(), RomInfo::edit_rominfo(), DDStructureParser::endElement(), AutoExpire::ExpireEpisodesOverMax(), AutoExpire::ExpireRecordings(), IconData::ExportIconMap(), NativeArchive::exportRecording(), NativeArchive::exportVideo(), extractDetailsFromFilename(), ScheduledRecording::fetchChannelInfo(), FileScanner::FileScanner(), FileAssociationsImp::fill_from_db(), MultiValueImp::fill_from_db(), SingleValueImp::fill_from_db(), RomInfo::fillData(), FillData::fillData(), AutoExpire::FillDBOrdered(), Metadata::fillFieldList(), DTVMultiplex::FillFromDB(), ProgLister::fillItemList(), ProgramRecPriority::FillList(), PlaybackBox::FillList(), ChannelRecPriority::FillList(), UPnpMedia::FillMetaMaps(), GameTree::fillNode(), PlaybackBox::fillRecGroupPasswordCache(), Scheduler::FillRecordingDir(), Scheduler::FillRecordListFromDB(), ImportNativeWizard::fillSearchList(), CaptureCard::fillSelections(), VideoSource::fillSelections(), TransportList::fillSelections(), SRRecGroup::fillSelections(), SRInput::fillSelections(), ChannelSetting::fillSelections(), ScheduledRecording::fillSelections(), RecordingProfile::fillSelections(), ProfileGroup::fillSelections(), MythGamePlayerSettings::fillSelections(), Source::fillSelections(), ChannelListSetting::fillSelections(), Playlist::fillSonglistFromQuery(), Playlist::fillSonglistFromSmartPlaylist(), HttpStatus::FillStatusXML(), ProgLister::fillViewList(), Scheduler::findAllScheduledPrograms(), ChannelUtil::FindChannel(), ImportNativeWizard::findChannelMatch(), ChannelID::findHighest(), AlbumArtImages::findImages(), MythNewsConfig::findInDB(), MythNews::findInDB(), MythFlixConfig::findInDB(), SourceManager::findScripts(), SourceManager::findScriptsDB(), TabView::finishAddBookmark(), ProgramInfo::FinishedRecording(), LiveTVChain::FinishedRecording(), ProgramData::fix_end_times(), DataDirectProcessor::FixProgramIDs(), FlagCommercials(), HouseKeeper::flushLogs(), ProgramInfo::ForgetHistory(), ProgramList::FromOldRecorded(), ProgramList::FromProgram(), ProgramList::FromRecorded(), get_atsc_stuff(), get_cardtype(), get_cardtypes(), get_chan_id_from_db(), get_dtv_multiplex(), get_input_id(), get_max_chanid(), get_on_cardid(), get_ratings(), get_use_eit(), StatusBox::getActualRecordedBPS(), MythXML::GetAlbumArt(), MythburnWizard::getArchiveListFromDB(), ExportNativeWizard::getArchiveListFromDB(), ChannelUtil::GetATSCChannel(), ProgramInfo::GetAutoExpireFromRecorded(), ChannelUtil::GetBetterMplexID(), DTVChannel::GetCachedPids(), CardUtil::GetCardIDs(), CardUtil::GetCardList(), ChannelWizard::getCardtype(), DVBChannel::GetChanID(), ChannelUtil::GetChanID(), ChannelBase::GetChanID(), IPTVChannel::GetChanInfo(), ProgramInfo::GetChannel(), SourceUtil::GetChannelCount(), ChannelUtil::GetChannelData(), MythXML::GetChannelIcon(), DBox2EPG::GetChannelID(), MHIContext::GetChannelIndex(), TVRec::GetChannelInfo(), DBox2Channel::GetChannelNameFromNumber(), DBox2Channel::GetChannelNumberFromName(), ProgramInfo::GetChannelRecPriority(), ChannelUtil::GetChannels(), SourceUtil::GetChannelSeparator(), ChannelUtil::GetChannelSettings(), ChannelUtil::GetChannelStringField(), ChannelUtil::GetChannelValueStr(), CardUtil::GetCloneCardIDs(), CardUtil::GetConfiguredDVBInputs(), UPnpCDSExtension::GetCount(), PlayGroup::GetCount(), DBox2Channel::GetDefaultChannel(), CardUtil::GetDefaultInput(), CardUtil::GetDeviceLabel(), TVRec::GetDevices(), FileScanner::GetDirectoryId(), CardUtil::GetDisplayName(), UPnpCDSVideo::GetDistinctCount(), UPnpCDSExtension::GetDistinctCount(), ProgramInfo::GetDVDBookmark(), MusicPlayer::getFilenameFromID(), ProgramInfo::GetFilesize(), Channel::GetFormatForChannel(), getGlobalSetting(), CardUtil::GetGroupCardIDs(), MainServer::getGuideDataThrough(), ProfileGroup::getHostNames(), MythXML::GetHosts(), PlayGroup::GetInitialName(), CardUtil::GetInputGroups(), ChannelUtil::GetInputID(), CardUtil::GetInputIDs(), CardUtil::GetInputInfo(), CardUtil::GetInputNames(), JobQueue::GetJobArgs(), JobQueue::GetJobCmd(), JobQueue::GetJobFlags(), JobQueue::GetJobID(), JobQueue::GetJobInfoFromID(), JobQueue::GetJobsInQueue(), JobQueue::GetJobStatus(), MythMainWindow::GetKey(), MythXML::GetKeys(), HouseKeeper::getLastRun(), SourceUtil::GetListingsLoginData(), ProgramInfo::GetMarkupMap(), Metadata::getMetadataFromID(), ProgramInfo::GetMplexID(), ChannelUtil::GetMplexID(), MythXML::GetMusic(), RecordingProfile::getName(), ProfileGroup::getName(), PlayGroup::GetNames(), TVRec::GetNextProgram(), DBEvent::GetOverlappingPrograms(), DBPerson::GetPersonDB(), ProgramInfo::GetPositionMap(), ProgramInfo::GetPreserveEpisodeFromRecorded(), VideoDisplayProfile::GetProfileGroupID(), VideoDisplayProfile::GetProfiles(), ProgramInfo::GetProgramAtDateTime(), ProgramInfo::getProgramFlags(), ProgramInfo::GetProgramFromBasename(), ProgramInfo::GetProgramFromRecorded(), MythXML::GetProgramGuide(), ProgramInfo::getProgramProperties(), CardUtil::GetQuickTuning(), ProgramInfo::GetRecGroupPassword(), ProgramInfo::GetRecordBasename(), StorageGroup::getRecordingsGroups(), ThumbItem::GetRotationAngle(), ProgFinder::getSearchData(), MHIContext::GetServiceInfo(), ChannelUtil::GetServiceVersion(), PlayGroup::GetSetting(), MythXML::GetSetting(), MythContext::GetSetting(), LogViewer::getSetting(), MythContext::GetSettingOnHost(), RemoteEncoder::GetSignalLockTimeout(), SmartPlaylistDialog::getSmartPlaylistCategories(), SmartPlaylistEditor::getSmartPlaylistCategories(), SmartPlaylistDialog::getSmartPlaylists(), ChannelUtil::GetSourceID(), ChannelUtil::GetSourceIDForChannel(), SourceUtil::GetSourceName(), TVRec::GetStartChannel(), DBUtil::GetTables(), CardUtil::GetTimeouts(), ProgramInfo::GetTranscodedStatus(), ChannelUtil::GetTuningParams(), TV::GetValidRecorderList(), MythXML::GetVideo(), MythXML::GetVideoArt(), CardUtil::GetVideoDevices(), VideoSelector::getVideoListFromDB(), FillData::grabData(), FillData::grabDDData(), DataDirectProcessor::GrabNextSuggestedTime(), RecordingProfile::groupType(), MythburnWizard::handleAddVideo(), ExportNativeWizard::handleAddVideo(), ChannelData::handleChannels(), MainServer::HandleGetPendingRecordings(), MainServer::HandleLockTuner(), ProgramData::handlePrograms(), MainServer::HandleQueryRecordings(), SourceUtil::HasDigitalChannel(), CardUtil::IgnoreEncrypted(), IconData::ImportIconMap(), NativeArchive::importRecording(), NativeArchive::importVideo(), StorageGroup::Init(), InitializeDatabase(), InitializeDVDDatabase(), ChannelBase::InitializeInputs(), InitializeVideoDatabase(), ImportIconsWizard::initialLoad(), GameHandler::InitMetaDataMap(), insert_dtv_multiplex(), insert_program(), DBPerson::InsertCreditsDB(), DBEvent::InsertDB(), MythNewsConfig::insertInDB(), MythNews::insertInDB(), MythFlixConfig::insertInDB(), DBPerson::InsertPersonDB(), CustomPriority::installClicked(), is_dishnet_eit(), is_input_group_busy(), SourceUtil::IsAnySourceScanable(), MythburnWizard::isArchiveItemValid(), CardUtil::IsCardTypePresent(), ProgramInfo::IsCommFlagged(), ProgramInfo::IsEditing(), SourceUtil::IsEncoder(), Metadata::isInDatabase(), ProgramInfo::IsInUse(), Ripper::isNewTune(), CardUtil::IsTunerShared(), StatusBox::keyPressEvent(), lastInsertId(), CardUtil::LinkInputGroup(), NetworkControl::listRecordings(), NetworkControl::listSchedule(), TV::LiveTV(), CardInputEditor::load(), InputGroup::load(), TransFreqTableSelector::load(), VideoSourceSelector::load(), StorageGroupListEditor::load(), StorageGroupEditor::load(), InputSelector::load(), MultiplexSetting::load(), PlaylistsContainer::load(), SimpleDBStorage::load(), DiSEqCDevLNB::Load(), DiSEqCDevRotor::Load(), DiSEqCDevSwitch::Load(), DiSEqCDevTree::Load(), DiSEqCDevSettings::Load(), DirectoryContainer::Load(), SourceSetting::load(), MetadataListManager::loadAllFromDatabase(), RecordingProfile::loadByGroup(), RecordingProfile::loadByID(), CardInput::loadByInput(), ScheduledRecording::loadBySearch(), RecordingProfile::loadByType(), EITCache::LoadChannel(), KeyBindings::LoadContexts(), SourceSetup::loadData(), ScreenSetup::loadData(), VideoDisplayProfile::LoadDB(), SmartPlaylistEditor::loadFromDatabase(), KeyBindings::LoadJumppoints(), Playlist::loadPlaylist(), Playlist::loadPlaylistByID(), MythNews::loadSites(), MainServer::LocalFilePath(), lock_channel(), lockSchema(), lockShutdown(), MythContext::LogEntry(), SmartPlaylistEditor::lookupCategoryID(), main(), ProgramInfo::MarkAsInUse(), GalleryUtil::Move(), MythFlix::MythFlix(), MythFlixQueue::MythFlixQueue(), MythNewsConfig::MythNewsConfig(), SmartPlaylistEditor::newCategory(), VideoSelector::OKPressed(), RecordingSelector::OKPressed(), FileSelector::OKPressed(), StorageGroupEditor::open(), RecordingProfileEditor::open(), ProfileGroupEditor::open(), PlayGroupEditor::open(), performActualUpdate(), Metadata::persist(), Bookmarks::populateListView(), BookmarksConfig::populateListView(), ProgLister::powerEdit(), preMusic(), WeatherSource::probeScript(), UPnpCDSExtension::ProcessContainer(), UPnpCDSVideo::ProcessItem(), UPnpCDSExtension::ProcessItem(), UPnpCDSExtension::ProcessKey(), MoviesUI::processMovie(), MoviesUI::processTheatre(), purgeGameDB(), DBUtil::QueryDBMSVersion(), JobQueue::QueueJob(), ProgramInfo::ReactivateRecording(), ManualSchedule::recordClicked(), MythMainWindow::RegisterJump(), MythMainWindow::RegisterKey(), LiveTVChain::ReloadAll(), PreviousList::removalDialog(), ThumbItem::Remove(), ScheduledRecording::remove(), FileAssociationsImp::remove(), MultiValueImp::remove(), SingleValueImp::remove(), FileScanner::RemoveFileFromDB(), MythNewsConfig::removeFromDB(), MythNews::removeFromDB(), MythFlixConfig::removeFromDB(), ExportNativeWizard::removeItem(), GalleryUtil::Rename(), SmartPlaylistEditor::renameCategory(), GalleryUtil::RenameDirectory(), replace_in_db(), IconData::ResetIconMap(), AllMusic::resync(), romInDB(), HouseKeeper::RunHouseKeeping(), SearchDialog::runQuery(), Scheduler::RunScheduler(), RunSimpleQuery(), runVideoSelector(), CardInput::save(), XMLTVConfig::save(), TransFreqTableSelector::save(), AutoIncrementDBSetting::save(), ScheduledRecording::save(), ProgramInfo::Save(), SimpleDBStorage::save(), ChannelID::save(), DTVChannel::SaveCachedPids(), SmartPlaylistEditor::saveClicked(), SourceSetup::saveData(), ScreenSetup::saveData(), VideoDisplayProfile::SaveDB(), AlbumArtImages::saveImageType(), SavePending(), Playlist::savePlaylist(), MythContext::SaveSettingOnHost(), SmartPLCriteriaRow::saveToDatabase(), MetadataImp::saveToDatabase(), ScanWizardScanner::Scan(), FileScanner::ScanArtwork(), FileScanner::ScanMusic(), SIScan::ScanServicesSourceID(), SIScan::ScanTransport(), ImportNativeWizard::searchCallsign(), ImportNativeWizard::searchChanID(), ImportNativeWizard::searchChanNo(), ImportNativeWizard::searchName(), ProgFinder::selectSearchData(), set_lineup_type(), set_on_source(), ProgramInfo::SetAutoExpire(), ProgramInfo::SetBookmark(), TVRec::SetChannelInfo(), ChannelUtil::SetChannelValue(), ProgramInfo::SetCommFlagged(), ProgramInfo::SetCutList(), ProgramInfo::SetDeleteFlag(), ProgramInfo::SetDupHistory(), ProgramInfo::SetDVDBookmark(), ProgramInfo::SetEditing(), RomInfo::setFavorite(), ProgramInfo::SetFilesize(), setGlobalSetting(), ProgramInfo::SetMarkupMap(), ProgramInfo::SetPositionMap(), ProgramInfo::SetPositionMapDelta(), ProgramInfo::SetPreserveEpisode(), PlaybackBox::SetRecGroupPassword(), ProgramInfo::SetRecordBasename(), ThumbItem::SetRotationAngle(), ChannelUtil::SetServiceVersion(), StartingChannel::SetSourceID(), SmartPLResultViewer::setSQL(), ProgramInfo::SetTranscoded(), setupDatabase(), Weather::setupScreens(), SourceManager::setupSources(), setupTVs(), ProgramInfo::SetWatchedFlag(), TVRec::ShouldSwitchToAnotherCard(), TitleDialog::showCurrentTitle(), ProgramInfo::showDetails(), PlaybackBox::showRecGroupChanger(), PlaybackBox::showRecGroupChooser(), BookmarksConfig::slotBookmarksViewExecuted(), MythNews::slotNewsRetrieved(), BookmarksConfig::slotWebSiteAdded(), ChannelOptionsCommon::sourceChanged(), EITScanner::StartActiveScan(), ProgramInfo::StartedRecording(), DiSEqCDevLNB::Store(), DiSEqCDevRotor::Store(), DiSEqCDevSwitch::Store(), DiSEqCDevTree::Store(), DiSEqCDevSettings::Store(), CustomEdit::storeClicked(), ChannelBase::StoreDefaultInput(), ChannelBase::StoreInputChannels(), ScheduledRecording::testRecording(), CustomPriority::testSchedule(), TVRec::ToggleChannelFavorite(), GuideGrid::toggleChannelFavorite(), ProgramInfo::ToMap(), MainServer::TruncateAndClose(), CardUtil::TVOnly(), CardUtil::UnlinkInputGroup(), unlock_channel(), unlockSchema(), unlockShutdown(), update_channel_basic(), ChannelUtil::UpdateChannel(), DataDirectProcessor::UpdateChannelsSafe(), DataDirectProcessor::UpdateChannelsUnsafe(), DBEvent::UpdateDB(), DBox2EPG::UpdateDB(), UpdateDBVersionNumber(), updateDiskCount(), updateDisplayRom(), AutoExpire::UpdateDontExpireSet(), UpdateGameCounts(), GameHandler::UpdateGameDB(), updateGameName(), ProgLister::updateKeywordInDB(), ProgramInfo::UpdateLastDelete(), HouseKeeper::updateLastrun(), DataDirectProcessor::UpdateListings(), Scheduler::UpdateManuals(), SmartPlaylistEditor::updateMatches(), Scheduler::UpdateMatches(), MoviesUI::updateMovieTimes(), Scheduler::UpdateNextRecord(), DataDirectProcessor::UpdateProgramViewTable(), ProgramInfo::UpdateRecGroup(), ProgramInfo::UpdateRecordingEnd(), VideoSelector::updateSelectedList(), RecordingSelector::updateSelectedList(), FileSelector::updateSelectedList(), GameHandler::updateSettings(), IconData::UpdateSourceIcons(), DataDirectProcessor::UpdateStationViewTable(), CallRecord::updateYourselfInDB(), DirEntry::updateYourselfInDB(), UpgradeGameDatabaseSchema(), UpgradeMusicDatabaseSchema(), UpgradeTVDatabaseSchema(), DBox2EPG::UseOnAirGuide(), ProgramInfo::UsesMaxEpisodes(), Scheduler::verifyCards(), GameHandler::VerifyGameDB(), and HouseKeeper::wantToRun().
| bool MSqlQuery::exec | ( | const QString & | query | ) |
Wrap QSqlQuery::exec(const QString &query) so we can display SQL.
Definition at line 385 of file mythdbcon.cpp.
| bool MSqlQuery::prepare | ( | const QString & | query | ) |
QSqlQuery::prepare() is not thread safe in Qt <= 3.3.2.
Definition at line 411 of file mythdbcon.cpp.
Referenced by FileAssociationsImp::add(), MultiValueImp::add(), SingleValueImp::add(), DBEvent::AddAuthority(), FileScanner::AddFileToDB(), ProgramInfo::AddHistory(), Scheduler::AddNewRecords(), Scheduler::AddNotListed(), ProfileGroup::allowedGroupName(), LiveTVChain::AppendNewProgram(), ChannelRecPriority::applyChannelRecPriorityChange(), ProgramInfo::ApplyRecordPlayGroupChange(), ProgramInfo::ApplyRecordRecGroupChange(), ProgramInfo::ApplyRecordRecID(), ProgramInfo::ApplyRecordRecTitleChange(), ProgramInfo::ApplyTranscoderProfileChange(), DBUtil::BackupDB(), InputGroupMap::Build(), UPnpMedia::buildFileList(), UPnpCDSVideo::BuildItemQuery(), UPnpCDSTv::BuildItemQuery(), UPnpCDSMusic::BuildItemQuery(), UPnpMedia::BuildMediaMap(), MoviesUI::buildMovieDataTree(), Scheduler::BuildNewRecordsQueries(), MoviesUI::buildTheaterDataTree(), ProfileGroupEditor::callDelete(), VideoSourceEditor::cardTypesInclude(), ChannelWizard::cardTypesInclude(), change_program(), TV::ChangeChannel(), JobQueue::ChangeJobArgs(), JobQueue::ChangeJobCmds(), JobQueue::ChangeJobComment(), JobQueue::ChangeJobFlags(), JobQueue::ChangeJobHost(), JobQueue::ChangeJobStatus(), chanid_available(), ChannelEditor::channelIconImport(), DDStructureParser::characters(), StorageGroup::CheckAllStorageGroupDirs(), ImportIconsWizard::checkAndDownload(), ChannelBase::CheckChannel(), TVRec::CheckChannelPrefix(), checkChannelPresets(), checkStoragePaths(), CustomPriority::checkSyntax(), CustomEdit::checkSyntax(), FileScanner::cleanDB(), HouseKeeper::CleanupAllOldInUsePrograms(), CleanupMyOldInUsePrograms(), HouseKeeper::CleanupMyOldRecordings(), JobQueue::CleanupOldJobsInQueue(), HouseKeeper::CleanupOrphanedLivetvChains(), HouseKeeper::CleanupProgramListings(), HouseKeeper::CleanupRecordedTables(), clearArchiveTable(), EITCache::ClearChannelLocks(), ProgramData::clearDataByChannel(), ProgramData::clearDataBySource(), ProgramInfo::ClearMarkupMap(), ProgramInfo::ClearPositionMap(), StatusBox::clicked(), clone_capturecard(), clone_cardinputs(), KeyBindings::CommitAction(), KeyBindings::CommitJumppoint(), CompleteJob(), convert_diseqc_db(), GalleryUtil::Copy(), ChannelWizard::countCardtypes(), DiSEqCDevDevice::CreateById(), ChannelUtil::CreateChannel(), CardUtil::CreateInputGroup(), UPnpCDSVideo::CreateItems(), UPnpCDSExtension::CreateItems(), CardInput::CreateNewInputGroup(), VideoDisplayProfile::CreateProfile(), VideoDisplayProfile::CreateProfileGroup(), CustomEdit::CustomEdit(), CustomPriority::CustomPriority(), ProgramRecPriority::deactivate(), commDetector2::debugDirectory(), MythGamePlayerEditor::del(), ChannelEditor::del(), TransportListEditor::Delete(), GalleryUtil::Delete(), delete_in_db(), delete_program(), JobQueue::DeleteAllJobs(), CardUtil::DeleteCard(), SmartPlaylistEditor::deleteCategory(), ChannelEditor::deleteChannels(), CustomPriority::deleteClicked(), VideoDisplayProfile::DeleteDB(), ProgramInfo::DeleteHistory(), CardUtil::DeleteInput(), PreviousList::deleteItem(), JobQueue::DeleteJob(), ProgLister::deleteKeyword(), CardUtil::DeleteOrphanInputs(), PlaylistsContainer::deletePlaylist(), VideoDisplayProfile::DeleteProfileGroup(), VideoDisplayProfile::DeleteProfiles(), LiveTVChain::DeleteProgram(), SmartPlaylistEditor::deleteSmartPlaylist(), SourceUtil::DeleteSource(), Ripper::deleteTrack(), LiveTVChain::DestroyChain(), DVDTitle::determineInputID(), DisplayRecGroup(), StorageGroupListEditor::doDelete(), StorageGroupEditor::doDelete(), PlayGroupEditor::doDelete(), MainServer::DoDeleteInDB(), StatusBox::doListingsStatus(), StatusBox::doLogEntries(), MythburnWizard::doRemoveArchiveItem(), StatusBox::doScheduleStatus(), JobQueue::DoTranscodeThread(), StatusBox::doTunerStatus(), doUpgradeTVDatabaseSchema(), MetadataImp::dropFromDB(), Metadata::dumpToDatabase(), CaptureCardEditor::edit(), ProgramRecPriority::edit(), ChannelRecPriority::edit(), RomInfo::edit_rominfo(), DDStructureParser::endElement(), AutoExpire::ExpireEpisodesOverMax(), AutoExpire::ExpireRecordings(), IconData::ExportIconMap(), NativeArchive::exportRecording(), NativeArchive::exportVideo(), extractDetailsFromFilename(), ScheduledRecording::fetchChannelInfo(), FileScanner::FileScanner(), RomInfo::fillData(), FillData::fillData(), AutoExpire::FillDBOrdered(), Metadata::fillFieldList(), DTVMultiplex::FillFromDB(), ProgLister::fillItemList(), ProgramRecPriority::FillList(), PlaybackBox::FillList(), ChannelRecPriority::FillList(), UPnpMedia::FillMetaMaps(), GameTree::fillNode(), PlaybackBox::fillRecGroupPasswordCache(), Scheduler::FillRecordingDir(), Scheduler::FillRecordListFromDB(), CaptureCard::fillSelections(), VideoSource::fillSelections(), TransportList::fillSelections(), SRRecGroup::fillSelections(), SRInput::fillSelections(), ChannelSetting::fillSelections(), ScheduledRecording::fillSelections(), RecordingProfile::fillSelections(), ProfileGroup::fillSelections(), MythGamePlayerSettings::fillSelections(), Source::fillSelections(), ChannelListSetting::fillSelections(), Playlist::fillSonglistFromSmartPlaylist(), HttpStatus::FillStatusXML(), ProgLister::fillViewList(), Scheduler::findAllScheduledPrograms(), ChannelUtil::FindChannel(), ImportNativeWizard::findChannelMatch(), ChannelID::findHighest(), AlbumArtImages::findImages(), MythNewsConfig::findInDB(), MythNews::findInDB(), MythFlixConfig::findInDB(), SourceManager::findScripts(), SourceManager::findScriptsDB(), TabView::finishAddBookmark(), ProgramInfo::FinishedRecording(), LiveTVChain::FinishedRecording(), DataDirectProcessor::FixProgramIDs(), FlagCommercials(), HouseKeeper::flushLogs(), ProgramInfo::ForgetHistory(), ProgramList::FromOldRecorded(), ProgramList::FromProgram(), ProgramList::FromRecorded(), get_atsc_stuff(), get_cardtype(), get_cardtypes(), get_chan_id_from_db(), get_dtv_multiplex(), get_input_id(), get_max_chanid(), get_on_cardid(), get_ratings(), get_use_eit(), StatusBox::getActualRecordedBPS(), MythXML::GetAlbumArt(), MythburnWizard::getArchiveListFromDB(), ExportNativeWizard::getArchiveListFromDB(), ChannelUtil::GetATSCChannel(), ProgramInfo::GetAutoExpireFromRecorded(), ChannelUtil::GetBetterMplexID(), DTVChannel::GetCachedPids(), CardUtil::GetCardIDs(), CardUtil::GetCardList(), ChannelWizard::getCardtype(), DVBChannel::GetChanID(), ChannelUtil::GetChanID(), ChannelBase::GetChanID(), IPTVChannel::GetChanInfo(), ProgramInfo::GetChannel(), SourceUtil::GetChannelCount(), ChannelUtil::GetChannelData(), MythXML::GetChannelIcon(), DBox2EPG::GetChannelID(), MHIContext::GetChannelIndex(), TVRec::GetChannelInfo(), DBox2Channel::GetChannelNameFromNumber(), DBox2Channel::GetChannelNumberFromName(), ProgramInfo::GetChannelRecPriority(), ChannelUtil::GetChannels(), SourceUtil::GetChannelSeparator(), ChannelUtil::GetChannelSettings(), ChannelUtil::GetChannelStringField(), ChannelUtil::GetChannelValueStr(), CardUtil::GetCloneCardIDs(), CardUtil::GetConfiguredDVBInputs(), UPnpCDSExtension::GetCount(), PlayGroup::GetCount(), DBox2Channel::GetDefaultChannel(), CardUtil::GetDefaultInput(), CardUtil::GetDeviceLabel(), TVRec::GetDevices(), FileScanner::GetDirectoryId(), CardUtil::GetDisplayName(), UPnpCDSVideo::GetDistinctCount(), UPnpCDSExtension::GetDistinctCount(), ProgramInfo::GetDVDBookmark(), MusicPlayer::getFilenameFromID(), ProgramInfo::GetFilesize(), Channel::GetFormatForChannel(), getGlobalSetting(), CardUtil::GetGroupCardIDs(), MainServer::getGuideDataThrough(), ProfileGroup::getHostNames(), MythXML::GetHosts(), PlayGroup::GetInitialName(), CardUtil::GetInputGroups(), ChannelUtil::GetInputID(), CardUtil::GetInputIDs(), CardUtil::GetInputInfo(), CardUtil::GetInputNames(), JobQueue::GetJobArgs(), JobQueue::GetJobCmd(), JobQueue::GetJobFlags(), JobQueue::GetJobID(), JobQueue::GetJobInfoFromID(), JobQueue::GetJobsInQueue(), JobQueue::GetJobStatus(), MythMainWindow::GetKey(), MythXML::GetKeys(), HouseKeeper::getLastRun(), SourceUtil::GetListingsLoginData(), ProgramInfo::GetMarkupMap(), Metadata::getMetadataFromID(), ProgramInfo::GetMplexID(), ChannelUtil::GetMplexID(), MythXML::GetMusic(), RecordingProfile::getName(), ProfileGroup::getName(), PlayGroup::GetNames(), TVRec::GetNextProgram(), DBEvent::GetOverlappingPrograms(), DBPerson::GetPersonDB(), ProgramInfo::GetPositionMap(), ProgramInfo::GetPreserveEpisodeFromRecorded(), VideoDisplayProfile::GetProfileGroupID(), VideoDisplayProfile::GetProfiles(), ProgramInfo::GetProgramAtDateTime(), ProgramInfo::getProgramFlags(), ProgramInfo::GetProgramFromBasename(), ProgramInfo::GetProgramFromRecorded(), MythXML::GetProgramGuide(), ProgramInfo::getProgramProperties(), CardUtil::GetQuickTuning(), ProgramInfo::GetRecGroupPassword(), ProgramInfo::GetRecordBasename(), StorageGroup::getRecordingsGroups(), ThumbItem::GetRotationAngle(), ProgFinder::getSearchData(), MHIContext::GetServiceInfo(), ChannelUtil::GetServiceVersion(), PlayGroup::GetSetting(), MythXML::GetSetting(), MythContext::GetSetting(), LogViewer::getSetting(), MythContext::GetSettingOnHost(), RemoteEncoder::GetSignalLockTimeout(), SmartPlaylistDialog::getSmartPlaylists(), ChannelUtil::GetSourceID(), ChannelUtil::GetSourceIDForChannel(), SourceUtil::GetSourceName(), TVRec::GetStartChannel(), DBUtil::GetTables(), CardUtil::GetTimeouts(), ProgramInfo::GetTranscodedStatus(), ChannelUtil::GetTuningParams(), TV::GetValidRecorderList(), MythXML::GetVideo(), MythXML::GetVideoArt(), CardUtil::GetVideoDevices(), VideoSelector::getVideoListFromDB(), DataDirectProcessor::GrabNextSuggestedTime(), RecordingProfile::groupType(), MythburnWizard::handleAddVideo(), ExportNativeWizard::handleAddVideo(), ChannelData::handleChannels(), MainServer::HandleGetPendingRecordings(), MainServer::HandleLockTuner(), ProgramData::handlePrograms(), MainServer::HandleQueryRecordings(), SourceUtil::HasDigitalChannel(), CardUtil::IgnoreEncrypted(), IconData::ImportIconMap(), NativeArchive::importRecording(), NativeArchive::importVideo(), StorageGroup::Init(), InitializeDatabase(), ChannelBase::InitializeInputs(), ImportIconsWizard::initialLoad(), GameHandler::InitMetaDataMap(), insert_dtv_multiplex(), insert_program(), DBPerson::InsertCreditsDB(), DBEvent::InsertDB(), MythNewsConfig::insertInDB(), MythNews::insertInDB(), MythFlixConfig::insertInDB(), DBPerson::InsertPersonDB(), CustomPriority::installClicked(), is_dishnet_eit(), is_input_group_busy(), SourceUtil::IsAnySourceScanable(), MythburnWizard::isArchiveItemValid(), CardUtil::IsCardTypePresent(), ProgramInfo::IsCommFlagged(), ProgramInfo::IsEditing(), SourceUtil::IsEncoder(), Metadata::isInDatabase(), ProgramInfo::IsInUse(), Ripper::isNewTune(), CardUtil::IsTunerShared(), StatusBox::keyPressEvent(), CardUtil::LinkInputGroup(), NetworkControl::listRecordings(), NetworkControl::listSchedule(), TV::LiveTV(), CardInputEditor::load(), InputGroup::load(), TransFreqTableSelector::load(), VideoSourceSelector::load(), StorageGroupListEditor::load(), StorageGroupEditor::load(), InputSelector::load(), MultiplexSetting::load(), PlaylistsContainer::load(), SimpleDBStorage::load(), DiSEqCDevLNB::Load(), DiSEqCDevRotor::Load(), DiSEqCDevSwitch::Load(), DiSEqCDevTree::Load(), DiSEqCDevSettings::Load(), SourceSetting::load(), MetadataListManager::loadAllFromDatabase(), RecordingProfile::loadByGroup(), RecordingProfile::loadByID(), CardInput::loadByInput(), ScheduledRecording::loadBySearch(), RecordingProfile::loadByType(), EITCache::LoadChannel(), KeyBindings::LoadContexts(), SourceSetup::loadData(), ScreenSetup::loadData(), VideoDisplayProfile::LoadDB(), SmartPlaylistEditor::loadFromDatabase(), KeyBindings::LoadJumppoints(), Playlist::loadPlaylist(), Playlist::loadPlaylistByID(), MainServer::LocalFilePath(), lock_channel(), lockSchema(), MythContext::LogEntry(), SmartPlaylistEditor::lookupCategoryID(), main(), ProgramInfo::MarkAsInUse(), GalleryUtil::Move(), MythFlixQueue::MythFlixQueue(), SmartPlaylistEditor::newCategory(), VideoSelector::OKPressed(), RecordingSelector::OKPressed(), FileSelector::OKPressed(), StorageGroupEditor::open(), RecordingProfileEditor::open(), ProfileGroupEditor::open(), PlayGroupEditor::open(), performActualUpdate(), Metadata::persist(), ProgLister::powerEdit(), WeatherSource::probeScript(), UPnpCDSExtension::ProcessContainer(), UPnpCDSExtension::ProcessKey(), MoviesUI::processMovie(), MoviesUI::processTheatre(), purgeGameDB(), DBUtil::QueryDBMSVersion(), JobQueue::QueueJob(), ProgramInfo::ReactivateRecording(), ManualSchedule::recordClicked(), MythMainWindow::RegisterJump(), MythMainWindow::RegisterKey(), LiveTVChain::ReloadAll(), PreviousList::removalDialog(), ThumbItem::Remove(), ScheduledRecording::remove(), FileAssociationsImp::remove(), MultiValueImp::remove(), SingleValueImp::remove(), FileScanner::RemoveFileFromDB(), MythNewsConfig::removeFromDB(), MythNews::removeFromDB(), MythFlixConfig::removeFromDB(), ExportNativeWizard::removeItem(), GalleryUtil::Rename(), SmartPlaylistEditor::renameCategory(), GalleryUtil::RenameDirectory(), replace_in_db(), IconData::ResetIconMap(), romInDB(), HouseKeeper::RunHouseKeeping(), SearchDialog::runQuery(), Scheduler::RunScheduler(), runVideoSelector(), CardInput::save(), XMLTVConfig::save(), TransFreqTableSelector::save(), ScheduledRecording::save(), ProgramInfo::Save(), SimpleDBStorage::save(), ChannelID::save(), DTVChannel::SaveCachedPids(), SmartPlaylistEditor::saveClicked(), SourceSetup::saveData(), ScreenSetup::saveData(), VideoDisplayProfile::SaveDB(), AlbumArtImages::saveImageType(), SavePending(), Playlist::savePlaylist(), MythContext::SaveSettingOnHost(), SmartPLCriteriaRow::saveToDatabase(), MetadataImp::saveToDatabase(), ScanWizardScanner::Scan(), SIScan::ScanServicesSourceID(), SIScan::ScanTransport(), ImportNativeWizard::searchCallsign(), ImportNativeWizard::searchChanID(), ImportNativeWizard::searchChanNo(), ImportNativeWizard::searchName(), ProgFinder::selectSearchData(), set_lineup_type(), set_on_source(), ProgramInfo::SetAutoExpire(), ProgramInfo::SetBookmark(), TVRec::SetChannelInfo(), ChannelUtil::SetChannelValue(), ProgramInfo::SetCommFlagged(), ProgramInfo::SetCutList(), ProgramInfo::SetDeleteFlag(), ProgramInfo::SetDupHistory(), ProgramInfo::SetDVDBookmark(), ProgramInfo::SetEditing(), RomInfo::setFavorite(), ProgramInfo::SetFilesize(), setGlobalSetting(), ProgramInfo::SetMarkupMap(), ProgramInfo::SetPositionMap(), ProgramInfo::SetPositionMapDelta(), ProgramInfo::SetPreserveEpisode(), PlaybackBox::SetRecGroupPassword(), ProgramInfo::SetRecordBasename(), ThumbItem::SetRotationAngle(), ChannelUtil::SetServiceVersion(), StartingChannel::SetSourceID(), ProgramInfo::SetTranscoded(), Weather::setupScreens(), SourceManager::setupSources(), setupTVs(), ProgramInfo::SetWatchedFlag(), TVRec::ShouldSwitchToAnotherCard(), ProgramInfo::showDetails(), PlaybackBox::showRecGroupChanger(), PlaybackBox::showRecGroupChooser(), BookmarksConfig::slotBookmarksViewExecuted(), MythNews::slotNewsRetrieved(), BookmarksConfig::slotWebSiteAdded(), ChannelOptionsCommon::sourceChanged(), EITScanner::StartActiveScan(), ProgramInfo::StartedRecording(), DiSEqCDevLNB::Store(), DiSEqCDevRotor::Store(), DiSEqCDevSwitch::Store(), DiSEqCDevTree::Store(), DiSEqCDevSettings::Store(), CustomEdit::storeClicked(), ChannelBase::StoreDefaultInput(), ChannelBase::StoreInputChannels(), ScheduledRecording::testRecording(), CustomPriority::testSchedule(), TVRec::ToggleChannelFavorite(), GuideGrid::toggleChannelFavorite(), ProgramInfo::ToMap(), MainServer::TruncateAndClose(), CardUtil::TVOnly(), CardUtil::UnlinkInputGroup(), unlock_channel(), unlockSchema(), update_channel_basic(), ChannelUtil::UpdateChannel(), DataDirectProcessor::UpdateChannelsSafe(), DataDirectProcessor::UpdateChannelsUnsafe(), DBEvent::UpdateDB(), DBox2EPG::UpdateDB(), UpdateDBVersionNumber(), updateDiskCount(), updateDisplayRom(), AutoExpire::UpdateDontExpireSet(), UpdateGameCounts(), GameHandler::UpdateGameDB(), updateGameName(), ProgLister::updateKeywordInDB(), ProgramInfo::UpdateLastDelete(), HouseKeeper::updateLastrun(), DataDirectProcessor::UpdateListings(), Scheduler::UpdateManuals(), Scheduler::UpdateMatches(), Scheduler::UpdateNextRecord(), DataDirectProcessor::UpdateProgramViewTable(), ProgramInfo::UpdateRecGroup(), ProgramInfo::UpdateRecordingEnd(), VideoSelector::updateSelectedList(), RecordingSelector::updateSelectedList(), FileSelector::updateSelectedList(), GameHandler::updateSettings(), IconData::UpdateSourceIcons(), DataDirectProcessor::UpdateStationViewTable(), UpgradeMusicDatabaseSchema(), UpgradeTVDatabaseSchema(), DBox2EPG::UseOnAirGuide(), ProgramInfo::UsesMaxEpisodes(), Scheduler::verifyCards(), GameHandler::VerifyGameDB(), and HouseKeeper::wantToRun().
| void MSqlQuery::bindValues | ( | MSqlBindings & | bindings | ) |
Add all the bindings in the passed in bindings.
Definition at line 427 of file mythdbcon.cpp.
Referenced by ProgramList::FromOldRecorded(), ProgramList::FromProgram(), ProgFinder::getSearchData(), SimpleDBStorage::load(), SimpleDBStorage::save(), ProgFinder::selectSearchData(), and Scheduler::UpdateMatches().
| QVariant MSqlQuery::lastInsertId | ( | ) |
Return the id of the last inserted row.
Note: Currently, this function is only implemented in Qt4 (in QSqlQuery and QSqlResult), and is implemented here until the switch to Qt4. Also, the current implementation will only work for a DBMS that supports the function LAST_INSERT_ID() (i.e. MySQL), and will _not_ work in SQLite.
Definition at line 436 of file mythdbcon.cpp.
Referenced by Metadata::dumpToDatabase(), FileScanner::GetDirectoryId(), MoviesUI::processMovie(), MoviesUI::processTheatre(), AutoIncrementDBSetting::save(), Playlist::savePlaylist(), DiSEqCDevLNB::Store(), DiSEqCDevRotor::Store(), and DiSEqCDevSwitch::Store().
| bool MSqlQuery::testDBConnection | ( | ) | [static] |
Checks DB connection + login (login info via Mythcontext).
Definition at line 421 of file mythdbcon.cpp.
Referenced by BuildVideoMarkup(), MainServer::DoDeleteThread(), JobQueue::DoFlagCommercialsThread(), FlagCommercials(), PreviewGenerator::GetScreenGrab(), main(), JobQueue::ProcessJob(), and MythContextPrivate::TestDBconnection().
| MSqlQueryInfo MSqlQuery::InitCon | ( | ) | [static] |
Only use this in combination with MSqlQuery constructor.
Definition at line 308 of file mythdbcon.cpp.
Referenced by FileAssociationsImp::add(), MultiValueImp::add(), SingleValueImp::add(), FileScanner::AddFileToDB(), ProgramInfo::AddHistory(), addMyselfToDirectory(), ProfileGroup::allowedGroupName(), LiveTVChain::AppendNewProgram(), ChannelRecPriority::applyChannelRecPriorityChange(), ProgramInfo::ApplyRecordPlayGroupChange(), ProgramInfo::ApplyRecordRecGroupChange(), ProgramInfo::ApplyRecordRecID(), ProgramInfo::ApplyRecordRecTitleChange(), ProgramInfo::ApplyTranscoderProfileChange(), BackendQueryDiskSpace(), DBUtil::BackupDB(), Bookmarks::Bookmarks(), BookmarksConfig::BookmarksConfig(), InputGroupMap::Build(), UPnpMedia::BuildMediaMap(), DVDTranscodeThread::buildTranscodeCommandLine(), ProfileGroupEditor::callDelete(), VideoSourceEditor::cardTypesInclude(), ChannelWizard::cardTypesInclude(), TV::ChangeChannel(), JobQueue::ChangeJobArgs(), JobQueue::ChangeJobCmds(), JobQueue::ChangeJobComment(), JobQueue::ChangeJobFlags(), JobQueue::ChangeJobHost(), JobQueue::ChangeJobStatus(), ChannelEditor::channelIconImport(), StorageGroup::CheckAllStorageGroupDirs(), ImportIconsWizard::checkAndDownload(), ChannelBase::CheckChannel(), TVRec::CheckChannelPrefix(), checkChannelPresets(), checkHandlers(), checkStoragePaths(), CustomPriority::checkSyntax(), CustomEdit::checkSyntax(), chooseQueue(), FileScanner::cleanDB(), HouseKeeper::CleanupAllOldInUsePrograms(), CleanupMyOldInUsePrograms(), HouseKeeper::CleanupMyOldRecordings(), JobQueue::CleanupOldJobsInQueue(), HouseKeeper::CleanupOrphanedLivetvChains(), HouseKeeper::CleanupProgramListings(), HouseKeeper::CleanupRecordedTables(), GameHandler::clearAllGameData(), clearArchiveTable(), EITCache::ClearChannelLocks(), ProgramData::clearDataByChannel(), ProgramData::clearDataBySource(), ProgramInfo::ClearMarkupMap(), ProgramInfo::ClearPositionMap(), StatusBox::clicked(), clone_capturecard(), clone_cardinputs(), KeyBindings::CommitAction(), KeyBindings::CommitJumppoint(), CompareTVDatabaseSchemaVersion(), CompleteJob(), convert_diseqc_db(), GalleryUtil::Copy(), ChannelWizard::countCardtypes(), DiSEqCDevDevice::CreateById(), ChannelUtil::CreateChannel(), CardUtil::CreateInputGroup(), UPnpCDSVideo::CreateItems(), UPnpCDSExtension::CreateItems(), CardInput::CreateNewInputGroup(), VideoDisplayProfile::CreateProfile(), VideoDisplayProfile::CreateProfileGroup(), CustomEdit::CustomEdit(), CustomPriority::CustomPriority(), ProgramRecPriority::deactivate(), commDetector2::debugDirectory(), MythGamePlayerEditor::del(), ChannelEditor::del(), TransportListEditor::Delete(), GalleryUtil::Delete(), delete_in_db(), CardUtil::DeleteAllCards(), JobQueue::DeleteAllJobs(), SourceUtil::DeleteAllSources(), CardUtil::DeleteCard(), SmartPlaylistEditor::deleteCategory(), ChannelEditor::deleteChannels(), CustomPriority::deleteClicked(), VideoDisplayProfile::DeleteDB(), ProgramInfo::DeleteHistory(), CardUtil::DeleteInput(), PreviousList::deleteItem(), JobQueue::DeleteJob(), ProgLister::deleteKeyword(), CardUtil::DeleteOrphanInputs(), PlaylistsContainer::deletePlaylist(), VideoDisplayProfile::DeleteProfileGroup(), VideoDisplayProfile::DeleteProfiles(), LiveTVChain::DeleteProgram(), SmartPlaylistEditor::deleteSmartPlaylist(), SourceUtil::DeleteSource(), Ripper::deleteTrack(), CallRecord::deleteYourselfFromDB(), DirEntry::deleteYourselfFromDB(), LiveTVChain::DestroyChain(), DVDTitle::determineInputID(), DisplayRecGroup(), StorageGroupListEditor::doDelete(), StorageGroupEditor::doDelete(), PlayGroupEditor::doDelete(), MainServer::DoDeleteInDB(), StatusBox::doListingsStatus(), StatusBox::doLogEntries(), DoOldVideoDatabaseSchemaUpgrade(), MythburnWizard::doRemoveArchiveItem(), StatusBox::doScheduleStatus(), JobQueue::DoTranscodeThread(), StatusBox::doTunerStatus(), doUpgradeTVDatabaseSchema(), MetadataImp::dropFromDB(), Metadata::dumpToDatabase(), CaptureCardEditor::edit(), ProgramRecPriority::edit(), ChannelRecPriority::edit(), RomInfo::edit_rominfo(), AutoExpire::ExpireEpisodesOverMax(), AutoExpire::ExpireRecordings(), IconData::ExportIconMap(), NativeArchive::exportRecording(), NativeArchive::exportVideo(), extractDetailsFromFilename(), ScheduledRecording::fetchChannelInfo(), FileScanner::FileScanner(), FileAssociationsImp::fill_from_db(), MultiValueImp::fill_from_db(), SingleValueImp::fill_from_db(), RomInfo::fillData(), FillData::fillData(), AutoExpire::FillDBOrdered(), Metadata::fillFieldList(), DTVMultiplex::FillFromDB(), ProgLister::fillItemList(), ProgramRecPriority::FillList(), PlaybackBox::FillList(), ChannelRecPriority::FillList(), UPnpMedia::FillMetaMaps(), GameTree::fillNode(), PlaybackBox::fillRecGroupPasswordCache(), Scheduler::FillRecordingDir(), ImportNativeWizard::fillSearchList(), CaptureCard::fillSelections(), VideoSource::fillSelections(), TransportList::fillSelections(), SRRecGroup::fillSelections(), SRInput::fillSelections(), ChannelSetting::fillSelections(), ScheduledRecording::fillSelections(), RecordingProfile::fillSelections(), ProfileGroup::fillSelections(), MythGamePlayerSettings::fillSelections(), Source::fillSelections(), ChannelListSetting::fillSelections(), Playlist::fillSonglistFromQuery(), Playlist::fillSonglistFromSmartPlaylist(), HttpStatus::FillStatusXML(), ProgLister::fillViewList(), Scheduler::findAllScheduledPrograms(), ChannelUtil::FindChannel(), ImportNativeWizard::findChannelMatch(), ChannelID::findHighest(), AlbumArtImages::findImages(), MythNewsConfig::findInDB(), MythNews::findInDB(), MythFlixConfig::findInDB(), SourceManager::findScripts(), SourceManager::findScriptsDB(), TabView::finishAddBookmark(), ProgramInfo::FinishedRecording(), LiveTVChain::FinishedRecording(), ProgramData::fix_end_times(), FlagCommercials(), HouseKeeper::flushLogs(), ProgramInfo::ForgetHistory(), formattedFieldValue(), ProgramList::FromOldRecorded(), ProgramList::FromProgram(), ProgramList::FromRecorded(), get_cardtype(), get_cardtypes(), get_chan_id_from_db(), get_dtv_multiplex(), get_input_id(), get_on_cardid(), get_ratings(), get_use_eit(), StatusBox::getActualRecordedBPS(), MythXML::GetAlbumArt(), MythburnWizard::getArchiveListFromDB(), ExportNativeWizard::getArchiveListFromDB(), ChannelUtil::GetATSCChannel(), ProgramInfo::GetAutoExpireFromRecorded(), ChannelUtil::GetBetterMplexID(), DTVChannel::GetCachedPids(), CardUtil::GetCardIDs(), CardUtil::GetCardList(), ChannelWizard::getCardtype(), DVBChannel::GetChanID(), ChannelUtil::GetChanID(), ChannelBase::GetChanID(), IPTVChannel::GetChanInfo(), ProgramInfo::GetChannel(), SourceUtil::GetChannelCount(), ChannelUtil::GetChannelData(), MythXML::GetChannelIcon(), DBox2EPG::GetChannelID(), MHIContext::GetChannelIndex(), TVRec::GetChannelInfo(), DBox2Channel::GetChannelNameFromNumber(), DBox2Channel::GetChannelNumberFromName(), ProgramInfo::GetChannelRecPriority(), ChannelUtil::GetChannels(), SourceUtil::GetChannelSeparator(), ChannelUtil::GetChannelSettings(), ChannelUtil::GetChannelStringField(), ChannelUtil::GetChannelValueStr(), CardUtil::GetCloneCardIDs(), CardUtil::GetConfiguredDVBInputs(), UPnpCDSExtension::GetCount(), PlayGroup::GetCount(), DBox2Channel::GetDefaultChannel(), CardUtil::GetDefaultInput(), CardUtil::GetDeviceLabel(), TVRec::GetDevices(), FileScanner::GetDirectoryId(), CardUtil::GetDisplayName(), UPnpCDSVideo::GetDistinctCount(), UPnpCDSExtension::GetDistinctCount(), ProgramInfo::GetDVDBookmark(), MusicPlayer::getFilenameFromID(), ProgramInfo::GetFilesize(), Channel::GetFormatForChannel(), getGlobalSetting(), CardUtil::GetGroupCardIDs(), MainServer::getGuideDataThrough(), ProfileGroup::getHostNames(), MythXML::GetHosts(), PlayGroup::GetInitialName(), CardUtil::GetInputGroups(), ChannelUtil::GetInputID(), CardUtil::GetInputIDs(), CardUtil::GetInputInfo(), CardUtil::GetInputNames(), JobQueue::GetJobArgs(), JobQueue::GetJobCmd(), JobQueue::GetJobCommand(), JobQueue::GetJobFlags(), JobQueue::GetJobID(), JobQueue::GetJobInfoFromID(), JobQueue::GetJobsInQueue(), JobQueue::GetJobStatus(), MythMainWindow::GetKey(), MythXML::GetKeys(), HouseKeeper::getLastRun(), SourceUtil::GetListingsLoginData(), ProgramInfo::GetMarkupMap(), Metadata::getMetadataFromID(), ProgramInfo::GetMplexID(), ChannelUtil::GetMplexID(), MythXML::GetMusic(), RecordingProfile::getName(), ProfileGroup::getName(), PlayGroup::GetNames(), TVRec::GetNextProgram(), ProgramInfo::GetPositionMap(), ProgramInfo::GetPreserveEpisodeFromRecorded(), VideoDisplayProfile::GetProfileGroupID(), VideoDisplayProfile::GetProfiles(), ProgramInfo::GetProgramAtDateTime(), ProgramInfo::getProgramFlags(), ProgramInfo::GetProgramFromBasename(), ProgramInfo::GetProgramFromRecorded(), MythXML::GetProgramGuide(), ProgramInfo::getProgramProperties(), CardUtil::GetQuickTuning(), ProgramInfo::GetRecGroupPassword(), ProgramInfo::GetRecordBasename(), StorageGroup::getRecordingsGroups(), ThumbItem::GetRotationAngle(), ProgFinder::getSearchData(), MHIContext::GetServiceInfo(), ChannelUtil::GetServiceVersion(), PlayGroup::GetSetting(), MythXML::GetSetting(), MythContext::GetSetting(), LogViewer::getSetting(), MythContext::GetSettingOnHost(), RemoteEncoder::GetSignalLockTimeout(), SmartPlaylistDialog::getSmartPlaylistCategories(), SmartPlaylistEditor::getSmartPlaylistCategories(), SmartPlaylistDialog::getSmartPlaylists(), ChannelUtil::GetSourceID(), ChannelUtil::GetSourceIDForChannel(), SourceUtil::GetSourceName(), TVRec::GetStartChannel(), DBUtil::GetTables(), CardUtil::GetTimeouts(), ProgramInfo::GetTranscodedStatus(), ChannelUtil::GetTuningParams(), TV::GetValidRecorderList(), MythXML::GetVideo(), MythXML::GetVideoArt(), CardUtil::GetVideoDevices(), VideoSelector::getVideoListFromDB(), FillData::grabData(), RecordingProfile::groupType(), MythburnWizard::handleAddVideo(), ExportNativeWizard::handleAddVideo(), ChannelData::handleChannels(), MainServer::HandleGetPendingRecordings(), MainServer::HandleLockTuner(), ProgramData::handlePrograms(), MainServer::HandleQueryRecordings(), SourceUtil::HasDigitalChannel(), CardUtil::IgnoreEncrypted(), IconData::ImportIconMap(), NativeArchive::importRecording(), NativeArchive::importVideo(), TV::Init(), StorageGroup::Init(), InitializeDatabase(), InitializeDVDDatabase(), ChannelBase::InitializeInputs(), InitializeVideoDatabase(), ImportIconsWizard::initialLoad(), GameHandler::InitMetaDataMap(), insert_dtv_multiplex(), insert_program(), MythNewsConfig::insertInDB(), MythNews::insertInDB(), MythFlixConfig::insertInDB(), CustomPriority::installClicked(), is_dishnet_eit(), is_input_group_busy(), SourceUtil::IsAnySourceScanable(), MythburnWizard::isArchiveItemValid(), CardUtil::IsCardTypePresent(), ProgramInfo::IsCommFlagged(), ProgramInfo::IsEditing(), SourceUtil::IsEncoder(), Metadata::isInDatabase(), ProgramInfo::IsInUse(), Ripper::isNewTune(), CardUtil::IsTunerShared(), StatusBox::keyPressEvent(), CardUtil::LinkInputGroup(), NetworkControl::listRecordings(), NetworkControl::listSchedule(), TV::LiveTV(), CardInputEditor::load(), InputGroup::load(), TransFreqTableSelector::load(), VideoSourceSelector::load(), StorageGroupListEditor::load(), StorageGroupEditor::load(), InputSelector::load(), MultiplexSetting::load(), PlaylistsContainer::load(), SimpleDBStorage::load(), DiSEqCDevLNB::Load(), DiSEqCDevRotor::Load(), DiSEqCDevSwitch::Load(), DiSEqCDevTree::Load(), DiSEqCDevSettings::Load(), DirectoryContainer::Load(), SourceSetting::load(), MetadataListManager::loadAllFromDatabase(), RecordingProfile::loadByGroup(), RecordingProfile::loadByID(), CardInput::loadByInput(), ScheduledRecording::loadBySearch(), RecordingProfile::loadByType(), EITCache::LoadChannel(), KeyBindings::LoadContexts(), SourceSetup::loadData(), ScreenSetup::loadData(), VideoDisplayProfile::LoadDB(), SmartPlaylistEditor::loadFromDatabase(), KeyBindings::LoadJumppoints(), Playlist::loadPlaylist(), Playlist::loadPlaylistByID(), MythNews::loadSites(), MainServer::LocalFilePath(), lock_channel(), lockShutdown(), MythContext::LogEntry(), SmartPlaylistEditor::lookupCategoryID(), main(), ProgramInfo::MarkAsInUse(), GalleryUtil::Move(), MoviesUI::MoviesUI(), MSqlEscapeAsAQuery(), MythDbSettings1::MythDbSettings1(), MythFlix::MythFlix(), MythFlixQueue::MythFlixQueue(), MythNewsConfig::MythNewsConfig(), SmartPlaylistEditor::newCategory(), VideoSelector::OKPressed(), RecordingSelector::OKPressed(), FileSelector::OKPressed(), StorageGroupEditor::open(), RecordingProfileEditor::open(), ProfileGroupEditor::open(), PlayGroupEditor::open(), performActualUpdate(), Metadata::persist(), Bookmarks::populateListView(), BookmarksConfig::populateListView(), ProgLister::powerEdit(), preMusic(), WeatherSource::probeScript(), UPnpCDSExtension::ProcessContainer(), EITHelper::ProcessEvents(), GameHandler::processGames(), UPnpCDSVideo::ProcessItem(), UPnpCDSExtension::ProcessItem(), UPnpCDSExtension::ProcessKey(), purgeGameDB(), DBUtil::QueryDBMSVersion(), JobQueue::QueueJob(), ProgramInfo::ReactivateRecording(), ManualSchedule::recordClicked(), MythMainWindow::RegisterJump(), MythMainWindow::RegisterKey(), LiveTVChain::ReloadAll(), PreviousList::removalDialog(), ThumbItem::Remove(), ScheduledRecording::remove(), FileAssociationsImp::remove(), MultiValueImp::remove(), SingleValueImp::remove(), FileScanner::RemoveFileFromDB(), MythNewsConfig::removeFromDB(), MythNews::removeFromDB(), MythFlixConfig::removeFromDB(), ExportNativeWizard::removeItem(), GalleryUtil::Rename(), SmartPlaylistEditor::renameCategory(), GalleryUtil::RenameDirectory(), replace_in_db(), IconData::ResetIconMap(), AllMusic::resync(), romInDB(), HouseKeeper::RunHouseKeeping(), SearchDialog::runQuery(), RunSimpleQuery(), runVideoSelector(), CardInput::save(), XMLTVConfig::save(), TransFreqTableSelector::save(), AutoIncrementDBSetting::save(), ScheduledRecording::save(), ProgramInfo::Save(), SimpleDBStorage::save(), ChannelID::save(), DTVChannel::SaveCachedPids(), SmartPlaylistEditor::saveClicked(), SourceSetup::saveData(), ScreenSetup::saveData(), VideoDisplayProfile::SaveDB(), AlbumArtImages::saveImageType(), SavePending(), Playlist::savePlaylist(), MythContext::SaveSettingOnHost(), SmartPLCriteriaRow::saveToDatabase(), MetadataImp::saveToDatabase(), ScanWizardScanner::Scan(), FileScanner::ScanArtwork(), FileScanner::ScanMusic(), SIScan::ScanServicesSourceID(), SIScan::ScanTransport(), ImportNativeWizard::searchCallsign(), ImportNativeWizard::searchChanID(), ImportNativeWizard::searchChanNo(), ImportNativeWizard::searchName(), ProgFinder::selectSearchData(), set_lineup_type(), set_on_source(), ProgramInfo::SetAutoExpire(), ProgramInfo::SetBookmark(), TVRec::SetChannelInfo(), ChannelUtil::SetChannelValue(), ProgramInfo::SetCommFlagged(), ProgramInfo::SetCutList(), ProgramInfo::SetDeleteFlag(), ProgramInfo::SetDupHistory(), ProgramInfo::SetDVDBookmark(), ProgramInfo::SetEditing(), RomInfo::setFavorite(), ProgramInfo::SetFilesize(), setGlobalSetting(), ProgramInfo::SetMarkupMap(), ProgramInfo::SetPositionMap(), ProgramInfo::SetPositionMapDelta(), ProgramInfo::SetPreserveEpisode(), PlaybackBox::SetRecGroupPassword(), ProgramInfo::SetRecordBasename(), ThumbItem::SetRotationAngle(), ChannelUtil::SetServiceVersion(), StartingChannel::SetSourceID(), SmartPLResultViewer::setSQL(), ProgramInfo::SetTranscoded(), setupDatabase(), Weather::setupScreens(), SourceManager::setupSources(), setupTVs(), ProgramInfo::SetWatchedFlag(), TVRec::ShouldSwitchToAnotherCard(), TitleDialog::showCurrentTitle(), ProgramInfo::showDetails(), PlaybackBox::showRecGroupChanger(), PlaybackBox::showRecGroupChooser(), BookmarksConfig::slotBookmarksViewExecuted(), MythNews::slotNewsRetrieved(), BookmarksConfig::slotWebSiteAdded(), ChannelOptionsCommon::sourceChanged(), EITScanner::StartActiveScan(), ProgramInfo::StartedRecording(), DiSEqCDevLNB::Store(), DiSEqCDevRotor::Store(), DiSEqCDevSwitch::Store(), DiSEqCDevTree::Store(), DiSEqCDevSettings::Store(), CustomEdit::storeClicked(), ChannelBase::StoreDefaultInput(), ChannelBase::StoreInputChannels(), testDBConnection(), TVRec::ToggleChannelFavorite(), GuideGrid::toggleChannelFavorite(), ProgramInfo::ToMap(), MainServer::TruncateAndClose(), CardUtil::TVOnly(), CardUtil::UnlinkInputGroup(), unlock_channel(), unlockShutdown(), ChannelUtil::UpdateChannel(), DBox2EPG::UpdateDB(), UpdateDBVersionNumber(), updateDiskCount(), updateDisplayRom(), AutoExpire::UpdateDontExpireSet(), UpdateGameCounts(), GameHandler::UpdateGameDB(), updateGameName(), ProgLister::updateKeywordInDB(), ProgramInfo::UpdateLastDelete(), HouseKeeper::updateLastrun(), SmartPlaylistEditor::updateMatches(), ProgramInfo::UpdateRecGroup(), ProgramInfo::UpdateRecordingEnd(), VideoSelector::updateSelectedList(), RecordingSelector::updateSelectedList(), FileSelector::updateSelectedList(), GameHandler::updateSettings(), IconData::UpdateSourceIcons(), CallRecord::updateYourselfInDB(), DirEntry::updateYourselfInDB(), UpgradeGameDatabaseSchema(), UpgradeMusicDatabaseSchema(), UpgradeTVDatabaseSchema(), DBox2EPG::UseOnAirGuide(), ProgramInfo::UsesMaxEpisodes(), GameHandler::VerifyGameDB(), and HouseKeeper::wantToRun().
| MSqlQueryInfo MSqlQuery::SchedCon | ( | ) | [static] |
Returns dedicated connection. (Required for using temporary SQL tables.).
Definition at line 332 of file mythdbcon.cpp.
Referenced by Scheduler::RunScheduler(), Scheduler::Scheduler(), ScheduledRecording::testRecording(), and CustomPriority::testSchedule().
| MSqlQueryInfo MSqlQuery::DDCon | ( | ) | [static] |
Returns dedicated connection. (Required for using temporary SQL tables.).
Definition at line 357 of file mythdbcon.cpp.
Referenced by chanid_available(), DDStructureParser::characters(), DataDirectProcessor::CreateATempTable(), DataDirectProcessor::DataDirectProgramUpdate(), DDStructureParser::endElement(), DataDirectProcessor::FixProgramIDs(), get_atsc_stuff(), get_max_chanid(), FillData::grabDDData(), DataDirectProcessor::GrabNextSuggestedTime(), Scheduler::Scheduler(), update_channel_basic(), DataDirectProcessor::UpdateChannelsSafe(), DataDirectProcessor::UpdateChannelsUnsafe(), DataDirectProcessor::UpdateListings(), DataDirectProcessor::UpdateProgramViewTable(), and DataDirectProcessor::UpdateStationViewTable().
MSqlDatabase* MSqlQuery::m_db [private] |
Definition at line 145 of file mythdbcon.h.
Referenced by MSqlDatabase::db(), exec(), lastInsertId(), MSqlQuery(), prepare(), and ~MSqlQuery().
bool MSqlQuery::m_isConnected [private] |
bool MSqlQuery::m_returnConnection [private] |
1.5.5