public void upsertAccessLevel(DSLContext tx, UUID inventoryId, UUID teamId, ResourceAccessLevel level) { tx.insertInto(INVENTORY_TEAM_ACCESS) .columns(INVENTORY_TEAM_ACCESS.INVENTORY_ID, INVENTORY_TEAM_ACCESS.TEAM_ID, INVENTORY_TEAM_ACCESS.ACCESS_LEVEL) .values(inventoryId, teamId, level.toString()) .onDuplicateKeyUpdate() .set(INVENTORY_TEAM_ACCESS.ACCESS_LEVEL, level.toString()) .execute(); }
public void upsertAccessLevel(DSLContext tx, UUID secretId, UUID teamId, ResourceAccessLevel level) { tx.insertInto(SECRET_TEAM_ACCESS) .columns(SECRET_TEAM_ACCESS.SECRET_ID, SECRET_TEAM_ACCESS.TEAM_ID, SECRET_TEAM_ACCESS.ACCESS_LEVEL) .values(secretId, teamId, level.toString()) .onDuplicateKeyUpdate() .set(SECRET_TEAM_ACCESS.ACCESS_LEVEL, level.toString()) .execute(); }
public void upsertAccessLevel(DSLContext tx, UUID projectId, UUID teamId, ResourceAccessLevel level) { tx.insertInto(PROJECT_TEAM_ACCESS) .columns(PROJECT_TEAM_ACCESS.PROJECT_ID, PROJECT_TEAM_ACCESS.TEAM_ID, PROJECT_TEAM_ACCESS.ACCESS_LEVEL) .values(projectId, teamId, level.toString()) .onDuplicateKeyUpdate() .set(PROJECT_TEAM_ACCESS.ACCESS_LEVEL, level.toString()) .execute(); }
private void merge(DSLContext tx, UUID inventoryId, String itemPath, Object data) { tx.insertInto(INVENTORY_DATA) .columns(INVENTORY_DATA.INVENTORY_ID, INVENTORY_DATA.ITEM_PATH, INVENTORY_DATA.ITEM_DATA) .values(value(inventoryId), value(itemPath), field("?::jsonb", serialize(data))) .onDuplicateKeyUpdate() .set(INVENTORY_DATA.ITEM_DATA, field("?::jsonb", String.class, serialize(data))) .execute(); }