k-space/doorboy-proxy
11
0
Fork 0
Code Issues 4 Pull Requests Projects Activity

Harmonize database format #6

New Issue
Open
opened 2025-12-30 02:06:44 +00:00 by rasmus · 0 comments
rasmus commented 2025-12-30 02:06:44 +00:00
Owner
Copy Link

There are 3 ways to command a door:

Each write the database log in their own format, querying door logs for an user (/m/doorboy/log/) is impractical. There are schema deviations caused by duplicating code everywhere.

I would suggest a refactor:

  • k-space/todo#119 and pin all opens from Slack to a Passmower user
  • Web is untangled from inventory-app, moves to being an endpoint at doorboy-proxy, where to log in with Passmower.
  • Writes to database are by the same function. Database may be swapped out. Listening to DB writes can still stay.
There are 3 ways to command a door: - RFID - Slack - Web (via [Inventory](https://git.k-space.ee/k-space/inventory-app/src/branch/master/inventory-app/doorboy.py)) Each write the database log in their own format, querying door logs for an user (/m/doorboy/log/<user>) is impractical. There are schema deviations caused by duplicating code everywhere. I would suggest a refactor: - https://git.k-space.ee/k-space/todo/issues/119 and pin all opens from Slack to a Passmower user - Web is untangled from inventory-app, moves to being an endpoint at doorboy-proxy, where to log in with Passmower. - Writes to database are by the same function. Database may be swapped out. Listening to DB writes can still stay.
rasmus added the upkeep label 2025-12-30 02:06:44 +00:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bounty
10€
probably needs most of a visit dedicated to the task https://wiki.k-space.ee/en/about/task-bounties
bounty
20€
about a whole day or two to the task https://wiki.k-space.ee/en/about/task-bounties
bounty
5€
https://wiki.k-space.ee/en/about/task-bounties
bounty
package
See milestone, bounty for completing all issues.
disposal
Liability in safety, usability, space, or upkeep. It doesn't provide enough meaningful historical value (museum) nor personal interest.
 enchancement
Improving the existing
 greenlit
The stars have aligned: Orders have arrived, plan has been laid, only hands are needed. Just do it!
upkeep
Subjects of maintenance
No Label upkeep
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
akpall arti dos4dev eaas erki lauri madis plaes rasmus sander savva
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: k-space/doorboy-proxy#6
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?