go to post Evgeny Shvarov · Sep 26 Cool! Add dsw? Curious how it displays it? Also, DSW works neatly on a mobile
go to post Evgeny Shvarov · Sep 24 Thanks @David Hockenbroch ! An almost ideal pattern to run an SQL query in ObjectScript. If you could also share with error handling around? My typical pattern looks like this one below. Includes try-catch in case when I need to rollback something: try { set tStatement = ##class(%SQL.Statement).%New() set query = "ALTER Table "_table_" ADD PRIMARY KEY ("_column_")" $$$TOE(st,tStatement.%Prepare(query)) set rset=tStatement.%Execute() if rset.%SQLCODE < 0 { write "Error adding primary key: "_rset.%SQLCODE_" "_rset.%Message set ex=##class(%Exception.SQL).CreateFromSQLCODE(rset.%SQLCODE,rset.%Message) $$$ThrowStatus(ex.AsStatus()) } } catch ex { set st=ex.AsStatus() }
go to post Evgeny Shvarov · Sep 1 Oh my god! What a drama! Guys, you are maybe late for the Venice Film Festival 2025, but the Oscar 2026 nomination is yours! And moreover, Dave Davidson is healthy and sound because of Interoperability and InterSystems! Thanks @Vishal Pallerla and team!
go to post Evgeny Shvarov · Aug 27 It's not for JSON transformation directly, but a nice package by @Guillaume Rongier that lets you have messages contain data in JSON vs XML in the Interoperability pipeline.
go to post Evgeny Shvarov · Aug 23 Hi @Dmitrij Vladimirov ! This is pure ObjectScript AFAIK in an expression mode (think of it if you create a classmethod in ObjectScript in Expression mode), with options of %source to reference base class properties and %cube to reference Cube class methods.
go to post Evgeny Shvarov · Aug 21 BTW, faced the same situation today to have an option of getting full sqlname for a class, and generated a classmethod in VSCode with AI (no my personal touch): ClassMethod GetSQLTableName(pclass As %String) As %String { // returns the SQL table name for a class set tablename = ##class(%DeepSee.Utils).%GetSQLTableName(pclass) if tablename="" { set tablename=$TR($P(pclass,".",1,*-1),".","_")_"."_$p(pclass,".",*) } return tablename } And its working. Not bad for a bot.
go to post Evgeny Shvarov · Aug 20 Hi @Sam Duncan ! I think DC AI Bot answered right: if you try also add: zpm "enable -community" this will allow to install packages from a community registry
go to post Evgeny Shvarov · Aug 19 I guess DC AI bot takes only the post body into the consideration thinking the title is a summary of the post. I this case title is one question and post body is another one.
go to post Evgeny Shvarov · Aug 19 Thanks for this great contribution, @David McCaldon ! Could you please also publish at Open Exchange?
go to post Evgeny Shvarov · Aug 18 In anyways, there are folks on the community that can help even with these already undocummented stuff )
go to post Evgeny Shvarov · Aug 18 $zel, $zlp - two new ObjectScript functions in one day after more than 10 years in InterSystems... Love this community! )
go to post Evgeny Shvarov · Aug 18 Great app, @Raj Singh ! thanks for the contribution! Adding two more "cents" for different LOAD DATA usage options: 1. csvgen app, which allows you to create a table and import data automatically as simply as: do ##class(community.csvgen).Generate("/home/irisowner/dev/data.csv",",","package.class") It will guess datatypes and use LOAD DATA under the hood. 2. And csvgen-ui - a web UI for csvgen by @Guillaume Rongier Also, if you are into embedded Python, take a look at csvgenpy, which uses not LOAD DATA, but sqlalchemy.
go to post Evgeny Shvarov · Aug 14 Thank you, @John Murray, for what you did and keep doing for this community! Well deserved!
go to post Evgeny Shvarov · Aug 13 It works because you published a question on Developer Community :) (Joking, of course :) Jokes aside - a very helpful discussion! Thanks @Sylvain Guilbaud !
go to post Evgeny Shvarov · Aug 13 a really helpful repo, @Sylvain Guilbaud ! do you want to publish it on OEX? Please? )
go to post Evgeny Shvarov · Aug 13 Hi Paul! I suggest to take a look two mechanisms: 1. merge cpf - you can list the configuration changes made to vanilla iris/or your custom image. Example project, merge.cpf. 2. IPM with IPM you can deploy classes, web apps, files and production elements, run install scripts and version product changes. Example project, IPM manifest.
go to post Evgeny Shvarov · Aug 13 I see that coding guidlines for ObjectScript linter should be a document (json? yaml?) you include in your code repository or reference any file in a github/gitlab and VSCode linter follows it on-the-go. Or as some ObjectScript.Quality like ruleset, is it possible @Daniel Tamajon ? Or as a codetidy feature by @Timothy Leavitt, but it's not easy to use.
