[orientdb] Re: Recover all embedded records in any class

2016-11-09 Thread Academia Learning Centro de inglés y de formación
Hi, thanks!! I mean get all the records of the city class just like in the previous example but instead of using the graph model using the documents model (the classes are not inheriting from V) El miércoles, 9 de noviembre de 2016, 12:28:28 (UTC+1), alessand...@gmail.com escribió: > > Hi, >

[orientdb] Re: Recover all embedded records in any class

2016-11-09 Thread Academia Learning Centro de inglés y de formación
Thank you, very much!! > One last question, if instead of using the graph model, I use the document model, where classes do not inherit from V. How could I do this done previously (get all records embedded and not)? > El martes, 8 de noviembre de 2016, 15:46:47 (UTC+1),

[orientdb] Re: Recover all embedded records in any class

2016-11-09 Thread Academia Learning Centro de inglés y de formación
Thank you, One last question, if instead of using the graph model, I use the document model, where classes do not inherit from V. How could I do this done previously (get all records embedded and not)? El martes, 8 de noviembre de 2016, 15:46:47 (UTC+1), alessand...@gmail.com escribió: > >

[orientdb] Recover all embedded records in any class

2016-11-08 Thread Academia Learning Centro de inglés y de formación
Hello, I wanted to ask a question regarding the inscribed objects. Is there a way to retrieve all the objects of a class, for example class City and retrieve all the City records, including those inscribed in other records? Thanks. -- --- You received this message because you are

[orientdb] Re: Recover all embedded records in any class

2016-11-08 Thread Academia Learning Centro de inglés y de formación
Hi, thank you for answering me. An example: { "result": [ { "@type": "d", "@rid": "#21:0", "@version": 1, "@class": "Curso", "City": { "@type": "d", "@version": 0, "@class":

[orientdb] Re: Recover all embedded records in any class

2016-11-10 Thread Academia Learning Centro de inglés y de formación
OK thanks. One last question, in the document model, can also be inherited from class V? If so then it would be easier to find the city class, right? With the query of the previous example: Select expand (City) from v Or in the document model this is not possible? Thank you! El miércoles, 9

[orientdb] Re: Recover all embedded records in any class

2016-11-10 Thread Academia Learning Centro de inglés y de formación
(UTC+1), Academia Learning Centro de inglés y de formación escribió: > > OK thanks. One last question, in the document model, can also be inherited > from class V? > If so then it would be easier to find the city class, right? With the > query of the previous example: > Select

[orientdb] Re: Is it possible to get records without meta-information?

2016-11-14 Thread Academia Learning Centro de inglés y de formación
ot;@version": 1, "name": "malagon" }, { "@type": "d", "@version": 1, "name": "pozuelo" }, { "@type": "d",

[orientdb] Is it possible to get records without meta-information?

2016-11-14 Thread Academia Learning Centro de inglés y de formación
Can I get records without this parameters? "@type": "d", "@rid": "#21:2", "@version": 1, "@class": "EHR", Thanks -- --- 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

[orientdb] Re: Is it possible to get records without meta-information?

2016-11-15 Thread Academia Learning Centro de inglés y de formación
uot;@type": "d",) with its version. > > Il giorno lunedì 14 novembre 2016 15:13:25 UTC+1, Academia Learning Centro > de inglés y de formación ha scritto: >> >> Hi, >> >> I have tried, it has worked with some properties and with others, you >> w

[orientdb] Re: How to get the value of a vertex in json, java graph api?

2016-11-23 Thread Academia Learning Centro de inglés y de formación
Thanks, The problem is that when I use the toJson function, it's adding metainformation so I'm not worth it, I have to retrieve the information as it is, but I've encapsulated it in the value property select value from prueba

[orientdb] [HELP] Save fields in different order, (Example)

2016-11-23 Thread Academia Learning Centro de inglés y de formación
When I retrieve a json the fields are in different order than when saved Can I get them back in the same order? -- --- 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

[orientdb] Re: [HELP] Can I retrieve them in the same order in which they were saved?

2016-11-23 Thread Academia Learning Centro de inglés y de formación
I have the same problem El miércoles, 23 de noviembre de 2016, 12:23:34 (UTC+1), roberto carlos diaz justicia escribió: > > When I retrieve a json the fields are in different order than when saved > > Can I get them back in the same order? > -- --- You received this message because you are

[orientdb] Re: How to get the value of a vertex in json, java graph api?

2016-11-23 Thread Academia Learning Centro de inglés y de formación
Thanks, Could the same be done with the expand function? SELECT expand (out('hasVersions'))*.toJson()* as this FROM Composition WHERE idComposition = '3' El martes, 22 de noviembre de 2016, 17:11:35 (UTC+1), alessand...@gmail.com escribió: > > Hi, > you could use > > Iterable resultEhr =

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-22 Thread Academia Learning Centro de inglés y de formación
I do not understand what you mean, sorry. I created a document to insert a json, but how do I insert this in my vertex? El lunes, 21 de noviembre de 2016, 16:02:08 (UTC+1), alessand...@gmail.com escribió: > > You could use > > alter class yourclass superclasses v > > > -- --- You received

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-22 Thread Academia Learning Centro de inglés y de formación
Help, I need to create two vertices with json content and then join them using an edge El jueves, 17 de noviembre de 2016, 15:11:52 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > I'm doing it like this > > Vertex pruebaJson = graph.addVertex(&

[orientdb] How to get the value of a vertex in json, java graph api?

2016-11-22 Thread Academia Learning Centro de inglés y de formación
I am using this but I can not get its json value, only the OrientVertex Iterable resultEhr = graph.command( new OCommandSQL("select from EHR where ehrId = '" + ehrId + "'") ).execute(); if (resultEhr.iterator().hasNext()){ Vertex ehr = (Vertex) resultEhr.iterator().next(); }

[orientdb] Database is closed Exception

2016-11-24 Thread Academia Learning Centro de inglés y de formación
Hello I wanted to ask if I am doing this correctly or am doing something wrong, I initialize it like this: *Class orientDBService* OrientGraphFactory oFactory = new OrientGraphFactory (this.databaseURI).setupPool(1,10);; this.graph = oFactory.getTx(); Then I have two methods one to create a

Re: [orientdb] [HELP] Save fields in different order, (Example)

2016-11-24 Thread Academia Learning Centro de inglés y de formación
ks > > Luigi > > 2016-11-23 11:42 GMT+01:00 Academia Learning Centro de inglés y de > formación <learning...@gmail.com >: > >> When I retrieve a json the fields are in different order than when saved >> >> Can I get them back in the same order

[orientdb] Re: Database is closed Exception

2016-11-24 Thread Academia Learning Centro de inglés y de formación
016 11:04:08 UTC+1, Academia Learning > Centro de inglés y de formación ha scritto: >> >> Hello I wanted to ask if I am doing this correctly or am doing something >> wrong, I initialize it like this: >> *Class orientDBService* >> OrientGraphFactory oFactory = new

[orientdb] Re: Database is closed Exception

2016-11-24 Thread Academia Learning Centro de inglés y de formación
The last version, I downloaded it recently El jueves, 24 de noviembre de 2016, 22:51:46 (UTC+1), Oleksandr Gubchenko escribió: > > Which version are you using? > > Il giorno giovedì 24 novembre 2016 14:01:38 UTC+1, Academia Learning > Centro de inglés y de formación ha scr

[orientdb] Re: [orient-database] Fastest way to empty a graph database?

2016-11-22 Thread Academia Learning Centro de inglés y de formación
And if there are many classes, is there any way to do it through a for? Getting all kinds of classes and truncating? El jueves, 16 de diciembre de 2010, 10:38:56 (UTC+1), Lvc@ escribió: > > Hi, > you could truncate an entire class in this way: > > OClass cls =

[orientdb] HELP to Query with json attributes

2016-11-16 Thread Academia Learning Centro de inglés y de formación
Hi, I have this vertex of class CompositeVersion, How can I get all the vertices whose value has the property name equal to Laboratory report? I had tried with select from CompositeVersion where value.name.value = 'Laboratory report' but not working select from CompositeVersion

[orientdb] Re: Is it possible to get records without meta-information?

2016-11-16 Thread Academia Learning Centro de inglés y de formación
HELP El lunes, 14 de noviembre de 2016, 14:27:27 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > Can I get records without this parameters? > > "@type": "d", > "@rid": "#21:2", > "@version": 1, > &qu

Re: [orientdb] HELP to Query with json attributes

2016-11-16 Thread Academia Learning Centro de inglés y de formación
that reproduces the > problem? > > Thanks > > Luigi > > 2016-11-16 10:58 GMT+01:00 Academia Learning Centro de inglés y de > formación <learning...@gmail.com >: > >> Hi, >> >> I have this vertex of class CompositeVersion, >> >> How can I

Re: [orientdb] Edge vs Link, question and help (Example Inside)

2016-11-16 Thread Academia Learning Centro de inglés y de formación
es, you can mix document and graph models and > you should have no problems with this, so I suppose there is something > else... > > Thanks > > Luigi > > > 2016-11-16 11:10 GMT+01:00 Academia Learning Centro de inglés y de > formación <learning...@gmail.com >: >

[orientdb] Re: HELP to Query with json attributes

2016-11-16 Thread Academia Learning Centro de inglés y de formación
value.name.value = 'Laboratory report' El miércoles, 16 de noviembre de 2016, 10:58:21 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > Hi, > > I have this vertex of class CompositeVersion, > > How can I get all the vertices whose value has the property name equa

Re: [orientdb] HELP to Query with json attributes

2016-11-16 Thread Academia Learning Centro de inglés y de formación
syntax, it's supposed to work fine. > Could you please post a simple script to create a db that reproduces the > problem? > > Thanks > > Luigi > > 2016-11-16 10:58 GMT+01:00 Academia Learning Centro de inglés y de > formación <learning...@gmail.com >: > >>

Re: [orientdb] HELP to Query with json attributes

2016-11-16 Thread Academia Learning Centro de inglés y de formación
to work fine. > Could you please post a simple script to create a db that reproduces the > problem? > > Thanks > > Luigi > > 2016-11-16 10:58 GMT+01:00 Academia Learning Centro de inglés y de > formación <learning...@gmail.com >: > >> Hi, >> >>

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-18 Thread Academia Learning Centro de inglés y de formación
Thanks, I tried it and with the Odocument class it works, but with the JSONObject class the same thing is saved this time as an embedded document but then I can not retrieve the attributes by query (I attached image) I've only done it this way, but I do not think it's correct: OrientGraph

[orientdb] How to get the type of class from a vertex?

2016-11-21 Thread Academia Learning Centro de inglés y de formación
Hello, I want to empty the db and I was testing this way (I do not know if it's the right one) Iterable resultIteratorVertices = graph.getVertices(true); for (Vertex v : resultIteratorVertices){ graph.command( new OCommandSQL("TRUNCATE CLASS "+ *v.getClass* + " POLYMORPHIC UNSAFE")

[orientdb] Re: How to get the type of class from a vertex?

2016-11-21 Thread Academia Learning Centro de inglés y de formación
To not delete all classes / schemas / tables only the records El lunes, 21 de noviembre de 2016, 10:52:38 (UTC+1), Ivan Mainetti escribió: > > why you don't just delete and recreate the entire db? > > Il giorno lunedì 21 novembre 2016 10:28:55 UTC+1, Academia Learning Centro >

[orientdb] Re: How to get the type of class from a vertex?

2016-11-21 Thread Academia Learning Centro de inglés y de formación
es){ > e.remove(); > } > > Iterable resultIteratorVertices = g.getVertices(true); > for (Vertex v : resultIteratorVertices){ > v.remove(); > } > > > > > Il giorno lunedì 21 novembre 2016 11:01:42 UTC+1, Academia Learning Centro > de inglés y de formación ha scritto: &

[orientdb] Re: How to insert JSON with Java Graph API?

2016-11-21 Thread Academia Learning Centro de inglés y de formación
How can I convert that document class to graph then? If I can not create edges El jueves, 17 de noviembre de 2016, 15:45:42 (UTC+1), alessand...@gmail.com escribió: > > Hi, you could try with > > OrientGraph g=new OrientGraph(yourPath); > > ODocument pruebaJson = new ODocument("Person"); >

[orientdb] [HELP] find document inside list

2016-12-01 Thread Academia Learning Centro de inglés y de formación
Hi, I want to look for a document within a list, but I can not find the way, I'm trying this but it gives me error *select from object where compositionsList traverse ( class = 'composition' ),* but this not working { "object" :{ "compositionList" : [ {"class" : "composition"},

[orientdb] Re: [HELP] find document inside list

2016-12-02 Thread Academia Learning Centro de inglés y de formación
>> >> What is a type of compositionList? Is it an embedded list? >> >> Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning >> Centro de inglés y de formación ha scritto: >>> >>> Hi, I want to look for a document within a list, b

[orientdb] Re: [HELP] find document inside list

2016-12-02 Thread Academia Learning Centro de inglés y de formación
yes are list embedded El jueves, 1 de diciembre de 2016, 15:03:58 (UTC+1), Oleksandr Gubchenko escribió: > > What is a type of compositionList? Is it an embedded list? > > Il giorno giovedì 1 dicembre 2016 14:27:12 UTC+1, Academia Learning Centro > de inglés y de formación ha sc

[orientdb] [HELP] Order by date not working

2016-11-29 Thread Academia Learning Centro de inglés y de formación
I have tried with this query and I get this results (not ordered): *select value.uid.value as id, value.context.start_time.value as date* *from CompositionVersions order by value.context.start_time.value desc limit 5* id date fe9e6036 2014-02-23T12:33:10.000+01:00 80eee423

[orientdb] Re: [HELP] Order by date not working

2016-11-30 Thread Academia Learning Centro de inglés y de formación
2016, 14:39:03 (UTC+1), Oleksandr Gubchenko escribió: > > Which version are you using? > > Il giorno martedì 29 novembre 2016 14:18:25 UTC+1, Academia Learning > Centro de inglés y de formación ha scritto: >> >> I have tried with this query and I get this results (

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

2016-11-30 Thread Academia Learning Centro de inglés y de formación
How can I consult that? Is installed on my local hard drive, this has a capacity of 15.5GB free El miércoles, 30 de noviembre de 2016, 7:59:10 (UTC+1), Andrey Lomakin escribió: > > Hi, > I also need to know the size of your database on disk. > > On Tue, Nov 29, 2016 at 3:18 PM Aceitunas y

[orientdb] Re: [HELP] Order by date not working

2016-11-30 Thread Academia Learning Centro de inglés y de formación
Thanks, this works El martes, 29 de noviembre de 2016, 23:05:48 (UTC+1), Ivan Mainetti escribió: > > please try with > > select value.uid.value as id, value.context.start_time.value as date from > CompositionVersions order by date desc limit 5 > > > > >> -- --- You received this message

[orientdb] It is possible to find a field in an array without knowing the path

2016-11-30 Thread Academia Learning Centro de inglés y de formación
I need to retrieve all Compositions that have the temperature field but do not get their path since they are inside nested arrays -- --- You

Re: [orientdb] Re: Mass insertion of vertices very slow, is it necessary Performance Tuning?

2016-11-30 Thread Academia Learning Centro de inglés y de formación
, 2016 at 10:11 AM Academia Learning Centro de inglés y de > formación <learning...@gmail.com > wrote: > >> How can I consult that? Is installed on my local hard drive, this has a >> capacity of 15.5GB free >> >> >> El miércoles, 30 de noviembre de 2016, 7:59:

[orientdb] Re: It is possible to find a field in an array without knowing the path

2016-11-30 Thread Academia Learning Centro de inglés y de formación
I have tried with any() but not working El miércoles, 30 de noviembre de 2016, 12:50:43 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > I need to retrieve all Compositions that have the temperature field but do > not get their path since they are inside nest

[orientdb] How can I complete this query? arrays inside arrays

2016-12-05 Thread Academia Learning Centro de inglés y de formación
Hello guys I have an element with a json value and inside it has several arrays inside arrays. I want to retrieve the values of the field Temperature *only *of the arrays that are of the temperature type. But this query returns all the values with only one of the arrays is of type

[orientdb] Re: [HELP] find document inside list

2016-12-05 Thread Academia Learning Centro de inglés y de formación
This does not work, I need to find a field inside a json value, which inside has more nested fields and values, but I do not know the path El viernes, 2 de diciembre de 2016, 11:51:36 (UTC+1), user.w...@gmail.com escribió: > > Hi, > > try this: > > select from EHR where compositionsList.class

[orientdb] Re: How can I complete this query? arrays inside arrays

2016-12-05 Thread Academia Learning Centro de inglés y de formación
' in value.content.data.events.data.items.name.value El lunes, 5 de diciembre de 2016, 11:08:03 (UTC+1), Academia Learning Centro de inglés y de formación escribió: > > Hello guys I have an element with a json value and inside it has several > arrays inside arrays. > > I want to retrieve the values of the field Te

[orientdb] Re: It is possible to find a field in an array without knowing the path

2016-11-30 Thread Academia Learning Centro de inglés y de formación
escribió: > > could you add examples of query you tried? > > > Il giorno mercoledì 30 novembre 2016 12:50:43 UTC+1, Academia Learning > Centro de inglés y de formación ha scritto: >> >> I need to retrieve all Compositions that have the temperature field but >> do not

[orientdb] Re: Get element by array in json

2016-12-19 Thread Academia Learning Centro de inglés y de formación
> > I've got it using > select from CompositionVersions " + "where (select distinct (id) from (select id, date, events.data.items as items " + "from (select id, value.data.origin.value as date, value.data.events as events " + "from (select value.uid.value as id, value.content as value " +