Python-сообщество

def createConnection():
    bdname = returnBd()
    db = QtSql.QSqlDatabase.addDatabase('QSQLITE')
    db.setDatabaseName(bdname)
    if not db.open():
       print('BD не подключена')
       return False
    #db.close()
    return True

def selSettings(self):
            sql = 'SELECT * FROM settings'
            res=[]
            query = QtSql.QSqlQuery(sql)
            query.executedQuery()
            while query.next():
              res = ([[query.value(0), query.value(1), query.value(2), query.value(3), query.value(4), query.value(5), query.value(6)]])
            return res

def upSettings(self):
            sql = 'UPDATE settings SET value = ? WHERE id = 1'
            query = QtSql.QSqlQuery()
            query.prepare(sql)
            query.addBindValue(self.value.text())
            query.executedQuery()