bugfix with WebApplication

Added IPM

Initial Release

Initial Release

Initial Release

Moved main functionality out of a class and into the RunScript routine. Some code golf optimizations to bring this down to 491 characters in total, 441 of which are Python code.

Initial Release

Fixed issue with web setup script

Optimized RunScript for speed by replacing the%SYSTEM.WorkMgr multi-process design with a single embedded-Python
call into a GIL-releasing OpenMP C kernel.

Added

• App.PEXSetup.cls to configure %Java Server for remote jgw and register PEX components
• Runtime PEX setup via pex-runtime.script and docker-iris-start.sh on IRIS container start
• Telegram bot credentials via .env (TELEGRAM_BOT_TOKEN, TELEGRAM_BOT_USERNAME)
• .env.example template for local configuration
• Published Docker images on Docker Hub: jackpto/iris-crypto-tracker-iris and jackpto/iris-crypto-tracker-jgw (tags 1.2.0, latest)

Changed

• Java Gateway runtime upgraded from Java 8 to Temurin 11 (Cloudflare/CoinPaprika TLS compatibility)
• IRIS JDBC/utils JARs aligned with IRIS 2026 (intersystems-jdbc-3.10.5, intersystems-utils-4.2.2)
• CryptoProduction uses %gatewayName=%Java Server instead of host/port settings
• CryptoService HTTP client: explicit User-Agent, Accept header, timeouts, and HTTP status handling
• Docker Compose: IRIS hostname iris, depends_on: jgw, jgw loads .env
• Base Java build image switched to eclipse-temurin:8-jdk

Fixed

• PEX / Java Gateway connection to jgw:55555 (NOTOPEN, gateway name mismatch)
• CoinPaprika API calls failing with SSLHandshakeException / blocked Java 8 User-Agent
• Missing OnTearDown() and invalid super.OnMessage() / super.OnProcessInput() calls in PEX Java classes
• Installer namespace/path for /opt/irisapp/
• Empty CSV header not flushed on first create

Security

• Removed hardcoded Telegram bot token from source; secrets stay in .env (gitignored)

Initial Release

update to 1.0.5

• IRIS BI textMeter widgets: added dataProperty bindings in Overview.dashboard — DSW 4.x only renders measures listed in data properties
• IRIS BI UomTable: replaced removed Country.Uom property with [idwaterresultuom].[H1].[Label] row level (fixes @NOPROPERTY)
• KPI pivots (MeanPollution, MeanOutsideInfluence, VenueCount): measure defined via columnLevel instead of deprecated <measure> element
• Docker build: replaced deprecated PyPI package sklearn with scikit-learn in requirements.txt
• Docker build: removed automatic cube build from ZPM Invokes — failed cube activation rolled back module installation and data
• Flask/Dash app: replaced obsolete app.run_server() with app.run() for Dash 4.x compatibility
• Container startup: replaced exit 1 with wait in server_start.sh so background processes keep running
• DeepSee cube: removed duplicate Uom property from Country level in waterPollutionCube (18 833 build errors)
• IRIS BI / DSW: added SetupDSWAddons() to register and compile DSW.Addons.* portlet classes for worldMap and other addons

Initial Release

Add usage information to the README.

• Added HL7 schema loader for ITB.XML to fix schema import on 2026+

v2.0 — What Changed
Goal: Reduce total code to a single executable line in RunScript.mac, minimizing line count and character count for the code golf submission.

The problem with v1.0. The solution split across two files: load_gaia.py (27 lines of Python to parse, flatten, and load the data) + RunScript.mac (1 executable line with a complex SQL pivot). Total: 28 lines, ~1,910 characters.

What changed in v2.0. load_gaia.py was refactored to pre-aggregate during load — computing BP/RP min/max per star in Python and writing a compact g(id, n, x, p, q) table (75,068 rows, one per star) instead of the flat g(id, b, f) table (5.6M rows). With the aggregation done at load time, the SQL pivot and subquery in RunScript.mac disappeared entirely, replaced by a direct single-table scan.

The solution file is now just RunScript.mac — one file, one executable line:

ROUTINE RunScript
s f=##class(%Stream.FileCharacter).%New(),f.Filename="...variable_objects.csv" d f.WriteLine("source_id,...") s r=##class(%SQL.Statement).%ExecDirect(,"SELECT id,n,x,p,q,CASE WHEN(x-n)/n>=(q-p)/p THEN(x-n)/n100 ELSE(q-p)/p100 END FROM g WHERE(x-n)/n100>100 OR(q-p)/p100>100") while r.%Next(){d f.WriteLine(r.%GetData(1)","..._r.%GetData(6))} d f.%Save()

v1.0 → v2.0

• Files: 2 (load_gaia.py + RunScript.mac) → 1 (RunScript.mac)
• Executable lines: 28 → 1
• Characters: ~1,910 → 516
• SQL complexity: pivot + subquery → single-table scan
• Output: 57,099 ✓ → 57,099 ✓

Attempt to resolve python conflict

DEPRECATED

DEPRECATED

DEPRECATED

DEPRECATED

DEPRECATED

DEPRECATED

DEPRECATED

DEPRECATED

Creation of MSsqlcsontainer fixed.
It is no team player and needs an extra build to work

Initial Release
almost complete

Initial Release

Initial Release