d1d4d529a8
Add methods to handle SOS events and device status updates in Firebase and our DB
2025-06-23 08:10:33 -06:00
cf19f08dca
turn on all the updates data points
2025-06-23 07:33:01 -06:00
ff370b2baa
Implement message queue for TuyaWebSocketService and batch processing
2025-06-23 07:31:58 -06:00
04f64407e1
turn off some update data points
2025-06-23 07:10:47 -06:00
d7eef5d03e
Merge pull request #427 from SyncrowIOT/revert-426-SP-1778-be-fix-time-out-connections-in-the-db
...
Revert "SP-1778-be-fix-time-out-connections-in-the-db"
2025-06-23 07:09:20 -06:00
c8d691b380
tern off data procedure
2025-06-23 07:02:23 -06:00
75d03366c2
Revert "SP-1778-be-fix-time-out-connections-in-the-db"
2025-06-23 06:58:57 -06:00
52cb69cc84
Merge pull request #426 from SyncrowIOT/SP-1778-be-fix-time-out-connections-in-the-db
...
SP-1778-be-fix-time-out-connections-in-the-db
2025-06-23 06:38:58 -06:00
a6053b3971
refactor: implement query runners for database operations in multiple services
2025-06-23 06:34:53 -06:00
60d2c8330b
fix: increase DB max pool size ( #425 )
2025-06-23 15:23:53 +03:00
fddd06e06d
fix: add space condition to the join operator instead of general query ( #423 )
2025-06-23 12:44:19 +03:00
3160773c2a
fix: spaces structure in communities ( #420 )
2025-06-23 10:21:55 +03:00
110ed4157a
task: add spaces filter to get devices by project ( #422 )
2025-06-23 09:34:59 +03:00
aa9e90bf08
Test/prevent server block on rate limit ( #419 )
...
* increase DB max connection to 50
2025-06-19 14:34:23 +03:00
c5dd5e28fd
Test/prevent server block on rate limit ( #418 )
2025-06-19 13:54:22 +03:00
603e74af09
Test/prevent server block on rate limit ( #417 )
...
* task: add trust proxy header
* add logging
* task: test rate limits on sever
* task: increase rate limit timeout
* fix: merge conflicts
2025-06-19 12:54:59 +03:00
0e36f32ed6
Test/prevent server block on rate limit ( #415 )
...
* task: increase rate limit timeout
2025-06-19 10:15:29 +03:00
705ceeba29
Test/prevent server block on rate limit ( #414 )
...
* task: test rate limits on sever
2025-06-19 09:45:09 +03:00
a37d5bb299
task: add trust proxy header ( #411 )
...
* task: add trust proxy header
* add logging
2025-06-18 12:05:53 +03:00
689a38ee0c
Revamp/space management ( #409 )
...
* task: add getCommunitiesV2
* task: update getOneSpace API to match revamp structure
* refactor: implement modifications to pace management APIs
* refactor: remove space link
2025-06-18 10:34:29 +03:00
a91d0f22a4
fix: send correct enable status to email sender function ( #407 )
2025-06-13 09:46:41 +03:00
0db060ae3f
Merge pull request #406 from SyncrowIOT/add-space-daily-occupancy-duration-entity
...
feat: add SpaceDailyOccupancyDuration entity, DTO, and repository for occupancy tracking
2025-06-12 04:17:18 -06:00
f2ed04f206
feat: add SpaceDailyOccupancyDuration entity, DTO, and repository for occupancy tracking
2025-06-12 02:49:59 -06:00
ea9a65178d
fix: add space filter to "join" operation instead of "and" operation ( #405 )
2025-06-11 16:28:33 +03:00
8503ee728d
Refactor/space management ( #404 )
...
* refactor: reducing used queries on get communities (#385 )
* refactor: fix create space logic (#394 )
* Remove unique constraint on subspace and product in SubspaceProductAllocationEntity; update product relation to nullable in NewTagEntity
* refactor: fix create space logic
* device model updated to include the fixes and final columns
* updated space models to include suggested fixes, update final logic and column names
* task: removing old references of the old tag-product relation
* task: remove old use of tags
* task: remove old tag & tag model usage
* refactor: delete space
* task: remove unused functions
* fix lint rule
2025-06-11 13:15:21 +03:00
4f5e1b23f6
Merge pull request #403 from SyncrowIOT/SP-1629-AND-SP-1630-AQI-APIs
...
Sp 1629 and sp 1630 aqi ap is
2025-06-11 00:28:14 -06:00
2cb77504ca
Add PollutantType enum and update AQI-related entities and services to use it
2025-06-11 00:28:00 -06:00
c86be27576
Add AQI module and related services, controllers, and DTOs
...
- Introduced AqiModule with AqiService and AqiController for handling AQI data.
- Added DTOs for AQI requests: GetAqiDailyBySpaceDto and GetAqiPollutantBySpaceDto.
- Implemented AqiDataService for managing AQI sensor historical data.
- Updated existing modules to include AqiDataService where necessary.
- Defined new routes for AQI data retrieval in ControllerRoute.
2025-06-10 18:19:34 -06:00
3a08f9f258
Merge branch 'dev' into aqi-test
2025-06-10 17:08:06 -06:00
5c96a3b117
Merge pull request #402 from SyncrowIOT/add-code-and-value-as-uniqe-key
...
Refactor DeviceStatusLogEntity: expand unique constraint to include c…
2025-06-10 01:43:09 -06:00
97e14e70f7
Refactor DeviceStatusLogEntity: expand unique constraint to include code and value
2025-06-10 01:41:41 -06:00
03d44cb14f
Merge pull request #401 from SyncrowIOT/fix-log-insert-error
...
Refactor DeviceStatusLogEntity: update unique constraint to include d…
2025-06-10 01:27:15 -06:00
0793441e06
Refactor DeviceStatusLogEntity: correct unique constraint name for event time and device ID
2025-06-10 01:24:33 -06:00
b6321c2530
Refactor DeviceStatusLogEntity: update unique constraint to include deviceId
2025-06-10 01:18:58 -06:00
b8d34b0d9f
Merge pull request #400 from SyncrowIOT/revert-398-fix-log-duplication-issue
...
Revert "Refactor DeviceStatusLogEntity: update unique constraint and primary …"
2025-06-10 01:04:29 -06:00
c1065126aa
Revert "Refactor DeviceStatusLogEntity: update unique constraint and primary …"
2025-06-10 01:03:45 -06:00
1742454984
Merge pull request #398 from SyncrowIOT/fix-log-duplication-issue
...
Refactor DeviceStatusLogEntity: update unique constraint and primary …
2025-06-10 00:26:43 -06:00
7eb13088ac
Refactor DeviceStatusLogEntity: update unique constraint and primary key definition
2025-06-09 04:50:58 -06:00
7b97e50d2e
Merge pull request #391 from SyncrowIOT/DATA-space-model-aqi-update-logic
...
AQI space model updated with new hourly to daily logic for calculatio…
2025-06-04 17:40:39 -04:00
4fb26fc131
Merge pull request #397 from SyncrowIOT/DATA-daily-procedure-aqi
...
Procedures insert-all, update, and select for daily space air quality…
2025-06-04 17:39:34 -04:00
ee0261d102
Fix typos procedure select and update
2025-06-04 17:32:50 -04:00
0d6de2df43
Refactor AqiSpaceDailyPollutantStatsEntity: update unique constraint and rename event fields for clarity
2025-06-04 15:24:13 -06:00
80e89dd035
fix name of snapshot table
2025-06-04 17:20:25 -04:00
466863e71f
Procedures insert-all, update, and select for daily space air quality stats
2025-06-04 16:33:55 -04:00
30aafdede6
Merge pull request #390 from SyncrowIOT/DATA-device-model-aqi-update-logic
...
device model for aqi updated with hourly to daily logic getting max, …
2025-06-04 12:04:10 +03:00
01ce4d4b29
Merge pull request #396 from SyncrowIOT/fix-some-issue-in-get-commuinty-and-weather-apis
...
Fix some issue in get commuinty and weather apis
2025-06-04 01:32:21 -06:00
43dfaaa90d
fix: utilize WEATHER_API_URL in WeatherService for dynamic API endpoint
2025-06-04 01:32:01 -06:00
ea021ad228
fix: update error message for invalid latitude and longitude in fetchWeatherDetails method
2025-06-04 01:09:49 -06:00
cd3e9016f2
fix: improve error handling in fetchWeatherDetails method
2025-06-04 01:08:33 -06:00
ef2245eae1
Add AQI space daily pollutant stats module and related entities, DTOs, and repositories
2025-06-03 23:37:52 -06:00
