-
Notifications
You must be signed in to change notification settings - Fork 0
/
script.log
29 lines (29 loc) · 2.42 KB
/
script.log
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
[Mon Nov 11 12:08:22 AM JST 2024] Fetching device data...
[Mon Nov 11 12:08:26 AM JST 2024] 'last-24-hours.json' downloaded, filtered, and formatted successfully.
[Mon Nov 11 12:08:26 AM JST 2024] Validating processed data...
[Mon Nov 11 12:08:26 AM JST 2024] All records contain the 'device' field.
[Mon Nov 11 12:08:27 AM JST 2024] Validation completed.
[Mon Nov 11 12:08:27 AM JST 2024] Running DuckDB SQL script to create table and insert data...
[Mon Nov 11 12:08:27 AM JST 2024] DuckDB SQL script executed successfully.
[Mon Nov 11 12:08:27 AM JST 2024] Checking if 'device_filename' column exists in 'measurements' table...
[Mon Nov 11 12:08:27 AM JST 2024] Column existence count: 1
[Mon Nov 11 12:08:27 AM JST 2024] 'device_filename' column already exists in 'measurements' table.
[Mon Nov 11 12:08:27 AM JST 2024] Filtering and transforming devices for 'last-24-hours.json'...
[Mon Nov 11 12:08:27 AM JST 2024] 'last-24-hours.json' created with 'device_filename' field.
[Mon Nov 11 12:08:27 AM JST 2024] Filtering and transforming devices for 'last-24-hours-air.json'...
[Mon Nov 11 12:08:27 AM JST 2024] 'last-24-hours-air.json' created with 'device_filename' field.
[Mon Nov 11 12:08:27 AM JST 2024] Filtering and transforming devices for 'last-24-hours-radiation-7318u.json'...
[Mon Nov 11 12:08:27 AM JST 2024] 'last-24-hours-radiation-7318u.json' created with 'device_filename' field.
[Mon Nov 11 12:08:27 AM JST 2024] Filtering and transforming devices for 'last-24-hours-radiation-7318c.json'...
[Mon Nov 11 12:08:27 AM JST 2024] 'last-24-hours-radiation-7318c.json' created with 'device_filename' field.
[Mon Nov 11 12:08:27 AM JST 2024] Filtering and transforming devices for 'last-24-hours-radiation-712ec.json'...
[Mon Nov 11 12:08:27 AM JST 2024] 'last-24-hours-radiation-712ec.json' created with 'device_filename' field.
[Mon Nov 11 12:08:27 AM JST 2024] Filtered and transformed outputs written to:
[Mon Nov 11 12:08:27 AM JST 2024] last-24-hours.json
[Mon Nov 11 12:08:27 AM JST 2024] last-24-hours-air.json
[Mon Nov 11 12:08:27 AM JST 2024] last-24-hours-radiation-7318u.json
[Mon Nov 11 12:08:27 AM JST 2024] last-24-hours-radiation-7318c.json
[Mon Nov 11 12:08:27 AM JST 2024] last-24-hours-radiation-712ec.json
[Mon Nov 11 12:08:27 AM JST 2024] Total measurements in DuckDB: 161473
[Mon Nov 11 12:08:27 AM JST 2024] Running Python script to export device_urn JSON files...
[Mon Nov 11 12:08:34 AM JST 2024] Device URN JSON files exported successfully.