org.transitime.reports

Class PredAccuracyIntervalQuery

java.lang.Object

org.transitime.reports.PredictionAccuracyQuery

org.transitime.reports.PredAccuracyIntervalQuery

public class PredAccuracyIntervalQuery
extends PredictionAccuracyQuery

For doing SQL query and generating JSON data for a prediction accuracy intervals chart.

Author:

SkiBu Smith

Nested Class Summary

Nested classes/interfaces inherited from class org.transitime.reports.PredictionAccuracyQuery

PredictionAccuracyQuery.IntervalsType

Constructor Summary

Constructors

Constructor and Description
PredAccuracyIntervalQuery(java.lang.String agencyId) Creates connection to database for the specified agency
PredAccuracyIntervalQuery(java.lang.String dbType, java.lang.String dbHost, java.lang.String dbName, java.lang.String dbUserName, java.lang.String dbPassword) Creates connection to database.

Method Summary

Modifier and Type	Method and Description
java.lang.String	getJson(java.lang.String beginDateStr, java.lang.String endDateStr, java.lang.String beginTimeStr, java.lang.String endTimeStr, java.lang.String[] routeIds, java.lang.String predSource, java.lang.String predType, PredictionAccuracyQuery.IntervalsType intervalsType, double intervalPercentage1, double intervalPercentage2) Performs the query and returns the data in an JSON string so that it can be used for a chart.
static void	main(java.lang.String[] args) For debugging

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PredAccuracyIntervalQuery

public PredAccuracyIntervalQuery(java.lang.String dbType,
                                 java.lang.String dbHost,
                                 java.lang.String dbName,
                                 java.lang.String dbUserName,
                                 java.lang.String dbPassword)
                          throws java.sql.SQLException

Creates connection to database.

Parameters:

dbType -

dbHost -

dbName -

dbUserName -

dbPassword -

Throws:

java.sql.SQLException

PredAccuracyIntervalQuery

public PredAccuracyIntervalQuery(java.lang.String agencyId)
                          throws java.sql.SQLException

Creates connection to database for the specified agency

Parameters:

agencyId -

Throws:

java.sql.SQLException

Method Detail

getJson

public java.lang.String getJson(java.lang.String beginDateStr,
                                java.lang.String endDateStr,
                                java.lang.String beginTimeStr,
                                java.lang.String endTimeStr,
                                java.lang.String[] routeIds,
                                java.lang.String predSource,
                                java.lang.String predType,
                                PredictionAccuracyQuery.IntervalsType intervalsType,
                                double intervalPercentage1,
                                double intervalPercentage2)
                         throws java.sql.SQLException,
                                java.text.ParseException

Performs the query and returns the data in an JSON string so that it can be used for a chart.

Parameters:

beginDateStr - Begin date for date range of data to use.

endDateStr - End date for date range of data to use. Since want to include data for the end date, 1 day is added to the end date for the query.

beginTimeStr - For specifying time of day between the begin and end date to use data for. Can thereby specify a date range of a week but then just look at data for particular time of day, such as 7am to 9am, for those days. Set to null or empty string to use data for entire day.

endTimeStr - For specifying time of day between the begin and end date to use data for. Can thereby specify a date range of a week but then just look at data for particular time of day, such as 7am to 9am, for those days. Set to null or empty string to use data for entire day.

routeIds - Specifies which routes to do the query for. Can be null for all routes or an array of route IDs.

predSource - The source of the predictions. Can be null or "" (for all), "Transitime", or "Other"

predType - Whether predictions are affected by wait stop. Can be "" (for all), "AffectedByWaitStop", or "NotAffectedByWaitStop".

intervalsType - Specifies whether should output for intervals standard deviation info, percentage info, or both.

intervalPercentage1 - For when outputting intervals as percentages. Not used if intervalsType is STD_DEV.

intervalPercentage2 - For when outputting intervals as percentages. Only used if intervalsType is PERCENTAGE.

Returns:

the full JSON string contain both columns and rows info, or null if no data returned from query

Throws:

java.sql.SQLException

java.text.ParseException

main

public static void main(java.lang.String[] args)

For debugging

Parameters:

args -