diff options
author | tpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da> | 2011-06-25 05:28:35 +0000 |
---|---|---|
committer | tpearson <tpearson@283d02a7-25f6-0310-bc7c-ecb5cbfe19da> | 2011-06-25 05:28:35 +0000 |
commit | f008adb5a77e094eaf6abf3fc0f36958e66896a5 (patch) | |
tree | 8e9244c4d4957c36be81e15b566b4aa5ea26c982 /kexi/migration/mysql | |
parent | 1210f27b660efb7b37ff43ec68763e85a403471f (diff) | |
download | koffice-f008adb5a77e094eaf6abf3fc0f36958e66896a5.tar.gz koffice-f008adb5a77e094eaf6abf3fc0f36958e66896a5.zip |
TQt4 port koffice
This should enable compilation under both Qt3 and Qt4; fixes for any missed components will be forthcoming
git-svn-id: svn://anonsvn.kde.org/home/kde/branches/trinity/applications/koffice@1238284 283d02a7-25f6-0310-bc7c-ecb5cbfe19da
Diffstat (limited to 'kexi/migration/mysql')
-rw-r--r-- | kexi/migration/mysql/mysqlmigrate.cpp | 94 | ||||
-rw-r--r-- | kexi/migration/mysql/mysqlmigrate.h | 27 |
2 files changed, 61 insertions, 60 deletions
diff --git a/kexi/migration/mysql/mysqlmigrate.cpp b/kexi/migration/mysql/mysqlmigrate.cpp index a2c62dd5..013613ea 100644 --- a/kexi/migration/mysql/mysqlmigrate.cpp +++ b/kexi/migration/mysql/mysqlmigrate.cpp @@ -20,11 +20,11 @@ #include "mysqlmigrate.h" -#include <qstring.h> -#include <qregexp.h> -#include <qfile.h> -#include <qvariant.h> -#include <qvaluelist.h> +#include <tqstring.h> +#include <tqregexp.h> +#include <tqfile.h> +#include <tqvariant.h> +#include <tqvaluelist.h> #include <kdebug.h> #include <mysql_version.h> @@ -52,9 +52,9 @@ KEXIMIGRATE_DRIVER_INFO( MySQLMigrate, mysql ) }*/ //! Constructor (needed for trading interface) -MySQLMigrate::MySQLMigrate(QObject *parent, const char *name, - const QStringList &args) : - KexiMigrate(parent, name, args) +MySQLMigrate::MySQLMigrate(TQObject *tqparent, const char *name, + const TQStringList &args) : + KexiMigrate(tqparent, name, args) ,d(new MySqlConnectionInternal(0)) ,m_mysqlres(0) { @@ -92,7 +92,7 @@ bool MySQLMigrate::drv_disconnect() /* ************************************************************************** */ /*! Get the types and properties for each column. */ bool MySQLMigrate::drv_readTableSchema( - const QString& originalName, KexiDB::TableSchema& tableSchema) + const TQString& originalName, KexiDB::TableSchema& tableSchema) { // m_table = new KexiDB::TableSchema(table); @@ -100,7 +100,7 @@ bool MySQLMigrate::drv_readTableSchema( // tableSchema.setCaption(table + " table"); //Perform a query on the table to get some data - QString query = QString("SELECT * FROM `") + drv_escapeIdentifier(originalName) + "` LIMIT 0"; + TQString query = TQString("SELECT * FROM `") + drv_escapeIdentifier(originalName) + "` LIMIT 0"; if(d->executeSQL(query)) { MYSQL_RES *res = mysql_store_result(d->mysql); if (res != NULL) { @@ -109,14 +109,14 @@ bool MySQLMigrate::drv_readTableSchema( MYSQL_FIELD *fields = mysql_fetch_fields(res); for(unsigned int i = 0; i < numFlds; i++) { - QString fldName(fields[i].name); - QString fldID( KexiUtils::string2Identifier(fldName) ); + TQString fldName(fields[i].name); + TQString fldID( KexiUtils::string2Identifier(fldName) ); KexiDB::Field *fld = new KexiDB::Field(fldID, type(originalName, &fields[i])); if(fld->type() == KexiDB::Field::Enum) { - QStringList values = examineEnumField(originalName, &fields[i]); + TQStringList values = examineEnumField(originalName, &fields[i]); } fld->setCaption(fldName); @@ -136,14 +136,14 @@ bool MySQLMigrate::drv_readTableSchema( /*! Get a list of tables and put into the supplied string list */ -bool MySQLMigrate::drv_tableNames(QStringList& tableNames) +bool MySQLMigrate::drv_tableNames(TQStringList& tableNames) { if(d->executeSQL("SHOW TABLES")) { MYSQL_RES *res = mysql_store_result(d->mysql); if (res != NULL) { MYSQL_ROW row; while ((row = mysql_fetch_row(res)) != NULL) { - tableNames << QString::fromUtf8(row[0]); //utf8.. ok? + tableNames << TQString::fromUtf8(row[0]); //utf8.. ok? } mysql_free_result(res); } else { @@ -160,7 +160,7 @@ bool MySQLMigrate::drv_tableNames(QStringList& tableNames) On success the result is stored in \a stringList and true is returned. \return cancelled if there are no records available. */ tristate MySQLMigrate::drv_queryStringListFromSQL( - const QString& sqlStatement, uint columnNumber, QStringList& stringList, int numRecords) + const TQString& sqlStatement, uint columnNumber, TQStringList& stringList, int numRecords) { stringList.clear(); if (d->executeSQL(sqlStatement)) { @@ -190,7 +190,7 @@ tristate MySQLMigrate::drv_queryStringListFromSQL( mysql_free_result(res); return false; } - stringList.append( QString::fromUtf8(row[columnNumber], lengths[columnNumber]) ); //ok? utf8? + stringList.append( TQString::fromUtf8(row[columnNumber], lengths[columnNumber]) ); //ok? utf8? } mysql_free_result(res); } else { @@ -204,7 +204,7 @@ tristate MySQLMigrate::drv_queryStringListFromSQL( /*! Fetches single record from result obtained by running \a sqlStatement. */ -tristate MySQLMigrate::drv_fetchRecordFromSQL(const QString& sqlStatement, +tristate MySQLMigrate::drv_fetchRecordFromSQL(const TQString& sqlStatement, KexiDB::RowData& data, bool &firstRecord) { if (firstRecord || !m_mysqlres) { @@ -235,12 +235,12 @@ tristate MySQLMigrate::drv_fetchRecordFromSQL(const QString& sqlStatement, } data.resize(numFields); for (int i=0; i < numFields; i++) - data[i] = QString::fromUtf8(row[i], lengths[i] ); //ok? utf8? + data[i] = TQString::fromUtf8(row[i], lengths[i] ); //ok? utf8? return true; } /*! Copy MySQL table to KexiDB database */ -bool MySQLMigrate::drv_copyTable(const QString& srcTable, KexiDB::Connection *destConn, +bool MySQLMigrate::drv_copyTable(const TQString& srcTable, KexiDB::Connection *destConn, KexiDB::TableSchema* dstTable) { if(d->executeSQL("SELECT * FROM `" + drv_escapeIdentifier(srcTable)) + "`") { @@ -249,8 +249,8 @@ bool MySQLMigrate::drv_copyTable(const QString& srcTable, KexiDB::Connection *de MYSQL_ROW row; const KexiDB::QueryColumnInfo::Vector fieldsExpanded( dstTable->query()->fieldsExpanded() ); while ((row = mysql_fetch_row(res)) != NULL) { - const int numFields = QMIN((int)fieldsExpanded.count(), (int)mysql_num_fields(res)); - QValueList<QVariant> vals; + const int numFields = TQMIN((int)fieldsExpanded.count(), (int)mysql_num_fields(res)); + TQValueList<TQVariant> vals; unsigned long *lengths = mysql_fetch_lengths(res); if (!lengths) { mysql_free_result(res); @@ -280,14 +280,14 @@ bool MySQLMigrate::drv_copyTable(const QString& srcTable, KexiDB::Connection *de } -bool MySQLMigrate::drv_getTableSize(const QString& table, Q_ULLONG& size) { +bool MySQLMigrate::drv_getTableSize(const TQString& table, TQ_ULLONG& size) { if(d->executeSQL("SELECT COUNT(*) FROM `" + drv_escapeIdentifier(table)) + "`") { MYSQL_RES *res = mysql_store_result(d->mysql); if (res != NULL) { MYSQL_ROW row; while ((row = mysql_fetch_row(res)) != NULL) { //! @todo check result valid - size = QString(row[0]).toULongLong(); + size = TQString(row[0]).toULongLong(); } mysql_free_result(res); } else { @@ -300,7 +300,7 @@ bool MySQLMigrate::drv_getTableSize(const QString& table, Q_ULLONG& size) { } //! Convert a MySQL type to a KexiDB type, prompting user if necessary. -KexiDB::Field::Type MySQLMigrate::type(const QString& table, +KexiDB::Field::Type MySQLMigrate::type(const TQString& table, const MYSQL_FIELD *fld) { // Field type @@ -391,12 +391,12 @@ KexiDB::Field::Type MySQLMigrate::type(const QString& table, Assumes fld is a CHAR, VARCHAR, one of the BLOBs or TEXTs. \return KexiDB::Field::Text, KexiDB::Field::LongText or KexiDB::Field::BLOB */ -KexiDB::Field::Type MySQLMigrate::examineBlobField(const QString& table, +KexiDB::Field::Type MySQLMigrate::examineBlobField(const TQString& table, const MYSQL_FIELD* fld) { - QString mysqlType; + TQString mysqlType; KexiDB::Field::Type kexiType; - QString query = "SHOW COLUMNS FROM `" + drv_escapeIdentifier(table) + - "` LIKE '" + QString::fromLatin1(fld->name) + "'"; + TQString query = "SHOW COLUMNS FROM `" + drv_escapeIdentifier(table) + + "` LIKE '" + TQString::tqfromLatin1(fld->name) + "'"; if(d->executeSQL(query)) { MYSQL_RES *res = mysql_store_result(d->mysql); @@ -404,7 +404,7 @@ KexiDB::Field::Type MySQLMigrate::examineBlobField(const QString& table, if (res != NULL) { MYSQL_ROW row; while ((row = mysql_fetch_row(res)) != NULL) { - mysqlType = QString(row[1]); + mysqlType = TQString(row[1]); } mysql_free_result(res); } else { @@ -417,10 +417,10 @@ KexiDB::Field::Type MySQLMigrate::examineBlobField(const QString& table, kdDebug() << "MySQLMigrate::examineBlobField: considering " << mysqlType << endl; - if(mysqlType.contains("blob", false) != 0) { + if(mysqlType.tqcontains("blob", false) != 0) { // Doesn't matter how big it is, it's binary kexiType = KexiDB::Field::BLOB; - } else if(mysqlType.contains("text", false) != 0) { + } else if(mysqlType.tqcontains("text", false) != 0) { // All the TEXT types are too big for Kexi text. kexiType = KexiDB::Field::BLOB; } else if(fld->length < 200) { @@ -440,11 +440,11 @@ KexiDB::Field::Type MySQLMigrate::examineBlobField(const QString& table, strings, "option1", "option2". \return list of possible values the field can take */ -QStringList MySQLMigrate::examineEnumField(const QString& table, +TQStringList MySQLMigrate::examineEnumField(const TQString& table, const MYSQL_FIELD* fld) { - QString vals; - QString query = "SHOW COLUMNS FROM `" + drv_escapeIdentifier(table) + - "` LIKE '" + QString::fromLatin1(fld->name) + "'"; + TQString vals; + TQString query = "SHOW COLUMNS FROM `" + drv_escapeIdentifier(table) + + "` LIKE '" + TQString::tqfromLatin1(fld->name) + "'"; if(d->executeSQL(query)) { MYSQL_RES *res = mysql_store_result(d->mysql); @@ -452,7 +452,7 @@ QStringList MySQLMigrate::examineEnumField(const QString& table, if (res != NULL) { MYSQL_ROW row; while ((row = mysql_fetch_row(res)) != NULL) { - vals = QString(row[1]); + vals = TQString(row[1]); } mysql_free_result(res); } else { @@ -460,7 +460,7 @@ QStringList MySQLMigrate::examineEnumField(const QString& table, } } else { // Huh? MySQL wont tell us what values it can take. - return QStringList(); + return TQStringList(); } kdDebug() << "MySQLMigrate::examineEnumField: considering " @@ -470,22 +470,22 @@ QStringList MySQLMigrate::examineEnumField(const QString& table, if(!vals.startsWith("enum(")) { // Huh? We're supposed to be parsing an enum! kdDebug() << "MySQLMigrate::examineEnumField:1 not an enum!" << endl; - return QStringList(); + return TQStringList(); } if(!vals.endsWith(")")) { kdDebug() << "MySQLMigrate::examineEnumField:2 not an enum!" << endl; - return QStringList(); + return TQStringList(); } - // It'd be nice to use QString.section or QStringList.split, but we need + // It'd be nice to use TQString.section or TQStringList.split, but we need // to be careful as enum values can have commas and quote marks in them // e.g. CREATE TABLE t(f enum('option,''') gives one option: "option,'" vals = vals.remove(0,5); - QRegExp rx = QRegExp("^'((?:[^,']|,|'')*)'"); - QStringList values = QStringList(); + TQRegExp rx = TQRegExp("^'((?:[^,']|,|'')*)'"); + TQStringList values = TQStringList(); int index = 0; - while ((index = rx.search(vals, index, QRegExp::CaretAtOffset)) != -1) { + while ((index = rx.search(vals, index, TQRegExp::CaretAtOffset)) != -1) { int len = rx.matchedLength(); if (len != -1) { kdDebug() << "MySQLMigrate::examineEnumField:3 " << rx.cap(1) << endl; @@ -494,8 +494,8 @@ QStringList MySQLMigrate::examineEnumField(const QString& table, kdDebug() << "MySQLMigrate::examineEnumField:4 lost" << endl; } - QChar next = vals[index + len]; - if (next != QChar(',') && next != QChar(')')) { + TQChar next = vals[index + len]; + if (next != TQChar(',') && next != TQChar(')')) { kdDebug() << "MySQLMigrate::examineEnumField:5 " << (char)next << endl; } index += len + 1; @@ -509,7 +509,7 @@ void MySQLMigrate::getConstraints(int flags, KexiDB::Field* fld) { fld->setPrimaryKey(flags & PRI_KEY_FLAG); fld->setAutoIncrement(flags & AUTO_INCREMENT_FLAG); fld->setNotNull(flags & NOT_NULL_FLAG); - fld->setUniqueKey(flags & UNIQUE_KEY_FLAG); + fld->setUniqueKey(flags & UNITQUE_KEY_FLAG); //! @todo: Keys and uniqueness } diff --git a/kexi/migration/mysql/mysqlmigrate.h b/kexi/migration/mysql/mysqlmigrate.h index 9f32bd2f..e7627e76 100644 --- a/kexi/migration/mysql/mysqlmigrate.h +++ b/kexi/migration/mysql/mysqlmigrate.h @@ -30,6 +30,7 @@ namespace KexiMigration class MySQLMigrate : public KexiMigrate { Q_OBJECT + TQ_OBJECT KEXIMIGRATION_DRIVER private: @@ -38,44 +39,44 @@ namespace KexiMigration protected: //Driver specific function to return table names - virtual bool drv_tableNames(QStringList& tablenames); + virtual bool drv_tableNames(TQStringList& tablenames); //Driver specific implementation to read a table schema virtual bool drv_readTableSchema( - const QString& originalName, KexiDB::TableSchema& tableSchema); + const TQString& originalName, KexiDB::TableSchema& tableSchema); //Driver specific connection implementation virtual bool drv_connect(); virtual bool drv_disconnect(); virtual tristate drv_queryStringListFromSQL( - const QString& sqlStatement, uint columnNumber, - QStringList& stringList, int numRecords = -1); + const TQString& sqlStatement, uint columnNumber, + TQStringList& stringList, int numRecords = -1); - virtual tristate drv_fetchRecordFromSQL(const QString& sqlStatement, + virtual tristate drv_fetchRecordFromSQL(const TQString& sqlStatement, KexiDB::RowData& data, bool &firstRecord); - virtual bool drv_copyTable(const QString& srcTable, + virtual bool drv_copyTable(const TQString& srcTable, KexiDB::Connection *destConn, KexiDB::TableSchema* dstTable); virtual bool drv_progressSupported() { return true; } - virtual bool drv_getTableSize(const QString& table, Q_ULLONG& size); + virtual bool drv_getTableSize(const TQString& table, TQ_ULLONG& size); //TODO: move this somewhere to low level class (MIGRATION?) -// virtual bool drv_getTablesList( QStringList &list ); +// virtual bool drv_getTablesList( TQStringList &list ); //TODO: move this somewhere to low level class (MIGRATION?) -// virtual bool drv_containsTable( const QString &tableName ); +// virtual bool drv_containsTable( const TQString &tableName ); public: // MySQLMigrate(); - MySQLMigrate(QObject *parent, const char *name, const QStringList& args = QStringList()); + MySQLMigrate(TQObject *tqparent, const char *name, const TQStringList& args = TQStringList()); ~MySQLMigrate(); - KexiDB::Field::Type type(const QString& table, const MYSQL_FIELD* t); + KexiDB::Field::Type type(const TQString& table, const MYSQL_FIELD* t); - KexiDB::Field::Type examineBlobField(const QString& table, + KexiDB::Field::Type examineBlobField(const TQString& table, const MYSQL_FIELD* fld); - QStringList examineEnumField(const QString& table, + TQStringList examineEnumField(const TQString& table, const MYSQL_FIELD* fld); void getConstraints(int mysqlConstraints, KexiDB::Field* fld); void getOptions(int flags, KexiDB::Field* fld); |