You may know it but IRIS is a database with the ability to execute code.
The code execution part is called an Application Server.
Today IRIS supports natively two languages: ObjectScript and Python.
Executing code is good, knowing how to organize it is better.
Organizing code is software architecture, not everyone has the desire or knowledge to create such a solution.
To do this, many programming languages offer what we call Frameworks.
Hello,
I'm looking for a way to write a stored procedure or something to return a ResultSet with Embedded Python.
My goal is the following:
I have a Goal table with a Text field that is free text.
CREATE Table Goal (
Id int,
Text VARCHAR(5000)
);
I would like to create a procedure that returns all the entities (in the iKnow sense) in a new Entity column.
Python code, i would like to use :
import iknowpy
engine = iknowpy.iKnowEngine()
# Row to parse
text = 'This is a test of the Python interface to the iKnow engine. another sentence to test this program with.'
engine.
Easy to use HL7v2 to FHIR, CDA to FHIR, FHIR to HL7v2 as a Service.
The aim of this project is to provide an REST API that can convert easily various health formats. Post the desire format in the REST body, get the answer in the new format.
:fire: Official Version : https://aws.amazon.com/marketplace/pp/prodview-q7ryewpz75cq2 :fire:
:tv: Video : https://youtu.be/lr2B7zSFkds :tv:
Clone this repository
git clone https://github.com/grongierisc/iris-healthtoolkit-service.This proof of concept aims to show how the iris interoperability framework can be used with embedded python.
Template project with various Python code to be used with InterSystems IRIS Community Edition with container.
Featuring :
In companies, most of the time, we have test, stage and production environments.
It is very common that we, the developers, do not have the right to modify or touch the production directly because all the modifications must be traced in a versioning tool and tested before a production release.
However, a read access to the production (especially to the traces) can allow us to better understand a possible bug.
That's why I propose this ZPM module that creates a new role in IRIS that allows access to the productions and this only in read-only with access to the visual traces.
A simple python script to copy/scrap/crawl a FHIR repository to another one.
The script is written in Python 3.
python -m venv .venv
source .venv/bin/activate
pip install git+https://github.com/grongierisc/fhir-scraper
cp .venv/bin/fhir-scraper.py .
Edit fhir-scraper.py for your needs.
Run it :
python fhir-scraper.py
First clone this repository.
git clone https://github.com/grongierisc/fhir-scraper
You can install it quickly into a Virtual Environment.
All French-speaking developers are friendly invited to follow a stream in the form of a journal.
Every first Thursday of the month at 12:00 (Paris time), we organize a 30-45 minutes stream on Youtube with the following format :
Previous episodes :
This repository is a demonstration of IntegratedML and Embedded Python.
This article contains the materials, examples, exercises to learn the basic concepts of IAM.
You have all resources available on this git : https://github.com/grongierisc/iam-training.
Solutions are in training branch.
This article will cover the following points :
Hi everyone,
I need to call a SOAP service using IRIS Interoperability and this SOAP service returns a Microsoft DataSet with a DiffGrams payload.
Do you know how to handle this kind of Objects ?
SOAP Payload Response :
<?xml version="1.0" ?This is iris-key-uploader a frontend in Angular with it's rest API.
The aim of this project is to easily import key file to Iris from a web ui.
Unfortunatly the IRIS panel to change key doesn't give the opportunity to upload the license.
As you can see, you can only browse from the server side.
What if, you don't have a direct access to it ?
You would like to have a simple web page to upload the new key and activate it.
This is the purpose of this project.
http://localhost:52773/keyuploader/index.The aim of my question is to achieve this :
You can notice that some information of the PID segment are obfuscated.
I do have a solution but it involve a modification of EnsLib.HL7.Message. It's not a best practice.
Do you have idea or a simple solution that doesn't involve overloading every HL7 classes ?
Here is my solution :
https://github.com/grongierisc/hl7-msg-anonymizer
This is a modification of EnsLib.HL7.Message to not display Patient demography information in visual trace.
iOS app to export HealthKit data to InterSystems IRIS for Health (or any FHIR repository)
The objective is to
This is a csvgen UI frontend in Angular 8. The aim of this project is to easily import csv file to Iris from a web ui.
It will automatically install the dependency of csvgen and sslclient
zpm "install csvgen-ui"
This will create two new endpoints :
One for the Rest API for uploading files
/api/{namespace}/csvgen/
One for the UI
/csp/{namespace}/csvgen/index.html
Run the server
docker-compose up -d
The UI is per-namespcae, this mean it will be available only for the namespace where csvgen-ui is install.
Hello,
Recently I tried to connect to JDBC on IRIS 2020.3+ and I came across the following error:
SQL Error [461] [08S01]: [InterSystems IRIS JDBC] Communication link failure: Communication error: Server closed communication device
This error implies that the port is not open.
Checking with the netstat command:
irisowner@78c3e30b7f41:/opt/irisapp$ netstat -a
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0 0.0.0.0:1972 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.11:38005 0.0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:52773 0.0.
An implementation of JSON-Patch in ObjectScript.
JSON-Patch (RFC6902) is a standard format that allows you to update a JSON document by sending the changes rather than the whole document. JSON Patch plays well with the HTTP PATCH verb (method) and REST style programming.
With zpm :
USER>zpm
zpm:USER>install objectscript-json-patch
Use it with this call :
Do ##class(Grongier.JSON.Utils).Patch(tDoc,tPatch)
Where :
Ready to use demo of an FHIR Server with IRIS for Health 2020.2 :
Clone this repository
git clone https://github.com/grongierisc/FHIR-HL7v2-SQL-Demo.git
Docker
docker-compose up --build -d
Can use postman config in misc/fhirhl7v2demo.postman_collection.json
Use UX at http://localhost:4201
Login/Password : SuperUser/password
3 steps to use it :
Click on the left arrow between IRIS and the ambulance.
InterSystems offers an API-design first approach.
You can check this post for more informations : https://community.intersystems.com/post/iris-api-explorer-application.
One practical thing about this approch and the OpenAPI specification is the definition of exchange objects.
The do ^%REST command does not create object definitions, but only routes and associated methods.
Output for the do ^%REST command for PetShop example :
REST Command Line Interface (CLI) helps you CREATE or DELETE a REST application.
Has you may know, EnsDemo from Ensemble are not available anymore on IRIS.
This is a good thing, Iris is cloud oriented, it must be light, fast. Now the new way of sharing samples or modules is through git, continuous integration and OpenExchange.
But, in some cases you want to go back to your good old samples from EnsDemo to get inspiration or best practices.
Good news, there is a git for that :
How to use it ?
Clone this repository
git clone https://github.com/grongierisc/InstallEnsDemoLite.gitAnd run install.sh
sh install.Hi,
I try to implement an iFind index.
Here is my definition class :
IRIS and Ensemble are designed to act as an ESB/EAI. This mean they are build to process lots of small messages.
But some times, in real life we have to use them as ETL. The down side is not that they can't do so, but it can take a long time to process millions of row at once.
To improve performance, I have created a new SQLOutboundAdaptor who only works with JDBC.
Extend EnsLib.SQL.OutboundAdapter to add batch batch and fetch support on JDBC connection.
Benchmarks released on Postgres 11.2 with 1 000 000 rows fetched and 100 000 rows inserted on 2 columns.
Hi, I'm looking for a way to implement the JDBC pattern "executeBatch" in ObjectScript: https://www.tutorialspoint.com/jdbc/jdbc-batch-processing.htm
Since Ensemble 2017.2.2 there is a new method called executeParametersBatch : https://docs.intersystems.com/ens20172/csp/docbook/relnotes/index.html#…
Even in the Ensemble 2018.1 change log, mention a patch on this method: https://docs.intersystems.com/ens20181/csp/docbook/relnotes/index.html#…
Do you have any examples or tracks to use the executeParametersBatch method of %Net.Remote.Java.JDBCGateway?
Hi,
We recover a large amount of data from an external database (SQLServer, about 1 million rows in JDBC).
However, we have treatment time issue.
This process takes more than 30 minutes whereas on a "classic" SQL Server Management Studio type request takes less than a minute.
While searching on the internet, I came across this article: http://makejavafaster.blogspot.com/2015/06/jdbc-fetch-size-performance.html
It explains how in Java, we can tweak the FetchSize parameter of the JDBC driver to optimize this kind of process.
Is there a way to access this JDBC parameter through the EnsLib.SQL.