Python IRIS SQL Procedures Sample

Subscribe
1
Bookmark
1
Details
Releases
Reviews
Issues
Provider

What's new in this version

Initial Release

iris-sql-python-sample

Samples how to create InterSystems IRIS SQL Stored Procedures using Embedded Python

Installation

  1. Clone/git pull the repo into any local directory
$ git clone https://github.com/yurimarx/iris-sql-python-sample.git
  1. Open a Docker terminal in this directory and run:
$ docker-compose build
  1. Run the IRIS container:
$ docker-compose up -d 
  1. 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

Geopy

  1. 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

Chronyk

Credits

ZPM installation
zpm "install iris-sql-python-sample"
Category
Technology Example
Works with
InterSystems IRISInterSystems IRIS for Health
Tags
Info
Publisher
Visum Consult
Version
1.0.0
Last updated
2022-07-20
Repository
Open
Documentation
Open
License
Link