sqlite/sqlitedriver.cpp

/* This file is part of the KDE project
   Copyright (C) 2003-2004 Jaroslaw Staniek <js@iidea.pl>
 
   This program is free software; you can redistribute it and/or
   modify it under the terms of the GNU Library General Public
   License as published by the Free Software Foundation; either
   version 2 of the License, or (at your option) any later version.
 
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
   Library General Public License for more details.
 
   You should have received a copy of the GNU Library General Public License
   along with this program; see the file COPYING.  If not, write to
   the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
 * Boston, MA 02110-1301, USA.
*/
 
#include <kexidb/connection.h>
#include <kexidb/drivermanager.h>
#include <kexidb/driver_p.h>
#include <kexidb/utils.h>
 
#include "sqlite.h"
#include "sqlitedriver.h"
#include "sqliteconnection.h"
#include "sqliteconnection_p.h"
#include "sqliteadmin.h"
 
#include <kdebug.h>
 
using namespace KexiDB;
 
#ifdef SQLITE2
KEXIDB_DRIVER_INFO( SQLiteDriver, sqlite2 )
#else
KEXIDB_DRIVER_INFO( SQLiteDriver, sqlite3 )
#endif

class KexiDB::SQLiteDriverPrivate 
{
    public:
        SQLiteDriverPrivate()
        {
        }
};
 
//PgSqlDB::PgSqlDB(TQObject *parent, const char *name, const TQStringList &) 
SQLiteDriver::SQLiteDriver( TQObject *parent, const char *name, const TQStringList &args )
    : Driver( parent, name, args )
    ,dp( new SQLiteDriverPrivate() )
{
    d->isFileDriver = true;
    d->isDBOpenedAfterCreate = true;
    d->features = SingleTransactions | CursorForward
#ifndef SQLITE2
        | CompactingDatabaseSupported;
#endif
    ;
    
    //special method for autoincrement definition
    beh->SPECIAL_AUTO_INCREMENT_DEF = true;
    beh->AUTO_INCREMENT_FIELD_OPTION = ""; //not available
    beh->AUTO_INCREMENT_TYPE = "INTEGER";
    beh->AUTO_INCREMENT_PK_FIELD_OPTION = "PRIMARY KEY";
    beh->AUTO_INCREMENT_REQUIRES_PK = true;
    beh->ROW_ID_FIELD_NAME = "OID";
    beh->_1ST_ROW_READ_AHEAD_REQUIRED_TO_KNOW_IF_THE_RESULT_IS_EMPTY=true;
    beh->QUOTATION_MARKS_FOR_IDENTIFIER='"';
    beh->SELECT_1_SUBQUERY_SUPPORTED = true;
    beh->SQL_KEYWORDS = keywords;
    initSQLKeywords(29);
 
    //predefined properties
    d->properties["client_library_version"] = sqlite_libversion();
    d->properties["default_server_encoding"] = 
#ifdef SQLITE2
        sqlite_libencoding();
#else //SQLITE3
        "UTF8"; //OK?
#endif
 
    d->typeNames[Field::Byte]="Byte";
    d->typeNames[Field::ShortInteger]="ShortInteger";
    d->typeNames[Field::Integer]="Integer";
    d->typeNames[Field::BigInteger]="BigInteger";
    d->typeNames[Field::Boolean]="Boolean";
    d->typeNames[Field::Date]="Date";         // In fact date/time types could be declared as datetext etc. 
    d->typeNames[Field::DateTime]="DateTime"; // to force text affinity..., see http://sqlite.org/datatype3.html
    d->typeNames[Field::Time]="Time";         //
    d->typeNames[Field::Float]="Float";
    d->typeNames[Field::Double]="Double";
    d->typeNames[Field::Text]="Text";
    d->typeNames[Field::LongText]="CLOB";
    d->typeNames[Field::BLOB]="BLOB";
}
 
SQLiteDriver::~SQLiteDriver()
{
    delete dp;
}
 
 
KexiDB::Connection* 
SQLiteDriver::drv_createConnection( ConnectionData &conn_data )
{
    return new SQLiteConnection( this, conn_data );
}
 
bool SQLiteDriver::isSystemObjectName( const TQString& n ) const
{
    return Driver::isSystemObjectName(n) || n.lower().startsWith("sqlite_");
}
 
bool SQLiteDriver::drv_isSystemFieldName( const TQString& n ) const
{
    return n.lower()=="_rowid_"
        || n.lower()=="rowid"
        || n.lower()=="oid";
}
 
TQString SQLiteDriver::escapeString(const TQString& str) const
{
    return TQString("'")+TQString(str).replace( '\'', "''" ) + "'";
}
 
TQCString SQLiteDriver::escapeString(const TQCString& str) const
{
    return TQCString("'")+TQCString(str).replace( '\'', "''" )+"'";
}
 
TQString SQLiteDriver::escapeBLOB(const TQByteArray& array) const
{
    return KexiDB::escapeBLOB(array, KexiDB::BLOBEscapeXHex);
}
 
TQString SQLiteDriver::drv_escapeIdentifier( const TQString& str) const
{
    return TQString(str).replace( '"', "\"\"" );
}
 
TQCString SQLiteDriver::drv_escapeIdentifier( const TQCString& str) const
{
    return TQCString(str).replace( '"', "\"\"" );
}
 
AdminTools* SQLiteDriver::drv_createAdminTools() const
{
#ifdef SQLITE2
    return new AdminTools(); //empty impl.
#else
    return new SQLiteAdminTools();
#endif
}
 
#include "sqlitedriver.moc"