#2)
Every LOCK persists until the process is ended or the LOCK is removed explicitely (LOCK -....)
it is not related to any error handling.
#1)
depends on your design.
If there is no conflict of subscripts between ADD and REMOVE possible there is no need of a Lock
no need for this COPY
if your docker-compose.yml contains
volumes:
- ./:/home/irisowner/dev
So comparing .CLS to .MAC/.INT is like comparing a goat to the final cheese you buy.
video added https://youtu.be/fl0SDt-rxAU
A few questions:
To get the property position dynamically by program you may use this ClassMethod
ClassMethod PropSeq(classname As %String = "", propname As %String = "")
As %String [ SqlProc ]
{
if classname="" set classname=..%ClassName(1)
set pos=0
&sql(
SELECT SequenceNumber INTO :pos
FROM %Dictionary.CompiledProperty
WHERE transient=0
AND parent=:classname
AND name=:propname
)
if SQLCODE set pos="-1;"_SQLCODE
quit pos
}
a somewhat 'dirty' approach
select ID, Name_GivenName from Demo.DemoPatient
where FOR SOME %ELEMENT(Demo.DemoPatient.Aliases) ($LISTFIND(%value,'Twain')>0)advantage - no need to know the structure of your serial class
risk - false positives for unexpected coincidences. eg. Washington, John, ...
the example builds on the fact that the storage structure of the serial object is known
Storage Default { <Data name="serItemState"> <Value name="1"> <Value>Subject</Value> </Value> <Value name="2"> <Value>Change</Value> </Value> <Value name="3"> <Value>Color</Value> </Value> </Data> <State>serItemState</State> <StreamLocation>^rcc.IC.serItemS</StreamLocation>
in this case color is #3 in serial storage ==>> $list(%Value,3)
So you need to know the position of FamilyName in HS.SDA3.Name (e.g.7 ?)
then you can use $list(%value,7) = 'Twain' as condition
7 is just a guess as I don't have any HS* classes at hands
This article is focused on indexing, though it shows the principle of the SQL query
Effective use of Collection Indexing and Querying Collections through SQL
THX. Never used it before
it applies to any code in ObjectScript
BIG THANKS!
That soved the problem
It's a shame that the owner of the package didn't react to the ISSUE on Github or OEX for 3 months
run
USER > zn "%SYS"
%SYS > ZLOAD JOURNAL
%SYS > Printin WebTerminal you just get NOTHING
in normal terminal and iterm you see the code
@Mario Sanchez Macias You missed the point.
The essential functionality is to have a total autonomous partition to work in.
It was never named so, but it is the real Shell for ObjectScript and its predecessors for >50 years !
THX
simple case:
write some lines of ObjectScript in TERMINAL with Functions, ....
NO need to compile it, no INT, no MAC, no traces.
Just DO it:
---
or load some INT., apply your changes, run it, forget it
no save, no recompile, ...
WebTerminal is based on Xecute and compiled code
Same in Studio.
Overall a nice idea.
the package still needs some polishing to convince
suggestion1: fix issue to build clean docker
suggestion2: re-enable Start+Stop message so uses see it was moving
suggestion3: show which class you check , kind of work log
suggestion4: also step into sub-packages e.g. not just rcc but also rcc.unittests. codeinspector could be a good start
sugesstion5: allow also MAC, INT, INC code to be checked
I just can repeat my message from OEX review !
.png)
it would be great if the issues in building Docker container would be fixed.
so we can touch it and reduce frustration of evaluators first
Actually it is broken, Issues pending since some days
Your code looks like a ClassQuery. %Library.Query
This is not a Stored Procedure :=> a ClassMethod ...[SqlProc,SqlName=anyname]
and everything happens inside this ClassMethod
you run is by CALL PROCEDURENAME
I use it since Caché 2014.* at least.
this just the latest documentation.
What's the purpose of the semicolon ? SELECT Name,Home_State FROM Sample.Person ;
for TEMP table see: https://docs.intersystems.com/iris20242/csp/docbook/DocBook.UI.Page.cls?KEY=RSQL_createtable#RSQL_createtable_desc_temp
Before collecting all pieces in the Stores Procedure
I'd suggest to test you queries isolated im SMP or from terminal in SQL shell
UNderstand a STORED PROCEDURE as a special case of a ClassMethod
using CREATE PRODURE .......LANGUAGE OBJECTSCRIPT
You can write it with all specials you need
see docs: https://docs.intersystems.com/iris20242/csp/docbook/Doc.View.cls?KEY=RSQL_createprocedure
write $translate($justify(input,ln)," ",0) if $d(^|"%SYS"|CONFIG("Namespaces"," "))
for set ns=$o(@$ZR) quit:ns="" write ns,! ; or do whatever you intendThanks! A great summary!
Oh dear !
I started with DSM 1.0 in 1978 and met Terry in the kick-off training for support in Mainard.
It was a great experience to me.
ÍD is an reserved name in IRIS / Ensemble
in fact as you describe it, it is rather a KEY than a typical ID
so this query may serve your needs
SELECT LIST(Value) WHERE KEY=11
SELECT LIST(Value) WHERE KEY=12