Re: [orientdb] Re: Fetch plan: Return expanded resultset
In the example below, is there anyway to avoid having the "this" returned
when using the toJSON way when using binary protocol
{ '@type': 'd',
this: '{"@rid":"#12:0"}
On Sunday, 1 November 2015 21:09:18 UTC, l.garulli wrote:
>
> Hey Tommy,
>
> Fetchplan with binary drivers (orientjs) works in different way than HTTP:
> fetched objects are sent to the client, so it stores them on a local cache
> for further retrieval. Look at:
> http://orientdb.com/docs/last/Fetching-Strategies.html#remote-connection.
>
> You could rather pass the fetchplan to the *.toJSON()* function. Example:
>
> select @this.toJSON('last_comment:0') from Questions order by createdAt desc
>
> But in this case the return is a JSON, not a Document instance.
>
> Look at:
> http://orientdb.com/docs/last/Fetching-Strategies.html#export-a-document-and-its-nested-documents-in-json
>
>
> Best Regards,
>
> Luca Garulli
> Founder & CEO
> OrientDB <http://orientdb.com/>
>
>
> On 31 October 2015 at 13:47, Thomas Kennedy <tomais....@gmail.com
> > wrote:
>
>> Any help would be much appreciated.
>>
>> On Wednesday, 28 October 2015 10:16:12 UTC, Thomas Kennedy wrote:
>>>
>>> I have a simple query
>>>
>>> select * from Questions fetchplan last_comment:0 order by createdAt desc
>>>
>>> I am looking for the resultset to return the last_comment expanded along
>>> with the result of the questions class.
>>>
>>> I am using a Orientjs to interface with orient. It doesnt return the
>>> expanded resultset. However when i run the above command in studio, I see
>>> it expanded.
>>>
>>> What do i need to do here?
>>>
>>> Orientdb v2.0.12
>>>
>>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to orient-databa...@googlegroups.com .
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Fetch plan: Return expanded resultset
Any help would be much appreciated. On Wednesday, 28 October 2015 10:16:12 UTC, Thomas Kennedy wrote: > > I have a simple query > > select * from Questions fetchplan last_comment:0 order by createdAt desc > > I am looking for the resultset to return the last_comment expanded along > with the result of the questions class. > > I am using a Orientjs to interface with orient. It doesnt return the > expanded resultset. However when i run the above command in studio, I see > it expanded. > > What do i need to do here? > > Orientdb v2.0.12 > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Fetch plan: Return expanded resultset
I have a simple query select * from Questions fetchplan last_comment:0 order by createdAt desc I am looking for the resultset to return the last_comment expanded along with the result of the questions class. I am using a Orientjs to interface with orient. It doesnt return the expanded resultset. However when i run the above command in studio, I see it expanded. What do i need to do here? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Querying Last Record LinkedList
I have a class User below and I'm storing profile pictures as a linkedlist
to another class called ProfilePicture.
I want to return all the columns in User and the last entry in the
profile_picture.
Any ideas how this query would look?
[ { '@type': 'd',
'@class': 'User',
username: 'tom',
email: 't...@tom.com',
profile_picture: [ [Object] ],
id: '#13:0' }
]
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Querying Last Record LinkedList
I solved it like this
Select email, last(profile_picture.filename) from User where username =
'tom'
Is this the most efficient way though?
On Monday, 22 June 2015 22:36:02 UTC+1, Thomas Kennedy wrote:
I have a class User below and I'm storing profile pictures as a linkedlist
to another class called ProfilePicture.
I want to return all the columns in User and the last entry in the
profile_picture.
Any ideas how this query would look?
[ { '@type': 'd',
'@class': 'User',
username: 'tom',
email: 't...@tom.com',
profile_picture: [ [Object] ],
id: '#13:0' }
]
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Time Series Last Node Link
I have a time series modelled in the graph way year(linkmap)-month(linkmap)-day(linkmap)-hour(linkmap) I have two other vertices which are events and users I want to join events to the time series. Is this best achieved by using an edge or a linkset? year(linkmap)-month(linkmap)-day(linkmap)-hour(linkmap)- ?Edge|Linkset? Event - User -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Edge Query Issue
I have a time series model where I create an edge between a hour vertex and
an event vertex. The edge is called registered_event.
I have tried the following query but it is not giving me results. Any ideas?
select expand(month[12].day[3].hour[23]).out('registered_event') from Year
where year = 2015
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Edge Query Issue
Correction it gives me the below record but I want to expand the
out('registered_events') relationship
METADATAPROPERTIESOUT
@rid
@version
@class
hour
registered_events
#24:7
http://localhost:2480/studio/index.html#/database/test/browse/edit/24:741
Hour23
#27:0
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:0
#27:1
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:1
#27:2
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:2
#27:3
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:3
#27:4
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:4
#27:5
http://localhost:2480/studio/index.html#/database/test/browse/edit/27:5
On Tuesday, 2 June 2015 23:39:55 UTC+1, Thomas Kennedy wrote:
I have a time series model where I create an edge between a hour vertex
and an event vertex. The edge is called registered_event.
I have tried the following query but it is not giving me results. Any
ideas?
select expand(month[12].day[3].hour[23]).out('registered_event') from Year
where year = 2015
On Tuesday, 2 June 2015 23:39:55 UTC+1, Thomas Kennedy wrote:
I have a time series model where I create an edge between a hour vertex
and an event vertex. The edge is called registered_event.
I have tried the following query but it is not giving me results. Any
ideas?
select expand(month[12].day[3].hour[23]).out('registered_event') from Year
where year = 2015
On Tuesday, 2 June 2015 23:39:55 UTC+1, Thomas Kennedy wrote:
I have a time series model where I create an edge between a hour vertex
and an event vertex. The edge is called registered_event.
I have tried the following query but it is not giving me results. Any
ideas?
select expand(month[12].day[3].hour[23]).out('registered_event') from Year
where year = 2015
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Activity Feed
Hi, Has anybody implemented an activity feed in Orient? Something like Linkedin or Twitter. I am looking for examples on how to do this? Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Extends OTriggered - Problem retrieving edge
I am having setting up a hook on a class. After altering the class to be OTriggered I am not able to retrieve any connected edges to that class. Does anybody know why this might be? Class A - Vertex Class B - OTriggered Class connected - Edge A-Connected-B If I convert B back to be a vertex then I am able to call the edge. Orient 2.0.5 -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Functions Javascript Copy Object Value
Hi, I am using the graph API in Javascript and was wondering how to split a string, var dStr = r[key].getRecord().field(@Rid); dStr.slice(1,3) It gives an error Cannot find function slice in object #17:6 Any tips on how to best copy the value out of the orient object so I can edit? Regards, Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Functions Javascript Copy Object Value
Solved by creating a string Object. new String(OrientOBj); On Thursday, 26 June 2014 21:48:12 UTC+1, Thomas Kennedy wrote: Hi, I am using the graph API in Javascript and was wondering how to split a string, var dStr = r[key].getRecord().field(@Rid); dStr.slice(1,3) It gives an error Cannot find function slice in object #17:6 Any tips on how to best copy the value out of the orient object so I can edit? Regards, Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Nodes and Edges
Hi Luca,
The node is traversed from #11:0. The vertices A are connected by an edge
called connects. I need to return all nodes and all links.
Regards,
Tom
@Class RID Name In out
-
A | #11:0 | Link1
A | #11:1 | Link2
A | #11:2 | Link3
A | #11:3 | Link4
Connects | #12:0 | | #11:1 | #11:0
Connects | #12:1 | | #11:2 | #11:1
Connects | #12:2 | | #11:3 | #11:2
On Monday, 9 June 2014 21:45:43 UTC+1, Lvc@ wrote:
Hi Thomas,
May you post here, given that domain, what's te result you want in terms
of output?
Lvc@
On 9 June 2014 20:20, Thomas Kennedy tomais@gmail.com javascript:
wrote:
Can anybody help here?
On Monday, 9 June 2014 08:17:20 UTC+1, Thomas Kennedy wrote:
The Root Node is #11:0
But I need both Class's V and E returned. And I only need the edge
connect.
select outE('connects') from A
It also sees to only go one level. I need all the connected edges of the
tree returned.
On Monday, 9 June 2014 00:09:27 UTC+1, Lvc@ wrote:
Hi,
Where do you start? If you don't have a root vertex, you could do:
select *, outE() from A
Or even:
select *, inV() from Connects
Lvc@
On 8 June 2014 18:20, Thomas Kennedy tomais@gmail.com wrote:
Hi,
I have a node A and these are connected by an edge called connects.
I want to return Both Vertex and Edge in the Query?
Any help would be grateful?
A
RID Name
-
#11:0 | Link1
#11:1 | Link2
#11:2 | Link3
#11:3 | Link4
Connects
RIDOut In
--
#12:0 | #11:1 | #11:0
#12:1 | #11:2 | #11:1
#12:2 | #11:3 | #11:2
--
---
You received this message because you are subscribed to the Google
Groups OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send
an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an
email to orient-databa...@googlegroups.com javascript:.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Nodes and Edges
The Root Node is #11:0
But I need both Class's V and E returned. And I only need the edge connect.
select outE('connects') from A
It also sees to only go one level. I need all the connected edges of the
tree returned.
On Monday, 9 June 2014 00:09:27 UTC+1, Lvc@ wrote:
Hi,
Where do you start? If you don't have a root vertex, you could do:
select *, outE() from A
Or even:
select *, inV() from Connects
Lvc@
On 8 June 2014 18:20, Thomas Kennedy tomais@gmail.com javascript:
wrote:
Hi,
I have a node A and these are connected by an edge called connects.
I want to return Both Vertex and Edge in the Query?
Any help would be grateful?
A
RID Name
-
#11:0 | Link1
#11:1 | Link2
#11:2 | Link3
#11:3 | Link4
Connects
RIDOut In
--
#12:0 | #11:1 | #11:0
#12:1 | #11:2 | #11:1
#12:2 | #11:3 | #11:2
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an
email to orient-databa...@googlegroups.com javascript:.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Nodes and Edges
Can anybody help here?
On Monday, 9 June 2014 08:17:20 UTC+1, Thomas Kennedy wrote:
The Root Node is #11:0
But I need both Class's V and E returned. And I only need the edge connect.
select outE('connects') from A
It also sees to only go one level. I need all the connected edges of the
tree returned.
On Monday, 9 June 2014 00:09:27 UTC+1, Lvc@ wrote:
Hi,
Where do you start? If you don't have a root vertex, you could do:
select *, outE() from A
Or even:
select *, inV() from Connects
Lvc@
On 8 June 2014 18:20, Thomas Kennedy tomais@gmail.com wrote:
Hi,
I have a node A and these are connected by an edge called connects.
I want to return Both Vertex and Edge in the Query?
Any help would be grateful?
A
RID Name
-
#11:0 | Link1
#11:1 | Link2
#11:2 | Link3
#11:3 | Link4
Connects
RIDOut In
--
#12:0 | #11:1 | #11:0
#12:1 | #11:2 | #11:1
#12:2 | #11:3 | #11:2
--
---
You received this message because you are subscribed to the Google
Groups OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send
an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Nodes and Edges
Hi, I have a node A and these are connected by an edge called connects. I want to return Both Vertex and Edge in the Query? Any help would be grateful? A RID Name - #11:0 | Link1 #11:1 | Link2 #11:2 | Link3 #11:3 | Link4 Connects RIDOut In -- #12:0 | #11:1 | #11:0 #12:1 | #11:2 | #11:1 #12:2 | #11:3 | #11:2 -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Javascript JSON Marshalling
This would be nice.
On Wednesday, 21 May 2014 12:45:47 UTC+1, Charles Pick wrote:
yes sounds good, should also support the normal
application/x-www-form-urlencoded
mime type, so the client can POST data like:
params[foo]=fooparams[bar]=bar
and the server would convert into:
{
params: {
foo: 'foo',
bar: 'bar'
}
}
which will make it easier to test with standard tooling and allow
interaction from the browser without depending on JS.
Charles
On Wed, May 21, 2014 at 11:18 AM, Luca Garulli l.ga...@gmail.comjavascript:
wrote:
Hi Thomas,
we could support passing a JSON as payload of POST operation with a JSON
that will be bound to params. Example:
{ a : 3, b : Jill }
And in my function I'll find the 2 params a and b bound with such value.
Charles is working to the new HTTP Api, WDYT Charles about it?
Lvc@
On 21 May 2014 01:18, Thomas Kennedy tomais@gmail.com
javascript:wrote:
JSON.parse fixed this.
On Tuesday, 20 May 2014 23:40:36 UTC+1, Thomas Kennedy wrote:
I have a server side with javascript function one parameter called Data.
The value of Data is {test:5}. This is passed in as a string.
in the javascript function I want to access the value of test.
return Data.test is not working
either is
var temp = JSON.stringify(Data);
return temp.test
Any help here how to convert string to JSON and access the object
properties
--
---
You received this message because you are subscribed to the Google
Groups OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send
an email to orient-databa...@googlegroups.com javascript:.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Data Modelling Question (Linkmap, Edge, Embeddedmap....)
I have a question about how to store some instances of meta data in a class. I have a class called Foo which stores instances of data. I have another class called properties that stores meta data of fields that can be stored in Foo.Properties. class Foo Name | String Properties | ? class Properties Name | String Type | String So what I want is to have something like RID NameProperties #11:0 record1 [#12:0:5,#12:1:20] #11:1 record2 [#12:2:[A,B,C,D]] RID Name Type #12:0 Min double #12:1 Maxdouble #12:2 Codes List What is the best way to link Foo.Properties with Properties class? Is this a linkmap, embeddedmap? Help with much appreciated Hope I was clear. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Data Modelling Question (Linkmap, Edge, Embeddedmap....)
Or should I have an edge that stores the instance of the value such as
Create vertex Foo set Name = record1
-#11:0
Create edge hasProperties from #11:0 to [#12:0,#12:1] set values = {5,20}
This way I would be able to get The meta data information and have instance
values associated with them?
Any thoughts?
On Wednesday, 21 May 2014 19:52:48 UTC+1, Thomas Kennedy wrote:
I have a question about how to store some instances of meta data in a
class.
I have a class called Foo which stores instances of data.
I have another class called properties that stores meta data of fields
that can be stored in Foo.Properties.
class Foo
Name | String
Properties | ?
class Properties
Name | String
Type | String
So what I want is to have something like
RID NameProperties
#11:0 record1 [#12:0:5,#12:1:20]
#11:1 record2 [#12:2:[A,B,C,D]]
RID Name Type
#12:0 Min double
#12:1 Maxdouble
#12:2 Codes List
What is the best way to link Foo.Properties with Properties class? Is this
a linkmap, embeddedmap?
Help with much appreciated Hope I was clear.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Javascript JSON Marshalling
JSON.parse fixed this.
On Tuesday, 20 May 2014 23:40:36 UTC+1, Thomas Kennedy wrote:
I have a server side with javascript function one parameter called Data.
The value of Data is {test:5}. This is passed in as a string.
in the javascript function I want to access the value of test.
return Data.test is not working
either is
var temp = JSON.stringify(Data);
return temp.test
Any help here how to convert string to JSON and access the object
properties
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] SQL Batch HTTP API
OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25
15:54:54
On Sun, May 11, 2014 at 8:20 AM, Thomas Kennedy tomais.kenn...@gmail.comwrote:
Hi,
I am executing the following using HTTP interface
{
transaction: true,
operations: [
{
type: script,
language: sql,
script: select * from ouser;
}
]
}
and get back the following error message? Has anybody been able to use the
SQL batch command. If so what should the JSON look like?
{ transaction : true,operations : [{ type : script, language :
sql, script : select * from ouser; } ]}string(126)
java.lang.ClassCastException:
com.orientechnologies.orient.core.sql.OSQLScriptEngine cannot be cast to
javax.script.Compilable
--
---
You received this message because you are subscribed to a topic in the
Google Groups OrientDB group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/orient-database/CvGzn_gI5qk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: SQL Batch HTTP API
OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25
15:54:54
On Sunday, 11 May 2014 08:20:56 UTC+1, Thomas Kennedy wrote:
Hi,
I am executing the following using HTTP interface
{
transaction: true,
operations: [
{
type: script,
language: sql,
script: select * from ouser;
}
]
}
and get back the following error message? Has anybody been able to use the
SQL batch command. If so what should the JSON look like?
{ transaction : true,operations : [{ type : script, language :
sql, script : select * from ouser; } ]}string(126)
java.lang.ClassCastException:
com.orientechnologies.orient.core.sql.OSQLScriptEngine cannot be cast to
javax.script.Compilable
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: SQL Batch HTTP API
Thanks Eric.
I downloaded the latest snapshot from may 8th. Unfortunately its still not
working for me.
Have you used this feature?
On Sunday, 11 May 2014 08:39:34 UTC+1, Erik Peterson wrote:
You may try a later snapshot, see...
https://oss.sonatype.org/content/repositories/snapshots/com/orientechnologies/orientdb-community/1.7-SNAPSHOT/
Erik
On Sunday, May 11, 2014 1:22:31 AM UTC-6, Thomas Kennedy wrote:
OrientDB console v.1.7-rc2 (build UNKNOWN@r${buildNumber}; 2014-03-25
15:54:54
On Sunday, 11 May 2014 08:20:56 UTC+1, Thomas Kennedy wrote:
Hi,
I am executing the following using HTTP interface
{
transaction: true,
operations: [
{
type: script,
language: sql,
script: select * from ouser;
}
]
}
and get back the following error message? Has anybody been able to use
the SQL batch command. If so what should the JSON look like?
{ transaction : true,operations : [{ type : script, language :
sql, script : select * from ouser; } ]}string(126)
java.lang.ClassCastException:
com.orientechnologies.orient.core.sql.OSQLScriptEngine cannot be cast to
javax.script.Compilable
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: OrientDB official Node.js driver
This is really great Luca. Hopefully the community can be active to post examples and provide code snippets to help others. On Wednesday, 7 May 2014 23:56:42 UTC+1, Lvc@ wrote: Hi, We decided to adopt the Oriento driver as the official *Node.js* driver for OrientDB. Now you can find it under the Orient Technologies umbrella projects: *https://github.com/orientechnologies/oriento https://github.com/orientechnologies/oriento* Why this driver? Because: - it's the most updated, aligned with 1.7-SNAPSHOT - the development is very active - has beautiful API I'm sure this will increase the OrientDB adoption for Node.js users. Thanks to Charles and all the driver contributors! Are you a driver author? Please let us know your plans, we'll evaluate to adopt it as official. Lvc@ -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Php Rest - Batch
Hi,
I am trying to use the batch interface to insert records. I have attached a
simple one record insert.
It is giving me an error
string(78) java.lang.ClassCastException: java.lang.String cannot be cast
to java.util.Map
Any suggestions?
Regards,
Tom
?php
$url = http://admin:admin@localhost:2480/batch/TestDB;;
$transaction = {'transaction' : true, 'operations' : [' { 'type' : 'c',
'record' : { '@class' : 'FieldsInstance', 'name' : 'Tommy'}]};
$ch = curl_init();
// set the target url
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
// do basic login authentication
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $transaction);
$res = curl_exec($ch);
curl_close($ch);
echo var_dump($res);
?
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Php Rest - Batch
There URL was incorrect.
Issue: fixed
On Tuesday, 22 April 2014 21:21:58 UTC+1, Thomas Kennedy wrote:
Hi,
I am trying to use the batch interface to insert records. I have attached
a simple one record insert.
It is giving me an error
string(78) java.lang.ClassCastException: java.lang.String cannot be cast
to java.util.Map
Any suggestions?
Regards,
Tom
?php
$url = http://admin:admin@localhost:2480/batch/TestDB;;
$transaction = {'transaction' : true, 'operations' : [' { 'type' : 'c',
'record' : { '@class' : 'FieldsInstance', 'name' : 'Tommy'}]};
$ch = curl_init();
// set the target url
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
// do basic login authentication
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $transaction);
$res = curl_exec($ch);
curl_close($ch);
echo var_dump($res);
?
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Php Rest - Batch
Correction the POSTFIELDS parameter was incorrect.
On Tuesday, 22 April 2014 21:55:48 UTC+1, Thomas Kennedy wrote:
There URL was incorrect.
Issue: fixed
On Tuesday, 22 April 2014 21:21:58 UTC+1, Thomas Kennedy wrote:
Hi,
I am trying to use the batch interface to insert records. I have attached
a simple one record insert.
It is giving me an error
string(78) java.lang.ClassCastException: java.lang.String cannot be cast
to java.util.Map
Any suggestions?
Regards,
Tom
?php
$url = http://admin:admin@localhost:2480/batch/TestDB;;
$transaction = {'transaction' : true, 'operations' : [' { 'type' : 'c',
'record' : { '@class' : 'FieldsInstance', 'name' : 'Tommy'}]};
$ch = curl_init();
// set the target url
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, 1);
// do basic login authentication
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $transaction);
$res = curl_exec($ch);
curl_close($ch);
echo var_dump($res);
?
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: console - embedded maps
I expect to see {Name:List}
On Monday, 7 April 2014 18:13:09 UTC+1, Thomas Kennedy wrote:
Hi,
I trying t use the console to insert some value into an embedded map type.
I input {Name:List} into the textbox and save and
get {Name:{List:null}} instead.
Can anybody help me with what im doing wrong.
Regards,
Tom
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Does OrientDB has collections?
Kevin, Orient has Classes which can be either a vertex or an edge if you want to use graph approach or you can just create a class which is the same a document collection. These classes are like documents in Mongo and can be schemaless. The studio is great to quickly create your data models. create class Person Extends V --- Like db.Person in Mongo To insert there are a few options but one way is to use create vertex Person set Name = Bill , Height=1.66 A vertex is like a row or record and an Edge is a relationship that can joins rows. Mongo has no concept like this. The only way is to embed data as subdocuments. Which results in many problems. You really have to do a lot of schema design to support querying up front. The great thing with Orient are that records are first class citizen which means that they are links rather than traditional joins. The data that has a relationship points to each other. I'm just new to Orient myself and have replaced my entire data layer in a matter of weeks. It has opened up new possibilities. Regards, Tom On Tuesday, 25 March 2014 16:47:29 UTC, Kevin K. Han wrote: Does OrientDB has the concept of collections just like in MongoDB? If not, how do I organize and group documents? -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: New node.js driver - Oriento
Excellent. I use node in my project. Will be sure to give it a try. On Thursday, 20 March 2014 01:49:52 UTC, Charles Pick wrote: Hi, I'd like to announce a new binary protocol client for nodejs - Orientohttps://github.com/codemix/oriento While it is descended from the great work Giraldo Rosales and Gabriel Petrovay (and others) have done on node-orientdb, it's been rewritten from the ground up to be faster, more flexible and with a nicer API. Its current status is alpha but it has a relatively thorough test suite and is being developed against the latest orientdb development branch - it's working with 1.7. In addition to the nicer API and performance improvements it also adds support for database migrations and a basic CLI. Please check it out on github at https://github.com/codemix/oriento - I hope you find it useful, Charles Pick cha...@codemix.com javascript: -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] PHP Driver
Hi, Is the orient PHP driver still under active development? https://github.com/AntonTerekhov/OrientDB-PHP Im trying to use it with 1.7rc1. Regards, Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: PHP Driver
Also if anybody knows if graphs are supported. On Wednesday, 12 March 2014 19:02:39 UTC, Thomas Kennedy wrote: Hi, Is the orient PHP driver still under active development? https://github.com/AntonTerekhov/OrientDB-PHP Im trying to use it with 1.7rc1. Regards, Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Retrieving JSON Tree From Graph
Are there any other ways than bringing back the relationships from my edge
relationship and building it in Php or Node?
Suggestions welcome.. Im just looking for tips on the most efficient way
with OrientDB
On Friday, 7 March 2014 00:35:09 UTC, Thomas Kennedy wrote:
Hi,
I have a tree structure in orient that I want to transform into the JSON
format like below. I am using D3.js and would like the data returned in the
correct format.
Does anybody the correct way to do this in Orient?
TIA
Tom
Orient Tree
node1
node2
node3
node4
...
.. JSON export data ...
{
node1
children[] {
node2
children[] {
node3
}
}
node4
}
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Retrieving JSON Tree From Graph
Hi,
I have a tree structure in orient that I want to transform into the JSON
format like below. I am using D3.js and would like the data returned in the
correct format.
Does anybody the correct way to do this in Orient?
TIA
Tom
Orient Tree
node1
node2
node3
node4
...
.. JSON export data ...
{
node1
children[] {
node2
children[] {
node3
}
}
node4
}
--
---
You received this message because you are subscribed to the Google Groups
OrientDB group.
To unsubscribe from this group and stop receiving emails from it, send an email
to orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
[orientdb] Re: Timeseries use case and insert command.
Hi Nikolas, Did you manage to get an example? Regards, Tom On Friday, 21 February 2014 16:46:40 UTC, Nikolas wrote: Hello, I'm totally newbie to OrientDB and i'm playing with the time series use case. I'don't understand how to populate a LINKMAP field with SQL to create years[2014], months[3] etc... Could someone help me ? Thank you! -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[orientdb] Re: Timeseries use case and insert command.
It would be great if anybody who had an example could post one here. On Sunday, 2 March 2014 21:25:30 UTC, Thomas Kennedy wrote: Hi Nikolas, Did you manage to get an example? Regards, Tom On Friday, 21 February 2014 16:46:40 UTC, Nikolas wrote: Hello, I'm totally newbie to OrientDB and i'm playing with the time series use case. I'don't understand how to populate a LINKMAP field with SQL to create years[2014], months[3] etc... Could someone help me ? Thank you! -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
[orientdb] Server Side Function
Hi, I am using the 1.7-rc1 version and have attempted to access an element on JSON object that is returned and receive a blank value. I execute the code on the studio thru the function section. var test = db.query(select from OUser); var thename = test[0][name]; //also tried this //var thename = test[0].name; return thename; Not sure if I am missing something obvious Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [orientdb] Server Side Function
Thanks Luigi. Not sure if that is explicitly stated enough in the documentation. Going by the documentation I would of thought that the return type was a Javascript JSON object. Can you point me to any documentation on this? Much appreciated On Wednesday, 19 February 2014 08:12:56 UTC, Luigi Dell'Aquila wrote: Hi Thomas, test[0] is actually an ODocument (a Java object). Just try this: test[0].field(name) Luigi 2014-02-19 3:23 GMT+01:00 Thomas Kennedy tomais@gmail.comjavascript: : Hi, I am using the 1.7-rc1 version and have attempted to access an element on JSON object that is returned and receive a blank value. I execute the code on the studio thru the function section. var test = db.query(select from OUser); var thename = test[0][name]; //also tried this //var thename = test[0].name; return thename; Not sure if I am missing something obvious Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com javascript:. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Re: [orientdb] Server Side Function
Thanks Luigi. Is there anything on using the OrientDB API with Javascript. As in where to see methods available like field as shown above. I thought that when writing code in the text pane that is was purely ecmascript. I have just started using orient so just feeling my way around. On Wednesday, 19 February 2014 08:53:53 UTC, Luigi Dell'Aquila wrote: You are right, the documentation about this aspect is not so clear (here is the link https://github.com/orientechnologies/orientdb/wiki/Functions). The result of every function call is serialized in JSON when sent to the client, but inside the function you are using native OrientDB API: the db object an instance of the Java class OScriptDocumentDatabaseWrapper, that is a wrapper of ODatabaseDocumentTx, so when you work with it you will get Java objects. Luigi 2014-02-19 9:32 GMT+01:00 Thomas Kennedy tomais@gmail.comjavascript: : Thanks Luigi. Not sure if that is explicitly stated enough in the documentation. Going by the documentation I would of thought that the return type was a Javascript JSON object. Can you point me to any documentation on this? Much appreciated On Wednesday, 19 February 2014 08:12:56 UTC, Luigi Dell'Aquila wrote: Hi Thomas, test[0] is actually an ODocument (a Java object). Just try this: test[0].field(name) Luigi 2014-02-19 3:23 GMT+01:00 Thomas Kennedy tomais@gmail.com: Hi, I am using the 1.7-rc1 version and have attempted to access an element on JSON object that is returned and receive a blank value. I execute the code on the studio thru the function section. var test = db.query(select from OUser); var thename = test[0][name]; //also tried this //var thename = test[0].name; return thename; Not sure if I am missing something obvious Tom -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com javascript:. For more options, visit https://groups.google.com/groups/opt_out. -- --- You received this message because you are subscribed to the Google Groups OrientDB group. To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
