public String getFeatureDistributionAudit() { StringBuilder sb = new StringBuilder(); sb.append("SELECT count(" + COL_EVENT_UUID + ") as NB, " + COL_EVENT_ACTION + " FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(" WHERE (" + COL_EVENT_TYPE + " LIKE '" + EventConstants.TARGET_FEATURE + "') "); sb.append(" AND (" + COL_EVENT_NAME + " LIKE ?) "); sb.append(" AND (" + COL_EVENT_TIME + "> ?) "); sb.append(" AND (" + COL_EVENT_TIME + "< ?)"); sb.append(" GROUP BY " + COL_EVENT_ACTION); return sb.toString(); }
public String sqlSaveAudit() { StringBuilder sb = new StringBuilder(); sb.append("INSERT INTO "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append("(EVT_UUID, EVT_TIME, EVT_TYPE, EVT_NAME, EVT_ACTION," + "EVT_HOSTNAME, EVT_SOURCE, EVT_DURATION, " + "EVT_USER, EVT_VALUE, EVT_KEYS) " + "VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); return sb.toString(); }
public String getEventByUuidQuery() { StringBuilder sb = new StringBuilder(); sb.append("SELECT * FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(" WHERE " + COL_EVENT_UUID + " LIKE ?"); return sb.toString(); }
public String getHitCount(String columName) { StringBuilder sb = new StringBuilder(); sb.append("SELECT count(" + COL_EVENT_UUID + ") as NB, " + columName + " FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(" WHERE (" + COL_EVENT_TYPE + " LIKE '" + EventConstants.TARGET_FEATURE + "') "); sb.append(" AND (" + COL_EVENT_ACTION + " LIKE '" + EventConstants.ACTION_CHECK_OK + "') "); sb.append(" AND (" + COL_EVENT_TIME + "> ?) "); sb.append(" AND (" + COL_EVENT_TIME + "< ?)"); sb.append(" GROUP BY " + columName); return sb.toString(); }
public String getPurgeAuditTrailQuery(EventQueryDefinition eqd) { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(buildWhereClause(eqd, false, true)); return sb.toString(); }
public String getSelectAuditTrailQuery(EventQueryDefinition eqd) { StringBuilder sb = new StringBuilder(); sb.append("SELECT * FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(buildWhereClause(eqd, false, true)); return sb.toString(); }
public String getPurgeFeatureUsageQuery(EventQueryDefinition eqd) { StringBuilder sb = new StringBuilder(); sb.append("DELETE FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(buildWhereClause(eqd, true, false)); return sb.toString(); }
public String getSelectFeatureUsageQuery(EventQueryDefinition eqd) { StringBuilder sb = new StringBuilder(); sb.append("SELECT * FROM "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append(buildWhereClause(eqd, true, false)); return sb.toString(); }
/** * SQL to create Tables (won't work for all DB). * * @return * sql to create audit table */ public String sqlCreateTableAudit() { StringBuilder sb = new StringBuilder("CREATE TABLE "); sb.append(getSchemaPattern()); sb.append(getTableNameAudit()); sb.append("( EVT_UUID VARCHAR(40) NOT NULL," + " EVT_TIME TIMESTAMP NOT NULL," + " EVT_TYPE VARCHAR(30) NOT NULL," + " EVT_NAME VARCHAR(30) NOT NULL," + " EVT_ACTION VARCHAR(30) NOT NULL," + " EVT_HOSTNAME VARCHAR(100) NOT NULL," + " EVT_SOURCE VARCHAR(30) NOT NULL," + " EVT_DURATION INTEGER," + " EVT_USER VARCHAR(30)," + " EVT_VALUE VARCHAR(100)," + " EVT_KEYS VARCHAR(255)," + "PRIMARY KEY(EVT_UUID, EVT_TIME))"); return sb.toString(); }
/** {@inheritDoc} */ @Override public void createSchema() { JdbcQueryBuilder qb = getQueryBuilder(); if (!JdbcUtils.isTableExist(dataSource, qb.getTableNameAudit())) { getJdbcTemplate().update(qb.sqlCreateTableAudit()); } }
Map < Integer, String > statementParams = new HashMap<Integer, String>(); StringBuilder sb = new StringBuilder("INSERT INTO " + getQueryBuilder().getTableNameAudit() + "(EVT_UUID,EVT_TIME,EVT_TYPE,EVT_NAME,EVT_ACTION,EVT_HOSTNAME,EVT_SOURCE,EVT_DURATION"); if (Util.hasLength(evt.getUser())) {
/** {@inheritDoc} */ @Override public void createSchema() { DataSource ds = getDataSource(); JdbcQueryBuilder qb = getQueryBuilder(); if (!isTableExist(ds, qb.getTableNameAudit())) { executeUpdate(ds, qb.sqlCreateTableAudit()); } }