/** * Default constructor. * * @param sqlStatementData * {@link SqlStatementData} to copy the database information from. */ public DatabaseInfoHelper(SqlStatementData sqlStatementData) { this.databaseProductName = sqlStatementData.getDatabaseProductName(); this.databaseProductVersion = sqlStatementData.getDatabaseProductVersion(); this.databaseUrl = sqlStatementData.getDatabaseUrl(); }
query.addIndexingRestriction(IndexQueryRestrictionFactory.equal("sql", sqlStatementData.getSql())); if (null != sqlStatementData.getDatabaseProductName()) { query.addIndexingRestriction(IndexQueryRestrictionFactory.equal("databaseProductName", sqlStatementData.getDatabaseProductName()));
return ObjectUtils.compare(o1.getSql(), o2.getSql()); case DATABASE_NAME: return ObjectUtils.compare(o1.getDatabaseProductName(), o2.getDatabaseProductName()); case DATABASE_VERSION: return ObjectUtils.compare(o1.getDatabaseProductVersion(), o2.getDatabaseProductVersion());
/** * {@inheritDoc} */ @Override public IAggregatedData<SqlStatementData> getClone(SqlStatementData sqlStatementData) { AggregatedSqlStatementData clone = new AggregatedSqlStatementData(); clone.setPlatformIdent(sqlStatementData.getPlatformIdent()); clone.setSensorTypeIdent(sqlStatementData.getSensorTypeIdent()); clone.setPreparedStatement(sqlStatementData.isPreparedStatement()); clone.setSql(sqlStatementData.getSql()); clone.setDatabaseProductName(sqlStatementData.getDatabaseProductName()); clone.setDatabaseProductVersion(sqlStatementData.getDatabaseProductVersion()); clone.setDatabaseUrl(sqlStatementData.getDatabaseUrl()); if (includeParameters && (null != sqlStatementData.getParameterValues())) { clone.setParameterValues(new ArrayList<>(sqlStatementData.getParameterValues())); } return clone; }
/** * {@inheritDoc} */ @Override public DetailsTable generate(DefaultData defaultData, RepositoryDefinition repositoryDefinition, Composite parent, FormToolkit toolkit) { SqlStatementData sqlStatementData = (SqlStatementData) defaultData; DetailsTable table = new DetailsTable(parent, toolkit, "SQL Info", 1); table.addContentRow("Is Prepared:", null, new DetailsCellContent[] { new YesNoDetailsCellContent(sqlStatementData.isPreparedStatement()) }); table.addContentRow("Database:", null, new DetailsCellContent[] { new DetailsCellContent(sqlStatementData.getDatabaseProductName()) }); table.addContentRow("Database version:", null, new DetailsCellContent[] { new DetailsCellContent(sqlStatementData.getDatabaseProductVersion()) }); table.addContentRow("Database URL:", null, new DetailsCellContent[] { new DetailsCellContent(sqlStatementData.getDatabaseUrl()) }); table.addContentRow("SQL:", null, new DetailsCellContent[] { new DetailsCellContent(sqlStatementData.getSqlWithParameterValues()) }); return table; }