--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/qtinternetradio/irdb/src/searchrltwrapper.cpp	Fri Sep 17 08:27:59 2010 +0300
@@ -0,0 +1,254 @@
+/*
+* 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 "searchrltwrapper.h"
+#include "irdb.h"
+
+searchRltWrapper::searchRltWrapper()
+{     
+}
+
+searchRltWrapper::~searchRltWrapper()
+{
+} 
+
+/*
+* 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 searchRltWrapper::putSearchRlt(const columnMap* const RowData,
+                                    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;
+        }
+    }
+    
+    insSqlStr = "insert into IRBuff ";   
+    updSqlStr = "update IRBuff set ";
+    RowDataAppend->insert(dataSource, QString::number(DATA_OF_SEARCHRLT));
+    RowDataAppend->insert(opt, QString::number(IRDB_OPT_INSERT));    
+ 
+    if(NULL != logoData)
+    {
+        pImgList = new QList<QByteArray>();
+        combinePutStr(RowDataAppend, colNameView, insSqlStr, updSqlStr, logoData, pImgList); 
+    
+    }
+    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, NULL, condSqlStr, condUserCidStr, pImgList)?ret = false:true;
+    }    
+
+    if(pImgList)
+    {
+        delete pImgList;
+        pImgList = NULL;
+    }
+    
+    return ret;
+}    
+
+QList<QVariant*>*  searchRltWrapper::getSearchRlt(const columnMap* const condAND,  
+                                                  const columnMap* const condOR)
+{
+    QString sltSqlStr = "select * from IRVIEW_searchRlt ";
+    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;
+        }
+    }
+
+    combineGetStr(condAND, condOR, colNameView, sltSqlStr);
+    pDataSet = new QList<QVariant*>();
+    if( m_pIRDB->selectRow(this, sltSqlStr, pDataSet) )
+    {
+        delete pDataSet;
+        pDataSet = NULL;
+    }
+    
+    return pDataSet;
+}
+
+
+bool searchRltWrapper::deleteSearchRlt(const columnMap* const condAND,
+                                       const columnMap* const condOR)
+{
+    QString deleteSqlStr = "delete from searchRlt ";
+    
+    if( (NULL != condAND)&&(NULL != condOR) )
+    {
+        return false;
+    }
+
+    if(condAND)
+    {
+        if(condAND->isEmpty())
+        {
+            return false;
+        }
+    }
+
+    if(condOR)
+    {
+        if(condOR->isEmpty())
+        {
+            return false;
+        }
+    }
+
+    combineDeleteStr(condAND, condOR, colNameView, deleteSqlStr);
+    return m_pIRDB->deleteRow(deleteSqlStr)? false:true;
+}
+
+
+bool searchRltWrapper::getIRTableCB(QSqlQuery& aIRDataSet, QList<QVariant*>* pDataSet)
+{
+
+    while (aIRDataSet.next()) 
+    {
+        QVariant* const p = new QVariant[IRDB_SEARCHRLT_COLUMN];
+
+        *pDataSet<<p;
+
+        for(int i = 0; i < IRDB_SEARCHRLT_COLUMN; i++)
+        {
+            *(p+i) = aIRDataSet.value(i);
+        }
+    }
+
+    return true;
+}
+
+uint searchRltWrapper::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;
+}
+