public static Query<Map<String, Object>> getBoundQuery(Handle handle, String dbPrefix, String tableParameterName, String tableName, String queryName) { return handle.createQuery(dbPrefix + queryName).define(tableParameterName, tableName); }
private static Query<MetadataInfo> getStatusQuery(final Handle handle, final String personality, final MigratoryOption [] options) { final Query<MetadataInfo> query = handle.createQuery(METADATA_PREFIX + "query_status") .define("include_internal", MigratoryOption.containsOption(MigratoryOption.INCLUDE_INTERNAL, options)) .define("include_failed", MigratoryOption.containsOption(MigratoryOption.INCLUDE_FAILED, options)) .define("personality_name", personality) .bind("personality_name", personality) .map(MetadataInfo.MAPPER); return query; } }
private static Query<MetadataInfo> getHistoryQuery(final Handle handle, final String personality, final MigratoryOption [] options) { final Query<MetadataInfo> query = handle.createQuery(METADATA_PREFIX + "query_history") .define("include_internal", MigratoryOption.containsOption(MigratoryOption.INCLUDE_INTERNAL, options)) .define("personality_name", personality) .bind("personality_name", personality) .map(MetadataInfo.MAPPER); return query; } }
(sortDirection == null || SortDirection.ASCENDING.equals(sortDirection)) ? "ASC" : "DESC"; select.define("order", order);
@Override public Object withHandle(final Handle h) throws Exception { h.execute("createSomethingTable"); int numCreated = h.createStatement("insertSomething") .bind("0", 0) .bind("1", "Jan") .execute(); assertThat(numCreated).as("number of rows inserted").isEqualTo(1); String name = h.createQuery("findById") .bind("0", 0) .define("columns", "name") .mapTo(String.class) .first(); assertThat(name).as("Jan's Name").isEqualTo("Jan"); return null; } });
.define("template", "select() ::= <% select id from something %>") .map(new IntegerMapper()) .list();