apptools-sqlgateway-demo

An example repository using PostgreSQL SQLgateway to demonstrate exporting and importing instances of the %Library.SQLConnection class with copying jdbc drivers. This is especially useful when you want to copy items to another iris server through the package manager's private registry while keeping your private settings.

Credits

0. OEX package migration-pg-iris-dataset provided by YURI MARX PEREIRA GOMES

   • Special thanks as this was an excellent base to start off.

1. Article about PostgreSQL into Docker:

   • https://levelup.gitconnected.com/creating-and-filling-a-postgres-db-with-docker-compose-e1607f6f882f

2. Git project created from:

   • https://github.com/jdaarevalo/docker_postgres_with_data
   • https://github.com/intersystems-community/iris-docker-zpm-usage-template

3. OEX package db-migration-using-SQLgateway provided by Robert Cemper

   • Thank you so much as this is a great project to learn and practice new skills.

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

Clone/git pull the repo into any local directory

git https://github.com/SergeyMi37/apptools-sqlgateway-demo.git

1. Build

docker-compose build

2. Run it in foreground. Sometimes container start is slower than estimated.

docker-compose up

docker-compose exec iris iris session iris

How to Test it

Open IRIS terminal and export the settings to a file:

zn "%SYS"
write ##class(apptools.core.json).ExportClassInstances("%Library.SQLConnection","select * FROM %Library.sys_SQLConnection where isJDBC = 1","/tmp/gateways.json")

Check database connection:

%SYS>do $system.SQLGateway.TestConnection("postgres")

Import zpm application with drivers

%SYS>zpm "install appmsw-gateway-sql"
...

See what drivers can be installed:

%SYS>do ##class(appmsw.gateway.jdbc).ImportSQLConnection("view")

Import drivers to instance:

%SYS>do ##class(appmsw.gateway.jdbc).ImportSQLConnection()