org.transitime.reports

Class PredAccuracyRangeQuery

java.lang.Object

org.transitime.reports.PredictionAccuracyQuery

org.transitime.reports.PredAccuracyRangeQuery

public class PredAccuracyRangeQuery
extends PredictionAccuracyQuery

For generating the JSON data for a Google chart for showing percent of predictions that lie between an error range.

Author:

SkiBu Smith

Nested Class Summary

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

PredictionAccuracyQuery.IntervalsType

Constructor Summary

Constructors

Constructor and Description
PredAccuracyRangeQuery(java.lang.String agencyId) Creates connection to database specified by the agencyId.
PredAccuracyRangeQuery(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, int maxEarlySec, int maxLateSec) 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

PredAccuracyRangeQuery

public PredAccuracyRangeQuery(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

PredAccuracyRangeQuery

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

Creates connection to database specified by the agencyId.

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,
                                int maxEarlySec,
                                int maxLateSec)
                         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".

maxEarlySec - How early in msec a prediction is allowed to be. Should be a negative value.

maxLateSec - How late a in msec a prediction is allowed to be. Should be a positive value.

Returns:

the full JSON string contain both cols 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 -