public <V> V executeScalar(Converter<V> converter){ try { //noinspection unchecked return converter.convert(executeScalar()); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database", e); } }
public <V> V executeScalar(Class<V> returnType){ try { Converter<V> converter; //noinspection unchecked converter = throwIfNull(returnType, getQuirks().converterOf(returnType)); //noinspection unchecked logExecution(); return executeScalar(converter); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database to type " + returnType, e); } }
/** * Gets iteration number for next iteration, 0 if no iteration exists * * @param connection * @return */ private static int getNextIterationNumber(Connection connection) { String query = "select max(iteration_number) from periodic_test_iterations"; try { return connection.createQuery(query).executeScalar(Integer.class) + 1; } catch (Exception ex) { return 0; } }
public <V> V executeScalar(Converter<V> converter){ try { //noinspection unchecked return converter.convert(executeScalar()); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database", e); } }
public <V> V executeScalar(Converter<V> converter) { try { //noinspection unchecked return converter.convert(executeScalar()); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database", e); } }
public static Instant getLastRunFor(Connection connection, String domain) { Instant lastRun = connection.createQuery("select max(timestamp) from current_tests where domain=:domain") .addParameter("domain", domain) .executeScalar(Instant.class); return lastRun; }
public static boolean isSubscribed(Connection connection, String email, String domain) { boolean subscribed = connection.createQuery( "select count(email) from subscribers " + "where domain = :domain and email = :email") .addParameter("email", email) .addParameter("domain", domain) .executeScalar(Integer.class) > 0; return subscribed; }
@SuppressWarnings("unchecked") public static Map<String, Object> getMap(String sql, Map<String, Object> params){ Connection con = sql2o.open(); Query query = con.createQuery(sql); executeQuery(query, params); Map<String, Object> t = (Map<String, Object>) query.executeScalar(); con.close(); return t; }
public <V> V executeScalar(Class<V> returnType) { try { Converter<V> converter; //noinspection unchecked converter = throwIfNull(returnType, getQuirks().converterOf(returnType)); //noinspection unchecked logExecution(); return executeScalar(converter); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database to type " + returnType, e); } }
public <V> V executeScalar(Class<V> returnType){ try { Converter<V> converter; //noinspection unchecked converter = throwIfNull(returnType, getQuirks().converterOf(returnType)); //noinspection unchecked logExecution(); return executeScalar(converter); } catch (ConverterException e) { throw new Sql2oException("Error occured while converting value from database to type " + returnType, e); } }
/** * Querying a model * * @param type model type * @param sql sql statement * @param params params * @param <S> * @return S */ public <S> S queryOne(Class<S> type, String sql, Object[] params) { Connection conn = getConn(); try { Query query = conn.createQuery(sql) .withParams(params) .setAutoDeriveColumnNames(true) .throwOnMappingFailure(false); return ifReturn(AnimaUtils.isBasicType(type), () -> query.executeScalar(type), () -> query.executeAndFetchFirst(type)); } finally { this.closeConn(conn); this.clean(null); } }