Solution One: Using Python |
Chameleon allows you to execute SQL queries against your database from any Python code inside your VMD file.
 | ||
|
To understand the details of how this works, see:
| ||
 |
To solve the example problem outlined in the previous section, we can record the value of our MRN number in a global Python variable called MRN by using the Python Inbound Script for PID field two:
Then, we only need to add a Python validation rule to our PID segment's Patient Internal ID field (field three).
Once inside the validation rule dialog, select Python Validation Rule from the list box and give the validation rule a useful name (such as ValidateIDs). Then, paste the following Python code into the text field of the validation rule dialog:
PRK = validation_field.subfield(0).value
# if both the MRN value and the PRK values are populated
# on the incoming message, then we perform our validation
if ( (MRN != "") and (PRK != "") ):
# let's get our default database
db = environment.get_default_database()
# now we escape the MRN value for the database we're using
escapedMRN = db.escape_string(MRN)
# construct the appropriate SQL select statement
SQL = "select PRK from Patient where MRN = " + escapedMRN
# execute the select query and get a result set back
ResultSet = db.execute_select(SQL)
# if this MRN value exists in the Patient table already,
# ensure that the PRK matches
if (ResultSet.count_of_row() > 0):
PRKinDatabase = ResultSet.value(0, "PRK")
# if the incoming PRK and the PRK in the db for this
# MRN do not match then raise an exception
if (PRKinDatabase != PRK):
Error = chmexception.errorobject
Error.description = "Database PRK " + PRKinDatabase + " does not match PRK incoming " + PRK + " for MRN value: " + MRN
raise chmexception
|
This code ensures that the MRN and PRK numbers match.