Yes, try this instead (in adaptor):
Method OnTask() As %Status
{
Set sc = ##super()
// all rows were just processed
// add your logic here
If '$IsObject(..%CurrResultSet) {
Set ^dbg($i(^dbg)) = "Last row"
}
Quit sc
}Worked for me.
It all depends on your locale.
In RUSW for example UTF8 is the default, bit not in English locales.
You can also use ^NLS to check/modify the defaults.
You can use both:
[ SqlComputeOnChange = (%%INSERT, %%UPDATE) ]
You can change the charset by setting this global:
set ^%SYS("CSP","DefaultFileCharset")="utf-8"
Do you want for each Movie object (row) to guarantee that it's Actors property would be unique (containing only distinct Actors)?
Or is it something else?
Can you show us examples of correct and incorrect Movie records?
I'd try
application/zipas a Content-Type.
Some questions/notes:
1. Why are you not using relationships?
2. If you have an object, which references another object in a property and you save a base object all it's properties-objects are also saved automatically. Have you thought about setting all references before save and after that only calling %Save() once?
3. I'd really recommend against relying on auto-incremental ID matches. They are NOT guaranteed to be equal.
4. The answer to your original question depends on where the failure was. %OnAfterSave is in transaction and is rolled back. However $Increment used to get hew IDs is not rolled back (as per documentation).
Tomorrow!
If you want it stored, make it triggered computed like this:
Property LabCode As %Library.String(MAXLEN = 64) [
SqlColumnNumber = 5,
SqlComputeCode = { set {*}= $EXTRACT({LabName},0,3)_" "_{LabID}},
SqlComputed,
SqlComputeOnChange = LabName ];Docs.
Note that it wouldn't recalc LabCode values for existing rows. If you need that, trigger recalculation with trivial update.
Use {%%ID}.
Here's an example:
Class util.Calc Extends %Persistent
{
Property calc As %String [ Calculated, SqlComputeCode = {set {*} = {%%ID}}, SqlComputed ];
/// do ##class(util.Calc).Test()
ClassMethod Test()
{
set obj = ..%New()
set sc = obj.%Save()
do ..AllFunc().%Display()
}
Query All() As %SQLQuery
{
SELECT *
FROM util.Calc
}
}Calling:
do ##class(util.Calc).Test()Returns:
ID calc
1 1
Docs.
That would work storagetime but not at runtime.
I think runtime hook disallowing duplicate inserts would be better.
To OP. Age seems like a strange property to store in your use case. It's better to store DoB I think.
There are many ways to do what you need.
Here's the questions you need to answer to choose the best path:
Some images are down for me.
Some info about upcoming AI/ML webinar.
Only a week left to register!
creatBlob
It probably should be createBlob.
What value are you expecting?
Base64 is often used to encode hashes:
write ##class(%SYSTEM.Encryption).Base64Encode(##class(%SYSTEM.Encryption).MD5Hash("f...@baz.com"))
You need to create a class, for example. Test.EnsUtils, in it add this class method.
After that execute the query above (name of the sql procedure would be Test.EnsUtils_ItemStatuses)
You'll need a SQL procedure to return status. I haven't found it already SQL enabled.
ClassMethod ItemStatuses(pName, pIsRunning, pEnabled, pID) As %String [ CodeMode = expression, SqlProc ]
{
##class(EnsPortal.Utils).ItemStatuses(pName, pIsRunning, pEnabled, pID)
}After that just query Ens_Config.Item:
SELECT
ID,
ClassName,
Name,
Enabled,
ItemStatuses(Name, 1, Enabled, Id) Status
FROM Ens_Config.ItemParameter pIsRunning means a running production.
Procedure returns comma-separated info about host status and io status.
What error are you getting?
The part of the code you've shown looks correct, except you don't need to call $zcvt, %Net.HttpRequest does that for you..
Converted original comment to an answer.
Full names always.
Check this guide.
Do you use an alternative or framework built around this native Unit Testing tool ?
Not really.
What is your experience with %UnitTest if you use it ?
Except lack of test parallelization it's actually quite good. Also would be great to be able to skip some tests natively.
Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question)
@Sergei Sarkisian any comments?
What process do you use to routinely run tests on your application ?
You can read about that in my series of articles on GitLab.
$ZUTIL(69,10) - Sets system behavior when journal is full.
Calls:
Parameters:
Description
$ZUTIL(69,10) determines Caché behavior when an error occurs in writing to the journal.
The default is zero (0). The native default for this switch is “false” (0); that is, to suspend journaling and allow Caché processing to continue. Invoking $ZUTIL(69,10) without specifying n returns the current switch setting.
This system-wide default can be configured. Go to the System Management Portal, select [Home] > [Configuration] >[Journal Settings]. View and edit the current setting of Freeze on error. The default is “No”. Setting $ZUTIL(69,10) changes the system configuration setting shown in the System Management Portal; this changepersists across a Caché shutdown and restart.
$ZUTIL(69,68) - Enables or disables the encryption of journal files system-wide.
Calls:
Parameters:
Description
The $ZUTIL(69,68) function disables or enables the encryption of journal files system-wide. $ZUTIL(69,68) takes effect when the next journal file is initiated.
Invoking $ZUTIL(69,68) without specifying n returns the current switch setting
$ZUTIL(69,70) - Enables or disables $DOUBLE returning INF and NAN values system-wide.
Calls:
Parameters
Description
The $ZUTIL(69,70) function sets the $DOUBLE function return value behavior system-wide. If 0, $DOUBLE returns INF (infinity), –INF, and NAN (Not A Number) for unresolvable IEEE floating point conversions. If 1, $DOUBLE generates Caché errors for unresolvable IEEE floating point conversions.
$ZUTIL(69,70) controls the issuing of INF, –INF, and NAN when a $DOUBLE numeric operation cannot be resolved to a numeric value. It does not control the issuing of INF, –INF, and NAN in all cases. $DOUBLE always returns INF, –INF, or NAN when you supply one of these strings as the input value, regardless of the $ZUTIL(69,70) setting.
Mathematical operations on $DOUBLE numbers that result in an INF, –INF, or NAN are controlled by $ZUTIL(69,70).
These include arithmetic operations, exponentiation, and logarithmic and trigonometric functions.
Invoking $ZUTIL(69,70) without specifying n returns the current switch setting.
add SOAP envelope
Not sure what are you trying to do. SOAP Operation should add all relevant headers and additional ones can be passed as objects. Docs.
UPD.
The quite strange thing is that when I try to log the class type I have obtained as output of the java class, I didn't get %String or some other
ObjectScript class but, instead, I get the xml message itself. It seem to be that the result don't have a proper class type.
That is correct, the ret variable seems to be a string, so it's not a class, therefore it cannot have a class name.
In Object Script there are objects and primitives (strings). Only objects have classes.
The final issue arise when I try to put the result into a stream; the xml message results empty and, moreover, If I try to send just the RPStream, I get this error: OID is null.
How are you doing it?
Please consider posting com.santer.siss.mapping.v25.fse.tester.HL7toXML:hl7ToRP method.
And also $$$CLASSNAME definition.
Which part of it?
There's like 5 different suggestions contradicting each other.
ByRef is just flavor text, only passing by dot matters.
Passing an object via dot to ByRef method argument means your code can return other object. If you only modify an existing object you don't need to use ByRef or pass object via dot.
I recommend using ByRef only in cases where you need to return different object.