mysqlmigrate.h

/* This file is part of the KDE project
   Copyright (C) 2004 Martin Ellis <m.a.ellis@ncl.ac.uk>
   Copyright (C) 2006 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.
*/
 
#ifndef MYSQLMIGRATE_H
#define MYSQLMIGRATE_H
 
#include "migration/keximigrate.h"
#include "kexidb/drivers/mySQL/mysqlconnection_p.h"
 
namespace KexiMigration
{
 
    class MySQLMigrate : public KexiMigrate
    {
        TQ_OBJECT
  
        KEXIMIGRATION_DRIVER
 
        private:
            MySqlConnectionInternal *d;
            MYSQL_RES *m_mysqlres;
 
        protected:
            //Driver specific function to return table names
            virtual bool drv_tableNames(TQStringList& tablenames);
            
            //Driver specific implementation to read a table schema
            virtual bool drv_readTableSchema(
                const TQString& originalName, KexiDB::TableSchema& tableSchema);
            //Driver specific connection implementation
            virtual bool drv_connect();
            virtual bool drv_disconnect();
 
            virtual tristate drv_queryStringListFromSQL(
                const TQString& sqlStatement, uint columnNumber, 
                TQStringList& stringList, int numRecords = -1);
 
            virtual tristate drv_fetchRecordFromSQL(const TQString& sqlStatement, 
                KexiDB::RowData& data, bool &firstRecord);
 
            virtual bool drv_copyTable(const TQString& srcTable, 
                KexiDB::Connection *destConn, KexiDB::TableSchema* dstTable);
 
            virtual bool drv_progressSupported() { return true; }
            virtual bool drv_getTableSize(const TQString& table, TQ_ULLONG& size);
 
//TODO: move this somewhere to low level class (MIGRATION?)
//          virtual bool drv_getTablesList( TQStringList &list );
//TODO: move this somewhere to low level class (MIGRATION?)
//          virtual bool drv_containsTable( const TQString &tableName );
 
        public:
//          MySQLMigrate();
            MySQLMigrate(TQObject *parent, const char *name, const TQStringList& args = TQStringList());
            ~MySQLMigrate();
            
            KexiDB::Field::Type type(const TQString& table, const MYSQL_FIELD* t);
            
            KexiDB::Field::Type examineBlobField(const TQString& table, 
                                                 const MYSQL_FIELD* fld);
            
            TQStringList examineEnumField(const TQString& table,
                                         const MYSQL_FIELD* fld);
            void getConstraints(int mysqlConstraints, KexiDB::Field* fld);
            void getOptions(int flags, KexiDB::Field* fld);
    };
}
 
#endif