def migrate_setting(): try: cnx = mysql.connector.connect( host=self.host, user=self.username, password=self.password, database=self.database, ) cursor = cnx.cursor() query = "SELECT * FROM setting" cursor.execute(query) for (id, category, name, value, updatedby, updatedat) in cursor: u = Setting() u.id = id u.category = category u.name = name u.value = value u.updated_by = updatedby u.updated_on = updatedat db.session.add(u) db.session.commit() cursor.close() cnx.close() return "done" except Exception as e: return str(e), 500