go to post Robert Cemper · Apr 30, 2021 Did you ever try this? https://learning.intersystems.com/course/view.php?id=28
go to post Robert Cemper · Apr 28, 2021 ¡Hola @Kurro Lopez !It's a really interresting issue.#2) your second example can't work by principal as you don't pass a call parameter.#1) It is not foreseen to use object properties as host-variables in SQLThe code fails in the generated Execute method. set tResult = tStatement.%Execute($g(pObject.KeyProcess),$g(pObject.CodeSpecialist),$g(pObject.CodeProvider),$g(pObject.CodeCenter),$g(pObject.Date)) $GET for oblect-properties is just not implemented. It is definded by the class and always there,But it is required and makes sense for multidimensional properties ! This is valid for ObjectScript as such and not related to SQL.But in handwritten code you can use $g(NOTHING,pObject.KeyProcess) The generator just doesn't do it. Workaround #1: directly fiddle in the generated code . Not recommendedWorkaround #2: move your properties with a helper function into local variablesand adjust your query to those variables example helper (with obj or id): ClassMethod FillProp(pObject As Kurro.MyClass) As %Boolean [ SqlName = FILLP, SqlProc ]{if '$isObject(pObject) set obj=##class(Kurro.MyClass).%OpenId(pObject)else set obj=pObjectset %Kurro("kp")=obj.KeyProcess ,%Kurro("sp")= obj.CodeSpecialist ,%Kurro("pr")= obj.CodeProvider ,%Kurro("cs")= obj.CodeCenter ,%Kurro("dt")= obj.Datequit 1}example query; Query GetInfoRcc(objid As %Integer) As %SQLQuery(CONTAINID = 0, ROWSPEC = "IdList:%String,IdProcess:%String,Duration:%String"){ SELECT IdList, IdProcess, Duration FROM Kurro.MyClass WHERE KeyProcess = :%Kurro("kp") AND CodeSpecialist = :%Kurro("sp") AND CodeProvider = :%Kurro("pr") AND CodeCenter = :%Kurro("cs") AND "Date" = :%Kurro("dt") AND FILLP(:objid) = 1} works as expected.Sorry for being late. I was interrupted by .... 15 times at least with nonsense
go to post Robert Cemper · Apr 28, 2021 There is an example of the WebSocket Server in namespace SAMPLES on Caché only:in addition there are 4 examples for Caché on Open Exchange https://openexchange.intersystems.com/package/WebSocketsSample https://openexchange.intersystems.com/package/WebSocketsSample https://openexchange.intersystems.com/package/WebSockets-Tutorial https://openexchange.intersystems.com/package/WebSocketClient-js
go to post Robert Cemper · Apr 25, 2021 try: ; set file=$system.Util.ManagerDirectory()_"messages.log" open file:("RS"):1 w $T open 2:99 try { for n=1:1 use file read lin use 2 write lin,! } catch { close 2,file write n_" lines",! } ; then use ^SPOOL mapping (OEX) to work on it with SQL
go to post Robert Cemper · Apr 24, 2021 start of sshd at container start is solved. THANKS to @Hannes Postl OEID
go to post Robert Cemper · Apr 23, 2021 Thanks to the input by @Hannes Postl OEID container start inclusive SSH is now standard $ docker-compose up -d
go to post Robert Cemper · Apr 23, 2021 Thank you @Hannes Postl OEID !You not only made my day but my week!My major issue is fixed and you inspired me to some useful changes
go to post Robert Cemper · Apr 23, 2021 Hello Hannes!Thanks for the hint ! I'll check immedeatly.- for the stop:I've seen this in some cases but could imagine it related to large global buffers.default timeout for docker stop iris is 10 sec but docker stop -t 60 iris will give it a minutethe total save approach could be docker exec iris iris stop iris quietly so iris is downdocker stop iris now stop the container
go to post Robert Cemper · Apr 23, 2021 Hi @Kurro Lopez ! The Follows operator is ] while ] stands for Binary Follows stands ]] for Binary Sorts After the difference is described there though it may sound esoteric at first sight.
go to post Robert Cemper · Apr 22, 2021 Reacting to various security concerns I have adjusted Dockerfile to the templateAt the price of an additional command @ container start.It is now: $ docker-compose up -d$ docker-compose exec -u root iris /sshstart.sh README.md is adjusted, Video is unchanged (to hide the additional grey hairs) .
go to post Robert Cemper · Apr 21, 2021 This is an excellent application.- It allows to create a base configuration and handle variants.- And it's an excellent readable and easy-to-understand documentation.- On top, it is JSON based and therefore well suited to source and version managementThe original CachéParameterFile iris.cpf does a mimic of versioning.But it is buried deep into the installation directory and as cryptic as theEgyptian Book of the Dead. [reserved to the priest of IRIS cultus] I was waiting for something similar useful for decades!I suggest: No one running and supporting more than 2 configurations should miss it!
go to post Robert Cemper · Apr 21, 2021 <ctrl>+C doesn't work anymore . I had to kill terminal or process I'll step back
go to post Robert Cemper · Apr 21, 2021 Great hint! Up to now I just used select text > right click "copy + paste"
go to post Robert Cemper · Apr 20, 2021 Why not take advantage of what is there and what is still working well.You can't get all the %R*.int and %G*.int routines in Studio (no idea about VSCode)But a closer look to the well know system globals and a ZLOAD brings those zombies back to life.
go to post Robert Cemper · Apr 20, 2021 @Alexey Maslov Following your suggestion, I investigated public key bases authentication.And it's of course available (no surprise it's standard Linux) $ cd /etc/ssh$ ls -ltotal 580-rw-r--r-- 1 root root 553122 Mar 4 2019 moduli-rw-r--r-- 1 root root 1580 Mar 4 2019 ssh_config-rw------- 1 root root 227 Apr 20 20:32 ssh_host_ecdsa_key-rw-r--r-- 1 root root 179 Apr 20 20:32 ssh_host_ecdsa_key.pub-rw------- 1 root root 411 Apr 20 20:32 ssh_host_ed25519_key-rw-r--r-- 1 root root 99 Apr 20 20:32 ssh_host_ed25519_key.pub-rw------- 1 root root 1679 Apr 20 20:32 ssh_host_rsa_key-rw-r--r-- 1 root root 399 Apr 20 20:32 ssh_host_rsa_key.pub BUT: - These keys change with every run of a docker build- the client side varies with the platform, client type, .... and is rather tricky It is for sure beyond the bounds of this demo For production, it makes sense, but not for download and run within 4 minutes.
