Cannot read data returned from orient-db in Node js using Orentjs

[gprasadg]

Hello,

I am new to orient-db and trying to fetch data from DB in my node application .
I have OrientDB 2.2.7 and orientjs 2.2.x.

1. I have a function (Javascript ) that returns data from the DB.
   getlist : { return orient.getDatabase().query("select from user where _id = ?", uId ); }
2. I have used orientjs to call the function as
   odb.open().then(function () {
   {
   return commonjs.odb.query('SELECT getList(:uId, :vId, :mine , :pageNo , :limit)', {
   params: {
   uId: userId,
   vId: VUID,
   mine: all,
   pageNo: offset,
   limit: limit
   }
   }).then(function (res) {
   console.log(JSON.stringify(res));
   }
3. When I try to stringify the result I get error TypeError: Converting circular structure to JSON
   How do i get data returned from the function ?

Please help ..

[wolf4ood]

Hi @gprasadg

can post here the result set of the query executed from Studio (2)?

Which is your data model?

does it works if you run directly (1) ?

Thanks
Enrico

[gprasadg]

Hi Enrico,

1. this is out put from Studio

{
    "result": [
        {
            "@type": "d",
            "@rid": "#-2:1",
            "@version": 0,
            "getList": [
                {
                    "@type": "d",
                    "@rid": "#-2:0",
                    "@version": 0,
                    "_id": "Efs3CocpxFcaB3SS4",
                    "name": "xyz@gmail.com",
                    "photoUrl": "",
                    "ojjs": 9
                }
            ]
        }
    ],
    "notification": "Query executed in 0.286 sec. Returned 1 record(s)"
}

1. Entity is a graph entity
2. yes it runs if executed directly.
3. I get a circular structure object, when function is executed through orient js odb.query api.

[suyogdilipkale]

I have same problem, please suggest how to parse query result. its blocker for us.

[suyogdilipkale]

We still have problem to parse query results while calling simple select query or server side javascript function. ex. I have following result when i call Javascript function:

"result": [
    {
        "@type": "d",
        "@rid": "#20:3",
        "@version": 14,
        "@class": "User",
        "_id": "L7emzMnY9JEYsqjPp",
        **"in_ShareVGame": 
[{
        "uName": "Gameer@gmail.com",
        "uEmail": "Gameer@gmail.com",
        "uUsername": "Gameer@gmail.com",
        "uPhoto": "null",
        "@fieldTypes": "in_ShareVGame=g"},
  {
        "uName": "Gameer@gmail.com",
        "uEmail": "Gameer@gmail.com",
        "uUsername": "Gameer@gmail.com",
        "uPhoto": "null",
        "@fieldTypes": "in_ShareVGame=g"},
      }]**

}

I want to parse data from in_ShareVGame. but when I try in my node js code its no success.

There is no simple help available or an example, and its blocker for orientDB developers, please give an sample nodejs example how to parse query result. ex, if i get list of users and then i have to bind it to in HTML UI. trust me that will be great guidance for developers.

http://stackoverflow.com/questions/35346193/how-to-use-array-results-from-orientjs-query-in-another-query-array-is-not-an

[wolf4ood]

@gprasadg

I don't see any recursion in you dataset let me check with function call.

[wolf4ood]

@suyogdilipkale

what did you try?

[suyogdilipkale]

Tried to parse as json. But no luck. Now thinking to use their HTTP API
On Aug 26, 2016 12:24 PM, "Enrico Risa" notifications@github.com wrote:

@suyogdilipkale https://github.com/suyogdilipkale

what did you try?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#197 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/APbznF-D_eszFlm95hdbFbEIJxIScubSks5qjo2mgaJpZM4Jsv5G
.

[wolf4ood]

@suyogdilipkale

can you share some code?

did you try as suggested in SO ?

[suyogdilipkale]

here is sample node code:

db.open().then(function () {
console.log('db connection open');
db.query('SELECT in_ShareVGame(:uId,:vKId)', {
params: {
uId: "Efs3CocpxFcaB3SS4",
vKId:'672818a1-d163-dcd8-dab2-2a45c385207f'
}
}).then(function (response) {
var allUsers = response[0];
var firstUser =allUsers.in_ShareVGame[0];
});
});

Here I want to list all records from list, in code I have tried to parse 1st record.

[wolf4ood]

@gprasadg @suyogdilipkale

i'm not able to reproduce, can you help me with a little test case or something like that?

Thanks, Enrico

[suyogdilipkale]

Can please paste your sample server function and nodejs client code?
On Aug 29, 2016 6:49 PM, "Enrico Risa" notifications@github.com wrote:

@gprasadg https://github.com/gprasadg @suyogdilipkale
https://github.com/suyogdilipkale

i'm not able to reproduce, can you help me with a little test case or
something like that?

Thanks, Enrico

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#197 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/APbznFqUjVcpIZ0GWpG4KTf22SbTSGeVks5qktx_gaJpZM4Jsv5G
.

[wolf4ood]

@suyogdilipkale

this is the code i tested.

https://gist.github.com/maggiolo00/22e7f1001f35a42c42ab941b6b4ef4ac

i create a server side function and then invoke it in a select.

[suyogdilipkale]

You hv just returned the query results, can you please just parse those
list fields and console in for loop? Just to confirm all fields are
displayed.

Try with some traversed query response.
On Aug 29, 2016 8:30 PM, "Enrico Risa" notifications@github.com wrote:

@suyogdilipkale https://github.com/suyogdilipkale

this is the code i tested.

https://gist.github.com/maggiolo00/22e7f1001f35a42c42ab941b6b4ef4ac

i create a server side function and then invoke it in a select.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#197 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/APbznFK3miDx6Qu1qXExnPOqabUHyebpks5qkvP6gaJpZM4Jsv5G
.

[wolf4ood]

@suyogdilipkale

can you modify my script in order to reproduce your issue?