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()

Source Link

Document

Constructor for QueryRunner.

Usage

From source file:com.netflix.metacat.usermetadata.mysql.MySqlLookupService.java

private void insertLookupValues(final Long id, final Set<String> inserts, final Connection conn)
        throws SQLException {
    final Object[][] params = new Object[inserts.size()][];
    final Iterator<String> iter = inserts.iterator();
    int index = 0;
    while (iter.hasNext()) {
        params[index++] = ImmutableList.of(id, iter.next()).toArray();
    }//w w  w. j a  v  a2 s .c o  m
    new QueryRunner().batch(conn, SQL_INSERT_LOOKUP_VALUES, params);
}

From source file:com.netflix.metacat.usermetadata.mysql.MysqlUserMetadataService.java

@SuppressWarnings("checkstyle:methodname")
private Void _deleteDefinitionMetadatas(final Connection conn, final List<QualifiedName> names)
        throws SQLException {
    if (names != null && !names.isEmpty()) {
        final List<String> paramVariables = names.stream().map(s -> "?").collect(Collectors.toList());
        final String[] aNames = names.stream().map(QualifiedName::toString).toArray(String[]::new);
        new QueryRunner().update(conn,
                String.format(SQL.DELETE_DEFINITION_METADATA, Joiner.on(",").skipNulls().join(paramVariables)),
                (Object[]) aNames);
    }//from www  .  j a  va2s  .c  o  m
    return null;
}

From source file:com.aw.core.dao.DAOSql.java

/**
 * Helper method used to retrieve the select count(*)
 *
 * @param sqlFromWhereClause SQL query without the SELECT section: "FROM x where X=y"
 * @param filterKeys         key used to restrict the search
 * @return number of rows that return the query
 *///  ww  w  .j a va 2s  . c  o m
public int findCountRows(String sqlFromWhereClause, Object[] filterKeys) {
    String sql = "SELECT count(*) " + sqlFromWhereClause;
    try {
        if (logger.isDebugEnabled()) {
            logger.debug("Executing:" + AWQueryRunner.buildSQLLog(sql, filterKeys));
        }
        Number num = (Number) new QueryRunner().query(getHibernateConnection(), sql, filterKeys,
                new ScalarHandler());
        return num.intValue();
    } catch (SQLException e) {
        throw AWBusinessException.wrapUnhandledException(logger, e);
    }
}

From source file:azkaban.project.JdbcProjectLoader.java

private List<Triple<String, Boolean, Permission>> fetchPermissionsForProject(Connection connection,
        Project project) throws ProjectManagerException {
    ProjectPermissionsResultHandler permHander = new ProjectPermissionsResultHandler();

    QueryRunner runner = new QueryRunner();
    List<Triple<String, Boolean, Permission>> permissions = null;
    try {//from www .  j av a  2 s  . c  o  m
        permissions = runner.query(connection, ProjectPermissionsResultHandler.SELECT_PROJECT_PERMISSION,
                permHander, project.getId());
    } catch (SQLException e) {
        throw new ProjectManagerException("Query for permissions for " + project.getName() + " failed.", e);
    }

    return permissions;
}

From source file:com.netflix.metacat.usermetadata.mysql.MySqlTagService.java

@Override
public Void rename(final QualifiedName name, final String newTableName) {
    try {/*from w  ww . jav  a  2 s  .co  m*/
        final Connection conn = getDataSource().getConnection();
        try {
            final QualifiedName newName = QualifiedName.ofTable(name.getCatalogName(), name.getDatabaseName(),
                    newTableName);
            new QueryRunner().update(conn, SQL_UPDATE_TAG_ITEM, newName.toString(), name.toString());
            conn.commit();
        } catch (Exception e) {
            conn.rollback();
            throw e;
        } finally {
            conn.close();
        }
    } catch (SQLException e) {
        final String message = String.format("Failed to rename item name %s", name);
        log.error(message, e);
        throw new UserMetadataServiceException(message, e);
    }
    return null;
}

From source file:com.netflix.metacat.usermetadata.mysql.MySqlLookupService.java

private void deleteLookupValues(final Long id, final Set<String> deletes, final Connection conn)
        throws SQLException {
    new QueryRunner().update(conn,
            String.format(SQL_DELETE_LOOKUP_VALUES, "'" + Joiner.on("','").skipNulls().join(deletes) + "'"),
            id);/*from  ww  w  .  ja va2s  .c  o  m*/
}

From source file:com.bjond.Main.java

public static String findRuleDefinitionNameByID(final Connection connection, final String ID)
        throws SQLException {
    String name = nameIDMap.get(ID);
    if (name != null) {
        return name;
    }//from  w w w  .j av  a  2  s . co  m

    val run = new QueryRunner();
    final StringStub stub = run.query(connection, "SELECT p.name FROM rule_definition p WHERE p.id = ?",
            new BeanHandler<>(StringStub.class), ID);

    if (stub != null) {
        nameIDMap.put(ID, stub.getName());
        return stub.getName();
    } else {
        return ID;
    }
}

From source file:com.gs.obevo.dbmetadata.impl.dialects.SybaseAseMetadataDialect.java

@Override
public ImmutableCollection<ExtraRerunnableInfo> searchExtraViewInfo(DaSchema schema, String tableName,
        Connection conn) throws SQLException {
    String query = String/*www  .ja va  2s  .  c  o m*/
            .format("select obj.name name, com.number number, colid2 colid2, colid colid, text text\n"
                    + "from %1$s..syscomments com\n" + ", %1$s..sysobjects obj\n" + "where com.id = obj.id\n"
                    + "and com.texttype = 0\n" + "and obj.type in ('V')\n"
                    + "order by com.id, number, colid2, colid\n", schema.getName());
    QueryRunner qr = new QueryRunner(); // using queryRunner so that we can reuse the connection
    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(qr.query(conn, query, new MapListHandler()))
            .toImmutable();

    ImmutableList<ExtraRerunnableInfo> viewInfos = maps
            .collect(new Function<Map<String, Object>, ExtraRerunnableInfo>() {
                @Override
                public ExtraRerunnableInfo valueOf(Map<String, Object> object) {
                    return new ExtraRerunnableInfo((String) object.get("name"), null,
                            (String) object.get("text"), null, ((Integer) object.get("colid2")).intValue(),
                            ((Integer) object.get("colid")).intValue());
                }
            });

    return viewInfos.groupBy(ExtraRerunnableInfo.TO_NAME).multiValuesView()
            .collect(new Function<RichIterable<ExtraRerunnableInfo>, ExtraRerunnableInfo>() {
                @Override
                public ExtraRerunnableInfo valueOf(RichIterable<ExtraRerunnableInfo> objectInfos) {
                    MutableList<ExtraRerunnableInfo> sortedInfos = objectInfos.toSortedList(Comparators
                            .fromFunctions(ExtraRerunnableInfo.TO_ORDER2, ExtraRerunnableInfo.TO_ORDER1));
                    StringBuilder definitionString = sortedInfos.injectInto(new StringBuilder(),
                            new Function2<StringBuilder, ExtraRerunnableInfo, StringBuilder>() {
                                @Override
                                public StringBuilder value(StringBuilder sb,
                                        ExtraRerunnableInfo rerunnableInfo) {
                                    return sb.append(rerunnableInfo.getDefinition());
                                }
                            });
                    return new ExtraRerunnableInfo(sortedInfos.get(0).getName(), null,
                            definitionString.toString());
                }
            }).toList().toImmutable();
}

From source file:com.gs.obevo.dbmetadata.impl.dialects.MsSqlMetadataDialect.java

@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn)
        throws SQLException {
    QueryRunner query = new QueryRunner();

    ImmutableList<Map<String, Object>> maps = ListAdapter
            .adapt(query.query(conn,//from w w w . j ava 2s  .c  o m
                    "SELECT DOMAIN_NAME as USER_TYPE_NAME " + "FROM INFORMATION_SCHEMA.DOMAINS "
                            + "WHERE DOMAIN_CATALOG = '" + schema.getName() + "'",
                    new MapListHandler()))
            .toImmutable();

    return maps.collect(new Function<Map<String, Object>, DaUserType>() {
        @Override
        public DaUserType valueOf(Map<String, Object> map) {
            return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
        }
    });
}

From source file:edu.pitt.dbmi.ipm.service.storage.PostgreStorage.java

@Override
public JSONObject getJSONResult(String SPARQL_URL, String query) throws QueryException {
    JSONObject jsonObj = null;//  w w w.  j a v  a2 s. c  o m
    List<Map<String, Object>> listOfMaps = null;
    Connection connection = null;
    try {
        connection = getConnection();
        QueryRunner queryRunner = new QueryRunner();
        listOfMaps = queryRunner.query(connection, query, new MapListHandler());

        // convert list of maps to listof maps of maps
        List<Map<String, Map<String, Object>>> newList = new LinkedList<Map<String, Map<String, Object>>>();
        Map<String, Map<String, Object>> outerMap = null;
        Map<String, Object> innerMap = null;
        List<String> headerList = new LinkedList<String>();
        Object value = "";
        String key = null;
        for (Map<String, Object> oldMap : listOfMaps) {
            outerMap = new HashMap<String, Map<String, Object>>();
            for (Map.Entry<String, Object> entry : oldMap.entrySet()) {
                key = entry.getKey();
                innerMap = new HashMap<String, Object>();
                value = entry.getValue();
                if (value != null) {
                    innerMap.put("value", value);
                    outerMap.put(key, innerMap);
                }
                if (!headerList.contains(key))
                    headerList.add(key);
            }
            newList.add(outerMap);
        }

        String newJson = "{\"results\":{\"bindings\":" + new Gson().toJson(newList) + "},\"head\":{\"vars\":"
                + new Gson().toJson(headerList) + "}}";

        listOfMaps.clear();
        listOfMaps = null;
        newList.clear();
        newList = null;

        jsonObj = new JSONObject(newJson);

    } catch (SQLException se) {
        throw new QueryException(
                "PostgreStorage getJSONResult: Couldn't query the database." + se.getMessage());
    } catch (JSONException e) {
        throw new QueryException("PostgreStorage getJSONResult: " + e.getMessage());
    } catch (Exception e) {
        throw new QueryException("PostgreStorage getJSONResult: " + e.getMessage());
    } finally {
        DbUtils.closeQuietly(connection);
    }

    return jsonObj;
}