Hi Community!
There are two general ways to execute arbitrary SQL in serverside ObjectScript code: EmbeddedSQL and ObjectScript SQL a.k.a. Dynamic SQL.
E.g. if we want to get the value of the property of instance with a certain ID using SQL we can do:
&sql(SELECT Name INTO :name FROM Sample.Person WHERE ID=1)
write nameSame result with %SQL.Statement:
set rs=##class(%SQL.Statement).%ExecDirect(,"SELECT Name as name FROM Sample.Person where ID=1")
do rs.%Next()
write rs.nameHi Community!
This is the update on what are the new applications submitted on OpenExchange in January and February 2019
This is a tiny example of how to run a server command from within Caché / Ensemble / IRIS and get back the full output as seen in any server command shell.
QEWD.js is a Node.js framework for REST APIs, interactive WebSocket and/or Ajax applications, capable of running as a monolithic application or split across MicroServices. Fully supports Cache, Ensemble and IRIS, allowing use of existing Cache ObjectScript code, Cache Objects and Cache SQL, but also allows the database to be abstracted as a persistent JSON / Document database.
With this simple Business Operation, you can easily leverage your predictive models (saved as PMML) in a Production. There's both a generic BO and a utility method that allows you to generate dedicated operation / request / response classes.
Helps to generate fake/test data for development purposes
WsockClient.csp and WsocClient.js
Web socket clients on CSP and InterSystems node.js adapter to collect end manage data transferred to the client in InterSystems IRIS or Caché
CachéQuality for VSCode by @Daniel Tamajon
IDE extension that helps you detect and fix quality issues as you write code. Like a spell checker, this extension squiggles flaws so they can be fixed before committing code. You can get it directly from the VS Code Marketplace and it will then detect new bugs and quality issues as you code (ObjectScript and JavaScript)
Hi Community!
When you run IRIS container out-of-the-box and connect to it via terminal e.g. with:
docker-compose exec iris bashYou see something like:
root@7b19f545187b:/opt/app# irissession IRIS
Node: 7b19f545187b, Instance: IRIS
Username: ***
Password: ***
USER>And you enter login and password every time.
How to programmatically setup docker-compose file to have IRIS container with OS authentication enabled? And have the following while entering the terminal:
root@7b19f545187b:/opt/app# irissession IRIS
Node: 7b19f545187b, Instance: IRIS
USER>
Hi Community!
Here is a digest of the Developer Community postings in February 2019.
Most viewed
How to Develop InterSystems Applications in Your Favorite IDE 240
Apache HTTPD Web Server Configuration for HealthShare 230
Alternative to using % to make a variable public 151
VSCode-ObjectScript next release 0.7.9 129
How to return JSON Array in SQL request for a List Property? 122
Tools and Framework Development and Deployment Guidelines . What is The Best Approach? 117
Consume data from websocket 114
What are the pros and cons of keeping INT code 112
Accessing the lock table and another process's variables, potentially on a different server 107
InterSystems IRIS Example Reference Architectures for Amazon Web Services (AWS) 105
Ethereum Adapter for InterSystems IRIS Data Platform 101
Using Oauth2 with SOAP (Web)Services 61
See the details below
Hi Community!
Good news! We have a new release of InterSystems Open Exchange.
This release comes with some better options to expose your solutions and tools.
What's new?
✓ Embedded videos;
✓ Screenshots;
✓ Download stats.
See the details below.
Hi Community!
Suppose I have a property in a ObjectScript class:
Property values As list Of %StringWhat an SQL query can help to return the values of the property as JSON array via SQL access (JDBC)?
Hi Community!
What's the limit for Namespaces and Databases for one InterSystems IRIS installation?
Yes, I checked with documentation but cannot find it at once.
Hi guys!
Suppose you developed a tool, framework, library on InterSystems ObjectScript for InterSystems Data Platform, share it via Open Exchange and want people to install it.
What is the best strategy if it is a library and supposed to be called from different namespaces?
Here are the following thoughts:
1. Tool's developer should be able to use globals to read/store data the tool needs.
2. Tool's consumer should be confident, that the thing he/she installs will not harm the application's data.
3. A tool should be callable from any application's namespace.
4. Tool's installation(in general) should not request manual security changes (e.g. grant the write access to IRISLIB) and %YourClass is not an option.
5. It's easy to uninstall the tool - just delete the namespace/database (maybe delete some web-apps too).