Examples with ResultSet com.gamebuster19901.excite.bot.database.sql.ResultSet used on opensource projects

Example 1 with ResultSet

use of com.gamebuster19901.excite.bot.database.sql.ResultSet in project ExciteBot by TheGameCommunity.

the class Audit method addAudit.

@Deprecated
@SuppressWarnings("rawtypes")
protected static Audit addAudit(MessageContext executor, MessageContext context, AuditType type, String description, Instant dateIssued) {
    PreparedStatement ps;
    try {
        ps = Insertion.insertInto(AUDITS).setColumns(AUDIT_TYPE, ISSUER_ID, ISSUER_NAME, DESCRIPTION, DATE_ISSUED).to(type, context.getAuthor().getID(), context.getAuthor().getName(), description, Instant.now()).prepare(executor, true);
        ps.execute();
        ResultSet results = ps.getGeneratedKeys();
        results.next();
        long auditID = results.getLong(GENERATED_KEY);
        Row row = Table.selectAllFromWhere(executor, AUDITS, new Comparison(AUDIT_ID, EQUALS, auditID)).getRow(true);
        return new Audit(row, type);
    } catch (SQLException e) {
        throw new IOError(e);
    }
}