FCL/sf/app/podcatcher: engine/src/ShowEngine.cpp@713bd6cc0b7a (annotated)

2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1	/*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	2	* Copyright (c) 2007-2010 Sebastian Brannstrom, Lars Persson, EmbedDev AB
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	3	*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	4	* All rights reserved.
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	5	* This component and the accompanying materials are made available
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	6	* under the terms of the License "Eclipse Public License v1.0"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	7	* which accompanies this distribution, and is available
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	8	* at the URL "http://www.eclipse.org/legal/epl-v10.html".
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	9	*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	10	* Initial Contributors:
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	11	* EmbedDev AB - initial contribution.
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	12	*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	13	* Contributors:
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	14	*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	15	* Description:
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	16	*
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	17	*/
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	18
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	19	#include "ShowEngine.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	20	#include "FeedEngine.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	21	#include "FeedInfo.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	22	#include <bautils.h>
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	23	#include <s32file.h>
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	24	#include "SettingsEngine.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	25	#include <e32hashtab.h>
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	26	#include <httperr.h>
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	27	#include "debug.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	28	#include "PodcastUtils.h"
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	29
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	30	const TUint KMaxDownloadErrors = 3;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	31	const TInt KMimeBufLength = 100;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	32
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	33	CShowEngine::CShowEngine(CPodcastModel& aPodcastModel) :
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	34	iPodcastModel(aPodcastModel),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	35	iDB(*aPodcastModel.DB())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	36	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	37	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	38
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	39	EXPORT_C CShowEngine::~CShowEngine()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	40	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	41	delete iShowClient;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	42	iObservers.Close();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	43	delete iShowDownloading;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	44	delete iMetaDataReader;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	45	iApaSession.Close();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	46	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	47
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	48	EXPORT_C CShowEngine* CShowEngine::NewL(CPodcastModel& aPodcastModel)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	49	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	50	CShowEngine* self = new (ELeave) CShowEngine(aPodcastModel);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	51	CleanupStack::PushL(self);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	52	self->ConstructL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	53	CleanupStack::Pop(self);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	54	return self;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	55	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	56
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	57	EXPORT_C void CShowEngine::GetMimeType(const TDesC& aFileName, TDes& aMimeType)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	58	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	59	aMimeType.Zero();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	60	RFile file;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	61	if (file.Open(iPodcastModel.FsSession(), aFileName, 0) == KErrNone)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	62	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	63	if (file.Read(iRecogBuffer) == KErrNone)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	64	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	65	TDataRecognitionResult result;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	66	if (iApaSession.RecognizeData(aFileName, iRecogBuffer, result)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	67	== KErrNone)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	68	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	69	aMimeType.Copy(result.iDataType.Des());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	70	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	71
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	72	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	73	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	74	file.Close();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	75	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	76
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	77	void CShowEngine::ConstructL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	78	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	79	iShowClient = CHttpClient::NewL(iPodcastModel, *this);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	80	iShowClient->SetResumeEnabled(ETrue);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	81	iMetaDataReader = new (ELeave) CMetaDataReader(*this, iPodcastModel.FsSession());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	82	iMetaDataReader->ConstructL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	83	User::LeaveIfError(iApaSession.Connect());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	84	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	85
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	86	EXPORT_C void CShowEngine::SuspendDownloads()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	87	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	88	iPodcastModel.SettingsEngine().SetDownloadSuspended(ETrue);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	89	iShowClient->Stop();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	90	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	91
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	92	EXPORT_C void CShowEngine::ResumeDownloadsL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	93	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	94	DP("CShowEngine::ResumeDownloadsL BEGIN");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	95	if (iPodcastModel.SettingsEngine().DownloadSuspended())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	96	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	97	iPodcastModel.SettingsEngine().SetDownloadSuspended(EFalse);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	98	iDownloadErrors = 0;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	99	DownloadNextShowL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	100	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	101	DP("CShowEngine::ResumeDownloadsL END");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	102	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	103
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	104	EXPORT_C void CShowEngine::RemoveAllDownloadsL()
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	105	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	106	if (!iPodcastModel.SettingsEngine().DownloadSuspended())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	107	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	108	SuspendDownloads();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	109	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	110
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	111	DBRemoveAllDownloadsL();
22 3243c9461520 Clear download queue now notifies UI teknolog parents: 21 diff changeset	112	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	113	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	114
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	115	EXPORT_C void CShowEngine::RemoveDownloadL(TUint aUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	116	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	117	DP("CShowEngine::RemoveDownloadL BEGIN");
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	118
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	119	TBool resumeAfterRemove = EFalse;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	120	// if trying to remove the present download, we first stop it
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	121	if (!iPodcastModel.SettingsEngine().DownloadSuspended() && iShowDownloading != NULL
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	122	&& iShowDownloading->Uid() == aUid)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	123	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	124	DP("CShowEngine::RemoveDownload\t This is the active download, we suspend downloading");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	125	SuspendDownloads();
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	126
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	127	// partial downloads should be removed
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	128	BaflUtils::DeleteFile(iPodcastModel.FsSession(), iShowDownloading->FileName());
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	129
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	130	resumeAfterRemove = ETrue;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	131	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	132
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	133	CShowInfo *info = DBGetShowByUidL(aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	134	if (info != NULL)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	135	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	136	info->SetDownloadState(ENotDownloaded);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	137	DBUpdateShowL(*info);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	138	delete info;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	139	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	140
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	141	DBRemoveDownloadL(aUid);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	142
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	143	if (resumeAfterRemove)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	144	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	145	ResumeDownloadsL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	146	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	147	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	148	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	149	NotifyShowDownloadUpdatedL(-1, -1);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	150	NotifyDownloadQueueUpdatedL();
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	151	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	152
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	153	DownloadNextShowL();
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	154	DP("CShowEngine::RemoveDownloadL END");
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	155	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	156
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	157	void CShowEngine::Connected(CHttpClient* /aClient/)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	158	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	159
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	160	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	161
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	162	void CShowEngine::Progress(CHttpClient* /aHttpClient /, TInt aBytes,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	163	TInt aTotalBytes)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	164	{
212 713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	165	//iShowDownloading->SetShowSize(aTotalBytes);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	166	TRAP_IGNORE(NotifyShowDownloadUpdatedL(aBytes, aTotalBytes));
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	167	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	168
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	169	void CShowEngine::Disconnected(CHttpClient* /aClient /)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	170	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	171	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	172
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	173	void CShowEngine::DownloadInfo(CHttpClient* aHttpClient, TInt aTotalBytes)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	174	{
167 4bfc2fcec5f6 Proposed fix for bug 2931 Sebastian Brannstrom <sebastianb@symbian.org> parents: 164 diff changeset	175	DP1("CShowEngine::DownloadInfo, About to download %d bytes", aTotalBytes);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	176	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	177
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	178	void CShowEngine::GetShowL(CShowInfo *info)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	179	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	180	CFeedInfo *feedInfo = iPodcastModel.FeedEngine().GetFeedInfoByUid(
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	181	info->FeedUid());
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	182
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	183	TFileName filePath;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	184	filePath.Copy(iPodcastModel.SettingsEngine().BaseDir());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	185
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	186	TFileName relPath;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	187	relPath.Copy(feedInfo->Title());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	188	relPath.Append('\\');
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	189
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	190	TFileName fileName;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	191	PodcastUtils::FileNameFromUrl(info->Url(), fileName);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	192	relPath.Append(fileName);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	193	PodcastUtils::EnsureProperPathName(relPath);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	194
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	195	// complete file path is base dir + rel path
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	196	filePath.Append(relPath);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	197	info->SetFileNameL(filePath);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	198
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	199	User::LeaveIfError(iShowClient->GetL(info->Url(), filePath));
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	200	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	201
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	202	EXPORT_C void CShowEngine::AddShowL(const CShowInfo& aItem)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	203	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	204	DP1("CShowEngine::AddShowL, title=%S", &aItem.Title());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	205	CShowInfo *showInfo = DBGetShowByUidL(aItem.Uid());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	206
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	207	if (showInfo == NULL)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	208	{
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	209	DBAddShowL(aItem);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	210	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	211	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	212	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	213	delete showInfo;
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	214	User::Leave(KErrAlreadyExists);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	215	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	216	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	217
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	218	EXPORT_C void CShowEngine::AddObserver(MShowEngineObserver *observer)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	219	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	220	iObservers.Append(observer);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	221	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	222
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	223	EXPORT_C void CShowEngine::RemoveObserver(MShowEngineObserver *observer)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	224	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	225	TInt index = iObservers.Find(observer);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	226
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	227	if (index > KErrNotFound)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	228	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	229	iObservers.Remove(index);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	230	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	231	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	232
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	233	void CShowEngine::AddShowToMpxCollection(CShowInfo &/aShowInfo/)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	234	{
164 000f9fc147b2 Catch up with default branch; New v 27 SIS Sebastian Brannstrom <sebastianb@symbian.org> parents: 149 diff changeset	235	// do nothing (right now)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	236	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	237
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	238	void CShowEngine::CompleteL(CHttpClient* /aHttpClient/, TInt aError)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	239	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	240	if (iShowDownloading != NULL)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	241	{
212 713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	242	DP2("CShowEngine::CompleteL file=%S, aError=%d", &iShowDownloading->FileName(), aError);
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	243
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	244	if(aError != KErrCouldNotConnect)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	245	{
6 e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	246	if(aError == KErrDisconnected && iPodcastModel.SettingsEngine().DownloadSuspended())
e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	247	{
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	248	// no error if disconnect happened because of suspended downloading
6 e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	249	}
e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	250	else
e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	251	{
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	252	iShowDownloading->SetLastError(aError);
6 e211a78d3037 Fix for incorrect error handling of show downloads teknolog parents: 2 diff changeset	253	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	254
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	255	if (aError == KErrNone)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	256	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	257	TBuf<KMimeBufLength> mimeType;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	258	GetMimeType(iShowDownloading->FileName(), mimeType);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	259	_LIT(KMimeAudio,"audio");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	260	_LIT(KMimeVideo,"video");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	261	if (mimeType.Left(5) == KMimeAudio)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	262	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	263	iShowDownloading->SetShowType(EAudioPodcast);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	264	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	265	else if (mimeType.Left(5) == KMimeVideo)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	266	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	267	iShowDownloading->SetShowType(EVideoPodcast);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	268	}
212 713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	269
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	270	// setting file size
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	271	TEntry entry;
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	272	TInt err = iPodcastModel.FsSession().Entry(iShowDownloading->FileName(), entry);
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	273	if (err == KErrNone)
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	274	{
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	275	iShowDownloading->SetShowSize(entry.iSize);
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	276	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	277
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	278	iShowDownloading->SetDownloadState(EDownloaded);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	279	DBUpdateShowL(*iShowDownloading);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	280	DBRemoveDownloadL(iShowDownloading->Uid());
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	281	AddShowToMpxCollection(*iShowDownloading);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	282	NotifyShowFinishedL(aError);
15 93d9f66bf50b Cleaning description better for second line in search results teknolog parents: 6 diff changeset	283	iDownloadErrors = 0;
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	284	delete iShowDownloading;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	285	iShowDownloading = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	286	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	287	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	288	{
212 713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	289	if (aError == HTTPStatus::ERequestedRangeNotSatisfiable)
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	290	{
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	291	DP("ERequestedRangeNotSatisfiable, resetting download");
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	292	// file size got messed up, so delete downloaded file an re-queue
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	293	BaflUtils::DeleteFile(iPodcastModel.FsSession(),iShowDownloading->FileName());
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	294	iShowDownloading->SetDownloadState(EQueued);
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	295	DBUpdateShowL(*iShowDownloading);
713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	296	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	297	// 400 and 500 series errors are serious errors on which probably another download will fail
212 713bd6cc0b7a Fix for bug 3042 Sebastian Brannstrom <sebastianb@symbian.org> parents: 167 diff changeset	298	else if (aError>= HTTPStatus::EBadRequest && aError <= HTTPStatus::EBadRequest+200)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	299	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	300	iShowDownloading->SetDownloadState(EFailedDownload);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	301	DBUpdateShowL(*iShowDownloading);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	302	DBRemoveDownloadL(iShowDownloading->Uid());
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	303	NotifyShowFinishedL(aError);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	304
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	305	delete iShowDownloading;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	306	iShowDownloading = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	307	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	308	else if (aError == KErrDiskFull)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	309	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	310	// stop downloading immediately if disk is full
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	311	iShowDownloading->SetDownloadState(EQueued);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	312	DBUpdateShowL(*iShowDownloading);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	313	iDownloadErrors = KMaxDownloadErrors;
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	314	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	315	else // other kind of error, missing network etc, reque this show
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	316	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	317	iShowDownloading->SetDownloadState(EQueued);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	318	DBUpdateShowL(*iShowDownloading);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	319	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	320
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	321	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	322	iDownloadErrors++;
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	323	if (iDownloadErrors >= KMaxDownloadErrors)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	324	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	325	DP("Too many downloading errors, suspending downloads");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	326	iPodcastModel.SettingsEngine().SetDownloadSuspended(ETrue);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	327	NotifyShowFinishedL(aError);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	328	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	329	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	330	DownloadNextShowL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	331	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	332
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	333	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	334	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	335	// Connection error
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	336	if(iShowDownloading)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	337	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	338	iShowDownloading->SetDownloadState(EQueued);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	339	DBUpdateShowL(*iShowDownloading);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	340	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	341	iPodcastModel.SettingsEngine().SetDownloadSuspended(ETrue);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	342	NotifyShowFinishedL(aError);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	343	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	344	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	345	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	346
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	347	EXPORT_C CShowInfo* CShowEngine::ShowDownloading()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	348	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	349	return iShowDownloading;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	350	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	351
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	352	EXPORT_C CShowInfo* CShowEngine::GetShowByUidL(TUint aShowUid)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	353	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	354	return DBGetShowByUidL(aShowUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	355	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	356	CShowInfo* CShowEngine::DBGetShowByUidL(TUint aUid)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	357	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	358	DP("CShowEngine::DBGetShowByUid");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	359	CShowInfo *showInfo = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	360	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype from shows where uid=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	361	iSqlBuffer.Format(KSqlStatement, aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	362
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	363	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	364
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	365	//DP1("SQL: %S", &iSqlBuffer.Left(KSqlDPLen));
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	366
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	367	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	368	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	369
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	370	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	371	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	372	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	373	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	374	if (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	375	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	376	showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	377	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	378	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	379	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	380	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	381	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	382
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	383	return showInfo;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	384	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	385
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	386	EXPORT_C CShowInfo* CShowEngine::DBGetShowByFileNameL(TFileName aFileName)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	387	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	388	DP("CShowEngine::DBGetShowByUid");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	389	CShowInfo *showInfo = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	390	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype from shows where filename=\"%S\"");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	391	iSqlBuffer.Format(KSqlStatement, &aFileName);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	392
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	393	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	394
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	395	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	396	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	397
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	398	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	399	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	400	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	401	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	402	if (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	403	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	404	showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	405	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	406	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	407	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	408	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	409	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	410
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	411	return showInfo;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	412	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	413
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	414	void CShowEngine::DBGetAllShowsL(RShowInfoArray& aShowArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	415	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	416	DP("CShowEngine::DBGetAllShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	417	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype from shows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	418	iSqlBuffer.Format(KSqlStatement);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	419
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	420	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	421
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	422	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	423	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	424
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	425	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	426	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	427	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	428	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	429	while (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	430	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	431	CShowInfo* showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	432	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	433	aShowArray.Append(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	434	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	435	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	436	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	437	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	438	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	439
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	440	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	441
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	442	void CShowEngine::DBGetAllDownloadsL(RShowInfoArray& aShowArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	443	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	444	DP("CShowEngine::DBGetAllDownloads");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	445	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, shows.uid, showsize, trackno, pubdate, showtype, lasterror from downloads, shows where downloads.uid=shows.uid");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	446	iSqlBuffer.Format(KSqlStatement);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	447
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	448	#ifndef DONT_SORT_SQL
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	449	_LIT(KSqlSort, " order by dl_index");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	450	iSqlBuffer.Append(KSqlSort);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	451	#endif
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	452	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	453
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	454	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	455	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	456
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	457	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	458	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	459	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	460	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	461	while (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	462	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	463	CShowInfo* showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	464	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	465	aShowArray.Append(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	466	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	467	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	468	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	469	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	470	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	471	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	472	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	473	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	474	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	475
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	476	// delete downloads that don't have a show
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	477
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	478	_LIT(KSqlStatement2, "delete from downloads where uid not in (select downloads.uid from shows, downloads where shows.uid=downloads.uid)");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	479	iSqlBuffer.Format(KSqlStatement2);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	480
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	481	rc = sqlite3_prepare16_v2(&iDB, (const void) iSqlBuffer.PtrZ(), -1, &st, (const void*) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	482
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	483	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	484	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	485	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	486	rc = sqlite3_step(st);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	487	CleanupStack::PopAndDestroy(); // st
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	488	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	489	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	490	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	491	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	492	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	493	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	494
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	495	CShowInfo* CShowEngine::DBGetNextDownloadL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	496	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	497	DP("CShowEngine::DBGetNextDownload");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	498	CShowInfo *showInfo = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	499	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, shows.uid, showsize, trackno, pubdate, showtype, lasterror from downloads, shows where downloads.uid=shows.uid");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	500	iSqlBuffer.Format(KSqlStatement);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	501
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	502	#ifdef DONT_SORT_SQL
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	503	_LIT(KSqlSort, " limit 1");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	504	iSqlBuffer.Append(KSqlSort);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	505	#else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	506	_LIT(KSqlNoSort, " order by dl_index limit 1");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	507	iSqlBuffer.Append(KSqlNoSort);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	508	#endif
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	509
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	510	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	511
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	512	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	513	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	514
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	515	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	516	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	517	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	518	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	519	if (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	520	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	521	showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	522	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	523	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	524	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	525	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	526	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	527	User::Leave(KErrUnknown);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	528	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	529	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	530	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	531	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	532	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	533	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	534	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	535
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	536	return showInfo;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	537	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	538
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	539	void CShowEngine::DBGetShowsByFeedL(RShowInfoArray& aShowArray, TUint aFeedUid)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	540	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	541	DP1("CShowEngine::DBGetShowsByFeed BEGIN, feedUid=%u", aFeedUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	542	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where feeduid=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	543	iSqlBuffer.Format(KSqlStatement, aFeedUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	544
130 92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	545	if (iShowFilter == ENewShows)
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	546	{
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	547	_LIT(KSqlStatementNewShows, " and playstate = 0"); // ENeverPlayed
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	548	iSqlBuffer.Append(KSqlStatementNewShows);
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	549	}
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	550	else if (iShowFilter == EDownloadedShows)
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	551	{
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	552	_LIT(KSqlStatementDownloadedShows, " and downloadstate = 4"); // EDownloaded
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	553	iSqlBuffer.Append(KSqlStatementDownloadedShows);
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	554	}
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	555	else if (iShowFilter == ENewAndDownloadedShows)
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	556	{
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	557	_LIT(KSqlStatementDownloadedAndNewShows, " and (downloadstate = 4 or playstate = 0)"); // EDownloaded or ENeverPlayed
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	558	iSqlBuffer.Append(KSqlStatementDownloadedAndNewShows);
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	559
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	560	}
92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	561
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	562	#ifndef DONT_SORT_SQL
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	563	_LIT(KSqlOrderByDate, " order by pubdate desc");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	564	iSqlBuffer.Append(KSqlOrderByDate);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	565	#endif
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	566
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	567	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	568
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	569	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	570	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	571
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	572	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	573	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	574	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	575	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	576	while (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	577	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	578	CShowInfo* showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	579	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	580	aShowArray.Append(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	581	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	582	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	583	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	584	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	585	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	586	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	587	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	588	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	589	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	590	DP("CShowEngine::DBGetShowsByFeed END");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	591	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	592
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	593	TUint CShowEngine::DBGetDownloadsCountL()
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	594	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	595	DP("CShowEngine::DBGetDownloadsCount");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	596
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	597	_LIT(KSqlStatement, "select count(*) from downloads");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	598	iSqlBuffer.Format(KSqlStatement);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	599
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	600	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	601	TUint count = 0;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	602
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	603	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	604	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	605
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	606	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	607	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	608	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	609	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	610
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	611	if (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	612	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	613	count = sqlite3_column_int(st, 0);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	614	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	615	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	616	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	617	User::Leave(KErrUnknown);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	618	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	619
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	620	CleanupStack::PopAndDestroy(); //st
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	621	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	622	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	623	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	624	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	625	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	626	return count;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	627	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	628
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	629	void CShowEngine::DBGetDownloadedShowsL(RShowInfoArray& aShowArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	630	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	631	DP("CShowEngine::DBGetDownloadedShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	632	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where downloadstate=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	633	iSqlBuffer.Format(KSqlStatement, EDownloaded);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	634
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	635	#ifndef DONT_SORT_SQL
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	636	_LIT(KSqlSort, " order by title");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	637	iSqlBuffer.Append(KSqlSort);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	638	#endif
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	639
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	640	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	641
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	642	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	643	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	644
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	645	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	646	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	647	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	648	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	649	while (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	650	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	651	CShowInfo* showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	652	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	653	aShowArray.Append(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	654	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	655	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	656	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	657	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	658	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	659	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	660	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	661	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	662	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	663	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	664
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	665	void CShowEngine::DBGetNewShowsL(RShowInfoArray& aShowArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	666	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	667	DP("CShowEngine::DBGetNewShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	668	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where playstate=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	669	iSqlBuffer.Format(KSqlStatement, ENeverPlayed);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	670
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	671	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	672
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	673	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	674	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	675
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	676	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	677	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	678	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	679	Cleanup_sqlite3_finalize_PushL(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	680	while (rc == SQLITE_ROW)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	681	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	682	CShowInfo* showInfo = CShowInfo::NewLC();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	683	DBFillShowInfoFromStmtL(st, showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	684	aShowArray.Append(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	685	CleanupStack::Pop(showInfo);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	686	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	687	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	688	CleanupStack::PopAndDestroy();//st
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	689	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	690	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	691	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	692	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	693	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	694	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	695
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	696	void CShowEngine::DBDeleteOldShowsByFeedL(TUint aFeedUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	697	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	698	DP("CShowEngine::DBDeleteOldShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	699
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	700	// what we do:
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	701	// 1. sort shows by pubdate
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	702	// 2. select the first MaxListItems shows
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	703	// 3. delete the rest if downloadstate is ENotDownloaded
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	704
164 000f9fc147b2 Catch up with default branch; New v 27 SIS Sebastian Brannstrom <sebastianb@symbian.org> parents: 149 diff changeset	705	_LIT(KSqlStatement,"delete from shows where feeduid=%u and downloadstate=0 and uid not in (select uid from shows where feeduid=%u order by pubdate desc limit %u)");
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	706	iSqlBuffer.Format(KSqlStatement, aFeedUid, aFeedUid, iPodcastModel.SettingsEngine().MaxListItems());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	707
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	708	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	709
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	710	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	711	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	712
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	713	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	714	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	715	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	716	sqlite3_finalize(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	717	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	718	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	719	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	720	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	721	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	722
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	723	_LIT(KSqlStatement2, "delete from downloads where uid not in (select downloads.uid from shows, downloads where shows.uid=downloads.uid)");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	724	iSqlBuffer.Format(KSqlStatement2);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	725
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	726	rc = sqlite3_prepare16_v2(&iDB, (const void) iSqlBuffer.PtrZ(), -1, &st, (const void*) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	727
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	728	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	729	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	730	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	731	sqlite3_finalize(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	732	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	733	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	734	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	735	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	736	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	737	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	738
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	739	void CShowEngine::DBFillShowInfoFromStmtL(sqlite3_stmt st, CShowInfo showInfo)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	740	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	741	const void *urlz = sqlite3_column_text16(st, 0);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	742	TPtrC16 url((const TUint16*) urlz);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	743	showInfo->SetUrlL(url);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	744
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	745	const void *titlez = sqlite3_column_text16(st, 1);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	746	TPtrC16 title((const TUint16*) titlez);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	747	showInfo->SetTitleL(title);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	748
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	749	const void *descz = sqlite3_column_text16(st, 2);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	750	TPtrC16 desc((const TUint16*) descz);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	751	showInfo->SetDescriptionL(desc);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	752
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	753	const void *filez = sqlite3_column_text16(st, 3);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	754	TPtrC16 file((const TUint16*) filez);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	755	showInfo->SetFileNameL(file);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	756
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	757	sqlite3_int64 pos = sqlite3_column_int64(st, 4);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	758	TTimeIntervalMicroSeconds position(pos);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	759	showInfo->SetPosition(position);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	760
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	761	TUint playtime = sqlite3_column_int(st, 5);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	762	showInfo->SetPlayTime(playtime);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	763
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	764	TUint playstate = sqlite3_column_int(st, 6);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	765	showInfo->SetPlayState((TPlayState) playstate);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	766
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	767	TUint downloadstate = sqlite3_column_int(st, 7);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	768	showInfo->SetDownloadState((TDownloadState) downloadstate);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	769
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	770	TUint feeduid = sqlite3_column_int(st, 8);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	771	showInfo->SetFeedUid(feeduid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	772
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	773	TUint uid = sqlite3_column_int(st, 9);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	774	showInfo->SetUid(uid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	775
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	776	TUint showsize = sqlite3_column_int(st, 10);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	777	showInfo->SetShowSize(showsize);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	778
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	779	TUint trackno = sqlite3_column_int(st, 11);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	780	showInfo->SetTrackNo((TShowType) trackno);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	781
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	782	sqlite3_int64 pubdate = sqlite3_column_int64(st, 12);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	783	TTime timepubdate(pubdate);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	784	showInfo->SetPubDate(timepubdate);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	785
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	786	TUint showtype = sqlite3_column_int(st, 13);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	787	showInfo->SetShowType((TShowType) showtype);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	788
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	789	TInt lasterror = sqlite3_column_int(st, 14);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	790	showInfo->SetLastError(lasterror);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	791	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	792
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	793	void CShowEngine::DBAddShowL(const CShowInfo& aItem)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	794	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	795	DP2("CShowEngine::DBAddShow, title=%S, URL=%S", &aItem.Title(), &aItem.Url());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	796
21 420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	797	HBufC* titleBuf = HBufC::NewLC(KMaxLineLength);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	798	TPtr titlePtr(titleBuf->Des());
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	799	titlePtr.Copy(aItem.Title());
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	800	PodcastUtils::SQLEncode(titlePtr);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	801
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	802	HBufC* descBuf = HBufC::NewLC(KMaxLineLength);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	803	TPtr descPtr(descBuf->Des());
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	804	descPtr.Copy(aItem.Description());
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	805	PodcastUtils::SQLEncode(descPtr);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	806
164 000f9fc147b2 Catch up with default branch; New v 27 SIS Sebastian Brannstrom <sebastianb@symbian.org> parents: 149 diff changeset	807	_LIT(KSqlStatement, "insert into shows (url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype) values (\"%S\",\"%S\", \"%S\", \"%S\", \"%Lu\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%u\", \"%Lu\", \"%d\")");
21 420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	808
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	809	iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr,
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	810	&aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	811	aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	812	aItem.Uid(), aItem.ShowSize(), aItem.TrackNo(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	813	aItem.PubDate().Int64(), aItem.ShowType());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	814
21 420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	815	CleanupStack::PopAndDestroy(descBuf);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	816	CleanupStack::PopAndDestroy(titleBuf);
420a1b4930da SQLEncoding for showinfo added teknolog parents: 15 diff changeset	817
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	818	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	819
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	820	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	821	&st, (const void**) NULL);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	822
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	823	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	824	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	825	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	826	rc = sqlite3_step(st);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	827	if (rc != SQLITE_DONE)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	828	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	829	User::Leave(KErrAlreadyExists);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	830	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	831	CleanupStack::PopAndDestroy(); // st
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	832	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	833	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	834	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	835	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	836	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	837	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	838
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	839	void CShowEngine::DBAddDownloadL(TUint aUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	840	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	841	DP1("CShowEngine::DBAddDownload, aUid=%u", aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	842
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	843	_LIT(KSqlStatement, "insert into downloads (uid) values (%u)");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	844	iSqlBuffer.Format(KSqlStatement, aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	845	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	846
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	847	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	848	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	849
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	850	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	851	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	852	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	853	rc = sqlite3_step(st);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	854	if (rc != SQLITE_DONE)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	855	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	856	User::Leave(KErrUnknown);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	857	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	858	CleanupStack::PopAndDestroy(); // st
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	859	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	860	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	861	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	862	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	863	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	864	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	865
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	866	void CShowEngine::DBUpdateShowL(CShowInfo& aItem)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	867	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	868	DP1("CShowEngine::DBUpdateShow, title='%S'", &aItem.Title());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	869
30 7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	870	HBufC* titleBuf = HBufC::NewLC(KMaxLineLength);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	871	TPtr titlePtr(titleBuf->Des());
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	872	titlePtr.Copy(aItem.Title());
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	873	PodcastUtils::SQLEncode(titlePtr);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	874
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	875	HBufC* descBuf = HBufC::NewLC(KMaxLineLength);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	876	TPtr descPtr(descBuf->Des());
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	877	descPtr.Copy(aItem.Description());
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	878	PodcastUtils::SQLEncode(descPtr);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	879
164 000f9fc147b2 Catch up with default branch; New v 27 SIS Sebastian Brannstrom <sebastianb@symbian.org> parents: 149 diff changeset	880	_LIT(KSqlStatement, "update shows set url=\"%S\", title=\"%S\", description=\"%S\", filename=\"%S\", position=\"%Lu\", playtime=\"%u\", playstate=\"%u\", downloadstate=\"%u\", feeduid=\"%u\", showsize=\"%u\", trackno=\"%u\",pubdate=\"%Lu\", showtype=\"%d\", lasterror=\"%d\" where uid=\"%u\"");
30 7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	881	iSqlBuffer.Format(KSqlStatement, &aItem.Url(), &titlePtr, &descPtr,
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	882	&aItem.FileName(), aItem.Position().Int64(), aItem.PlayTime(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	883	aItem.PlayState(), aItem.DownloadState(), aItem.FeedUid(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	884	aItem.ShowSize(), aItem.TrackNo(), aItem.PubDate().Int64(),
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	885	aItem.ShowType(), aItem.LastError(), aItem.Uid());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	886
30 7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	887	CleanupStack::PopAndDestroy(descBuf);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	888	CleanupStack::PopAndDestroy(titleBuf);
7bca37ba5fa9 Added SQLEncoding for update of showinfo. Removed ABLD.BAT from repo teknolog parents: 22 diff changeset	889
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	890	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	891
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	892	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	893	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	894
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	895	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	896	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	897	Cleanup_sqlite3_finalize_PushL(st);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	898	rc = sqlite3_step(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	899
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	900	if (rc != SQLITE_DONE)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	901	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	902	User::Leave(KErrUnknown);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	903	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	904	CleanupStack::PopAndDestroy(); // st
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	905	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	906	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	907	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	908	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	909	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	910	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	911
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	912	void CShowEngine::DBDeleteShowL(TUint aUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	913	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	914	DP("CShowEngine::DBDeleteShow");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	915
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	916	_LIT(KSqlStatement, "delete from shows where uid=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	917	iSqlBuffer.Format(KSqlStatement, aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	918
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	919	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	920
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	921	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	922	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	923
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	924	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	925	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	926	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	927	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	928
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	929	if (rc != SQLITE_DONE)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	930	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	931	User::Leave(KErrUnknown);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	932	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	933	CleanupStack::PopAndDestroy(); // st
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	934	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	935	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	936	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	937	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	938	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	939	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	940
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	941	void CShowEngine::DBDeleteAllShowsByFeedL(TUint aFeedUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	942	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	943	DP("CShowEngine::DBDeleteAllShowsByFeed");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	944
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	945	_LIT(KSqlStatement, "delete from shows where feeduid=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	946	iSqlBuffer.Format(KSqlStatement, aFeedUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	947
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	948	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	949
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	950	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	951	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	952
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	953	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	954	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	955	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	956	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	957
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	958	if (rc != SQLITE_DONE)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	959	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	960	User::Leave(KErrUnknown);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	961	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	962	CleanupStack::PopAndDestroy(); // st
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	963	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	964	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	965	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	966	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	967	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	968	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	969
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	970	void CShowEngine::DBRemoveAllDownloadsL()
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	971	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	972	DP("CShowEngine::DBRemoveAllDownloads");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	973
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	974	_LIT(KSqlStatement, "delete from downloads");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	975	iSqlBuffer.Format(KSqlStatement);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	976
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	977	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	978
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	979	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	980	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	981
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	982	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	983	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	984	rc = sqlite3_step(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	985	sqlite3_finalize(st);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	986	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	987	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	988	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	989	User::Leave(KErrCorrupt);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	990	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	991
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	992	_LIT(KSqlStatement2, "update shows set downloadstate=0 where downloadstate=1");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	993	iSqlBuffer.Format(KSqlStatement2);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	994
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	995	rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1, &st,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	996	(const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	997
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	998	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	999	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1000	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1001	rc = sqlite3_step(st);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1002	if (rc != SQLITE_DONE)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1003	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1004	User::Leave(KErrUnknown);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1005	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1006	CleanupStack::PopAndDestroy(); // st
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1007	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1008	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1009	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1010	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1011	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1012
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1013	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1014
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1015	void CShowEngine::DBRemoveDownloadL(TUint aUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1016	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1017	DP("CShowEngine::DBRemoveDownload");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1018
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1019	_LIT(KSqlStatement, "delete from downloads where uid=%u");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1020	iSqlBuffer.Format(KSqlStatement, aUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1021
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1022	sqlite3_stmt *st;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1023
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1024	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1025	&st, (const void**) NULL);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1026
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1027	if (rc == SQLITE_OK)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1028	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1029	Cleanup_sqlite3_finalize_PushL(st);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1030	rc = sqlite3_step(st);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1031	if (rc != SQLITE_DONE)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1032	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1033	User::Leave(KErrUnknown);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1034	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1035	CleanupStack::PopAndDestroy(); // st
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1036	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1037	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1038	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1039	User::Leave(KErrCorrupt);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1040	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1041	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1042
145 cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1043	void CShowEngine::DBSwapDownloadsL(TDownload aFirstDL, TDownload aSecondDL)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1044	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1045	DP("CShowEngine::DBSwapDownloadsL");
149 70b2f592a460 Enabled Brendan's download queue operations; Fixed minor bug in queue swapping method teknolog parents: 148 diff changeset	1046	_LIT(KSqlStatement, "update downloads set uid=%u where dl_index=%d");
145 cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1047
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1048	iSqlBuffer.Format(KSqlStatement, aFirstDL.iUid, aSecondDL.iIndex);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1049	sqlite3_stmt *st;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1050	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1051	&st, (const void**) NULL);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1052
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1053	if (rc == SQLITE_OK)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1054	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1055	Cleanup_sqlite3_finalize_PushL(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1056	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1057	if (rc != SQLITE_DONE)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1058	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1059	User::Leave(KErrUnknown);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1060	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1061	CleanupStack::PopAndDestroy(); // st
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1062	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1063	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1064	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1065	User::Leave(KErrCorrupt);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1066	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1067
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1068	iSqlBuffer.Format(KSqlStatement, aSecondDL.iUid, aFirstDL.iIndex);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1069
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1070	rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1071	&st, (const void**) NULL);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1072
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1073	if (rc == SQLITE_OK)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1074	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1075	Cleanup_sqlite3_finalize_PushL(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1076	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1077	if (rc != SQLITE_DONE)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1078	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1079	User::Leave(KErrUnknown);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1080	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1081	CleanupStack::PopAndDestroy(); // st
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1082	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1083	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1084	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1085	User::Leave(KErrCorrupt);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1086	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1087	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1088
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1089	EXPORT_C CShowInfo* CShowEngine::GetNextShowByTrackL(CShowInfo* aShowInfo)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1090	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1091	CShowInfo* nextShow = NULL;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1092	RShowInfoArray array;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1093	DBGetShowsByFeedL(array, aShowInfo->FeedUid());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1094	TUint diff = KMaxTInt;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1095	for (TInt loop = 0; loop < array.Count(); loop++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1096	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1097	if (aShowInfo->TrackNo() < array[loop]->TrackNo())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1098	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1099	if ((array[loop]->TrackNo() - aShowInfo->TrackNo()) < diff)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1100	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1101	diff = array[loop]->TrackNo() - aShowInfo->TrackNo();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1102	nextShow = array[loop];
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1103	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1104	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1105	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1106	array.ResetAndDestroy();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1107	return nextShow;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1108	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1109
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1110	TBool CShowEngine::CompareShowsByUid(const CShowInfo &a, const CShowInfo &b)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1111	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1112	return a.Uid() == b.Uid();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1113	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1114
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1115	TInt CShowEngine::CompareShowsByDate(const CShowInfo &a, const CShowInfo &b)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1116	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1117	if (a.PubDate() > b.PubDate())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1118	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1119	// DP2("Sorting %S less than %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1120	return -1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1121	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1122	else if (a.PubDate() == b.PubDate())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1123	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1124	// DP2("Sorting %S equal to %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1125	return 0;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1126	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1127	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1128	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1129	// DP2("Sorting %S greater than %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1130	return 1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1131	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1132	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1133
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1134	TInt CShowEngine::CompareShowsByTrackNo(const CShowInfo &a, const CShowInfo &b)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1135	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1136	if (a.TrackNo() < b.TrackNo())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1137	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1138	return -1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1139	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1140	else if (a.TrackNo() == b.TrackNo())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1141	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1142	return 0;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1143	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1144	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1145	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1146	return 1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1147	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1148	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1149
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1150	TInt CShowEngine::CompareShowsByTitle(const CShowInfo &a, const CShowInfo &b)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1151	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1152	if (a.Title() < b.Title())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1153	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1154	// DP2("Sorting %S less than %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1155	return -1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1156	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1157	else if (a.Title() == b.Title())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1158	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1159	// DP2("Sorting %S equal to %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1160	return 0;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1161	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1162	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1163	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1164	// DP2("Sorting %S greater than %S", &a.iTitle, &b.iTitle);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1165	return 1;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1166	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1167	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1168
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1169	EXPORT_C void CShowEngine::DeletePlayedShowsL(RShowInfoArray &aShowInfoArray)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1170	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1171	for (TInt i = 0; i < aShowInfoArray.Count(); i++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1172	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1173	if (aShowInfoArray[i]->PlayState() == EPlayed
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1174	&& aShowInfoArray[i]->FileName().Length() > 0)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1175	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1176	BaflUtils::DeleteFile(iPodcastModel.FsSession(), aShowInfoArray[i]->FileName());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1177	aShowInfoArray[i]->SetDownloadState(ENotDownloaded);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1178	DBUpdateShowL(*aShowInfoArray[i]);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1179	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1180	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1181	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1182
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1183	EXPORT_C void CShowEngine::DeleteAllShowsByFeedL(TUint aFeedUid, TBool aDeleteFiles)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1184	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1185	RShowInfoArray array;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1186	DBGetShowsByFeedL(array, aFeedUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1187
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1188	const TInt count = array.Count();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1189
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1190	for (TInt i = count - 1; i >= 0; i--)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1191	{
53 b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1192	if (iShowDownloading && iShowDownloading->Uid() == array[i]->Uid())
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1193	{
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1194	// trying to delete the active download
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1195	RemoveDownloadL(iShowDownloading->Uid());
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1196	}
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1197
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1198	// delete downloaded file
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1199	if (array[i]->FileName().Length() > 0)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1200	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1201	if (aDeleteFiles)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1202	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1203	BaflUtils::DeleteFile(iPodcastModel.FsSession(), array[i]->FileName());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1204	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1205	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1206	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1207	array.ResetAndDestroy();
53 b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1208
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1209	// delete all shows from DB
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1210	DBDeleteAllShowsByFeedL(aFeedUid);
53 b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1211
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1212	// this will clear out deleted shows from the download queue
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1213	DBGetAllDownloadsL(array);
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1214	array.ResetAndDestroy();
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1215
b778853e60a7 Fix for bug 2217 teknolog parents: 44 diff changeset	1216	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1217	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1218
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1219	EXPORT_C void CShowEngine::DeleteOldShowsByFeedL(TUint aFeedUid)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1220	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1221	DBDeleteOldShowsByFeedL(aFeedUid);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1222	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1223
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1224	EXPORT_C void CShowEngine::DeleteShowL(TUint aShowUid, TBool aRemoveFile)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1225	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1226
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1227	CShowInfo *info = DBGetShowByUidL(aShowUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1228
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1229	if (info != NULL)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1230	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1231	if (info->FileName().Length() > 0 && aRemoveFile)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1232	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1233	BaflUtils::DeleteFile(iPodcastModel.FsSession(), info->FileName());
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1234	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1235
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1236	info->SetDownloadState(ENotDownloaded);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1237	DBUpdateShowL(*info);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1238	delete info;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1239	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1240	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1241
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1242	EXPORT_C void CShowEngine::GetShowsByFeedL(RShowInfoArray& aShowArray, TUint aFeedUid)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1243	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1244	DP("CShowEngine::GetShowsByFeed");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1245	DBGetShowsByFeedL(aShowArray, aFeedUid);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1246	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1247
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1248	EXPORT_C void CShowEngine::GetAllShowsL(RShowInfoArray &aArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1249	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1250	DP("CShowEngine::GetAllShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1251	DBGetAllShowsL(aArray);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1252	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1253
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1254	EXPORT_C void CShowEngine::GetShowsDownloadedL(RShowInfoArray &aArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1255	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1256	DP("CShowEngine::GetShowsDownloaded");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1257	DBGetDownloadedShowsL(aArray);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1258	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1259
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1260	EXPORT_C void CShowEngine::GetNewShowsL(RShowInfoArray &aArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1261	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1262	DP("CShowEngine::GetNewShows");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1263	DBGetNewShowsL(aArray);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1264	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1265
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1266	EXPORT_C void CShowEngine::GetShowsDownloadingL(RShowInfoArray &aArray)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1267	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1268	DP("CShowEngine::GetShowsDownloading");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1269	DBGetAllDownloadsL(aArray);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1270	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1271
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1272	EXPORT_C TInt CShowEngine::GetNumDownloadingShows()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1273	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1274	TUint count = 0;
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1275	TRAP_IGNORE(count = DBGetDownloadsCountL());
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1276
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1277	return (const TInt) count;
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1278	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1279
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1280	EXPORT_C void CShowEngine::AddDownloadL(CShowInfo& aInfo)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1281	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1282	aInfo.SetDownloadState(EQueued);
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1283	DBUpdateShowL(aInfo);
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1284	DBAddDownloadL(aInfo.Uid());
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1285	DownloadNextShowL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1286	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1287
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1288	void CShowEngine::DownloadNextShowL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1289	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1290	DP("CShowEngine::DownloadNextShowL BEGIN");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1291	// Check if we have anything in the download queue
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1292	const TInt count = DBGetDownloadsCountL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1293	DP("CShowEngine::DownloadNextShow\tTrying to start new download");DP1("CShowEngine::DownloadNextShow\tShows in download queue %d", count);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1294
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1295	if (count > 0)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1296	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1297	if (iPodcastModel.SettingsEngine().DownloadSuspended())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1298	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1299	DP("CShowEngine::DownloadNextShow\tDownload process is suspended, ABORTING");
34 a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1300	// Inform the observers
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1301	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1302	return;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1303	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1304	else if (iShowClient->IsActive())
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1305	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1306	DP("CShowEngine::DownloadNextShow\tDownload process is already active.");
34 a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1307	// Inform the observers
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1308	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1309	return;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1310	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1311	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1312	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1313	if (iShowDownloading) {
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1314	delete iShowDownloading;
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1315	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1316
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1317	// Start the download
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1318	iShowDownloading = DBGetNextDownloadL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1319
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1320	while(iShowDownloading != NULL)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1321	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1322	DP1("CShowEngine::DownloadNextShow\tDownloading: %S", &(iShowDownloading->Title()));
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1323	iShowDownloading->SetDownloadState(EDownloading);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1324	iShowDownloading->SetLastError(KErrNone);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1325	DBUpdateShowL(*iShowDownloading);
34 a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1326	// Inform the observers
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1327	// important to do this after we change download state
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1328	NotifyDownloadQueueUpdatedL();
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1329
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1330	TRAPD(error,GetShowL(iShowDownloading));
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1331	if (error == KErrNone)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1332	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1333	break;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1334	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1335	else
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1336	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1337	iShowDownloading->SetDownloadState(EFailedDownload);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1338	DBRemoveDownloadL(iShowDownloading->Uid());
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1339	DBUpdateShowL(*iShowDownloading);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1340	CleanupStack::PopAndDestroy(iShowDownloading);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1341
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1342	iShowDownloading = DBGetNextDownloadL();
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1343	if(iShowDownloading == NULL)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1344	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1345	iPodcastModel.SettingsEngine().SetDownloadSuspended(ETrue);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1346	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1347	}
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1348	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1349	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1350	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1351	else
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1352	{
34 a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1353	// Inform the observers
a6046405f1aa Fix for download icons not updating correctly teknolog parents: 30 diff changeset	1354	NotifyDownloadQueueUpdatedL();
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1355	iShowDownloading = NULL;DP("CShowEngine::DownloadNextShow\tNothing to download");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1356	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1357	DP("CShowEngine::DownloadNextShowL END");
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1358	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1359
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1360	void CShowEngine::NotifyDownloadQueueUpdatedL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1361	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1362	const TInt count = iObservers.Count();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1363	for (TInt i = 0; i < count; i++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1364	{
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1365	iObservers[i]->DownloadQueueUpdatedL(1, DBGetDownloadsCountL() - 1);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1366	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1367	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1368
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1369	void CShowEngine::NotifyShowDownloadUpdatedL(TInt aBytesOfCurrentDownload, TInt aBytesTotal)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1370	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1371	const TInt count = iObservers.Count();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1372	for (TInt i = 0; i < count; i++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1373	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1374	iObservers[i]->ShowDownloadUpdatedL(aBytesOfCurrentDownload, aBytesTotal);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1375	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1376	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1377
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1378	void CShowEngine::NotifyShowFinishedL(TInt aError)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1379	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1380	const TInt count = iObservers.Count();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1381	for (TInt i = 0; i < count; i++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1382	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1383	iObservers[i]->ShowDownloadFinishedL(iShowDownloading?iShowDownloading->Uid():0, aError);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1384	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1385	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1386
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1387	EXPORT_C void CShowEngine::NotifyShowListUpdatedL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1388	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1389	for (TInt i = 0; i < iObservers.Count(); i++)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1390	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1391	iObservers[i]->ShowListUpdatedL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1392	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1393	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1394
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1395	void CShowEngine::ReadMetaDataL(CShowInfo& aShowInfo)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1396	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1397	//DP1("Read %S", &(aShowInfo->Title()));
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1398	DBUpdateShowL(aShowInfo);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1399	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1400
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1401	void CShowEngine::ReadMetaDataCompleteL()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1402	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1403	NotifyShowListUpdatedL();
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1404	MetaDataReader().SetIgnoreTrackNo(EFalse);
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1405	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1406
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1407	EXPORT_C void CShowEngine::UpdateShowL(CShowInfo& aInfo)
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1408	{
35 66c5303f3610 A ton of CodeScanner fixes (high issues) - but not all Brendan Donegan <brendand@symbian.org> parents: 30 diff changeset	1409	DBUpdateShowL(aInfo);
2 29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1410	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1411
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1412	EXPORT_C CMetaDataReader& CShowEngine::MetaDataReader()
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1413	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1414	return *iMetaDataReader;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1415	}
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1416
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1417	void CShowEngine::FileError(TUint /aError/)
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1418	{
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1419	iDownloadErrors = KMaxDownloadErrors;
29cda98b007e Initial import of Podcatcher from the Bergamot project skip parents: diff changeset	1420	}
60 4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1421
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1422	EXPORT_C void CShowEngine::CheckForDeletedShows(TUint aFeedUid)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1423	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1424	RShowInfoArray shows;
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1425
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1426	TRAPD(err, DBGetShowsByFeedL(shows, aFeedUid));
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1427
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1428	if (err != KErrNone)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1429	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1430	// probably a catastrophic error, but it doesn't
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1431	// matter for this method
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1432	return;
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1433	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1434
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1435	for (int i=0;i<shows.Count();i++)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1436	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1437	if (shows[i]->DownloadState() == EDownloaded && shows[i]->FileName() != KNullDesC)
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1438	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1439	if(!BaflUtils::FileExists(iPodcastModel.FsSession(),shows[i]->FileName()))
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1440	{
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1441	// file doesn't exist anymore, assume it was deleted from outside
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1442	DP1("Show %S does not exist on disk, flagging as non downloaded", &shows[i]->FileName());
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1443	shows[i]->SetDownloadState(ENotDownloaded);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1444	shows[i]->SetPlayState(EPlayed);
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1445	TRAP_IGNORE(DBUpdateShowL(*shows[i]));
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1446	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1447	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1448	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1449	}
4d230e702aa3 Moved development branch from MCL to FCL teknolog parents: 34 diff changeset	1450
148 e3f9b65d6910 Cleanup from the merge Brendan Donegan <brendand@symbian.org> parents: 147 diff changeset	1451	EXPORT_C void CShowEngine::SetShowFilter(TShowFilter aFilter)
e3f9b65d6910 Cleanup from the merge Brendan Donegan <brendand@symbian.org> parents: 147 diff changeset	1452	{
e3f9b65d6910 Cleanup from the merge Brendan Donegan <brendand@symbian.org> parents: 147 diff changeset	1453	iShowFilter = aFilter;
e3f9b65d6910 Cleanup from the merge Brendan Donegan <brendand@symbian.org> parents: 147 diff changeset	1454	}
e3f9b65d6910 Cleanup from the merge Brendan Donegan <brendand@symbian.org> parents: 147 diff changeset	1455
145 cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1456	EXPORT_C void CShowEngine::MoveDownloadUpL(TUint aUid)
130 92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	1457	{
145 cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1458	DP("CShowEngine::MoveDownLoadUpL");
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1459	_LIT(KSqlStatement, "select * from downloads");
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1460	iSqlBuffer.Format(KSqlStatement);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1461
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1462	sqlite3_stmt *st;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1463
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1464	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1465	&st, (const void**) NULL);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1466
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1467	if (rc == SQLITE_OK)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1468	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1469	RArray<TDownload> downloads;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1470	CleanupClosePushL(downloads);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1471
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1472	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1473	Cleanup_sqlite3_finalize_PushL(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1474
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1475	TInt selectedIdx = -1;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1476	while (rc == SQLITE_ROW && selectedIdx == -1)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1477	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1478	TDownload download;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1479
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1480	download.iIndex = sqlite3_column_int(st, 0);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1481	download.iUid = sqlite3_column_int(st, 1);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1482
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1483	downloads.Append(download);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1484
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1485	if (download.iUid == aUid)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1486	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1487	selectedIdx = downloads.Count()-1;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1488	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1489
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1490	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1491	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1492	CleanupStack::PopAndDestroy();//st, downloads
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1493
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1494	// If the selected download was found in the database
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1495	if (selectedIdx != -1)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1496	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1497	// Swap the specified download with the one above it
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1498	TDownload selectedDownload = downloads[selectedIdx];
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1499	TDownload previousDownload = downloads[selectedIdx - 1];
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1500
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1501	// SQL - Update index (with index of selected download) where uid is of previous download
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1502	// and update index (with index of previous download) where uid if of selected download
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1503	DBSwapDownloadsL(selectedDownload, previousDownload);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1504	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1505	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1506	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1507	User::Leave(KErrNotFound);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1508	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1509
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1510	CleanupStack::PopAndDestroy(); // downloads
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1511	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1512	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1513	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1514	User::Leave(KErrCorrupt);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1515	}
130 92572a695a1d Added new experimental feature to show only new and downloaded shows; Updated SIS files teknolog parents: 67 diff changeset	1516	}
145 cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1517
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1518	EXPORT_C void CShowEngine::MoveDownloadDownL(TUint aUid)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1519	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1520	DP("CShowEngine::MoveDownLoadDownL");
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1521
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1522	// An upside-down list will result in the download moving down
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1523	_LIT(KSqlStatement, "select * from downloads order by dl_index desc");
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1524	iSqlBuffer.Format(KSqlStatement);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1525
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1526	sqlite3_stmt *st;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1527
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1528	int rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1529	&st, (const void**) NULL);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1530
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1531	if (rc == SQLITE_OK)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1532	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1533	RArray<TDownload> downloads;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1534	CleanupClosePushL(downloads);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1535
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1536	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1537	Cleanup_sqlite3_finalize_PushL(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1538
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1539	TInt selectedIdx = -1;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1540	while (rc == SQLITE_ROW && selectedIdx == -1)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1541	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1542	TDownload download;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1543
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1544	download.iIndex = sqlite3_column_int(st, 0);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1545	download.iUid = sqlite3_column_int(st, 1);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1546
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1547	downloads.Append(download);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1548
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1549	if (download.iUid == aUid)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1550	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1551	selectedIdx = downloads.Count()-1;
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1552	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1553
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1554	rc = sqlite3_step(st);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1555	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1556	CleanupStack::PopAndDestroy();//st, downloads
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1557
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1558	// If the selected download was found in the database
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1559	if (selectedIdx != -1)
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1560	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1561	// Swap the specified download with the one above it
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1562	TDownload selectedDownload = downloads[selectedIdx];
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1563	TDownload previousDownload = downloads[selectedIdx - 1];
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1564
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1565	// SQL - Update index (with index of selected download) where uid is of previous download
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1566	// and update index (with index of previous download) where uid if of selected download
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1567	DBSwapDownloadsL(selectedDownload, previousDownload);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1568	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1569	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1570	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1571	User::Leave(KErrNotFound);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1572	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1573
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1574	CleanupStack::PopAndDestroy(); // downloads
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1575	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1576	else
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1577	{
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1578	User::Leave(KErrCorrupt);
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1579	}
cc0182a5da39 Fix for Bug 2604 and bulk of the work towards implementing Bug 2737 Brendan Donegan <brendand@symbian.org> parents: 67 diff changeset	1580	}

author	Sebastian Brannstrom <sebastianb@symbian.org>
	Wed, 28 Jul 2010 14:18:09 +0100
branch	symbian1
changeset 212	713bd6cc0b7a
parent 167	4bfc2fcec5f6
child 246	140a404c6b53
permissions	-rw-r--r--