iris-sql-python-sample
Samples how to create InterSystems IRIS SQL Stored Procedures using Embedded Python
Installation
- Clone/git pull the repo into any local directory
$ git clone https://github.com/yurimarx/iris-sql-python-sample.git
- Open a Docker terminal in this directory and run:
$ docker-compose build
- Run the IRIS container:
$ docker-compose up -d
- For use Geopy with GetFullAddress SQL Stored Procedure: Go to SQL Execution on Management Portal:
SELECT
ID, City, Name, State, Street, Zip, dc_pythonsql.GetFullAddress(Street, City, State) As FullAddress
FROM dc_pythonsql.Company
- For use Chronyk with GetHumanDate SQL Stored Procedure: Go to SQL Execution on Management Portal:
SELECT
ID, City, Name, State, Street, Zip, dc_pythonsql.GetHumanDate('yesterday') As Datetime
FROM dc_pythonsql.Company
Credits