jpdbi

NAME

SYNOPTICS

DESCRIPTION

PREREQUSITS

OPTIONS

CONFIG FILES / SETUP

EXTENDED QUERY

If you want to search for DCM4CHE database fields, not included in the standard search option, you can use --query option.

Simply use --query "<table>.<field>='<value>'".

- --query "series.src_aet='DCM4CHE'" would search for DCM4CHE in src_aet field.

You can also use SQL wildcards.

- --query "series.src_aet like '%CHE%'" would search for any src_aet containing the string CHE.

And you can combine queries

- --query "series.src_aet like '%CHE%' or series.src_aet like '%DCM%'"
- --query "series.src_aet like '%CHE%' and series.ext_retr_aet like '%DCM%'"

Look at the DCM4CHE documentation for the database layout.

SCRIPTS

One way to use jpdbi is to install the required libraries (see also PREREQUESITS) into a a directory, e.g. /opt/java/lib and use follwing script ...


#! /bin/sh

CP=$(echo /opt/java/lib/*.jar | sed -e "s/ /:/g")

java -cp ${CP} com.agfa.db.tools.Jpdbi "$@"

... but there are probably better ways to do this.

BUGS

This tool should not exists in first place - specialy the update part - whenever you an use the official DCM4CHE web interface.

Second, I do not know that much about DICOM, databases, and never learn java or even read a book about java programming - keep that in mind, if you look at the sourcecode - and when you use jpdbi.

This tool has mainly been testen with an oracle setup - specially the *update*s might not work with other databases.

AUTHOR

Kianusch Sayah Karadji kianusch+jpdbi@gmail.com