def insert_or_update_resource(RE_id: int, ST_id: int, MR_id: int, resource_data: resource.Resource): resource_data = str(json.dumps(resource_data.dict())) select_Query = "select from create_or_update_resources(%s,%s,%s,%s);" data = ( RE_id, ST_id, MR_id, resource_data, ) res = Connect_TO_DB(select_Query, data) return {}
def insert_or_update_resource(RE_id: int, ST_id: int, MR_id: int, resource_data: resource.Resource): con = psycopg2.connect(dbname=DB_name, user=DB_user, password=DB_pass, host=DB_Host) cur = con.cursor() resource_data = str(json.dumps(resource_data.dict())) cur.execute( 'show search_path; set search_path to casa_della_energia ;select from create_or_update_resources(%s,%s,%s,%s);', (RE_id, ST_id, MR_id, resource_data)) res = cur.fetchall() con.commit() cur.close() print(res) if con is not None: con.close() return {}