public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andreas Joseph Krogh <[email protected]>
To: Steve Midgley <[email protected]>
Cc: [email protected]
Subject: Re: How to ensure a log-entry is created based on state of data in other tables
Date: Thu, 9 Feb 2023 17:33:07 +0100 (CET)
Message-ID: <VisenaEmail.6a.d3040d504876c082.1863705b248@visena.app.internal.visena.net> (raw)
In-Reply-To: <CAJexoSJT_uVdMGwne8wDBEsZEMA_jfPdz41S0W9sVoj+MugOUA@mail.gmail.com>
References: <VisenaEmail.3d.88fc3a77a99e504f.18635052f66@visena.app.internal.visena.net>
<CAJexoSJT_uVdMGwne8wDBEsZEMA_jfPdz41S0W9sVoj+MugOUA@mail.gmail.com>
På torsdag 09. februar 2023 kl. 16:08:16, skrev Steve Midgley <
[email protected] <mailto:[email protected]>>:
[…]
What is the time window required for "DONE" and "NOT_DONE" to be correct? Do
they need to be atomic (meaning the time window is effectively 0)? Or can the
system "notice" recent changes and keep track of done/not done after-the-fact?
If your time window is > 0, it seems like recurring processes could be set up
to track DONE / NOT_DONE?
Another totally different way to think about this is to create a view that
provides answers on DONE and NOT_DONE as computed values based on the
underlying state of the table at the time the view is queried? That would seem
to satisfy a time window of 0?
Steve
Yes, they need to be atomic. Either all are DONE and there is an entry in
activity_product_log for product_id, or there is no entry in
activity_product_log.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
[email protected] <mailto:[email protected]>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: How to ensure a log-entry is created based on state of data in other tables
In-Reply-To: <VisenaEmail.6a.d3040d504876c082.1863705b248@visena.app.internal.visena.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox