public UUID insert(DSLContext tx, UUID orgId, String name, String description) { return tx.insertInto(TEAMS) .columns(TEAMS.ORG_ID, TEAMS.TEAM_NAME, TEAMS.DESCRIPTION) .values(orgId, name, description) .returning(TEAMS.TEAM_ID) .fetchOne() .getTeamId(); }
public UUID insert(DSLContext tx, String username, UserType type, boolean admin) { return tx.insertInto(USERS) .columns(USERS.USERNAME, USERS.IS_ADMIN, USERS.USER_TYPE) .values(username, admin, type.toString()) .returning(USERS.USER_ID) .fetchOne().getUserId(); }
@Transactional public Pizza save(Pizza pizza) { Long pizzaId = dslContext.insertInto(PIZZA, PIZZA.BASE_ID, PIZZA.NAME, PIZZA.PRICE) .values(pizza.getBase().getId(), pizza.getName(), pizza.getPrice()) .returning(PIZZA.ID) .fetchOne() .getId(); int[] x = dslContext.batch(pizza.getToppings().stream() .map(t -> dslContext .insertInto(PIZZA_TOPPINGS, PIZZA_TOPPINGS.PIZZA_ID, PIZZA_TOPPINGS.TOPPINGS_ID) .values(pizzaId, t.getId())) .toArray(Query[]::new)) .execute(); pizza.setId(pizzaId); return pizza; } }
private UUID insert(DSLContext tx, UUID inventoryId, String queryName, String text) { return tx.insertInto(INVENTORY_QUERIES) .columns(INVENTORY_QUERIES.INVENTORY_ID, INVENTORY_QUERIES.QUERY_NAME, INVENTORY_QUERIES.QUERY_TEXT) .values(value(inventoryId), value(queryName), value(text)) .returning(INVENTORY_QUERIES.QUERY_ID) .fetchOne() .getQueryId(); }
public UUID insert(String name, UUID parentId, Map<String, Object> rules) { return txResult(tx -> tx.insertInto(POLICIES) .columns(POLICIES.POLICY_NAME, POLICIES.PARENT_POLICY_ID, POLICIES.RULES) .values(value(name), value(parentId), field("?::jsonb", serialize(rules))) .returning(POLICIES.POLICY_ID) .fetchOne() .getPolicyId()); }