Home Applications ipython-iris-magic

ipython-iris-magic

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
0
0 reviews
0
Awards
122
Views
0
IPM installs
1
2
Details
Releases
Reviews
Issues
Pull requests
Articles
%%iris magic for IPython, can run ObjectScript command in Notebooks

What's new in this version

Initial release

ipython-iris-magic

%%iris magic for IPython, can run ObjectScript command in Notebooks.

It can be run in any Notebook and does not require any special setup on IRIS or the Notebook.

Demo

image

As you can see, the first line load the magic, the second line connect to the server, the third line run the ObjectScript command.

All of this demo is in the example/Notebooks/Demo-Iris-Magic.ipynb

To run the demo run the following command in the root of the project:

docker-compose up

Then go to this url: http://127.0.0.1:8888/notebooks/Demo-Iris-Magic.ipynb

Load the magic

%load_ext iris_magic

Connect to the server

%%iris iris://superuser:SYS@localhost:1972/USER

Run the ObjectScript command

%%iris
Set x = 1
Write x

Installation

In order to use this magic, you need to install the ipython-iris-magic package.

pip install ipython-iris-magic

All the dependencies will be installed automatically.

Usage

%load_ext iris_magic
%%iris iris://superuser:SYS@localhost:1972/USER 
set test = "toto"
zw test

Output:

test="toto"

You can also use the magic to run SQL query.

Load the magic

%load_ext sql

/!\ You need to install the sql extension first.

The sql extension is not part of the standard IPython installation. You can install it with the following command:

pip install ipython-sql

Connect to the server

%sql iris://superuser:SYS@localhost:1972/USER

Run the SQL query

%sql SELECT 1
Read more
Made with
Version
0.0.602 Dec, 2022
Category
Frameworks
Works with
InterSystems IRIS
First published
02 Dec, 2022