/*
* Copyright (c) 2010 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.
*
* Contributors:
*
* Description: 
*
*/

#include <QtGui>
#include <QGraphicsLayout>
#include <hbmainwindow.h>
#include <hbwidget.h>
#include <hbtextedit.h>
#include <qsql.h>
#include <qsqldatabase.h>
#include <qsqlquery.h>
#include "testci.h"

TestCI::TestCI( )
{
}

TestCI::~TestCI()
{

}

void TestCI::updatedbcontent( HbTextEdit* aHbTextEdit )
    {
    QString mConnectionName("cpixcontentinfo.sq");
    QString mDatabaseName("c:\\Private\\2001f6fb\\cpixcontentinfo.sq");

    QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE", mConnectionName);
    db.setDatabaseName(mDatabaseName);

    QSqlQuery query(QSqlDatabase::database(mConnectionName));
    QString statement = "SELECT * FROM table1";

    query.prepare(statement);
    query.exec();
    QString resultinstring("Database View : \n");
    resultinstring.append( "ContentName   INS   BLS  \n" );
    resultinstring.append( "--------------------------------\n" );
    
    while (query.next())
       {
       QString category_name = query.value(0).toString();
       int ins = query.value(1).toInt ();
       int bls = query.value(2).toInt ( );
       resultinstring  += category_name + "   " +  QString().setNum( ins ) + "   " +QString().setNum( bls ) + "\n";
       aHbTextEdit->setPlainText ( resultinstring );  
       }
    
    db.close();
    return;   
    }

void TestCI::doCITest()
{
    //Declare controls
    HbTextEdit* resultsBox;
    
    HbMainWindow *BigScreen = new HbMainWindow();
    HbWidget *w = new HbWidget;
    QGraphicsLinearLayout *layout = new QGraphicsLinearLayout;
    layout->setOrientation(Qt::Vertical);
        
    //Initialize controls    
    resultsBox = new HbTextEdit;
    layout->addItem( resultsBox );
    
    resultsBox->setReadOnly( true );    
    
    updatedbcontent ( resultsBox );
    
    w->setLayout( layout );
    BigScreen->addView ( w );
    BigScreen->show();    
}