Examples with FinalSQLString com.palantir.nexus.db.sql.BasicSQLString.FinalSQLString used on opensource projects

Example 1 with FinalSQLString

use of com.palantir.nexus.db.sql.BasicSQLString.FinalSQLString in project atlasdb by palantir.

the class BasicSQL method selectLightResultSetSpecifyingDBType.

protected AgnosticLightResultSet selectLightResultSetSpecifyingDBType(final Connection c, final FinalSQLString sql, Object[] vs, final DBType dbType, @Nullable Integer fetchSize) throws PalantirSqlException, PalantirInterruptedException {
    if (SqlLoggers.LOGGER.isTraceEnabled()) {
        SqlLoggers.LOGGER.trace("SQL light result set selection query: {}", sql.getQuery());
    }
    // $NON-NLS-1$
    final ResourceCreationLocation alrsCreationException = new ResourceCreationLocation("This is where the AgnosticLightResultSet wrapper was created");
    PreparedStatementVisitor<AgnosticLightResultSet> preparedStatementVisitor = ps -> {
        // $NON-NLS-1$
        final ResourceCreationLocation creationException = new ResourceCreationLocation("This is where the ResultsSet was created", alrsCreationException);
        final ResultSetVisitor<AgnosticLightResultSet> resultSetVisitor = rs -> {
            try {
                return new AgnosticLightResultSetImpl(rs, dbType, rs.getMetaData(), ps, // $NON-NLS-1$
                "selectList", sql, getSqlTimer(), creationException);
            } catch (Exception e) {
                closeSilently(rs);
                BasicSQLUtils.throwUncheckedIfSQLException(e);
                throw Throwables.throwUncheckedException(e);
            }
        };
        try {
            return runCancellably(ps, resultSetVisitor, sql, AutoClose.FALSE, fetchSize);
        } catch (Exception e) {
            closeSilently(ps);
            BasicSQLUtils.throwUncheckedIfSQLException(e);
            throw Throwables.throwUncheckedException(e);
        }
    };
    return wrapPreparedStatement(c, sql, vs, preparedStatementVisitor, // $NON-NLS-1$
    "selectList", // don't close the ps
    AutoClose.FALSE);
}

Example 2 with FinalSQLString

use of com.palantir.nexus.db.sql.BasicSQLString.FinalSQLString in project atlasdb by palantir.

the class SQL method fromResultSet.

public AgnosticLightResultSet fromResultSet(PreparedStatement preparedStatement, ResultSet resultSet, DBType dbType, String queryString) {
    FinalSQLString sqlString = SQLString.getUnregisteredQuery(queryString);
    String timingModule = "visitResultSet";
    ResultSetMetaData metaData = ResultSets.getMetaData(resultSet);
    SqlTimer sqlTimer = getSqlTimer();
    // $NON-NLS-1$
    ResourceCreationLocation creationException = new ResourceCreationLocation("This is where the ResultsSet was created");
    return new AgnosticLightResultSetImpl(resultSet, dbType, metaData, preparedStatement, timingModule, sqlString, sqlTimer, creationException);
}

Example 3 with FinalSQLString

use of com.palantir.nexus.db.sql.BasicSQLString.FinalSQLString in project atlasdb by palantir.

the class BasicSQL method runCancellablyInternal.

private static <T> T runCancellablyInternal(final PreparedStatement ps, ResultSetVisitor<T> visitor, final FinalSQLString sql, AutoClose autoClose, @Nullable Integer fetchSize) throws PalantirInterruptedException, PalantirSqlException {
    final String threadString = sql.toString();
    Future<ResultSet> result = service.submit(ThreadNamingCallable.wrapWithThreadName(() -> {
        if (Thread.currentThread().isInterrupted()) {
            // $NON-NLS-1$
            SqlLoggers.CANCEL_LOGGER.error("Threadpool thread has interrupt flag set!");
            // we want to clear the interrupted status here -
            // we cancel via the prepared statement, not interrupts
            Thread.interrupted();
        }
        if (fetchSize != null) {
            ps.setFetchSize(fetchSize);
        }
        return ps.executeQuery();
    }, threadString, ThreadNamingCallable.Type.APPEND));
    ResultSet rs = null;
    long startTime = System.currentTimeMillis();
    final String oldName = Thread.currentThread().getName();
    final String currentTimestamp = DateTimeFormat.forPattern("HH:mm:ss").print(System.currentTimeMillis());
    Thread.currentThread().setName(oldName + " blocking on " + threadString + " started at " + currentTimestamp);
    try {
        rs = result.get();
        return visitor.visit(rs);
    } catch (InterruptedException e) {
        try {
            // $NON-NLS-1$
            SqlLoggers.CANCEL_LOGGER.debug("about to cancel a SQL call", e);
            PreparedStatements.cancel(ps);
            // $NON-NLS-1$
            throw new PalantirInterruptedException("SQL call interrupted", e);
        } finally {
            // we delay this as long as possible, but under no
            // circumstances lose it
            Thread.currentThread().interrupt();
        }
    } catch (ExecutionException ee) {
        throw handleInterruptions(startTime, ee);
    } finally {
        Thread.currentThread().setName(oldName);
        if (rs != null && autoClose == AutoClose.TRUE) {
            ResultSets.close(rs);
        }
    }
}

Example 4 with FinalSQLString

use of com.palantir.nexus.db.sql.BasicSQLString.FinalSQLString in project atlasdb by palantir.

the class BasicSQL method selectResultSetSpecifyingDBType.

protected AgnosticResultSet selectResultSetSpecifyingDBType(final Connection c, final FinalSQLString sql, Object[] vs, final DBType dbType) throws PalantirSqlException, PalantirInterruptedException {
    if (SqlLoggers.LOGGER.isTraceEnabled()) {
        SqlLoggers.LOGGER.trace("SQL result set query: {}", sql.getQuery());
    }
    return wrapPreparedStatement(c, sql, vs, ps -> runCancellably(ps, (ResultSetVisitor<AgnosticResultSet>) rs -> {
        List<List<Object>> rvs = new ArrayList<List<Object>>();
        ResultSetMetaData meta = ResultSets.getMetaData(rs);
        int columnCount = ResultSets.getColumnCount(meta);
        Map<String, Integer> columnMap = ResultSets.buildInMemoryColumnMap(meta, dbType);
        while (ResultSets.next(rs)) {
            List<Object> row = Lists.newArrayListWithCapacity(columnCount);
            for (int i = 0; i < columnCount; i++) {
                row.add(ResultSets.getObject(rs, i + 1));
            }
            rvs.add(row);
        }
        return new AgnosticResultSetImpl(rvs, dbType, columnMap);
    }, sql, null), // $NON-NLS-1$
    "selectList");
}