{'Station': 'VARCHAR(16) NOT NULL', 'StationName': 'VARCHAR(128)', 'Readtime': 'VARCHAR(64)', 'Temperature': 'DECIMAL(6,2) DEFAULT 0', 'Windspeed': 'DECIMAL(6,2) DEFAULT 0', 'WindDirection': 'VARCHAR(16)', 'Lasttouch': 'DATETIME', 'Humidity': 'DECIMAL(6,2) DEFAULT 0', 'Module': 'VARCHAR(255)', 'PRIMARY_KEY': 'Station'}
{'Station': 'VARCHAR(16) NOT NULL', 'Readtime': 'VARCHAR(64) NOT NULL', 'Temperature': 'DECIMAL(6,2) DEFAULT 0', 'Windspeed': 'DECIMAL(6,2) DEFAULT 0', 'WindDirection': 'VARCHAR(16)', 'Lasttouch': 'DATETIME', 'Humidity': 'DECIMAL(6,2) DEFAULT 0', 'Module': 'VARCHAR(255)'}
CREATE TABLE IF NOT EXISTS `def_weather` (
`Station` CHAR(25) NOT NULL DEFAULT '',
`Package` VARCHAR(255) NOT NULL DEFAULT '',
`Module` VARCHAR(255)
DEFAULT 'ObjServiceWeather',
`Infrastructure` CHAR(1)
NOT NULL DEFAULT '',
`StationName` CHAR(255)
NOT NULL DEFAULT '',
PRIMARY KEY (`Station`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE={collation}
REPLACE INTO data_weather_current
(Station, StationName, Readtime,
Temperature, Windspeed,
WindDirection, Lasttouch, Humidity, Module)
VALUES
('{station}', '{station_name}', '{read_time}',
{temperature}, {wind_speed},
'{wind_direction}', NOW(), {humidity},
'ObjServiceWeather')
INSERT INTO data_weather_history
(Station, Readtime, Temperature,
Windspeed, WindDirection,
Lasttouch, Humidity, Module)
VALUES
('{station}', '{read_time}',
{temperature}, {wind_speed},
'{wind_direction}', NOW(), {humidity},
'ObjServiceWeather')
SELECT Station, StationName, Readtime,
Temperature, Windspeed,
WindDirection, Humidity
FROM data_weather_current WHERE Station = '{station}'
SELECT Readtime, Temperature, Windspeed,
WindDirection, Humidity
FROM data_weather_history WHERE Station = '{station}' ORDER BY Readtime DESC LIMIT {limit}
SELECT Station, StationName, Readtime,
Temperature, Humidity, Windspeed
FROM data_weather_current ORDER BY Station