Insert into a database
Verified
Added by iNTERFACEWARE
Use conn:execute() to insert data into a database table
Source Code
-- connect to a SQLite database
conn = db.connect{
api = db.SQLITE,
name = 'test',
live = true
}
-- insert data into a database table
conn:execute('INSERT INTO Patient (FirstName, LastName) VALUES("Fred", "Smith")')
Description
Use conn:execute() to insert data into a database table
Usage Details
Use conn:execute() to insert data into a database table. The code connects to a SQLite database, you can substitute with any database connection.
How to use the snippet:
- Paste the insert code into your script
Added by iNTERFACEWARE
Using date and time functions with some formatting examples
Added by iNTERFACEWARE
Use table.insert() to insert an element into a table
Added by iNTERFACEWARE
Use node.insert() to insert a node into an XML node tree
Added by iNTERFACEWARE
Use conn:merge{} to merge data into a database
Added by iNTERFACEWARE
How to parse an HL7 message and create an HL7 output message
Added by iNTERFACEWARE
How to parse an X12 message using x12.parse()
Added by iNTERFACEWARE
How to parse an XML message using xml.parse()
Added by iNTERFACEWARE
How to parse and serialize JSON, using json.parse{} and json.serialize{}
Added by iNTERFACEWARE
Use iguana.isTest() to allow code to run in the editor but not in the live channel
Added by iNTERFACEWARE
Use iguana.isTest() to prevent code from running in the editor
Added by iNTERFACEWARE
Use conn:query() to select data from a table in a database
Added by iNTERFACEWARE
Use the error() function to raise an error and write it to the logs
Added by iNTERFACEWARE
Use os.fs.glob() to return to process a list of filenames and statistics matching a specified pattern
Added by iNTERFACEWARE
How to open and read a file from disk, either one line at a time, or read the whole file at once
Added by iNTERFACEWARE
How to remove duplicate words from a string, using PCRE regex with string.rxsub()
Added by iNTERFACEWARE
Use os.fs.rename() to rename a file or directory, if the file or directory does not exist an error is returned
Added by iNTERFACEWARE
Use string.gsub() to find and replace one or more instances of text within a string
Added by iNTERFACEWARE
Execute programs and batch files, you can also load results from a directory listing etc.
Added by iNTERFACEWARE
Use iguana.setChannelStatus{} to set the channel dashboard channel status "light" and message
Added by iNTERFACEWARE
Set the timeout for the current script, must be set inside a function, usually main().