nadeemlab / SPT

Spatial profiling toolbox for spatial characterization of tumor immune microenvironment in multiplex images
https://oncopathtk.org
Other
21 stars 2 forks source link

Add computation job queue queries #362

Closed jimmymathews closed 1 month ago

jimmymathews commented 1 month ago

This PR adds load_query.sql and load_query_breakdown.sql. These query for the number of computation jobs in the queue, and the same number but broken down by dataset, respectively. They require the database to be formatted in the new "schema-oriented" way, to come with #358.

One can download these queries directly from the git repository, but they can also be dumped to the terminal with an spt command:

spt db load-query --all
spt db load-query --breakdown-by-dataset