public class WeatherDataLogger extends SqlQuery
DEFAULT_port
44444
.java ca.bc.webarts.tools.WeatherDataLogger [WEATHERSTATION_HOST] - WEATHERSTATION_HOST is optional
Modifier and Type | Field and Description |
---|---|
protected int |
debug_
Simple multi-level debug flag (0-2).The higher the number, the higher the verbosity.
|
protected static String |
DEFAULT_DB_NAME |
protected static String |
DEFAULT_DB_PASSWORD |
protected static String |
DEFAULT_DB_SERVER_HOST_IP |
protected static String |
DEFAULT_DB_USER |
protected static String |
DEFAULT_WEATHERSTATION_HOST |
protected String |
weatherDBHostIP_ |
protected String |
weatherDBName_ |
protected String |
weatherDBPassword_ |
protected String |
weatherDBUser_ |
protected String |
weatherStationHostIP_ |
protected WeatherStationRestRequester |
wsRR_ |
calendar_, columnDelimitor, con, DB2_DB, db2DbDriverName, db2DbPort, dbConnectString, dbDriverName, dbIP, dbName, dbPassword, dbPort, dbType_, dbUser, debugOut, DEFAULT_COLUMN_DELIMITOR, DEFAULT_DB, DERBY_DB, derbyDbDriverName, derbyDbPort, dy_, HSQL_DB, hsqlDbDriverName, hsqlDbPort, log_, MARIADB_DB, mariadbDbDriverName, mariadbDbPort, mo_, MYSQL_DB, mysqlDbDriverName, mysqlDbPort, ODBC_DB, odbcDbDriverName, ORACLE_DB, ORACLEDEDICATED_DB, oraDbDriverName, oraDbPort, oraDedicated_, OTHER_DB, pgDbDriverName, pgDbPort, POSTGRE_DB, proxoolDriverName, proxoolMaximumConnectionCount_, randLong, randStr, sqlFrom, sqlFrom2, sqlFrom3, sqlFrom4, sqlFrom5, sqlOrder, sqlSelect, sqlWhere, SYSTEM_FILE_SEPERATOR, SYSTEM_LINE_SEPERATOR, testDbConnectString, useProxoolPool_, yr_
Constructor and Description |
---|
WeatherDataLogger()
Default Constructor for the WeatherDataLogger object and uses the defaults weatherStation host.
|
WeatherDataLogger(String weatherStationHostIP)
Default Constructor for the WeatherDataLogger object and uses the defaults weatherStation host.
|
Modifier and Type | Method and Description |
---|---|
private String |
getLogTempSql(double temp,
String tempUnits)
Gets the SQL that will log (add a DB Table row) the temperature data.
|
void |
initiateLogging()
Starts logging all weather data to database.
|
static void |
main(String[] args) |
canConnect, canConnect, convertSqlResultsToCSV, convertSqlResultsToXLS, copyIntoWorkbook, createCurrentTimeStamp, csvToJSON, generateCategoryBarChart, generatePieChart, getColumnDelimitor, getDbConnectString, getDbDriverName, getDbIP, getDbName, getDbPassword, getDbUser, getSqlFrom, getSqlFrom2, getSqlFrom3, getSqlFrom4, getSqlFrom5, getSqlOrder, getSqlSelect, getSqlWhere, getTimeDelta, query, query, resultSetToCSVFile, saveChartToSVG, sbIntoWorkbook, sbIntoWorkbook, sbToArray, sbToArray, sbToCsv, sbToDataArray, sbToDataArray, sbToDataRowArray, sbToDataRowArray, sbToFile, sbToJSON, sbToSheet, sbToWbk, sbToWorkbook, sbToWorksheet, sbToXLS, setCaseInsensitive, setCaseSensitive, setColumnDelimitor, setDbConnectString, setDbDriverName, setDbIP, setDbName, setDbPassword, setDbUser, setSqlFrom, setSqlFrom2, setSqlFrom3, setSqlFrom4, setSqlFrom5, setSqlOrder, setSqlSelect, setSqlWhere, setUseDb2DB, setUseDerbyDB, setUseHsqlDB, setUseMariadbDB, setUseMysqlDB, setUseOdbcDB, setUseOracleDB, setUseOracleDedicatedDB, setUsePostgreDB, testDbQuery
protected static String DEFAULT_DB_SERVER_HOST_IP
protected static String DEFAULT_DB_NAME
protected static String DEFAULT_DB_USER
protected static String DEFAULT_DB_PASSWORD
protected static String DEFAULT_WEATHERSTATION_HOST
protected int debug_
protected String weatherStationHostIP_
protected String weatherDBHostIP_
protected String weatherDBName_
protected String weatherDBUser_
protected String weatherDBPassword_
protected WeatherStationRestRequester wsRR_
public WeatherDataLogger()
public WeatherDataLogger(String weatherStationHostIP)
public void initiateLogging()
private String getLogTempSql(double temp, String tempUnits)
WebARTS Library Licensed Under the GNU - General Public License. Other Libraries licensed under their respective Open Source Licenses