def select_query(query, params): try: con = DBconnect.connect() cursor = con.cursor() cursor.execute(query, params) result = cursor.fetchall() cursor.close() con.close() except db.Error as e: raise Exception(e.message) return result
def update_query(query, params): try: con = DBconnect.connect() cursor = con.cursor() cursor.execute(query, params) con.commit() inserted_id = cursor.lastrowid cursor.close() con.close() except db.Error as e: raise Exception(e.message) return inserted_id