Create an information table for saving pictures

#  Initialize database 
db = QtSql.QSqlDatabase.addDatabase('QSQLITE')
db.setDatabaseName('user.db')
db.open()
query = QSqlQuery()
#  Create picture information table 
if not query.exec_("create table img(id integer primary key autoincrement,userName TEXT, imgName TEXT,time TEXT,place TEXT,author TEXT,imgType TEXT,imgDesc TEXT,image blob)"):
    print( query.lastError().text())
else:
    print(' Create success ')

take opencv The picture is converted to binary sqllite

#  Judge whether it exists 
 sql_code = "select * from img where imgName='{}'".format(imgName)
 query.exec_(sql_code)
 if query.next():
     QMessageBox.information(self, " Tips ", " The picture already exists ！", QMessageBox.Yes)
     return 0
 #  Convert picture to byte stream 
 success, encoded_image = cv2.imencode('.png', self.img)
 content = encoded_image.tobytes()
 #  Insert data into the database 
 query.prepare("insert into img (userName,imgName,time,place,author,imgType,imgDesc,image) values(?,?,?,?,?,?,?,?)")
 query.addBindValue(self.username)
 query.addBindValue(imgName)
 query.addBindValue(time)
 query.addBindValue(place)
 query.addBindValue(author)
 query.addBindValue(imgType)
 query.addBindValue(imgDesc)
 query.addBindValue(content)
 #  Save the data 
 if not query.exec():
     QMessageBox.warning(self, ' Submit failed ', ' Please make sure it does not contain special characters ！'+query.lastError().text(), QMessageBox.Ok)
     return
 QMessageBox.information(self, " Tips ", " Upload successful ！", QMessageBox.Yes)

Query the image

sql_code = 'select image from img where userName=="%{}%" and (imgName like "%{}%" or time like "%{}%" or place like "%{}%" or imgDesc like "%{}%" or author like "%{}%" or imgType like "%{}%")'.format(self.username,keyword,keyword,keyword,keyword,keyword,keyword)
query.exec_(sql_code)
while query.next():
     #  Loading pictures 
     img = np.frombuffer(query.value(0).tobytes())