def createConnection():
db = QSqlDatabase.addDatabase('QSQLITE')
db.setDatabaseName('memory')
if not db.open():
QMessageBox.critical(
None, qApp.tr("Cannot open database"),
qApp.tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information "
"how to build it.\n\n"
"Click Cancel to exit."), QMessageBox.Cancel)
return False
query = QSqlQuery()
query.exec_("create table person(id int primary key, "
"firstname varchar(20), lastname varchar(20),"
"archive BOOLEAN NOT NULL CHECK (archive IN (0,1)))")
query.exec_("insert into person values(101, 'Danny', 'Young', 1)")
query.exec_("insert into person values(102, 'Christine', 'Holand', 0)")
query.exec_("insert into person values(103, 'Lars', 'Gordon', 1)")
query.exec_("insert into person values(104, 'Roberto', 'Robitaille', 0)")
query.exec_("insert into person values(105, 'Maria', 'Papadopoulos', 1)")
query.exec_("insert into person values(106, 'Luisa', 'Papadopoulos', 1)")
query.exec_("insert into person values(107, 'Luis', 'Papadopoulos', 1)")
return True
def set_databaseconnection():
'''
Setting connection with SQLite
'''
filepath = os.path.join(os.path.dirname(__file__), '..', '..', '..',
'ResourceFiles', 'Database', 'Intg_osdag.sqlite')
# filepath = "D:\EclipseWorkspace\OsdagWorkshop\Database\CleatSections"
# db = QSqlDatabase.database("QSQLITE")
# if db.IsValid():
# return True
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(filepath)
# db.open()
if not db.open():
QMessageBox.critical(
None, qApp.tr("Cannot open database"),
qApp.tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information "
"how to build it.\n\n"
"Click Cancel to exit."), QMessageBox.Cancel)
return False
def createConnection():
db = QSqlDatabase.addDatabase('QSQLITE')
db.setDatabaseName('task')
if not db.open():
QMessageBox.critical(
None, qApp.tr("Cannot open database"),
qApp.tr("Unable to establish a database connection."),
QMessageBox.Cancel)
return False
return True
def set_databaseconnection():
'''
Setting connection with SQLite
'''
# TODO explicitly close database connection on exit
filepath = os.path.join(os.path.dirname(__file__), '..', '..', '..', 'ResourceFiles', 'Database', 'Intg_osdag.sqlite')
db = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName(filepath)
if not db.open():
QMessageBox.critical(None, qApp.tr("Cannot open database"),
qApp.tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information "
"how to build it.\n\n"
"Click Cancel to exit."),
QMessageBox.Cancel)
return False
def add(self, result: str, nbr_predicted: int):
if result in self.results_cache:
pass
else:
db: QSqlDatabase = QSqlDatabase.addDatabase("QSQLITE")
db.setDatabaseName('demo.db')
if not db.open():
QMessageBox.critical(None, qApp.tr("无法打开数据库"),
qApp.tr('无法连接数据库'), QMessageBox.Cancel)
logging.info('数据库连接失败....', hasError=True)
else:
logging.info('数据库已连接.....')
query = QtSql.QSqlQuery()
query.exec_(
"update user_face_info set punched=1 where user_id={}".format(
nbr_predicted))
self.results_cache.append(result)
result = "{0} 打卡成功!".format(result)
self.punch_signal.emit(result)