jpdbi - Display and optionally manipulate DCM4CHE Database entries. |
jpdbi [options] [<LastName> [<FirstName> [<Birthdate>]]] |
jpdbi will query DCM4CHE DB - via jdbc - so you will have access to the DCM4CHE data from command line and even if JBOSS ist not running. If configured it will also allow updates/changes to the data. e.g. one can change the ISSUER on the PATIENT level both in the database and the DICOM Database BLOB. jpdbi will display the date beginning at the PATIENT level down to FILES/FILESYSTEM level. |
Help and Version
Database Link
Search OptionsThe first three optional command line arguments are defined as Firstname, Lastname and Birthdate. Those three can be combined with any other search option. Searching without any search criteria is not a good idea - specially for large archives - so it is deactivated. If you really want to display all patients, use a corresponding wildcard. SQL-Wildcards are supported on most fields. Use % for a multi-character wildcard and _ for a single character wildcard.
Display Options
Display Level OptionsDefault level to be displayed is PATIENT level - one can choose the desired level to display - the chosen level and all levels above will be included in the output.
Output Options
Database / Dataset manipulation
Fields to be updated have to be configured in the jpdbi-properties file.
|
PROPERITIESjpdbi can be configured with the jpdbi.properites or the jdb.properties. Both files are located in the /etc directory. Those file are java properties files. Following configuration options can be set:
ExampleThis is the supplied properties included in the standard installation:
|
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.
Kianusch Sayah Karadji kianusch+jpdbi@gmail.com
jdbexp - a command line generic database query tool.