Hi all,
I am trying to compile my swagger class file with swagger JSON which is a valid JSON as I created it and verified from swagger.io 2.0 spec.
But getting below error. I am not very clear with the error message. Please help me resolve the same.
ObjectScript error: <CLASS DOES NOT EXIST>removeprj+7^%occClass *SwaggerClass

> ERROR #5091: An error has occurred while removing projection SwaggerClass:Reference.

> ERROR #5030: An error occurred while compiling class 'SwaggerClass'

Hi all,
I am trying to execute a query like the below code.
set statement = ##class(%ResultSet).%New("some_class:query_method").   // here query method is empty and with rowspec some columname

statement.Execute(param1)

I want to fetch data type of column value returned from above. eg - Name - VARCHAR, amount - INTEGER etc.
How can I get it. Or if not possible directly. Is there any other way to validate or get datatype of values returned. Line we have type() in python3

Hi all,

I am using %Library.ResultSet to execute my query which I have something like this.
Query GetABC() As %SqlQuery [SqlProc]{

}

After I execute this query and a resultset it returns from this. Now What I want to know is the SQL statement which will have the values dynamically added into while execution.

Hi All,

I am facing some issues. I am having a SQL query that is executed using %SQL.Statement ExecDirect() method. Now I want to convert it into Embedded SQL using &SQL().
But where clause is dynamic in my case and It may contain 3-4 clauses.

Hi All,

I am trying to fetch resultset using the below code - 

set rs = ##class(%ResultSet).%New("Simple.Person:ValidateAge")

do rs.Execute()

it is giving me error while the same code I run it through iris terminal worked fine. 
I want to understand that problem behind this. Also how can I check the possible methods that I can use on 'rs' somewhat dir() does in python.

Hi all,

I am using ExecDirect() method to get SQL resultset of type %SQL.StatementResult. 

now I am fetch a column something like this rs.%Get("Amount") but if amount column is empty then it is return me empty string. If There is any way to set something like this in IRIS rs.%Get("Amount",0.00) if that is possible.

Hi all,
I am creating a property in my class something like below. I want to initialize it to 0.00 this a default value.

Property currentLimit As %Numeric(SCALE = 2);

Hi all,
I am using ExecDirect() method to execute my SQL query which is something like "SELECT * from Account where AccountNumber = ? "
But when I am providing a accountnumber that don't exists it doesn't return anything as aspected. while I am trying to check resultset.%SQLCODE in this case it is giving me 0 not 100. What's wrong with my SQL query and Also I there any other Property through which I check for if my resultset is null or it has some values.

Hi All,

I am writing few test for REST API need help from you guys as  I am new to Objectscript. I want to implement mocking into testcase but didn't get any good resource for the same. please help me

Getting INVALID OREF error while unit testing. Also ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size() these are working fine getting 7 value from both. but still it is not working.

do $$$AssertEquals(ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size(), "Validation for Headers")

error - INVALID OREF>TestAccountSearchWithoutAccount+6

Hi All,
I want to write testcase in objectscript but stuck at this point where I am getting a DynamicObject from the class method and how can I assert this and check it is okay. 
Also if in any case error It will throw error custom exception class that I created. How to handle assertion for exception in this case also.

Hi All,
I was creating a unit test directory with the below script. But it not creating any directory as mentioned in code. I am working on MacBook with irisusr User as standard installation process.

if '$data(^UnitTestRoot) {

set mainFolder = "UnitTest\NewDir\"

set st = ##class(%File).CreateDirectoryChain(mainFolder _ testSuite)

if $$$ISOK(st) { set ^UnitTestRoot = mainFolder }

else {

write !, "UnitTestRoot folder could not be created. Consult with instructor."

do $system.Status.DisplayError(st)

}

}

Hi All,

I am trying to execute my SQL query using ExecDirect() method and it returns a ResultSet. No doubt it works fine after this I am trying to fetch each value using a loop code below. But before that, I am also checking for %SQLCODE = 100 which is for an empty resultset I think. However, It is not working as desired. In the case of an empty resultset also I am getting %SQLCODE = 0 until result.%Next() is called. Also, %ROWCOUNT is giving 0 in a case where my query is return 1 result row. I am so confused about this.
while resultset.%Next() {

// code

}

I am creating a class code below

Class Sample.Header

{

Property Key As %String;

Property Show As %Boolean;

}

when I am trying to create an object of this class

using set obj = ##class(Sample.Header).%New()

getting error <METHOD DOES NOT EXIST> %New, Sample.Header

Hi all,
I have install git-source-control to the namespace TEST. Also it is working fine as I am able to add files to my local git repo and see the changes in it.
But while I try to open GUI for the same i am getting service unable error on this URL 

http://127.0.0.1:52773/isc/studio/usertemplates/gitsourcecontrol/gitpro…

what's wrong with this.

Hello all,
I am creating a REST API with a spec-first approach. However, I am using the try-catch method to handle any exception if any occurs. But whenever any error related to syntax or something occurs, we get internal server error 

{

"errors": [

{

"code": 6220,

"domain": "%ObjectErrors",

"error": "ERROR #6220: Internal Server Error",

"id": "InternalError"

}

],

"summary": "ERROR #6220: Internal Server Error"

}

This is I think IRIS defined, I want to customize my own Internal server error. 

I am having a datatype DATE value from db 41966. And I want to convert it to epoch time.
Also, in case of DATETIME value how can I convert it to epoch.

I want to fetch both column name and value from resultset of sql query . I am using ExecDirect() method for SQL execution. 

please help me out.

Hi everyone, 
I am new to "git-source-control", what i am doing so far will explain you in few steps.
1. installed git-source-control into a namsapace TEST using ZPM "install git-source-control"
2. configure the git settings and created a new mapping for as such 

3. Now when I am trying to ADD a new file which is created for eg - NewFolder/impl.cls , getting an error like this

exporting new version of NewFolder.impl.cls to /Users/abc/workspace/NewFolder/impl.cls

No mapping with a matching path found for file NewFolder/impl.cls

ERROR #5001: Create Directory failed: _err
Here workspace is my git repo

Unable to run iris terminal as well as on management portal I am getting permission error.

ERROR in page definition:
Error #940: Insufficient privilege for operation

I already have created a User - irisusr and group - irisusr

if I am running sudo iris terminal IRIS command then it open terminal But earlier it was working fine.

getting an error while installing  git-source-control
Log of error 
 

zpm "install git-source-control"

[TTN|git-source-control]    Reload START (/Users/irisusr/mgr/.modules/TTN/git-source-control/2.2.0/)
[TTN|git-source-control]    Reload SUCCESS
[git-source-control]    Module object refreshed.
[TTN|git-source-control]    Validate START
[TTN|git-source-control]    Validate SUCCESS
[TTN|git-source-control]    Compile START
[git-source-control]    Compile FAILURE
ERROR!

I want to connect IRIS system as it has all the database tables. on top of that I am creating a REST API in python. How can I connect to IRIS DB. here is my example code for connection

def connect():

connection_string = "localhost:1972/USER"

username = "_SYSTEM"

password = "SYS"

conn = iris.connect(connection_string, username, password)

after this connection is created but how can I get tables data. Please let me know more about how we can integrate IRIS database into a python REST API.

I have a repository on github. I wanna setup that repo into my local IRIS instance and also I want to work on different branch and commit those back to the same repo. 
Please help me through this. 
I also have a .DAT file which i think contains code and data and not .git folder. So how can i sync that to my git repo for further development.

I am having code like this,

set args = []

set resultSet = ##class(%SQL.Statement).%ExecDirect( , sql_whereClause, args)

Instead of placing args[1],args[2] etc into the above I want to pass the whole args at a time if it possible.?

how can we track logs of our rest api that we create in web applications. As i am running it on local system.

how can i use git for versioning while working in IRIS. 
I am having directory that i created while working in iris. How can i manage version control using git in this case.

Is it possible with vscode terminal or with a normal terminal in mac.

Just for knowledge purpose. Is there any disadvantage of using IRIS on Mac/Linux machine over a windows system

how can i import IRIS.DAT file into iris system. I am told that it is database file that will be import into iris db.

Unlike IRIS Studio have compile depended classes feature. How to achieve this in mac on Vscode.

IRIS on mac unable to run my rest api which I created using spec first approach. 
I am getting a 403 forbidden account error.