示例#1
0
 def __init__(self, name, parent=None):
     settings = SettingsParser()
     # avoid overwriting connections that ain't finished yet
     while QSqlDatabase.contains(name):
         if name[-1].isdigit():
             name = name[0:-1] + str( int(name[-1]) + 1 )
         else:
             name = name + str(2)
     self._db = QSqlDatabase.addDatabase("QPSQL", name)
     self._db.setHostName(settings.get_value("Database", "hostname"))
     self._db.setDatabaseName("seareiros_bd")
     self._db.setUserName("seareiros")
     self._db.setPassword("localadm")
示例#2
0
文件: model.py 项目: lcolman/Litey
	def _sql_version(self):
		'''internal init function to check version of SQLite driver in-use by QtSql module'''
		con='LiteyVersionCheck'
		db = QSqlDatabase.addDatabase("QSQLITE",con)
		db.setDatabaseName(':memory:')
		db.open()
		ver=db.exec_('select sqlite_version()')
		assert ver.next()
		result=str(ver.value(0))
		ver.finish()
		del ver
		db.close()
		del db
		QSqlDatabase.removeDatabase(con)
		return result
示例#3
0
 def __init__(self, database_name):
     self.database_name = database_name
     self.db = QSqlDatabase.addDatabase('QSQLITE')
     self.db.setDatabaseName(self.database_name)
     if self.open():
         if not 'employee' in self.db.tables():
             create_tables()
示例#4
0
 def __init__(self, parent=None):
     super(MainWindow, self).__init__(parent)
     database = QSqlDatabase.addDatabase('QSQLITE')
     database.setDatabaseName('astatsscraper.db') # Better lookup logic needed
     if not database.open():
         print('Error opening database!')
     model = QSqlTableModel(db=database)
     model.setTable('steam_apps')
     table = QTableView()
     table.setEditTriggers(QAbstractItemView.NoEditTriggers)
     table.setModel(model)
     self.setCentralWidget(table)
     table.show()
示例#5
0
 def __init__(self, parent=None):
     super(MainWindow, self).__init__(parent)
     database = QSqlDatabase.addDatabase('QSQLITE')
     database.setDatabaseName(
         'astatsscraper.db')  # Better lookup logic needed
     if not database.open():
         print('Error opening database!')
     model = QSqlTableModel(db=database)
     model.setTable('steam_apps')
     table = QTableView()
     table.setEditTriggers(QAbstractItemView.NoEditTriggers)
     table.setModel(model)
     self.setCentralWidget(table)
     table.show()
示例#6
0
文件: main.py 项目: jlehtoma/MaeBird
 def load_db(self, dbname, modelname=None):
     self.db = QSqlDatabase.addDatabase(self.dbtype)
     self.db.setDatabaseName(dbname)
     if not self.db.open():
         QMessageBox.warning(self, "Batabase connection",
             "Database Error: %s" % (self.db.lastError().text()))
         return
     self.dbfile = dbname
     
     if modelname not in self.models.model_names:
         modeldlg = ModelDialog(self.models.model_names)
         if modeldlg.exec_():
             modelname = modeldlg.selected_model()
     
     if modelname:
         self.load_model(modelname)
示例#7
0
    def InitTable(self):
        """Funzione che accede al database ed imposta il data model"""
        db = QSqlDatabase.addDatabase("QSQLITE")

        db.setDatabaseName(self.myWidget.txtPercorso.text())
        db.open()

        model = QSqlTableModel()
        model.setTable("contatti")
        model.setEditStrategy(QSqlTableModel.OnManualSubmit)
        model.select()
        model.setHeaderData(0, QtCore.Qt.Horizontal, "Nome")
        model.setHeaderData(1, QtCore.Qt.Horizontal, "Cognome")
        model.setHeaderData(2, QtCore.Qt.Horizontal, "Telefono")

        self.tableModel = model
        self.myWidget.lstRubrica.setModel(model)
示例#8
0
    def InitTable(self):
        """Funzione che accede al database ed imposta il data model"""
        db = QSqlDatabase.addDatabase("QSQLITE")

        db.setDatabaseName(self.myWidget.txtPercorso.text())
        db.open()
        
        model =  QSqlTableModel()
        model.setTable("contatti")
        model.setEditStrategy(QSqlTableModel.OnManualSubmit)
        model.select()
        model.setHeaderData(0, QtCore.Qt.Horizontal, "Nome")
        model.setHeaderData(1, QtCore.Qt.Horizontal, "Cognome")
        model.setHeaderData(2, QtCore.Qt.Horizontal, "Telefono")
                
        self.tableModel = model
        self.myWidget.lstRubrica.setModel(model)
示例#9
0
def dbConnect():
    db = QSqlDatabase.addDatabase("QSQLITE")
    filename = "pythonthusiast.db"
    database =  QFile(filename)
    if not database.exists():
        qDebug("Database not found. Creating and opening")
        db.setDatabaseName(filename)
        db.open()
        query = QSqlQuery()
        query.exec_("create table qtapp_users "
                    "(id integer primary key autoincrement, "
                    "username varchar(30), "
                    "password varchar(255))")
        query.prepare("insert into qtapp_users(username, password) values(:username, :password)")
        query.bindValue(":username", "eko")
        query.bindValue(":password", computeHash("password"))
        query.exec_()
    else:
        qDebug("Database found. Opening")
        db.setDatabaseName(filename)
        db.open()
    return db.isOpen()
示例#10
0
        self.__conf["mainWindowGeometry"] = self.saveGeometry()
        self.__conf["mainWindowState"] = self.saveState()


if __name__ == "__main__":
    ret = 0
    log = QFile("log")
    log.open(QIODevice.WriteOnly)
    try:
        app = QApplication(sys.argv)

        locale = QLocale.system().name()
        translator = QTranslator()
        translator.load("qt_" + locale,
            QLibraryInfo.location(QLibraryInfo.TranslationsPath))
        app.installTranslator(translator)

        # Configuration de la base de données
        db = QSqlDatabase.addDatabase("QSQLITE")
        db.setDatabaseName('private/gem.db')
        db.open()

        # Création de l'_ui principale et boucle principale
        ui = GestionAbsences()
        ui.show()
        ret = app.exec_()
    except Exception:
        traceback.print_exc(file=log)
        log.close()
    sys.exit(ret)
示例#11
0
            self.sentSignal.emit(MailSender.MAIL_ERROR_TIMEOUT)
        except Exception, e:
            print e
            self.sentSignal.emit(MailSender.MAIL_ERROR_OTHER)


if __name__ == "__main__":
    """Main de test"""
    import sys
    from PySide.QtGui import QApplication
    from PySide.QtCore import QLibraryInfo, QLocale, QTranslator
    from PySide.QtSql import QSqlDatabase

    app = QApplication(sys.argv)

    locale = QLocale.system().name()
    translator = QTranslator()
    translator.load("qt_" + locale,
                    QLibraryInfo.location(QLibraryInfo.TranslationsPath))
    app.installTranslator(translator)

    # Configuration de la base de données
    db = QSqlDatabase.addDatabase("QSQLITE")
    db.setDatabaseName('private/gem.db')
    db.open()

    ui = MailUI()
    ui.show()
    ret = app.exec_()
    sys.exit(ret)
示例#12
0
 def cleanup(self, conn_name):
     """ may not be the same connection name as appointed by 'name' argument
     See Worker class '__init__' method bellow """
     QSqlDatabase.removeDatabase(conn_name)
示例#13
0
文件: model.py 项目: lcolman/Litey
	def connect(self,fi):
		'''Database connection method'''
		self.db = QSqlDatabase.addDatabase("QSQLITE")
		self.db.setDatabaseName(fi)
		assert self.db.open()
		self.rehash(LiteyModel.ModelArea.ALL)