--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/qtinternetradio/irdb/src/channelhistorywrapper.cpp Fri Sep 17 08:27:59 2010 +0300
@@ -0,0 +1,262 @@
+/*
+* Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of "Eclipse Public License v1.0"
+* which accompanies this distribution, and is available
+* at the URL "http://www.eclipse.org/legal/epl-v10.html".
+*
+* Initial Contributors:
+* Nokia Corporation - initial contribution.
+*
+* Description:
+*
+*/
+
+#include <QSqlQuery>
+#include <QVariant>
+#include "channelhistorywrapper.h"
+#include "irdb.h"
+
+
+channelHistoryWrapper::channelHistoryWrapper()
+{
+}
+
+channelHistoryWrapper::~channelHistoryWrapper()
+{
+}
+
+bool channelHistoryWrapper::deleteChannelHistory(const columnMap* const condAND,
+ const columnMap* const condOR)
+{
+ QString deleteSqlStr;
+
+ if( (NULL != condAND)&&(NULL != condOR) )
+ {
+ return false;
+ }
+
+ if(condAND)
+ {
+ if(condAND->isEmpty())
+ {
+ return false;
+ }
+ }
+
+ if(condOR)
+ {
+ if(condOR->isEmpty())
+ {
+ return false;
+ }
+ }
+
+ deleteSqlStr = "delete from channelHistory ";
+ combineDeleteStr(condAND, condOR, colNameView, deleteSqlStr);
+
+ return m_pIRDB->deleteRow(deleteSqlStr)?false:true;
+}
+
+bool channelHistoryWrapper::getIRTableCB(QSqlQuery& aIRDataSet, QList<QVariant*>* pQListDataSet)
+{
+ while (aIRDataSet.next())
+ {
+ QVariant* const p = new QVariant[IRDB_CHANNELHISTORY_COLUMN];
+ *pQListDataSet<<p;
+
+ for(int i = 0; i < IRDB_CHANNELHISTORY_COLUMN; i++)
+ {
+ *(p+i) = aIRDataSet.value(i);
+ }
+ }
+
+ return true;
+}
+
+uint channelHistoryWrapper::srhChannelId(QString& condUserCidStr,
+ const columnMap* const condAND,
+ const columnMap* const condOR)
+{
+ uint srhCID = 0;
+
+ //if condAND or condOR has channeld,
+ if(condAND != NULL)
+ {
+ srhCID = (condAND->value(channelId)).toUInt();
+ }
+ else if(condOR != NULL)
+ {
+ srhCID = (condOR->value(channelId)).toUInt();
+ }
+
+ if(srhCID)
+ {
+ return srhCID ;
+ }
+
+ //channelId column is false
+ //only one case, go to station view, channelUrl and channelNickName
+ //search channelId according to urlinof and channelNickName;
+ QString srhStr;
+ if(condAND != NULL)
+ {
+ if( ( !(condAND->value(channelUrl).isEmpty()) )&&( !(condAND->value(channelNickName).isEmpty()) ) )
+ {
+ srhStr = "where "+ colNameView[channelUrl] + " = ";
+ srhStr = srhStr + "'" + condAND->value(channelUrl) + "' AND " ;
+ srhStr = srhStr + colNameView[channelNickName] + " = ";
+ srhStr = srhStr + "'" + condAND->value(channelNickName) + "'";
+ }
+ condUserCidStr = srhStr;
+ }
+
+ return srhCID;
+}
+
+/*
+* this fuction don't suport "update" operation for mutliple records ;
+* if condAND != NULL AND condOR != NULL, illegal operation;
+* if condAND != NULL or condOR != NULL, it must be "update" operation.
+* if condAND == NULL AND condOR == NULL, it is "insert" or "update" operation;
+*
+*/
+bool channelHistoryWrapper::putChannelHistory(const columnMap* const RowData,
+ uint* const cidUserDefined,
+ const logoMap* const logoData,
+ const columnMap* const condAND,
+ const columnMap* const condOR)
+{
+ uint uCid = 0;
+ QString insSqlStr;
+ QString updSqlStr;
+ QString condSqlStr;
+ QString condUserCidStr;
+ columnMap* const RowDataAppend = const_cast<columnMap*>(RowData);
+ QList<QByteArray>* pImgList = NULL;
+ bool ret = true;
+
+
+ if( NULL == RowData )
+ {
+ return false;
+ }
+
+ if(RowData->isEmpty())
+ {
+ return false;
+ }
+
+
+ if( (NULL != condAND)&&(NULL != condOR) )
+ {
+ return false;
+ }
+
+ if(condAND)
+ {
+ if(condAND->isEmpty())
+ {
+ return false;
+ }
+ }
+
+ if(condOR)
+ {
+ if(condOR->isEmpty())
+ {
+ return false;
+ }
+ }
+
+ if(cidUserDefined)
+ {
+ *cidUserDefined = 0;
+ }
+
+ insSqlStr = "insert into IRBuff ";
+ updSqlStr = "update IRBuff set ";
+ RowDataAppend->insert(opt, QString::number(IRDB_OPT_INSERT));
+ RowDataAppend->insert(dataSource, QString::number(DATA_OF_CHANNELHISTORY));
+
+ if(NULL != logoData)
+ {
+ pImgList = new QList<QByteArray>();
+ combinePutStr(RowDataAppend, colNameView, insSqlStr, updSqlStr, logoData, pImgList);
+ *pImgList=logoData->values();
+
+ }
+ else
+ {
+ combinePutStr(RowDataAppend, colNameView, insSqlStr, updSqlStr);
+ }
+
+ if( (NULL == condAND)&&(NULL == condOR) )
+ {
+ uCid = srhChannelId(condUserCidStr,RowData);
+ }
+ else //here it must be "update" operation; condition string
+ {
+ uCid = srhChannelId(condUserCidStr,condAND, condOR);
+ combineCondStr(condAND, condOR, colNameView, condSqlStr);
+ }
+
+ if(uCid)
+ {
+ //updSqlStr += condSqlStr;
+ m_pIRDB->chgRowIRDB(insSqlStr, updSqlStr, uCid, condSqlStr, pImgList)? ret = false:true;
+ }
+ else //here deliver the updSqlstr and condSqlStr seperately.
+ {
+ m_pIRDB->chgRowIRDB(insSqlStr, updSqlStr, cidUserDefined, condSqlStr, condUserCidStr, pImgList)?ret = false:true;
+ }
+
+ if(pImgList)
+ {
+ delete pImgList;
+ pImgList = NULL;
+ }
+
+ return ret;
+}
+
+
+QList<QVariant*>* channelHistoryWrapper::getChannelHistory(const columnMap* const condAND,
+ const columnMap* const condOR)
+{
+ QString sltSqlStr;
+ QList<QVariant*> *pDataSet = NULL;
+ if( (NULL != condAND)&&(NULL != condOR) )
+ {
+ return NULL;
+ }
+
+ if(condAND)
+ {
+ if(condAND->isEmpty())
+ {
+ return NULL;
+ }
+ }
+
+ if(condOR)
+ {
+ if(condOR->isEmpty())
+ {
+ return NULL;
+ }
+ }
+
+ sltSqlStr = "select * from IRView_channelinfo ";
+ combineGetStr(condAND, condOR, colNameView,sltSqlStr);
+ pDataSet = new QList<QVariant*>();
+ if( m_pIRDB->selectRow(this, sltSqlStr, pDataSet) )
+ {
+ delete pDataSet;
+ pDataSet = NULL;
+ }
+
+ return pDataSet;
+}
+