diff options
Diffstat (limited to 'kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py')
| -rw-r--r-- | kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py | 180 |
1 files changed, 90 insertions, 90 deletions
diff --git a/kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py b/kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py index 985d757d..40d1a317 100644 --- a/kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py +++ b/kexi/plugins/scripting/scripts/copycenter/CopyCenterPluginQtSQL.py @@ -1,5 +1,5 @@ """ -CopyCenterPlugin to provide 'QtSQL'. +CopyCenterPlugin to provide 'TQtSQL'. Description: This python-script is a plugin for the CopyCenter.py. @@ -12,12 +12,12 @@ GPL v2 or higher. """ class CopyCenterPlugin: - """ The CopyCenterPlugin to provide 'QtSQL' to CopyCenter.py """ + """ The CopyCenterPlugin to provide 'TQtSQL' to CopyCenter.py """ - name = "QtSQL Database" + name = "TQtSQL Database" """ The name this plugin has. The name should be unique and will be used for displaying a caption. """ - + class Plugin: def _init_(self,copycenterplugin): self.copycenterplugin = copycenterplugin @@ -52,7 +52,7 @@ class CopyCenterPlugin: 'port': 3306, 'username': 'root', #'MyUsername', 'password': '', #'MySecretPassword', - 'database': '', #'MyQtSQLDatabase', + 'database': '', #'MyTQtSQLDatabase', 'table': '', #'table1', 'fields': '', #'f1,f2', 'where': '', @@ -61,9 +61,9 @@ class CopyCenterPlugin: self._init(copierer) tablename = str(self.widget.tableedit.text()) wherestatement = str(self.widget.whereedit.text()) - import qt - import qtsql - self.cursor = qtsql.QSqlCursor(tablename,True,self.database) + from TQt import qt + from TQt import qtsql + self.cursor = qtsql.TQSqlCursor(tablename,True,self.database) self.cursor.setFilter(wherestatement) if not self.cursor.select(): raise "Select on cursor failed.<br>%s<br>%s" % ( str(self.cursor.lastError().driverText()),str(self.cursor.lastError().databaseText()) ) @@ -98,7 +98,7 @@ class CopyCenterPlugin: 'port': 3306, 'username': 'root', #'MyUsername', 'password': '', #'MySecretPassword', - 'database': '', #'MyQtSQLDatabase', + 'database': '', #'MyTQtSQLDatabase', 'table': '', #'table2', 'fields': '', #'field1,field2', 'operation': 'Insert', #'Insert','Update'... @@ -106,8 +106,8 @@ class CopyCenterPlugin: } def init(self,copierer): self._init(copierer) - import qt - import qtsql + from TQt import qt + from TQt import qtsql self.fieldlist = [] for fieldname in str(self.widget.fieldedit.text()).split(","): @@ -115,7 +115,7 @@ class CopyCenterPlugin: if fn != "": self.fieldlist.append(fn) tablename = str(self.widget.tableedit.text()) - self.cursor = qtsql.QSqlCursor(tablename,True,self.database) + self.cursor = qtsql.TQSqlCursor(tablename,True,self.database) { 0: self.initInsert, 1: self.initUpdate @@ -132,16 +132,16 @@ class CopyCenterPlugin: def writeInsert(self, record): print "insert record: %s" % record - import qt + from TQt import qt cursorrecord = self.cursor.primeInsert() count = len(record) for i in range(len(self.fieldlist)): if i == count: break r = record[i] if r == None: - v = qt.QVariant() + v = qt.TQVariant() else: - v = qt.QVariant(r) + v = qt.TQVariant(r) cursorrecord.setValue(self.fieldlist[i], v) rowcount = self.cursor.insert() if rowcount < 1: @@ -162,11 +162,11 @@ class CopyCenterPlugin: pkindex = self.cursor.index(self.indexfieldname) if not pkindex: raise "Invalid index-field defined." self.cursor.setPrimaryIndex(pkindex) - #self.cursor.setMode( qtsql.QSqlCursor.Insert | qtsql.QSqlCursor.Update ) + #self.cursor.setMode( qtsql.TQSqlCursor.Insert | qtsql.TQSqlCursor.Update ) self.copierer.appendProgressMessage("Update SQL: %s" % str(self.cursor.executedQuery())) def writeUpdate(self, record): - import qt + from TQt import qt # determinate the primary-index try: idx = self.fieldlist.index(self.indexfieldname) @@ -192,9 +192,9 @@ class CopyCenterPlugin: if self.indexfieldname != fieldname: # don't update the indexfield! r = record[i] if r == None: - v = qt.QVariant() + v = qt.TQVariant() else: - v = qt.QVariant(r) + v = qt.TQVariant(r) cursorrecord.setValue(fieldname, v) # Write updated record. rowcount = self.cursor.update() @@ -210,11 +210,11 @@ class CopyCenterPlugin: pass def widget(self,dialog,plugin,parent): - """ Each plugin may provide a qt.QWidget back to the + """ Each plugin may provide a qt.TQWidget back to the CopyCenter.py. The widget will be used to configure our plugin settings. """ - import qt + from TQt import qt import os self.dialog = dialog @@ -228,14 +228,14 @@ class CopyCenterPlugin: item = None for table in self.mainwidget.plugin.database.tables(): if item == None: - item = qt.QListViewItem(self.listview,table) + item = qt.TQListViewItem(self.listview,table) else: - item = qt.QListViewItem(self.listview,item,table) + item = qt.TQListViewItem(self.listview,item,table) if table == text: self.listview.setSelected(item,True) self.listview.ensureItemVisible(item) - qt.QObject.connect(self.listview, qt.SIGNAL("doubleClicked(QListViewItem*, const QPoint&, int)"), self.okClicked) - qt.QObject.connect(self.okbtn, qt.SIGNAL("clicked()"), self.okClicked) + qt.TQObject.connect(self.listview, qt.SIGNAL("doubleClicked(QListViewItem*, const QPoint&, int)"), self.okClicked) + qt.TQObject.connect(self.okbtn, qt.SIGNAL("clicked()"), self.okClicked) def okClicked(self): item = self.listview.selectedItem() if item == None: @@ -248,7 +248,7 @@ class CopyCenterPlugin: def __init__(self, mainwidget): ListViewDialog.__init__(self,parent,"Fields") self.mainwidget = mainwidget - self.listview.setSelectionMode(qt.QListView.Multi) + self.listview.setSelectionMode(qt.TQListView.Multi) self.listview.setSorting(-1) self.listview.header().setClickEnabled(False) self.listview.addColumn("Name") @@ -264,10 +264,10 @@ class CopyCenterPlugin: opts = "" for s in ('Required','Calculated'): #,'Generated'): if getattr(fieldinfo,"is%s" % s)(): opts += "%s " % s - item = self.addItem((fieldinfo.name(), qt.QVariant.typeToName(fieldinfo.type()), opts),item) + item = self.addItem((fieldinfo.name(), qt.TQVariant.typeToName(fieldinfo.type()), opts),item) if allfields or fieldinfo.name() in fieldslist: self.listview.setSelected(item,True) - qt.QObject.connect(self.okbtn, qt.SIGNAL("clicked()"), self.okClicked) + qt.TQObject.connect(self.okbtn, qt.SIGNAL("clicked()"), self.okClicked) def okClicked(self): selitems = [] item = self.listview.firstChild() @@ -279,101 +279,101 @@ class CopyCenterPlugin: self.close() - class MainWidget(qt.QHBox): + class MainWidget(qt.TQHBox): def __init__(self,plugin,dialog,parent): - import qt - import qtsql - qt.QHBox.__init__(self,parent) + from TQt import qt + from TQt import qtsql + qt.TQHBox.__init__(self,parent) self.dialog = dialog self.plugin = plugin - self.connectionbox = qt.QVBox(parent) + self.connectionbox = qt.TQVBox(parent) self.connectionbox.setSpacing(2) - driverbox = qt.QHBox(self.connectionbox) - driverlabel = qt.QLabel("Driver:",driverbox) - self.driveredit = qt.QComboBox(driverbox) - for driver in qtsql.QSqlDatabase.drivers(): + driverbox = qt.TQHBox(self.connectionbox) + driverlabel = qt.TQLabel("Driver:",driverbox) + self.driveredit = qt.TQComboBox(driverbox) + for driver in qtsql.TQSqlDatabase.drivers(): self.driveredit.insertItem(driver) if self.plugin.options['driver'] == driver: self.driveredit.setCurrentItem(self.driveredit.count() - 1) driverlabel.setBuddy(self.driveredit) driverbox.setStretchFactor(self.driveredit,1) - hostbox = qt.QHBox(self.connectionbox) - hostlabel = qt.QLabel("Hostname:",hostbox) - self.hostedit = qt.QLineEdit(self.plugin.options['hostname'],hostbox) + hostbox = qt.TQHBox(self.connectionbox) + hostlabel = qt.TQLabel("Hostname:",hostbox) + self.hostedit = qt.TQLineEdit(self.plugin.options['hostname'],hostbox) hostlabel.setBuddy(self.hostedit) hostbox.setStretchFactor(self.hostedit,1) - - portbox = qt.QHBox(self.connectionbox) - portlabel = qt.QLabel("Port:",portbox) - self.portedit = qt.QLineEdit(str(self.plugin.options['port']),portbox) + + portbox = qt.TQHBox(self.connectionbox) + portlabel = qt.TQLabel("Port:",portbox) + self.portedit = qt.TQLineEdit(str(self.plugin.options['port']),portbox) portlabel.setBuddy(self.portedit) portbox.setStretchFactor(self.portedit,1) - userbox = qt.QHBox(self.connectionbox) - userlabel = qt.QLabel("Username:",userbox) - self.useredit = qt.QLineEdit(self.plugin.options['username'],userbox) + userbox = qt.TQHBox(self.connectionbox) + userlabel = qt.TQLabel("Username:",userbox) + self.useredit = qt.TQLineEdit(self.plugin.options['username'],userbox) userlabel.setBuddy(self.useredit) userbox.setStretchFactor(self.useredit,1) - - passbox = qt.QHBox(self.connectionbox) - passlabel = qt.QLabel("Password:",passbox) - self.passedit = qt.QLineEdit(self.plugin.options['password'],passbox) - self.passedit.setEchoMode(qt.QLineEdit.Password) + + passbox = qt.TQHBox(self.connectionbox) + passlabel = qt.TQLabel("Password:",passbox) + self.passedit = qt.TQLineEdit(self.plugin.options['password'],passbox) + self.passedit.setEchoMode(qt.TQLineEdit.Password) passlabel.setBuddy(self.passedit) passbox.setStretchFactor(self.passedit,1) - dbbox = qt.QHBox(self.connectionbox) - dblabel = qt.QLabel("Database:",dbbox) - self.dbedit = qt.QLineEdit(self.plugin.options['database'],dbbox) + dbbox = qt.TQHBox(self.connectionbox) + dblabel = qt.TQLabel("Database:",dbbox) + self.dbedit = qt.TQLineEdit(self.plugin.options['database'],dbbox) dblabel.setBuddy(self.dbedit) dbbox.setStretchFactor(self.dbedit,1) - - statusbar = qt.QHBox(parent) + + statusbar = qt.TQHBox(parent) statusbar.setSpacing(2) - statusbar.setStretchFactor(qt.QWidget(statusbar),1) - self.connectbtn = qt.QPushButton("Connect",statusbar) - qt.QObject.connect(self.connectbtn, qt.SIGNAL("clicked()"),self.connectClicked) - self.disconnectbtn = qt.QPushButton("Disconnect",statusbar) + statusbar.setStretchFactor(qt.TQWidget(statusbar),1) + self.connectbtn = qt.TQPushButton("Connect",statusbar) + qt.TQObject.connect(self.connectbtn, qt.SIGNAL("clicked()"),self.connectClicked) + self.disconnectbtn = qt.TQPushButton("Disconnect",statusbar) self.disconnectbtn.setEnabled(False) - qt.QObject.connect(self.disconnectbtn, qt.SIGNAL("clicked()"),self.disconnectClicked) + qt.TQObject.connect(self.disconnectbtn, qt.SIGNAL("clicked()"),self.disconnectClicked) - tablebox = qt.QHBox(parent) - tablelabel = qt.QLabel("Table:",tablebox) - self.tableedit = qt.QLineEdit(self.plugin.options['table'],tablebox) - qt.QObject.connect(self.tableedit, qt.SIGNAL("textChanged(const QString&)"), self.tableEditChanged) - self.tablebtn = qt.QPushButton("...",tablebox) + tablebox = qt.TQHBox(parent) + tablelabel = qt.TQLabel("Table:",tablebox) + self.tableedit = qt.TQLineEdit(self.plugin.options['table'],tablebox) + qt.TQObject.connect(self.tableedit, qt.SIGNAL("textChanged(const QString&)"), self.tableEditChanged) + self.tablebtn = qt.TQPushButton("...",tablebox) self.tablebtn.setEnabled(False) - qt.QObject.connect(self.tablebtn, qt.SIGNAL("clicked()"), self.tableBtnClicked) + qt.TQObject.connect(self.tablebtn, qt.SIGNAL("clicked()"), self.tableBtnClicked) tablelabel.setBuddy(self.tableedit) tablebox.setStretchFactor(self.tableedit,1) - fieldbox = qt.QHBox(parent) - fieldlabel = qt.QLabel("Fields:",fieldbox) - self.fieldedit = qt.QLineEdit(self.plugin.options['fields'],fieldbox) - self.fieldbtn = qt.QPushButton("...",fieldbox) + fieldbox = qt.TQHBox(parent) + fieldlabel = qt.TQLabel("Fields:",fieldbox) + self.fieldedit = qt.TQLineEdit(self.plugin.options['fields'],fieldbox) + self.fieldbtn = qt.TQPushButton("...",fieldbox) self.fieldbtn.setEnabled(False) - qt.QObject.connect(self.fieldbtn, qt.SIGNAL("clicked()"), self.fieldBtnClicked) + qt.TQObject.connect(self.fieldbtn, qt.SIGNAL("clicked()"), self.fieldBtnClicked) fieldlabel.setBuddy(self.fieldedit) fieldbox.setStretchFactor(self.fieldedit,1) if self.plugin.plugintype == "Source": - box = qt.QHBox(parent) - wherelabel = qt.QLabel("Where:",box) - self.whereedit = qt.QLineEdit(self.plugin.options['where'],box) + box = qt.TQHBox(parent) + wherelabel = qt.TQLabel("Where:",box) + self.whereedit = qt.TQLineEdit(self.plugin.options['where'],box) wherelabel.setBuddy(self.whereedit) box.setStretchFactor(self.whereedit,1) elif self.plugin.plugintype == "Destination": - - class OperationBox(qt.QVBox): + + class OperationBox(qt.TQVBox): def __init__(self, mainwidget, parent): self.mainwidget = mainwidget - qt.QVBox.__init__(self, parent) - opbox = qt.QHBox(self) - operationlabel = qt.QLabel("Operation:",opbox) - self.mainwidget.operationedit = qt.QComboBox(opbox) + qt.TQVBox.__init__(self, parent) + opbox = qt.TQHBox(self) + operationlabel = qt.TQLabel("Operation:",opbox) + self.mainwidget.operationedit = qt.TQComboBox(opbox) for op in ('Insert','Update'): self.mainwidget.operationedit.insertItem(op) if self.mainwidget.plugin.options['operation'] == op: @@ -381,7 +381,7 @@ class CopyCenterPlugin: operationlabel.setBuddy(self.mainwidget.operationedit) opbox.setStretchFactor(self.mainwidget.operationedit,1) self.box = None - qt.QObject.connect(self.mainwidget.operationedit, qt.SIGNAL("activated(int)"), self.operationActivated) + qt.TQObject.connect(self.mainwidget.operationedit, qt.SIGNAL("activated(int)"), self.operationActivated) self.operationActivated() def operationActivated(self, **args): if self.box: @@ -391,9 +391,9 @@ class CopyCenterPlugin: def showInsert(self): pass def showUpdate(self): - self.box = qt.QHBox(self) - indexlabel = qt.QLabel("Indexfield:", self.box) - self.mainwidget.indexedit = qt.QLineEdit(self.mainwidget.plugin.options['indexfield'], self.box) + self.box = qt.TQHBox(self) + indexlabel = qt.TQLabel("Indexfield:", self.box) + self.mainwidget.indexedit = qt.TQLineEdit(self.mainwidget.plugin.options['indexfield'], self.box) indexlabel.setBuddy(self.mainwidget.indexedit) self.box.setStretchFactor(self.mainwidget.indexedit,1) { @@ -451,14 +451,14 @@ class CopyCenterPlugin: return True print "trying to connect..." - import qtsql + from TQt import qtsql drivername = str(self.driveredit.currentText()) print "drivername: %s" % drivername connectionname = "CopyCenter%s" % self.plugin.plugintype print "connectionname: %s" % connectionname - self.plugin.database = qtsql.QSqlDatabase.addDatabase(drivername,connectionname) + self.plugin.database = qtsql.TQSqlDatabase.addDatabase(drivername,connectionname) if not self.plugin.database: - qt.QMessageBox.critical(self,"Failed to connect","<qt>Failed to create database for driver \"%s\"</qt>" % drivername) + qt.TQMessageBox.critical(self,"Failed to connect","<qt>Failed to create database for driver \"%s\"</qt>" % drivername) return False hostname = str(self.hostedit.text()) @@ -477,7 +477,7 @@ class CopyCenterPlugin: self.plugin.database.setDatabaseName(databasename) if not self.plugin.database.open(): - qt.QMessageBox.critical(self,"Failed to connect","<qt>%s<br><br>%s</qt>" % (self.plugin.database.lastError().driverText(),self.plugin.database.lastError().databaseText())) + qt.TQMessageBox.critical(self,"Failed to connect","<qt>%s<br><br>%s</qt>" % (self.plugin.database.lastError().driverText(),self.plugin.database.lastError().databaseText())) return False print "database is opened now!" self.updateConnectState() |