Обновление данных в таблице

 
def choose_picture_dialog_open(self):
    fname = QFileDialog.getOpenFileName(self,
                                        'Choose picture',
                                        './')
    pict_path = fname[0]
    pixmap = QtGui.QPixmap(fname[0])
    pixmap_resize = pixmap.scaled(380, 110, 149, 123)
    self.avatar.setPixmap(pixmap_resize)
    self.pict_import(User_ID, pict_path)
def pict_import(self, User_ID, pict_path):
    binary_pict = self.import_pict_binary(pict_path)
    # DBfunctions.update_record('user', 'Image', binary_pict, 'User_ID', User_ID)
    con = sqlite3.connect('./Data_base/DataBase.db')
    cur = con.cursor()
    data = (6789, 'rty', 'rty', binary_pict)
    query = 'UPDATE user SET Image ='+str(binary_pict)+' WHERE User_ID = 7827'
    cur.execute(query)
    con.commit()
    cur.close()
    con.close()
def import_pict_binary(self, pict_path):
    f = open(pict_path, 'rb')
    pict_binary = f.read()
    return pict_binary

def pict_import(self, User_ID, pict_path):
    binary_pict = self.import_pict_binary(pict_path)
    # DBfunctions.update_record('user', 'Image', binary_pict, 'User_ID', User_ID)
    con = sqlite3.connect('./Data_base/DataBase.db')
    cur = con.cursor()
    data = (6789, 'rty', 'rty', binary_pict)
    query = 'INSERT INTO user VALUES(?, ?, ?, ?)'
    cur.execute(query, data)
    con.commit()
    cur.close()
    con.close()

def update_record(table, param_column, param_val, id_column, record_id):
    con = sqlite3.connect('./Data_base/DataBase.db')
    cur = con.cursor()
    query = 'UPDATE '+table+' SET '+param_column+' = '+str(param_val)+' WHERE '+id_column+" = '"+str(record_id)+"'"
    print(query)
    cur.execute(query)
    con.commit()
    cur.close()
    con.close()