diff -r 065198191975 -r 5723da102db1 qtinternetradio/irdb/src/imgwrapper.cpp --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/qtinternetradio/irdb/src/imgwrapper.cpp Fri Sep 17 08:27:59 2010 +0300 @@ -0,0 +1,140 @@ +/* +* 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 +#include +#include "imgwrapper.h" +#include "irdb.h" + +imgWrapper::imgWrapper() +{ +} + +imgWrapper::~imgWrapper() +{ +} + + +bool imgWrapper::updateImg(const columnMap* const RowData, + const uint& channelId, + const logoMap* const logoData) +{ + QString insSqlStr; + QString updSqlStr; + QList* pImgList = NULL; + bool ret = true; + + if(!channelId) + { + return false; + } + + if( NULL == RowData ) + { + return false; + } + + if(RowData->isEmpty()) + { + return false; + } + + if( true != (RowData->value(channelId)).isEmpty() ) + { + return false; + } + + updSqlStr = "update img set "; + if(NULL != logoData) + { + pImgList = new QList(); + combinePutStr(RowData, colNameView, insSqlStr, updSqlStr, logoData, pImgList); + + } + else + { + combinePutStr(RowData, colNameView, insSqlStr, updSqlStr); + } + + //create insSqlstr and updSqlStr in advance; + updSqlStr = updSqlStr + "where channelId = " + QString::number(channelId); + + m_pIRDB->updRowImg(channelId, updSqlStr, pImgList)? ret = false:true; + if(pImgList) + { + delete pImgList; + pImgList = NULL; + } + + return ret; +} + +QList* imgWrapper::getImg(const columnMap* const condAND, + const columnMap* const condOR) +{ + QString sltSqlStr = "select * from IRVIEW_channelinfo "; + QList* pDataSet = NULL; + + if( (NULL != condAND)&&(NULL != condOR) ) + { + return NULL; + } + + if(condAND) + { + if(condAND->isEmpty()) + { + return NULL; + } + } + + if(condOR) + { + if(condOR->isEmpty()) + { + return NULL; + } + } + + combineGetStr(condAND, condOR, colNameView, sltSqlStr); + pDataSet = new QList(); + + if( m_pIRDB->selectRow(this, sltSqlStr, pDataSet) ) + { + delete pDataSet; + pDataSet = NULL; + } + + return pDataSet; +} + +bool imgWrapper::getIRTableCB(QSqlQuery& aIRDataSet, QList* pDataSet) +{ + + while (aIRDataSet.next()) + { + QVariant* const p = new QVariant[IRDB_CHANNELINFO_COLUMN]; + *pDataSet<