Home Applications Python IRIS SQL Procedures Sample

Python IRIS SQL Procedures Sample

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
5
1 reviews
0
Awards
207
Views
7
IPM installs
1
1
Details
Releases
Reviews
Issues
Pull requests
Articles
Samples of python running inside SQL InterSystems IRIS Database

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

Read more
Made with
Install
zpm install iris-sql-python-sample download archive
Version
1.0.020 Jul, 2022
Category
Technology Example
Works with
InterSystems IRISInterSystems IRIS for Health
First published
20 Jul, 2022
Last checked by moderator
27 Jun, 2023Works