Merge data into a database
Verified
Added by iNTERFACEWARE
Basic example of merging data into a SQLite database (code is "plug and play" as the DB will be created if it does not exist)
Source Code
function main(Data)
-- Parse the HL7 message
local Msg, Name = hl7.parse{vmd = 'example/demo.vmd', data = Data}
-- Create the database tables target node tree
local Out = db.tables{vmd = 'example/demo.vmd', name = Name}
--Map (part of) the message
Out.patient[1].Id = Msg.PID[3][1][1]
Out.patient[1].LastName = Msg.PID[5][1][1][1]
Out.patient[1].GivenName = Msg.PID[5][1][2]
Out.patient[1].Ssn = Msg.PID[19]
-- (1) Save data to database
-- connect to the database
if not Conn or not Conn:check() then
Conn = db.connect{
api=db.SQLITE,
name='test',
user='',
password='',
live=true
}
end
-- merge the data into the database
Conn:merge{data=Out, live = true}
end
Description
Basic example of merging data into a SQLite database (code is "plug and play" as the DB will be created if it does not exist)
Attachments
Usage Details
This code is a simple demonstration of merging data into a database. It does a very basic HL7 message mapping and then merges into a SQLite database. The code is “plug and play” because the SQLite database will be created if does not exist.
How to use the code:
- Use a To Translator script
- Add the code
- Load the sample messages from SampleData.txt
- Alternatively you can also load the attached project which already contains the sample messages
- Inspect the code and annotations to see how it works
Note: This code is explained in detail in the Merging data into a Database tutorial.
More Information