-- [event] begin

PRAGMA foreign_keys = ON;

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region ORDER BY region.id ASC

SELECT station.id AS station_id, station.name AS station_name, station.region_id AS station_region_id, station.sourcehistory AS station_sourcehistory, station.sourceforecastshort AS station_sourceforecastshort, station.sourceforecastlong AS station_sourceforecastlong, station.sequence AS station_sequence, station.altitude AS station_altitude, station.mapx AS station_mapx, station.mapy AS station_mapy 
FROM station ORDER BY station.sequence ASC

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT region.id AS region_id, region.name AS region_name, region.code AS region_code 
FROM region 
WHERE region.id = ?

SELECT history.id AS history_id, history.dt AS history_dt, history.day AS history_day, history.station_id AS history_station_id, history.sunrise AS history_sunrise, history.sunset AS history_sunset, history.cloudcover AS history_cloudcover, history.weatherevent AS history_weatherevent, history.radiationsun AS history_radiationsun, history.temperature AS history_temperature, history.humidity AS history_humidity, history.precipitation AS history_precipitation, history.windspeed AS history_windspeed, history.winddirection AS history_winddirection, history.temperatureground AS history_temperatureground, history.snowcover AS history_snowcover 
FROM history 
WHERE history.station_id = ? AND history.dt > ? ORDER BY history.dt ASC

SELECT station.id AS station_id, station.name AS station_name, station.region_id AS station_region_id, station.sourcehistory AS station_sourcehistory, station.sourceforecastshort AS station_sourceforecastshort, station.sourceforecastlong AS station_sourceforecastlong, station.sequence AS station_sequence, station.altitude AS station_altitude, station.mapx AS station_mapx, station.mapy AS station_mapy 
FROM station 
WHERE station.id = ?

SELECT aggregate.id AS aggregate_id, aggregate.dt AS aggregate_dt, aggregate.station_id AS aggregate_station_id, aggregate.data_count AS aggregate_data_count, aggregate.radiationsun_sum AS aggregate_radiationsun_sum, aggregate.radiationsun_count AS aggregate_radiationsun_count, aggregate.temperature_max AS aggregate_temperature_max, aggregate.temperature_avg AS aggregate_temperature_avg, aggregate.temperature_min AS aggregate_temperature_min, aggregate.temperature_count AS aggregate_temperature_count, aggregate.humidity_max AS aggregate_humidity_max, aggregate.humidity_avg AS aggregate_humidity_avg, aggregate.humidity_min AS aggregate_humidity_min, aggregate.humidity_count AS aggregate_humidity_count, aggregate.precipitation_sum AS aggregate_precipitation_sum, aggregate.precipitation_count AS aggregate_precipitation_count, aggregate.windspeed_avg AS aggregate_windspeed_avg, aggregate.windspeed_count AS aggregate_windspeed_count, aggregate.winddirection_max AS aggregate_winddirection_max, aggregate.winddirection_count AS aggregate_winddirection_count, aggregate.temperatureground_max AS aggregate_temperatureground_max, aggregate.temperatureground_avg AS aggregate_temperatureground_avg, aggregate.temperatureground_min AS aggregate_temperatureground_min, aggregate.temperatureground_count AS aggregate_temperatureground_count, aggregate.snowcover_max AS aggregate_snowcover_max, aggregate.snowcover_avg AS aggregate_snowcover_avg, aggregate.snowcover_min AS aggregate_snowcover_min, aggregate.snowcover_count AS aggregate_snowcover_count 
FROM station JOIN aggregate ON station.id = aggregate.station_id 
WHERE aggregate.station_id = ? AND aggregate.dt > ? AND aggregate.dt < ? ORDER BY aggregate.dt ASC
 LIMIT ? OFFSET ?

SELECT station.id AS station_id, station.name AS station_name, station.region_id AS station_region_id, station.sourcehistory AS station_sourcehistory, station.sourceforecastshort AS station_sourceforecastshort, station.sourceforecastlong AS station_sourceforecastlong, station.sequence AS station_sequence, station.altitude AS station_altitude, station.mapx AS station_mapx, station.mapy AS station_mapy 
FROM station 
WHERE station.id = ?

-- [event] rollback