search

billingross / trellis-v2

MIT License
0 stars 0 forks source link

Create sample database triggers #22

Closed billingross closed 2 months ago

billingross commented 2 months ago

I'm creating (3) database triggers to test the functionality of the new trellisdata package.

Triggers:

Queries:

For check-triggers I'll need to establish that these triggers are activated by the appropriate graph patterns.

billingross commented 2 months ago

I think maybe I want to separate the act of creating the ReadGroup/Sample nodes from adding their relationships. To avoid running duplicate queries. Relating ReadGroup to Sample shouldn't be reliant on any ReadGroup to Fastq relationship...

The problem is that I'm tracking all of these operations manually rather than being able to see when nodes are actually created. I think if I was using the Kafka plugin I could better see what is actually happening in the database. But then I would have to use Kafka. Kafka on GCP marketplace: https://console.cloud.google.com/marketplace/product/confluent-prod/apache-kafka-on-confluent-cloud?project=trellis-v2.

I don't want to do that now though.