/*
* 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 "cpredictivesearchsettingstable.h"
#include "dbsqlconstants.h"

// This macro suppresses log writes
//#define NO_PRED_SEARCH_LOGS
#include "predictivesearchlog.h"


_LIT(KSqlContactPredSearchSettingsTable, "pred_search_settings");

_LIT(KCreatePredSearchSettingsTable, "CREATE TABLE pred_search_settings (language INTEGER);");

_LIT(KPredSearchSettingsLanguage, "language");

// How many characters the decimal representation of enum QLocale::Language
// requires.
const TInt KSizeOfLanguageValue = 8;

//_LIT(KInsertFormat, "INSERT INTO pred_search_settings (language) VALUES (%d);");
// e.g. "INSERT INTO pred_search_settings (language) VALUES (8);"
_LIT(KInsertFormat, "INSERT INTO %S (%S) VALUES (%d);");

// e.g. "UPDATE pred_search_settings SET language = 9;"
_LIT(KUpdateFormat, "UPDATE %S SET %S = %d;");

// e.g. "SELECT language FROM pred_search_settings;"
_LIT(KSelectFormat, "SELECT %S FROM %S;");



CPredictiveSearchSettingsTable*
CPredictiveSearchSettingsTable::NewL(RSqlDatabase& aDatabase)
	{
	PRINT(_L("CPredictiveSearchSettingsTable::NewL"));
	CPredictiveSearchSettingsTable* self =
		CPredictiveSearchSettingsTable::NewLC(aDatabase);
	CleanupStack::Pop(self);
	PRINT(_L("CPredictiveSearchSettingsTable::NewL ends"));
	return self;
	}

CPredictiveSearchSettingsTable*
CPredictiveSearchSettingsTable::NewLC(RSqlDatabase& aDatabase)
	{
	PRINT(_L("CPredictiveSearchSettingsTable::NewLC"));
	CPredictiveSearchSettingsTable* self =
		new (ELeave) CPredictiveSearchSettingsTable(aDatabase);
	CleanupStack::PushL(self);
	self->ConstructL();
	PRINT(_L("CPredictiveSearchSettingsTable::NewLC ends"));
	return self;
	}

CPredictiveSearchSettingsTable::~CPredictiveSearchSettingsTable()
	{
	PRINT(_L("CPredictiveSearchSettingsTable dtor"));
	PRINT(_L("CPredictiveSearchSettingsTable dtor ends"));
	}

void CPredictiveSearchSettingsTable::CreateInDbL(CContactItem& /*aItem*/)
	{
	}

void CPredictiveSearchSettingsTable::UpdateL(const CContactItem& /*aItem*/)
	{
	}

void CPredictiveSearchSettingsTable::DeleteL(const CContactItem& /*aItem*/,
												TBool& /*aLowDiskErrorOccurred*/)
	{
	}

// Create table to an empty database, so there is no need to re-generate QWERTY
// tables.
void CPredictiveSearchSettingsTable::CreateTableL()
	{
	PRINT(_L("CPredictiveSearchSettingsTable::CreateTableL"));

	User::LeaveIfError(iDatabase.Exec(KCreatePredSearchSettingsTable));
	enum QLocale::Language language = GetCurrentLanguageL();
	HBufC* insert = HBufC::NewLC(KInsertFormat().Length() +
								 KSqlContactPredSearchSettingsTable().Length() +
							 	 KPredSearchSettingsLanguage().Length() +
							 	 KSizeOfLanguageValue);
	insert->Des().AppendFormat(KInsertFormat,
							   &KSqlContactPredSearchSettingsTable,
							   &KPredSearchSettingsLanguage,
							   language);
	User::LeaveIfError(iDatabase.Exec(*insert));
	CleanupStack::PopAndDestroy(insert);

	PRINT(_L("CPredictiveSearchSettingsTable::CreateTableL ends"));
	}

QList<QChar> CPredictiveSearchSettingsTable::FillAllTables() const
	{
	QList<QChar> tables;
	tables.append('1'); // Add one character (does not matter what the character is)
	return tables;
	}

HBufC* CPredictiveSearchSettingsTable::TableNameL(const QChar /*aCh*/) const
	{
	return KSqlContactPredSearchSettingsTable().AllocL();
	}

TBool CPredictiveSearchSettingsTable::IsLanguageValidL() const
	{
	PRINT(_L("CPredictiveSearchSettingsTable::IsLanguageValidL"));
	return ReadStoredLanguageL() == GetCurrentLanguageL();
	}

void CPredictiveSearchSettingsTable::StoreCurrentLanguageL() const
	{
	PRINT(_L("CPredictiveSearchSettingsTable::StoreCurrentLanguageL"));

	enum QLocale::Language language = GetCurrentLanguageL();
	HBufC* update = HBufC::NewLC(KUpdateFormat().Length() +
								 KSqlContactPredSearchSettingsTable().Length() +
							 	 KPredSearchSettingsLanguage().Length() +
							 	 KSizeOfLanguageValue);
	update->Des().AppendFormat(KUpdateFormat,
							   &KSqlContactPredSearchSettingsTable,
							   &KPredSearchSettingsLanguage,
							   language);
	User::LeaveIfError(iDatabase.Exec(*update));
	CleanupStack::PopAndDestroy(update);

	PRINT(_L("CPredictiveSearchSettingsTable::StoreCurrentLanguageL ends"));
	}

void CPredictiveSearchSettingsTable::ConstructL()
	{
	}

enum QLocale::Language CPredictiveSearchSettingsTable::GetCurrentLanguageL() const
	{
    enum QLocale::Language language(QLocale::C);
	QT_TRYCATCH_LEAVING(language = QLocale::system().language());
	PRINT1(_L("CPredictiveSearchSettingsTable::GetCurrentLanguageL ret=%d"), language);
	return language;
	}

enum QLocale::Language CPredictiveSearchSettingsTable::ReadStoredLanguageL() const
	{
	TInt bufSize = KSelectFormat().Length() +
				   KPredSearchSettingsLanguage().Length() +
				   KSqlContactPredSearchSettingsTable().Length();
	HBufC* select = HBufC::NewLC(bufSize);
	select->Des().AppendFormat(KSelectFormat,
		&KPredSearchSettingsLanguage,
		&KSqlContactPredSearchSettingsTable);

	RSqlStatement stmnt;
	CleanupClosePushL(stmnt);
	PRINT1(_L("CPredictiveSearchSettingsTable::ReadStoredLanguageL SQL:%S"), select);
    stmnt.PrepareL(iDatabase, *select);

	const TInt KLanguageIndex = 0;
	TInt err = stmnt.Next();
	enum QLocale::Language language(QLocale::C);
	if (err == KSqlAtRow)
        {
		language = static_cast<QLocale::Language>(stmnt.ColumnInt(KLanguageIndex));
		PRINT1(_L("read language=%d from DB"), language);
        }
	CleanupStack::PopAndDestroy(&stmnt);
	CleanupStack::PopAndDestroy(select);

    if (err != KSqlAtRow)
        {
		PRINT1(_L("CPredictiveSearchSettingsTable::ReadStoredLanguageL err=%d"), err);
        User::Leave(err);
        }
	PRINT1(_L("CPredictiveSearchSettingsTable::ReadStoredLanguageL ret=%d"), language);
	return language;
	}

/**
Constructor
*/
CPredictiveSearchSettingsTable::CPredictiveSearchSettingsTable(
	RSqlDatabase& aDatabase) :
	CPplPredictiveSearchTableBase(aDatabase, 0, 0)
	{
	}