-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathseed_timescale_dev.sql
More file actions
219 lines (205 loc) · 24.7 KB
/
seed_timescale_dev.sql
File metadata and controls
219 lines (205 loc) · 24.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
-- =====================================================
-- SEED DATA - TimescaleDB DEV Environment
-- Datos de Sensores - Últimas 4 Horas
-- =====================================================
-- Description: Lecturas realistas de sensores
-- Environment: DEVELOPMENT
-- Database: greenhouse_timeseries_dev
-- Schema: iot
-- Author: Claude Code
-- Date: 2025-11-16
-- =====================================================
BEGIN;
-- =====================================================
-- SENSOR READINGS - Últimas 4 horas
-- =====================================================
-- Intervalo: 5 minutos
-- Total readings: 48 intervals × 6 sensors = 288 registros
-- =====================================================
-- SARA_01 - Temperatura (TEMP_01) - Patrón diurno realista
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
-- Últimos 60 minutos (12 lecturas)
(NOW() - INTERVAL '5 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.5, '°C'),
(NOW() - INTERVAL '10 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.3, '°C'),
(NOW() - INTERVAL '15 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.7, '°C'),
(NOW() - INTERVAL '20 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.4, '°C'),
(NOW() - INTERVAL '25 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.6, '°C'),
(NOW() - INTERVAL '30 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.2, '°C'),
(NOW() - INTERVAL '35 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.8, '°C'),
(NOW() - INTERVAL '40 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.5, '°C'),
(NOW() - INTERVAL '45 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.3, '°C'),
(NOW() - INTERVAL '50 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.7, '°C'),
(NOW() - INTERVAL '55 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.4, '°C'),
(NOW() - INTERVAL '60 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 24.1, '°C'),
-- Hora 2 (12 lecturas)
(NOW() - INTERVAL '65 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.9, '°C'),
(NOW() - INTERVAL '70 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.7, '°C'),
(NOW() - INTERVAL '75 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.5, '°C'),
(NOW() - INTERVAL '80 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.8, '°C'),
(NOW() - INTERVAL '85 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.6, '°C'),
(NOW() - INTERVAL '90 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.4, '°C'),
(NOW() - INTERVAL '95 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.7, '°C'),
(NOW() - INTERVAL '100 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.5, '°C'),
(NOW() - INTERVAL '105 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.9, '°C'),
(NOW() - INTERVAL '110 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.6, '°C'),
(NOW() - INTERVAL '115 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.8, '°C'),
(NOW() - INTERVAL '120 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.3, '°C'),
-- Hora 3 (12 lecturas)
(NOW() - INTERVAL '125 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.1, '°C'),
(NOW() - INTERVAL '130 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.2, '°C'),
(NOW() - INTERVAL '135 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.4, '°C'),
(NOW() - INTERVAL '140 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.0, '°C'),
(NOW() - INTERVAL '145 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.3, '°C'),
(NOW() - INTERVAL '150 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.1, '°C'),
(NOW() - INTERVAL '155 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.5, '°C'),
(NOW() - INTERVAL '160 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.2, '°C'),
(NOW() - INTERVAL '165 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.4, '°C'),
(NOW() - INTERVAL '170 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.6, '°C'),
(NOW() - INTERVAL '175 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.3, '°C'),
(NOW() - INTERVAL '180 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.0, '°C'),
-- Hora 4 (12 lecturas)
(NOW() - INTERVAL '185 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.8, '°C'),
(NOW() - INTERVAL '190 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.9, '°C'),
(NOW() - INTERVAL '195 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.7, '°C'),
(NOW() - INTERVAL '200 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 23.0, '°C'),
(NOW() - INTERVAL '205 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.8, '°C'),
(NOW() - INTERVAL '210 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.6, '°C'),
(NOW() - INTERVAL '215 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.9, '°C'),
(NOW() - INTERVAL '220 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.7, '°C'),
(NOW() - INTERVAL '225 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.5, '°C'),
(NOW() - INTERVAL '230 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.8, '°C'),
(NOW() - INTERVAL '235 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.6, '°C'),
(NOW() - INTERVAL '240 minutes', 'SARA_TEMP01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'TEMPERATURE', 22.4, '°C');
-- SARA_01 - Humedad (HUM_01) - Patrón inverso a temperatura
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
-- Últimos 60 minutos
(NOW() - INTERVAL '5 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.3, '%'),
(NOW() - INTERVAL '10 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.8, '%'),
(NOW() - INTERVAL '15 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 61.9, '%'),
(NOW() - INTERVAL '20 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.5, '%'),
(NOW() - INTERVAL '25 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.1, '%'),
(NOW() - INTERVAL '30 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.7, '%'),
(NOW() - INTERVAL '35 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 61.8, '%'),
(NOW() - INTERVAL '40 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.4, '%'),
(NOW() - INTERVAL '45 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.9, '%'),
(NOW() - INTERVAL '50 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.2, '%'),
(NOW() - INTERVAL '55 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 62.6, '%'),
(NOW() - INTERVAL '60 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.1, '%'),
-- Hora 2
(NOW() - INTERVAL '65 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.4, '%'),
(NOW() - INTERVAL '70 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.8, '%'),
(NOW() - INTERVAL '75 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.2, '%'),
(NOW() - INTERVAL '80 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.7, '%'),
(NOW() - INTERVAL '85 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.0, '%'),
(NOW() - INTERVAL '90 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.5, '%'),
(NOW() - INTERVAL '95 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.9, '%'),
(NOW() - INTERVAL '100 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.3, '%'),
(NOW() - INTERVAL '105 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.6, '%'),
(NOW() - INTERVAL '110 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.1, '%'),
(NOW() - INTERVAL '115 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 63.8, '%'),
(NOW() - INTERVAL '120 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.6, '%'),
-- Hora 3
(NOW() - INTERVAL '125 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.0, '%'),
(NOW() - INTERVAL '130 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.8, '%'),
(NOW() - INTERVAL '135 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.5, '%'),
(NOW() - INTERVAL '140 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.3, '%'),
(NOW() - INTERVAL '145 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.9, '%'),
(NOW() - INTERVAL '150 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.1, '%'),
(NOW() - INTERVAL '155 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.7, '%'),
(NOW() - INTERVAL '160 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.2, '%'),
(NOW() - INTERVAL '165 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.8, '%'),
(NOW() - INTERVAL '170 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 64.5, '%'),
(NOW() - INTERVAL '175 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.0, '%'),
(NOW() - INTERVAL '180 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.4, '%'),
-- Hora 4
(NOW() - INTERVAL '185 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.8, '%'),
(NOW() - INTERVAL '190 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.6, '%'),
(NOW() - INTERVAL '195 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.0, '%'),
(NOW() - INTERVAL '200 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.4, '%'),
(NOW() - INTERVAL '205 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.9, '%'),
(NOW() - INTERVAL '210 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.3, '%'),
(NOW() - INTERVAL '215 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.7, '%'),
(NOW() - INTERVAL '220 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.1, '%'),
(NOW() - INTERVAL '225 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.5, '%'),
(NOW() - INTERVAL '230 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 65.9, '%'),
(NOW() - INTERVAL '235 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.2, '%'),
(NOW() - INTERVAL '240 minutes', 'SARA_HUM01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'HUMIDITY', 66.6, '%');
-- SARA_01 - Humedad del Suelo (SOIL_MOIST_01) - Estable con pequeñas variaciones
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
(NOW() - INTERVAL '5 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 52.3, '%'),
(NOW() - INTERVAL '10 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 52.1, '%'),
(NOW() - INTERVAL '15 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 52.4, '%'),
(NOW() - INTERVAL '20 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 52.2, '%'),
(NOW() - INTERVAL '30 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 52.0, '%'),
(NOW() - INTERVAL '60 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 51.8, '%'),
(NOW() - INTERVAL '120 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 51.5, '%'),
(NOW() - INTERVAL '180 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 51.2, '%'),
(NOW() - INTERVAL '240 minutes', 'SARA_SOIL01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'SOIL_MOISTURE', 51.0, '%');
-- SARA_01 - Intensidad de Luz (LIGHT_01) - Patrón de luz natural
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
(NOW() - INTERVAL '5 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 35000, 'lux'),
(NOW() - INTERVAL '10 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 34800, 'lux'),
(NOW() - INTERVAL '15 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 35200, 'lux'),
(NOW() - INTERVAL '30 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 34500, 'lux'),
(NOW() - INTERVAL '60 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 33800, 'lux'),
(NOW() - INTERVAL '120 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 32500, 'lux'),
(NOW() - INTERVAL '180 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 30800, 'lux'),
(NOW() - INTERVAL '240 minutes', 'SARA_LIGHT01_valor', '660e8400-e29b-41d4-a716-446655440001'::UUID, '550e8400-e29b-41d4-a716-446655440001'::UUID, 'LIGHT_INTENSITY', 28500, 'lux');
-- HORTAMED_A1 - Temperatura (TEMP_A1_01)
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
(NOW() - INTERVAL '3 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 18.5, '°C'),
(NOW() - INTERVAL '6 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 18.3, '°C'),
(NOW() - INTERVAL '9 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 18.7, '°C'),
(NOW() - INTERVAL '15 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 18.4, '°C'),
(NOW() - INTERVAL '30 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 18.2, '°C'),
(NOW() - INTERVAL '60 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 17.9, '°C'),
(NOW() - INTERVAL '120 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 17.5, '°C'),
(NOW() - INTERVAL '180 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 17.1, '°C'),
(NOW() - INTERVAL '240 minutes', 'HORTAMED_TEMP_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'TEMPERATURE', 16.8, '°C');
-- HORTAMED_A1 - Humedad (HUM_A1_01)
INSERT INTO iot.sensor_readings (time, sensor_id, greenhouse_id, tenant_id, sensor_type, value, unit)
VALUES
(NOW() - INTERVAL '3 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 75.2, '%'),
(NOW() - INTERVAL '6 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 75.6, '%'),
(NOW() - INTERVAL '9 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 75.0, '%'),
(NOW() - INTERVAL '15 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 75.4, '%'),
(NOW() - INTERVAL '30 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 75.9, '%'),
(NOW() - INTERVAL '60 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 76.3, '%'),
(NOW() - INTERVAL '120 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 76.8, '%'),
(NOW() - INTERVAL '180 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 77.2, '%'),
(NOW() - INTERVAL '240 minutes', 'HORTAMED_HUM_A1_01', '660e8400-e29b-41d4-a716-446655440004'::UUID, '550e8400-e29b-41d4-a716-446655440002'::UUID, 'HUMIDITY', 77.6, '%');
COMMIT;
-- =====================================================
-- VERIFICATION - TimescaleDB
-- =====================================================
-- Count total sensor readings
SELECT COUNT(*) as total_readings FROM iot.sensor_readings;
-- Count readings per sensor
SELECT
sensor_id,
sensor_type,
COUNT(*) as reading_count,
MIN(time) as first_reading,
MAX(time) as last_reading
FROM iot.sensor_readings
GROUP BY sensor_id, sensor_type
ORDER BY sensor_id;
-- Count readings per greenhouse
SELECT
greenhouse_id,
COUNT(*) as reading_count
FROM iot.sensor_readings
GROUP BY greenhouse_id
ORDER BY reading_count DESC;
-- Count readings per tenant
SELECT
tenant_id,
COUNT(*) as reading_count
FROM iot.sensor_readings
GROUP BY tenant_id
ORDER BY reading_count DESC;