Use DuckDB to store device states

Pierre-Gilles commented 1 month ago

Pull Request check-list

To ensure your Pull Request can be accepted as fast as possible, make sure to review and check all of these items:

[ ] If your changes affects code, did your write the tests?
[ ] Are tests passing? (npm test on both front/server)
[ ] Is the linter passing? (npm run eslint on both front/server)
[ ] Did you run prettier? (npm run prettier on both front/server)
[ ] If you are adding a new features/services, did you run integration comparator? (npm run compare-translations on front)
[ ] Did you test this pull request in real life? With real devices? If this development is a big feature or a new service, we recommend that you provide a Docker image to the community (french forum/english forum) for testing before merging.
[ ] If your changes modify the API (REST or Node.js), did you modify the API documentation? (Documentation is based on comments in code)
[ ] If you are adding a new features/services which needs explanation, did you modify the user documentation? See the GitHub repo and the website.
[ ] Did you add fake requests data for the demo mode (front/src/config/demo.js) so that the demo website is working without a backend? (if needed) See https://demo.gladysassistant.com.

NOTE: these things are not required to open a PR and can be done afterwards / while the PR is open.

Description of change

Please provide a description of the change here. It's always best with screenshots, so don't hesitate to add some!

cloudflare-pages[bot] commented 1 month ago

Deploying gladys-plus with Cloudflare Pages

Latest commit:	`3b84732`
Status:	✅ Deploy successful!
Preview URL:	https://1f36babd.gladys-plus.pages.dev
Branch Preview URL:	https://duckdb.gladys-plus.pages.dev

View logs

codecov[bot] commented 1 month ago

Codecov Report

Attention: Patch coverage is 99.06542% with 2 lines in your changes missing coverage. Please review.

Project coverage is 98.48%. Comparing base (41755fd) to head (3b84732).

Files	Patch %	Lines
server/lib/device/device.purgeAllSqliteStates.js	94.87%	2 Missing :warning:

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #2104 +/- ## ========================================== + Coverage 98.41% 98.48% +0.06% ========================================== Files 865 865 Lines 14169 14153 -16 ========================================== - Hits 13945 13938 -7 + Misses 224 215 -9 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

relativeci[bot] commented 1 month ago

#2680 Bundle Size — 10.19MiB (+0.14%).

3b84732(current) vs 41755fd master#2665(baseline)

[!WARNING] Bundle contains 3 duplicate packages – View duplicate packages

Bundle metrics 3 changes 1 regression

	Current #2680	Baseline #2665
Initial JS	`5.5MiB`(`+0.22%`)	`5.49MiB`
Initial CSS	`303.12KiB`	`303.12KiB`
Cache Invalidation	`63.18%`	`53.79%`
Chunks	`51`	`51`
Assets	`171`	`171`
Modules	`1490`	`1490`
Duplicate Modules	`21`	`21`
Duplicate Code	`0.83%`(`+1.22%`)	`0.82%`
Packages	`124`	`124`
Duplicate Packages	`3`	`3`

Bundle size by type Change

1 change

1 regression

| | Current
[#2680](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o?utm_source=github&utm_medium=pr-report "View bundle analysis report") | Baseline
[#2665](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2665-IW9wW3mdeWqvjCmghkn1?utm_source=github&utm_medium=pr-report "View baseline bundle analysis report") | |:--|--:|--:| | [JS](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-0_ft.JS-1_ft.IMG-0_ft.MEDIA-0_ft.FONT-0_ft.HTML-0_ft.OTHER-0%22%7D "View JS assets") | `7.28MiB` (`+0.19%`) | `7.27MiB` | | No change

[IMG](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-0_ft.JS-0_ft.IMG-1_ft.MEDIA-0_ft.FONT-0_ft.HTML-0_ft.OTHER-0%22%7D "View IMG assets") | `2.48MiB` | `2.48MiB` | | No change

[CSS](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-1_ft.JS-0_ft.IMG-0_ft.MEDIA-0_ft.FONT-0_ft.HTML-0_ft.OTHER-0%22%7D "View CSS assets") | `319.91KiB` | `319.91KiB` | | No change

[Fonts](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-0_ft.JS-0_ft.IMG-0_ft.MEDIA-0_ft.FONT-1_ft.HTML-0_ft.OTHER-0%22%7D "View Fonts assets") | `93.55KiB` | `93.55KiB` | | No change

[Other](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-0_ft.JS-0_ft.IMG-0_ft.MEDIA-0_ft.FONT-0_ft.HTML-0_ft.OTHER-1%22%7D "View Other assets") | `17.62KiB` | `17.62KiB` | | No change

[HTML](https://app.relative-ci.com/projects/PUROh8FAVkDKmpUrqr4u/jobs/2680-Px6IkG3C3632bGtMhB6o/assets?ba=%7B%22filters%22%3A%22ft.CSS-0_ft.JS-0_ft.IMG-0_ft.MEDIA-0_ft.FONT-0_ft.HTML-1_ft.OTHER-0%22%7D "View HTML assets") | `13.58KiB` | `13.58KiB` |

Bundle analysis report Branch duckdb Project dashboard

^{Generated by RelativeCI Documentation Report issue}

GladysAssistant / Gladys