Method | Description |
public void <init>(
com.pavelvlasov.sql.SQLProcessor processor
)
| Constructor |
public int commit(
int p1
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Parameters: ID |
public int deleteBaseline(
String p1
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes baseline violations |
public int deleteBaselineViolation(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from BASELINE_VIOLATION |
public int deleteBaselineViolation(
int Id
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from BASELINE_VIOLATION |
public int deleteBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public int deleteInspector(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from INSPECTOR |
public int deleteInspector(
int ReportId, String Name
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from INSPECTOR |
public int deleteMeasurement(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from MEASUREMENT |
public int deleteMeasurement(
int Id
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from MEASUREMENT |
public int deleteMetric(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from METRIC |
public int deleteMetric(
int ResultId, String Name
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from METRIC |
public int deleteOldResults(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes results with no parent and not linked to a new report |
public int deleteReport(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from REPORT |
public int deleteReport(
int Id
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from REPORT |
public int deleteViolation(
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes all records from VIOLATION |
public int deleteViolation(
int Id
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes by primary key from VIOLATION |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. Parameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. If converter is not null then elements will be results of conversion.Parameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. If targetClass is not null then elements will be of targetClass typeParameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. Parameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. If converter is not null then elements will be results of conversion. Parameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorSummary(
int p1, short p2, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. If targetClass is not null then elements will be of targetClass type. Parameters: root result, severity |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations. Parameters: root result, inspector name |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations. If converter is not null then elements will be results of conversion.Parameters: root result, inspector name |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations. If targetClass is not null then elements will be of targetClass typeParameters: root result, inspector name |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations and returns populated collection. Parameters: root result, inspector name |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations and returns populated collection. If converter is not null then elements will be results of conversion. Parameters: root result, inspector name |
public java.util.Collection getAggregatedResultsInspectorViolations(
int p1, String p2, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsInspectorViolations and returns populated collection. If targetClass is not null then elements will be of targetClass type. Parameters: root result, inspector name |
public int getAggregatedResultsInspectorViolationsCount(
int p1, String p2
)
throws java.sql.SQLException | Executes query and returns value of the first (the only) column in the first row. Parameters: root result, inspector name |
public java.util.Collection getAggregatedResultsMetric(
int p1
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric. Parameters: root result |
public java.util.Collection getAggregatedResultsMetric(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric. If converter is not null then elements will be results of conversion.Parameters: root result |
public java.util.Collection getAggregatedResultsMetric(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric. If targetClass is not null then elements will be of targetClass typeParameters: root result |
public java.util.Collection getAggregatedResultsMetric(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric and returns populated collection. Parameters: root result |
public java.util.Collection getAggregatedResultsMetric(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric and returns populated collection. If converter is not null then elements will be results of conversion. Parameters: root result |
public java.util.Collection getAggregatedResultsMetric(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetric and returns populated collection. If targetClass is not null then elements will be of targetClass type. Parameters: root result |
public AggregatedResultsMetricData getAggregatedResultsMetricData(
int p1, String p2
)
throws java.sql.SQLException | Executes query and returns single object. Parameters: root result, name |
public AggregatedResultsMetricData getAggregatedResultsMetricData(
int p1, String p2, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Parameters: root result, name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement. Parameters: root result, measurement name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement. If converter is not null then elements will be results of conversion.Parameters: root result, measurement name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement. If targetClass is not null then elements will be of targetClass typeParameters: root result, measurement name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement and returns populated collection. Parameters: root result, measurement name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement and returns populated collection. If converter is not null then elements will be results of conversion. Parameters: root result, measurement name |
public java.util.Collection getAggregatedResultsMetricMeasurement(
int p1, String p2, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.AggregatedResultsMetricMeasurement and returns populated collection. If targetClass is not null then elements will be of targetClass type. Parameters: root result, measurement name |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1
)
| Executes query, returns database backed collection with elements of type of the first column. Parameters: root result |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type of the first column. If converter is not null then it converts elements. Parameters: root result |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type of the first column. If target class is not null then elements are instances of target class created from the first column values. Parameters: root result |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. Parameters: root result |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. Elements get converted by the converter if it is not null.Parameters: root result |
public java.util.Collection getAggregatedResultsSeveritySummary(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. If target class is not null instances of target class are instantiated from first column valuesParameters: root result |
public int getAggregateResultsIsNew(
int p1
)
throws java.sql.SQLException | Executes query and returns value of the first (the only) column in the first row. Return 0 if not new, >0 if new. Parameters: root result |
public java.util.Collection getAllWarningsJoined(
int p1
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. warnings for result and its descendants with all needed data |
public java.util.Collection getAllWarningsJoined(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If converter is not null then elements will be results of conversion.warnings for result and its descendants with all needed data |
public java.util.Collection getAllWarningsJoined(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If targetClass is not null then elements will be of targetClass typewarnings for result and its descendants with all needed data |
public java.util.Collection getAllWarningsJoined(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. warnings for result and its descendants with all needed data |
public java.util.Collection getAllWarningsJoined(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If converter is not null then elements will be results of conversion. warnings for result and its descendants with all needed data |
public java.util.Collection getAllWarningsJoined(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If targetClass is not null then elements will be of targetClass type. warnings for result and its descendants with all needed data |
public Number getBaseLineIdByDate(
String p1, java.sql.Timestamp p2
)
throws java.sql.SQLException | Executes query and returns value of the first (the only) column in the first row. Parameters: report name, report date |
public java.util.Collection getBaselineViolation(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. Selects all rows from BASELINE_VIOLATION |
public java.util.Collection getBaselineViolation(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. If converter is not null then elements will be results of conversion.Selects all rows from BASELINE_VIOLATION |
public java.util.Collection getBaselineViolation(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. If targetClass is not null then elements will be of targetClass typeSelects all rows from BASELINE_VIOLATION |
public java.util.Collection getBaselineViolation(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. Selects all rows from BASELINE_VIOLATION |
public java.util.Collection getBaselineViolation(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from BASELINE_VIOLATION |
public java.util.Collection getBaselineViolation(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from BASELINE_VIOLATION |
public BaselineViolation getBaselineViolation(
int Id
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from BASELINE_VIOLATION |
public BaselineViolation getBaselineViolation(
int Id, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from BASELINE_VIOLATION |
public BaselineViolation getBaselineViolation(
String p1, String p2, String p3
)
throws java.sql.SQLException | Executes query and returns single object. Selects baseline violation by report name, inspector name and signature |
public BaselineViolation getBaselineViolation(
String p1, String p2, String p3, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects baseline violation by report name, inspector name and signature |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. If converter is not null then elements will be results of conversion.Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation. If targetClass is not null then elements will be of targetClass typeSelects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. If converter is not null then elements will be results of conversion. Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public java.util.Collection getBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.BaselineViolation and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public BasicResultTotal getBasicResultTotal(
int p1
)
throws java.sql.SQLException | Executes query and returns single object. Parameters: root result |
public BasicResultTotal getBasicResultTotal(
int p1, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Parameters: root result |
public int getCompositeResultSize(
int p1
)
throws java.sql.SQLException | Executes query and returns value of the first (the only) column in the first row. |
public java.util.Collection getInspector(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. Selects all rows from INSPECTOR |
public java.util.Collection getInspector(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. If converter is not null then elements will be results of conversion.Selects all rows from INSPECTOR |
public java.util.Collection getInspector(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector. If targetClass is not null then elements will be of targetClass typeSelects all rows from INSPECTOR |
public java.util.Collection getInspector(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. Selects all rows from INSPECTOR |
public java.util.Collection getInspector(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from INSPECTOR |
public java.util.Collection getInspector(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Inspector and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from INSPECTOR |
public Inspector getInspector(
int ReportId, String Name
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from INSPECTOR |
public Inspector getInspector(
int ReportId, String Name, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from INSPECTOR |
public java.util.Collection getMeasurement(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement. Selects all rows from MEASUREMENT |
public java.util.Collection getMeasurement(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement. If converter is not null then elements will be results of conversion.Selects all rows from MEASUREMENT |
public java.util.Collection getMeasurement(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement. If targetClass is not null then elements will be of targetClass typeSelects all rows from MEASUREMENT |
public java.util.Collection getMeasurement(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement and returns populated collection. Selects all rows from MEASUREMENT |
public java.util.Collection getMeasurement(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from MEASUREMENT |
public java.util.Collection getMeasurement(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Measurement and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from MEASUREMENT |
public Measurement getMeasurement(
int Id
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from MEASUREMENT |
public Measurement getMeasurement(
int Id, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from MEASUREMENT |
public java.util.Collection getMetric(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric. Selects all rows from METRIC |
public java.util.Collection getMetric(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric. If converter is not null then elements will be results of conversion.Selects all rows from METRIC |
public java.util.Collection getMetric(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric. If targetClass is not null then elements will be of targetClass typeSelects all rows from METRIC |
public java.util.Collection getMetric(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric and returns populated collection. Selects all rows from METRIC |
public java.util.Collection getMetric(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from METRIC |
public java.util.Collection getMetric(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Metric and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from METRIC |
public Metric getMetric(
int ResultId, String Name
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from METRIC |
public Metric getMetric(
int ResultId, String Name, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from METRIC |
public java.util.Collection getReport(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report. Selects all rows from REPORT |
public java.util.Collection getReport(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report. If converter is not null then elements will be results of conversion.Selects all rows from REPORT |
public java.util.Collection getReport(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report. If targetClass is not null then elements will be of targetClass typeSelects all rows from REPORT |
public java.util.Collection getReport(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report and returns populated collection. Selects all rows from REPORT |
public java.util.Collection getReport(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from REPORT |
public java.util.Collection getReport(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Report and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from REPORT |
public Report getReport(
int Id
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from REPORT |
public Report getReport(
int Id, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from REPORT |
public java.util.Collection getResultChildren(
int p1
)
| Executes query, returns database backed collection with elements of type of the first column. Returns result children. Parameters: result id |
public java.util.Collection getResultChildren(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type of the first column. If converter is not null then it converts elements. Returns result children. Parameters: result id |
public java.util.Collection getResultChildren(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type of the first column. If target class is not null then elements are instances of target class created from the first column values. Returns result children. Parameters: result id |
public java.util.Collection getResultChildren(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. Returns result children. Parameters: result id |
public java.util.Collection getResultChildren(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. Elements get converted by the converter if it is not null.Returns result children. Parameters: result id |
public java.util.Collection getResultChildren(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with values from the first column and returns the collection. If target class is not null instances of target class are instantiated from first column valuesReturns result children. Parameters: result id |
public String getResultType(
int p1
)
throws java.sql.SQLException | Executes query and returns value of the first (the only) column in the first row. |
public java.util.Collection getViolation(
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation. Selects all rows from VIOLATION |
public java.util.Collection getViolation(
com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation. If converter is not null then elements will be results of conversion.Selects all rows from VIOLATION |
public java.util.Collection getViolation(
Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation. If targetClass is not null then elements will be of targetClass typeSelects all rows from VIOLATION |
public java.util.Collection getViolation(
java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation and returns populated collection. Selects all rows from VIOLATION |
public java.util.Collection getViolation(
java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation and returns populated collection. If converter is not null then elements will be results of conversion. Selects all rows from VIOLATION |
public java.util.Collection getViolation(
java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.Violation and returns populated collection. If targetClass is not null then elements will be of targetClass type. Selects all rows from VIOLATION |
public Violation getViolation(
int Id
)
throws java.sql.SQLException | Executes query and returns single object. Selects by primary key from VIOLATION |
public Violation getViolation(
int Id, Class targetClass
)
throws java.sql.SQLException | Executes query and returns single object of target class type. Target class must be return type compatible. Selects by primary key from VIOLATION |
public java.util.Collection getViolationJoined(
int p1
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. Violations for result with all needed data |
public java.util.Collection getViolationJoined(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If converter is not null then elements will be results of conversion.Violations for result with all needed data |
public java.util.Collection getViolationJoined(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If targetClass is not null then elements will be of targetClass typeViolations for result with all needed data |
public java.util.Collection getViolationJoined(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. Violations for result with all needed data |
public java.util.Collection getViolationJoined(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If converter is not null then elements will be results of conversion. Violations for result with all needed data |
public java.util.Collection getViolationJoined(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If targetClass is not null then elements will be of targetClass type. Violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined. Waived violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined. If converter is not null then elements will be results of conversion.Waived violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined. If targetClass is not null then elements will be of targetClass typeWaived violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined and returns populated collection. Waived violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined and returns populated collection. If converter is not null then elements will be results of conversion. Waived violations for result with all needed data |
public java.util.Collection getWaivedViolationJoined(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.WaivedViolationJoined and returns populated collection. If targetClass is not null then elements will be of targetClass type. Waived violations for result with all needed data |
public java.util.Collection getWarningJoined(
int p1
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. warnings for result with all needed data |
public java.util.Collection getWarningJoined(
int p1, com.pavelvlasov.convert.Converter converter
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If converter is not null then elements will be results of conversion.warnings for result with all needed data |
public java.util.Collection getWarningJoined(
int p1, Class targetClass
)
| Executes query, returns database backed collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined. If targetClass is not null then elements will be of targetClass typewarnings for result with all needed data |
public java.util.Collection getWarningJoined(
int p1, java.util.Collection receiver
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. warnings for result with all needed data |
public java.util.Collection getWarningJoined(
int p1, java.util.Collection receiver, com.pavelvlasov.convert.Converter converter
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If converter is not null then elements will be results of conversion. warnings for result with all needed data |
public java.util.Collection getWarningJoined(
int p1, java.util.Collection receiver, Class targetClass
)
throws java.sql.SQLException | Executes query, populates collection with elements of type org.hammurapi.results.persistent.jdbc.sql.ViolationJoined and returns populated collection. If targetClass is not null then elements will be of targetClass type. warnings for result with all needed data |
public int incWaivedViolations(
int p1
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Parameters: ID |
public int insertBaselineViolation(
int Id, String ReportName, String Inspector, String Signature
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into BASELINE_VIOLATION |
public int insertBaselineViolation(
BaselineViolation rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into BASELINE_VIOLATION |
public int insertInspector(
int ReportId, String Name, short Severity, String Description, String ConfigInfo
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into INSPECTOR |
public int insertInspector(
Inspector rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into INSPECTOR |
public int insertMeasurement(
int Id, int ResultId, String Name, double MeasurementValue, String Source, int Line, int Col
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into MEASUREMENT |
public int insertMeasurement(
Measurement rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into MEASUREMENT |
public int insertMetric(
int ResultId, String Name
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into METRIC |
public int insertMetric(
Metric rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into METRIC |
public int insertReport(
int Id, String Name, Integer ReportNumber, Integer ResultId, Long ExecutionTime, String HostName, String HostId, String Description, boolean IsOld
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into REPORT |
public int insertReport(
Report rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into REPORT |
public int insertViolation(
int Id, int ResultId, int ReportId, String Inspector, Integer MessageId, Integer SourceId, int Line, int Col, String SignaturePostfix, Integer WaiverReason, java.sql.Date WaiverExpires, byte ViolationType
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into VIOLATION |
public int insertViolation(
Violation rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Inserts new record into VIOLATION |
public void processAggregatedResultsInspectorSummary(
int p1, short p2, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Parameters: root result, severity |
public void processAggregatedResultsInspectorViolations(
int p1, String p2, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Parameters: root result, inspector name |
public void processAggregatedResultsMetric(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Parameters: root result |
public void processAggregatedResultsMetricMeasurement(
int p1, String p2, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Parameters: root result, measurement name |
public void processAggregatedResultsSeveritySummary(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Parameters: root result |
public void processAllWarningsJoined(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. warnings for result and its descendants with all needed data |
public void processBaselineViolation(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from BASELINE_VIOLATION |
public void processBaselineViolationSignatureEQ(
String ReportName, String Inspector, String Signature, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects row(s) with equal index value(s): REPORT_NAME, INSPECTOR, SIGNATURE |
public void processInspector(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from INSPECTOR |
public void processMeasurement(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from MEASUREMENT |
public void processMetric(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from METRIC |
public void processReport(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from REPORT |
public void processResultChildren(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Returns result children. Parameters: result id |
public void processViolation(
com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Selects all rows from VIOLATION |
public void processViolationJoined(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Violations for result with all needed data |
public void processWaivedViolationJoined(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. Waived violations for result with all needed data |
public void processWarningJoined(
int p1, com.pavelvlasov.sql.RowProcessor processor
)
throws java.sql.SQLException | Executes query, iterates over rows and invokes methods of RowProcessor for each row. warnings for result with all needed data |
public int setOldReports(
int p1, String p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Deletes reports with the same name other than this one. Parameters: id, name |
public int setReportExecutionTime(
long p1, int p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. |
public int setReportResult(
int p1, int p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. |
public int setViolationLevel(
double p1, int p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Parameters: level, ID |
public int updateAggregatedResultsMaxSeverity(
short p1, int p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. |
public int updateAggregatedResultsViolations(
long p1, int p2
)
throws java.sql.SQLException | Executes update and returns number of affected rows. |
public int updateBaselineViolation(
BaselineViolation rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Updates record with by primary key in BASELINE_VIOLATION |
public int updateInspector(
Inspector rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Updates record with by primary key in INSPECTOR |
public int updateMeasurement(
Measurement rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Updates record with by primary key in MEASUREMENT |
public int updateReport(
Report rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Updates record with by primary key in REPORT |
public int updateViolation(
Violation rowInterface
)
throws java.sql.SQLException | Executes update and returns number of affected rows. Updates record with by primary key in VIOLATION |