public class EnvironmentSql extends AbstractSql
AbstractSql.Columns, AbstractSql.ExtractPropertyResources.Load, PropertyResources.URLResource| Modifier and Type | Field and Description |
|---|---|
private static String |
DEFDATEFIELD
Default field name.
|
private static String |
DEFGOODFIELD
Default field name.
|
private static double |
DEFINTERVAL
Default 5 min interval.
|
private static String |
DEFTABLE
The default table name.
|
static String |
KEY_DATEFIELD
Primary key.
|
static String |
KEY_GOODFIELD
The weather-good indicator, linked to either 'y' or 'n'.
|
static String |
KEY_INTERVAL
Default seconds between weather entries.
|
KEY_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 |
|---|
EnvironmentSql(Map<String,String> prop) |
| Modifier and Type | Method and Description |
|---|---|
private int |
count(String where) |
int |
countAll(Date from,
Date to) |
int |
countGood(Date from,
Date to) |
private String |
dateConstraint(Date from,
Date to) |
double |
getInterval()
Returns the average interval between measurement entries in the env
table.
|
delete, 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 String KEY_DATEFIELD
public static final String KEY_GOODFIELD
public static final String KEY_INTERVAL
private static final String DEFTABLE
private static final String DEFDATEFIELD
private static final String DEFGOODFIELD
private static final double DEFINTERVAL
public double getInterval()
public int countAll(Date from, Date to) throws SQLException
SQLExceptionpublic int countGood(Date from, Date to) throws SQLException
SQLExceptionprivate int count(String where) throws SQLException
SQLException