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.

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

Allow file extraction to be started directly from database table #1922

Open
rkm opened this issue Aug 30, 2024 · 3 comments
Open

Allow file extraction to be started directly from database table #1922

rkm opened this issue Aug 30, 2024 · 3 comments
Labels
enhancement New feature or request

Comments

@rkm
Copy link
Member

rkm commented Aug 30, 2024

It would be useful to have the ability to start an extraction job given from a database table which contains a list of extraction identifiers (e.g., SeriesInstanceUIDs)

@rkm rkm added the enhancement New feature or request label Aug 30, 2024
@jas88
Copy link
Member

jas88 commented Aug 30, 2024

Should we read the column directly, or just accept a CSV of IDs dumped by the DB client for simplicity?

@howff
Copy link
Contributor

howff commented Sep 1, 2024

Or allow the actual SQL query to be specified directly, for maximum flexibility?

@jas88
Copy link
Member

jas88 commented Sep 1, 2024

@howff That could work, but we do have command line SQL clients for doing that already, why reinvent the wheel/pipe?

mysqlcient 'SELECT SeriesInstanceUID FROM CT_SeriesTable WHERE ...' --tabbed -Usmi smi_images | tee project32-extraction1.csv | ./smi fetch-by-id --id=series --modality=CT

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants