Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Synchronisation of command centre data with a local data source (preferably a SQL backend) #9

Open
devraj opened this issue Jun 10, 2023 · 2 comments
Open

Synchronisation of command centre data with a local data source (preferably a SQL backend) #9

devraj opened this issue Jun 10, 2023 · 2 comments
Assignees
@devraj
Milestone
beta-1

Comments

@devraj
Copy link
Member

devraj commented Jun 10, 2023

Consider the Cardholder changes endpoint which essentially provides a list of events that occurred against a cardholder. These sorts of endpoints provide valuable information for third party integrations such as the ability to provide a history of when a customer has accessed a door.

Gallagher cloud does not provide the ability to add webhooks to receive events as they occur (which probably makes sense from a deployment and possibly security perspective).

Built on top of the base API client we should provide the ability to synchronise with the command centre, these would have to be written to a backend to keep a shadow of what is available on the command centre. The ida of this is not to query the command centre when the application is rendering interfaces.

This ticket has to be expanded with the details, possibly requires an RFC.
@devraj devraj self-assigned this Aug 11, 2023
@devraj devraj mentioned this issue Nov 21, 2023
Open
@devraj devraj mentioned this issue Feb 5, 2024
Open
@devraj devraj mentioned this issue Mar 27, 2024
Open
@devraj devraj added this to the beta-1 milestone Apr 14, 2024
@devraj
Copy link
Member Author

devraj commented Apr 15, 2024 •
edited
Loading

See also article on data sync

devraj added a commit that referenced this issue Apr 18, 2024
@devraj
feat: adds shillelagh REFS #31
2d257bd 
adds shillelagh to attempt implementing a sql layer on top of the
library and see if it helps with #9

todo items for me are:
- see if pyndatic can help define sqlalchemy schema
- as per #31 i want to have a sqlclahemy dialect
- be able to sync two sources one being the rest endpoints using
sqlalchemy
@devraj devraj changed the title Provide an optional synchronisation feature for API events Synchronisation of command centre data with a local data source (preferably a SQL backend) Apr 28, 2024
@devraj
Copy link
Member Author

devraj commented Apr 29, 2024

See also #31, might be worth merging?

@devraj devraj mentioned this issue May 5, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@devraj devraj

Labels
None yet
Projects
None yet
Milestone
beta-1
Development

No branches or pull requests
1 participant
@devraj