GoSelector-Docker

GoSelector-Docker

As the related PR was ignored for years, it’s now here
Some test data are preloaded for a quick start

Installation with ZPM

If the current ZPM instance is not installed, then in one line you can install the latest version of ZPM even with a proxy.

s r=##class(%Net.HttpRequest).%New(),proxy=$System.Util.GetEnviron("https_proxy") Do ##class(%Net.URLParser).Parse(proxy,.pr) s:$G(pr("host"))'="" r.ProxyHTTPS=1,r.ProxyTunnel=1,r.ProxyPort=pr("port"),r.ProxyServer=pr("host") s:$G(pr("username"))'=""&&($G(pr("password"))'="") r.ProxyAuthorization="Basic "_$system.Encryption.Base64Encode(pr("username")_":"_pr("password")) set r.Server="pm.community.intersystems.com",r.SSLConfiguration="ISC.FeatureTracker.SSL.Config" d r.Get("/packages/zpm/latest/installer"),$system.OBJ.LoadStream(r.HttpResponse.Data,"c")

If ZPM is installed, then ZAPM can be set with the command

zpm:USER>install alwo-goselector

Installation with Docker

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

Clone/git pull the repo into any local directory

$ git clone https://github.com/r-cemper/GoSelector-Docker.git

Build and run the container

$ docker-compose up -d   && docker-compose logs -f

How to Test it

Open IRIS console:

$ docker-compose exec iris iris session iris

or using iterm

http://localhost:42773/iterm/

System Management Portal

http://localhost:42773/csp/sys/UtilHome.csp

Database Column Selectivity is used as a guide by SQL Engine to influence choice of indexes for queries.
Implemented values maybe have already been added to distributed code for example by:

Do $SYSTEM.SQL.Stats.Table.SetFieldSelectivity("TEST","PropertyLen2","T1","5.1%")

Affects class storage definition adding:

<Property name="T1">
<Selectivity>5.1%</Selectivity>
</Property>

This scheduled Task:

• Does NOT modify Table / Class definitions
• Extracts existing column selectivity values found in an environment
• Profiles corresponding data values
• Generates a report of Column implemented selectivity versus actual ratio of distinct values
• Is not intended to replace or compete with other utilities

Can Use Task Schedule Output file option to create report file.

set task=##class(alwo.GoSelector).%New()
set task.ClassNamePattern="1""TEST."".E"
do task.OnTask()

Hope this utility may inspire reuse for other developer reporting needs.