public class WeatherSql extends EnvironmentSql
| Modifier and Type | Class and Description |
|---|---|
static class |
WeatherSql.Derivative
This class derives derivatives of weather sensor data at a given date.
|
static class |
WeatherSql.Focus
This class reads a focus optimum output file and calculates the
derivatives of the ambient and bay temperature at the times of measure.
|
static class |
WeatherSql.Interpolate
Interpolates the value of the stated sensor at the given date.
|
static class |
WeatherSql.Radar |
AbstractSql.Columns, AbstractSql.ExtractPropertyResources.Load, PropertyResources.URLResource| Modifier and Type | Field and Description |
|---|---|
private static String |
DATEDIFF
Used as a customized name for a second-length intervall date diff.
|
static String |
DATEKEY
The key for the DATE column.
|
private static String |
DATEORDER
Used as a customized name for a second-length intervall date diff.
|
static int |
ORDER
Default order of interpolating derivatives, 1=linear.
|
KEY_DATEFIELD, KEY_GOODFIELD, KEY_INTERVALKEY_TABLE, SQLBATCHDIR, SQLFAILDIRKEY_NOINITONCREATE, POSTFIX_ALPHABET, POSTFIX_BYTES, POSTFIX_DIR, POSTFIX_EXT, POSTFIX_FILE, POSTFIX_LIST, POSTFIX_MODTIME, POSTFIX_URLKEY_LISTSEPARATOR, KEY_MAPKEYVALUECHAR, KEY_MAPSEPARATORKEY_URLRESOURCES, KEY_URLUSECONFIG, KEY_URLUSECURRENT, KEY_URLUSEHOMECONFIG, KEY_CLASS| Constructor and Description |
|---|
WeatherSql(Map<String,String> prop)
Constructs a new history database.
|
| Modifier and Type | Method and Description |
|---|---|
List<Double> |
getDerivatives(List<String> sensors,
Date at)
Returns a list of differences usable as derivatives of the queried sensor
names to seconds.
|
List<Double> |
getDerivatives(List<String> sensors,
Date at,
int n)
Returns a list of differences usable as derivatives of the queried sensor
names to seconds.
|
Map<String,Double> |
getInterpolationAt(List<WeatherSql.Radar> whole,
Date at)
Parabolic interpolation of all sensor values found in the db dump.
|
List<WeatherSql.Radar> |
getWeather(List<String> sensors,
Date from,
Date to)
Returns a list of
HistoryAware.Picks of all targets that have
been picked between the given dates. |
private static Map<String,Double> |
parabolic(WeatherSql.Radar r0,
WeatherSql.Radar r1,
WeatherSql.Radar r2,
Date at) |
static void |
sort(List<WeatherSql.Radar> whole)
Sorts a list of weather entries grabbed from the db into natural ordering
of the date
|
countAll, countGood, getIntervaldelete, distinct, distinct, exit, getAccess, getDefaultArchive, getDefaultFormat, getTable, init, insert, isEntry, release, release, replace, retrieve, retrieve, retrieve, single, singleclone, createFrom, createFrom, createFrom, createInstance, getApplet, getAsResources, getLocate, getPropertiesToKey, getPropertiesToKey, getResource, getResourceAsStream, getResourceFromKey, getResources, hasLocalURLs, initProperties, keyCreate, keyCreate, reload, setAppletaugment, augment, augment, augment, augment, defaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsEnums, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, isNew, parseObject, parseObject, reload, removeProperty, requires, rescanned, setObject, setProperties, setProperty, stringProperties, toStringequals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitdefaultBoolean, defaultChar, defaultDouble, defaultFloat, defaultInt, defaultLong, defaultObject, defaultObject, defaultProperties, defaultProperty, getAsBoolean, getAsChar, getAsDouble, getAsFloat, getAsInt, getAsList, getAsLong, getAsMap, getAsObject, getAsObject, getProperties, getProperty, has, parseObject, removeProperty, setObject, setProperty, stringPropertiespublic static final int ORDER
public static final String DATEKEY
private static final String DATEDIFF
private static final String DATEORDER
public List<WeatherSql.Radar> getWeather(List<String> sensors, Date from, Date to)
HistoryAware.Picks of all targets that have
been picked between the given dates.public static void sort(List<WeatherSql.Radar> whole)
whole - public Map<String,Double> getInterpolationAt(List<WeatherSql.Radar> whole, Date at)
whole - Sorted list of sensor dataat - We want the interpolation at that time.private static Map<String,Double> parabolic(WeatherSql.Radar r0, WeatherSql.Radar r1, WeatherSql.Radar r2, Date at)
public List<Double> getDerivatives(List<String> sensors, Date at)