Allen Ayala [11:13 AM] Good morning, I’m trying t...
# pactflow
a
Allen Ayala [11:13 AM] Good morning, I’m trying to pull some reports from the PactFlow DB, and I wanted to figure out whether a participant is doing CDC or BDC. Is there a way to check for this on the DB?
m
hmm probably not easily
I’ll see what I can dig up
are you using an on-prem Pactflow instance, or cloud?
y
Hey, I would ask if you are using on-prem or the cloud, as SaaS doesn’t afford users access to the databse. You could string some stuff together with API’s. If a pacticipants has provider contracts, then they are doing, however they can also still perform a full fat verification with a Pact Verifier, against the consumer contracts, and therefore would be doing both The UI is aware, as we show ‘view contracts’ if the integration as a provider contract uploaded in its list
a
We’re running the PactFlow image in a Fargate cluster that we manage (so cloud?)
Our DB is hosted on aurora, and I have access to the schemas too
To clarify, we’re using on-prem PactFlow
m
we would prefer not to give you an SQL query, because it’s likely to be unstable over time
do you want to know the general numbers, or do you need to know for each application, if they are doing CDC vs BDC?
a
We would like to know for each application if they’re doing CDC or BDC from the consumer or provider perspective
thankyou 1
Is there any follow up to this? Basically I’m trying to generate a matrice of consumer and provider interactions and trying to see whether that pact is BDC or CDC
m
Hi Allen, In case you weren’t aware a colleague of yours has created ticket #00575650 with the same request. It’s with the team to review, please allow us some time to respond
👍 1