iris-python-lookup-table-utils

Downloads15
Subscribe
0
Bookmark
0
This application is not supported by InterSystems Corporation. Please be notified that you use it at your own responsibility.
Details
Releases
Reviews
Issues
Videos

What's new in this version

Initial Release

IRIS Python Lookup Table Utils (pylotaut)

Introduction

The IRIS Python Lookup Table Utils module provides a simple API to interact with the lookup tables in Intersystems IRIS from python.
Furthermore it offers the capability to import Excel sheets which is useful for project implementation and migration.

Click on the screenshot below to view the demo video:
Screenshot

Installation

  1. Build image docker-compose build
  2. Start container docker-compose up -d
  3. Open URL http://localhost:52795/csp/irisapp/EnsPortal.LookupSettings.zen
  4. Login with default credentials Admin and SYS and change password
  5. Enter iris shell docker-compose exec iris bash
  6. Open python shell irispython
  7. Import module from pylotaut import pylotaut
  8. Run commands pylotaut.<FUNCTION> documented in next chapter

API functions

All API functions accept or return python objects e.g. strings, dictionaries or tuples.

Get actions

  • get_value(table, key)
  • get_tables()
  • load_xlsx(path)
  • load_table(table_name)

Set actions

  • set_value(table, key, value)
  • create_lookuptable(table_name, items)

Delete actions

  • delete_key(table_name, key)
  • delete_table(table_name)

Print actions

  • list_tables()
  • print_value(table, key)
  • print_table(table_name)
Rating
5 (1)
Category
Technology Example
Works with
InterSystems IRISInterSystems IRIS for Health
Tags
Info
Version
1.0.0
Last updated
2023-09-16
Repository
Open
Documentation
Open
License
Link