Wow, what a useful thread! Thank you.

I especially like the fact that you offer solution in each IRIS language : SQL, Python, ObjectScript.

SELECT {fn WEEK('2004-02-25')} AS Week, {fn DAY('2004-02-25')} as Day,{fn DAYOFWEEK('2004-02-25')} as DayOfWeek,{fn Year('2004-02-25')} as Year,{fn Quarter('2004-02-25')} as Quarter,{fn DAYOFYEAR('2004-02-25')} as DayOfYear

Doc : https://docs.intersystems.com/iris20223/csp/documatic/%25CSP.Documatic…

not all your requirements but it's a start

Great article, if your are looking for an approach without objectscript and making use of "irispyhton", check this code :

python code :

import pandas as pd

from sqlalchemy import create_engine,types

engine = create_engine('iris+emb:///')

df = pd.read_csv("/irisdev/app/notebook/Notebooks/date_panda.csv")
# change type of FullDate to date
df['FullDate'] = pd.to_datetime(df['FullDate'])
df.head()

df.to_sql('DateFact', engine, schema="Demo" ,if_exists='replace', index=True,
        dtype={'DayName': types.VARCHAR(50), 'FullDate': types.DATE, 'MonthName': types.VARCHAR(50),
        'MonthYear': types.INTEGER, 'Year': types.INTEGER})

requirements.txt :

pandas
sqlalchemy==1.4.22
sqlalchemy-iris==0.5.0
irissqlcli

date_panda.csv

ID,DayName,FullDate,MonthName,MonthYear,Year
1,Monday,1900-01-01,January,190001,1900
2,Tuesday,1900-01-02,January,190001,1900
3,Wednesday,1900-01-03,January,190001,1900
4,Thursday,1900-01-04,January,190001,1900
5,Friday,1900-01-05,January,190001,1900
6,Saturday,1900-01-06,January,190001,1900
7,Sunday,1900-01-07,January,190001,1900
8,Monday,1900-01-08,January,190001,1900
9,Tuesday,1900-01-09,January,190001,1900

Sure you can, for example to retrieve all the patient with an observation based on the code : 8302-2

[FHIR EndPoint]/Patient?_has:Observation:patient:code=8302-2

More info here : https://www.hl7.org/fhir/search.html#has

For the python part have a look at this git :

https://github.com/LucasEnard/fhir-client-python

It's a simple example how to use python client to interact with a FHIR server.

For fhir-py to create the same query use raw search :

https://github.com/grongierisc/fhir-py#raw-parameters

Last but not least, check out our neat implementation of SQL On FHIR aka FHIR SQL Builder

Demo here : https://github.com/grongierisc/iris-fhirsqlbuilder

If I understand correctly, the trick is to load the "src/gbl/SYS.xml" file that holds the configuration of git-source-control module.

If we create a new file like a BP or a DTL, we still have to add it to the source control module with the UI. Then, if we do so, we have to update the "src/gbl/SYS.xml" file with the new file.

Am I right ?

Great post thanks.

If you want to go further check this git :

• https://github.com/grongierisc/kong-ee-training

In my point of view, this app is a game changer.

Let me explain why.

Imagine you have an DDL statement that you want to execute on a database. Example:

File: misc/init.sql

CREATE TABLE test.formation (
	name varchar(50) NULL,
	room varchar(50) NULL
);

INSERT INTO test.formation
(name, room)
VALUES('formation1', 'salle1');

You can execute this statement in the irissqlcli app by using the following command:

irissqlcli iris://_SYSTEM@localhost:51776/USER -W < misc/init.sql

Before this app, you had to use the terminal to execute this command.

cat <<EOF | iris session iris

do \$SYSTEM.SQL.Schema.ImportDDL("/irisdev/app/misc/init.sql",.log)
if log'="" { write "Error: ",log }
h
EOF

Let's compare the two commands:

One last thing, if I want to extract the data from a table, I can use the following command:

irissqlcli iris://_SYSTEM@localhost:51776/USER -W -e "SELECT * FROM test.formation" --csv

This command will return the following result:

"name","room"
"formation1","salle1"

Try to do the same thing with the terminal ;).

cat <<EOF | iris session iris
do ##class(%SQL.Statement).%ExecDirect(,"SELECT * FROM test.formation").%DisplayFormatted("CSV",,,.filesUsed)
do ##class(%Stream.FileCharacter).%OpenId(filesUsed(1)).OutputToDevice()
h
EOF

Cool, this can be really useful while waiting for OpenTelemetry and SAM.

The big advantage of this, is that you don't need other tool/server/docker.

Wow, easy to use (nice UI) and powerful in it's usage (spec first on OpenAPI 3.0) !

Hi Yuri,

I confirm this issue, I do encounter the same.

intersystemsdc/iris-community:preview, solve it.

Hi dear community,

If you lack inspiration for the contest, here are some ideas:

• A tool to improve the load of DDL or SQL statements in IRIS.

  • Why, because for now, we have to run an iris terminal then run an objectscritp command to load the DDL or SQL statements.
  • I wish a way that we can have a tool that bring the ability to parse a DDL or SQL file from a shell.
    • Example : iris load -f /path/to/file.sql

• A tool to automatically export objectscript classes to the local folder

  • I know we can do it with Timothy's tool, but I wish a simple hook that just export new classes or modified classes to the local folder. Not the whole source control system.

Class codeGolf.Pyramid
{

ClassMethod BuildPython(f As %Integer) [ Language = python ]
{
for i in range(f):
    print(' ' * (f - i - 1) + '#' * (2 * i + 1))
}

/// Description: Build a pyramid of height f
ClassMethod Build(f As %Integer) As %Status
{
    Set sc = $$$OK
    For i = 1:1:f {
        set space = $tr($j("",f-i)," "," ")
        set hash = $tr($j("",2*i-1)," ","#")
        Write space_hash, !
    }
    Return sc
}

}

My guess is that you try to use some outdated nativeapi drivers. https://github.com/intersystems/quickstarts-multimodel-python <- outdate more than 3 years old I encourage you to use this git for drivers : https://github.com/intersystems-community/iris-driver-distribution

If you are looking for python expérience on IRIS have a look at those git :

• https://github.com/grongierisc/iris-devslam
• https://github.com/intersystems-community/iris-embedded-python-template
• https://github.com/grongierisc/iris-python-flask-api-template
• https://github.com/grongierisc/iris-python-template

BTW : a more complete DB-API and SQL Alchemy support is under development

I would like to add the presentation of IRIS and Python that I did at the last IRIS Community Day. Here is the link to the power point. PythonEtIRIS.pptx

Just to be clear, the remove of the private web server is just for IRIS and IRIS for Health. IRIS and IRIS for Health community edition still has the private web server.

Then, the question is, what is the cost of this decision for end-developers like most of here.

I would say not that much as you think. The main raison is that most of the developer use the community edition. And the community edition still has the private web server. Then if you have an preinstalled IRIS, you will keep the private server.

The main cost is for the new developer that don't have an preinstalled IRIS and that don't want to use the community edition. I agree that installing a web server is not that easy if you sick on windows. But it is not that hard if you are on Linux or Mac.

For windows developers, may be we can provide simple installer that install a web server and configure it for IRIS.

Now, if we take a step back on the ease of use. I think, this decision is a good one, because it's the first major step of breaking down the monolith. From this point, we can start to make the product more modular. And of course, there is a lot of work to do.

I agree with you that we must improve our client libraries and drivers. Put them in direct distribution, make them more easy to use and with modern features.