Example usage for org.apache.commons.dbutils QueryRunner QueryRunner

Introduction

In this page you can find the example usage for org.apache.commons.dbutils QueryRunner QueryRunner.

Prototype

public QueryRunner(DataSource ds)

Source Link

Document

Constructor for QueryRunner that takes a DataSource to use.

Usage

From source file:com.pinterest.deployservice.db.DBHostDAOImpl.java

@Override
public List<String> getHostIdsByGroup(String groupName) throws Exception {
    return new QueryRunner(dataSource).query(GET_HOST_IDS_BY_GROUP,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), groupName);
}

From source file:com.xeiam.yank.Yank.java

/**
 * Executes the given INSERT, UPDATE, DELETE, REPLACE or UPSERT SQL prepared statement. Returns the number of rows affected.
 *
 * @param sql The query to execute/*from www . j ava  2  s  .  c  om*/
 * @param params The replacement parameters
 * @return The number of rows affected
 */
public static int execute(String sql, Object[] params) {

    int returnInt = 0;

    try {

        returnInt = new QueryRunner(YANK_POOL_MANAGER.getDataSource()).update(sql, params);

    } catch (SQLException e) {
        handleSQLException(e);
    }

    return returnInt;
}

From source file:io.apiman.manager.api.jdbc.JdbcMetricsAccessor.java

/**
 * @see io.apiman.manager.api.core.IMetricsAccessor#getUsagePerClient(java.lang.String, java.lang.String, java.lang.String, org.joda.time.DateTime, org.joda.time.DateTime)
 *//* w w w.  j  a  va 2s  .  c om*/
@Override
public UsagePerClientBean getUsagePerClient(String organizationId, String apiId, String version, DateTime from,
        DateTime to) {
    try {
        QueryRunner run = new QueryRunner(ds);
        String sql = "SELECT client_id, count(*) FROM gw_requests WHERE api_org_id = ? AND api_id = ? AND api_version = ? AND rstart >= ? AND rstart < ? GROUP BY client_id"; //$NON-NLS-1$
        ResultSetHandler<UsagePerClientBean> handler = new UsagePerClientHandler();
        return run.query(sql, handler, organizationId, apiId, version, from.getMillis(), to.getMillis());
    } catch (SQLException e) {
        e.printStackTrace();
        return new UsagePerClientBean();
    }
}

From source file:com.pinterest.arcee.db.DBHealthCheckDAOImpl.java

@Override
public List<HealthCheckBean> getOngoingRegularHealthChecksByGroup(String groupName) throws Exception {
    ResultSetHandler<List<HealthCheckBean>> h = new BeanListHandler<HealthCheckBean>(HealthCheckBean.class);
    return new QueryRunner(dataSource).query(GET_ONGOING_HEALTHCHECKS_BY_GROUP, h, groupName,
            HealthCheckType.TIME_TRIGGERED.toString(), HealthCheckState.COMPLETED.toString());
}

From source file:com.pinterest.deployservice.db.DBBuildDAOImpl.java

@Override
public List<BuildBean> getByCommit7(String scmCommit7, int pageIndex, int pageSize) throws Exception {
    ResultSetHandler<List<BuildBean>> h = new BeanListHandler<>(BuildBean.class);
    return new QueryRunner(dataSource).query(GET_BUILDS_BY_COMMIT_7, h, scmCommit7, (pageIndex - 1) * pageSize,
            pageSize);/*from www .  ja  v a  2 s.  c o m*/
}

From source file:com.pinterest.deployservice.db.DBAgentDAOImpl.java

@Override
public void delete(String hostId, String envId) throws Exception {
    new QueryRunner(dataSource).update(DELETE_AGENT, hostId, envId);
}

From source file:io.dockstore.common.BasicPostgreSQL.java

protected <T> T runSelectStatement(String query, ResultSetHandler<T> handler, Object... params) {
    try {/*from   w ww. j  a  v  a 2 s . c  om*/
        QueryRunner run = new QueryRunner(dataSource);
        return run.query(query, handler, params);
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

From source file:com.pinterest.arcee.db.DBGroupInfoDAOImpl.java

@Override
public List<String> getToUpdateGroups(long after) throws Exception {
    return new QueryRunner(dataSource).query(GET_TO_UPDATE_GROUPS_NAME,
            SingleResultSetHandlerFactory.<String>newListObjectHandler(), after);
}

From source file:com.pinterest.deployservice.db.DBHostTagDAOImpl.java

@Override
public void deleteAllByEnvIdAndHostIds(String envId, List<String> hostIds) throws Exception {
    String hostStr = QueryUtils.genStringGroupClause(hostIds);
    new QueryRunner(dataSource).update(String.format(DELETE_HOST_TAG_BY_ENV_ID_AND_HOST_ID, hostStr), envId);
}

From source file:com.pinterest.deployservice.db.DBHostDAOImpl.java

@Override
public Long getGroupSize(String groupName) throws Exception {
    Long n = new QueryRunner(dataSource).query(GET_GROUP_SIZE,
            SingleResultSetHandlerFactory.<Long>newObjectHandler(), groupName);
    return n == null ? 0 : n;
}