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

Database notifications on stock changes #276

Closed
sde1000 opened this issue Jan 18, 2024 · 0 comments
Closed

Database notifications on stock changes #276

sde1000 opened this issue Jan 18, 2024 · 0 comments
Labels
schema-change
Milestone
EMF 2024

Comments

@sde1000
Copy link
Owner

sde1000 commented Jan 18, 2024

Add triggers to send notifications when various things happen relating to stock:

  • When the item(s) on sale on a stock line change (notify about the stock line)
  • Any changes to a stock line (stock type, note [once implemented], deletion)
  • When the amount of stock of a stock item changes

These can be used for real-time updates in a web service.
@sde1000 sde1000 added this to the EMF 2024 milestone Jan 18, 2024
sde1000 added a commit that referenced this issue Feb 9, 2024
@sde1000
Database notifications on stock changes
bd19fe1 
Adds triggers to send database notifications for changes to stock lines,
stock types and stock items.

Adds a command ('monitor') to output received notifications to the
console. This also listens for previously defined notifications.

This implements #276 on github. Apart from the 'monitor' command, the
first consumer of these notifications is expected to be the EMF 2024 bar
website.
@sde1000 sde1000 closed this as completed Feb 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
schema-change
Projects
None yet
Milestone
EMF 2024
Development

No branches or pull requests
1 participant
@sde1000