SqlBrowser/SqlBrowserWidget.py

changeset 428
58405c24aa09
parent 13
1af94a91f439
child 500
c3abc7895a01
equal deleted inserted replaced
427:6af5d12cfecb 428:58405c24aa09
123 """ 123 """
124 err = QSqlError() 124 err = QSqlError()
125 125
126 self.__class__.cCount += 1 126 self.__class__.cCount += 1
127 db = QSqlDatabase.addDatabase(driver.upper(), 127 db = QSqlDatabase.addDatabase(driver.upper(),
128 "Browser%d" % self.__class__.cCount) 128 "Browser{0:d}".format(self.__class__.cCount))
129 db.setDatabaseName(dbName) 129 db.setDatabaseName(dbName)
130 db.setHostName(host) 130 db.setHostName(host)
131 db.setPort(port) 131 db.setPort(port)
132 if not db.open(user, password): 132 if not db.open(user, password):
133 err = db.lastError() 133 err = db.lastError()
134 db = QSqlDatabase() 134 db = QSqlDatabase()
135 QSqlDatabase.removeDatabase("Browser%d" % self.__class__.cCount) 135 QSqlDatabase.removeDatabase("Browser{0:d}".format(self.__class__.cCount))
136 136
137 self.connections.refresh() 137 self.connections.refresh()
138 138
139 return err 139 return err
140 140
201 model.setData(model.index(i, 0), fld.name()) 201 model.setData(model.index(i, 0), fld.name())
202 if fld.typeID() == -1: 202 if fld.typeID() == -1:
203 model.setData(model.index(i, 1), 203 model.setData(model.index(i, 1),
204 QVariant.typeToName(fld.type())) 204 QVariant.typeToName(fld.type()))
205 else: 205 else:
206 model.setData(model.index(i, 1), "%s1 (%s)" % (\ 206 model.setData(model.index(i, 1), "{0} ({1})".format(
207 QVariant.typeToName(fld.type()), 207 QVariant.typeToName(fld.type()),
208 fld.typeID())) 208 fld.typeID()))
209 if fld.length() < 0: 209 if fld.length() < 0:
210 model.setData(model.index(i, 2), "?") 210 model.setData(model.index(i, 2), "?")
211 else: 211 else:

eric ide

mercurial