@Luigi, I've tried it, it doesn't work .. @Riccardo, I need to execute only one query to get all the data I am looking for.
On Monday, July 6, 2015 at 10:23:31 AM UTC+2, Luigi Dell'Aquila wrote: > > Hi Mohamed, > > just try to add a "group by @class" at the end of the query ;-) > > Thanks > > Luigi > > > 2015-07-06 8:50 GMT+02:00 Riccardo Tasso <[email protected] > <javascript:>>: > >> What about CLASSES command? It should return: >> >> - class name >> - superclass name >> - list of clusters >> - number of records >> >> Cheers, >> Riccardo >> >> 2015-07-05 18:30 GMT+02:00 @raph <[email protected] <javascript:>>: >> >>> Thanks Hartmut, >>> >>> But I was hoping to get the solution with an sql query, I am using HTTP >>> API. >>> >>> >>> On Sunday, July 5, 2015 at 6:14:33 PM UTC+2, hartmut bischoff wrote: >>>> >>>> Hi, >>>> don't know the java-way to do it, but have a solution in ruby. >>>> With the active-orient-ORM-Adapter ( >>>> https://github.com/topofocus/active-orient ) >>>> you might do >>>> >>>> REST::Model.orientdb = ror = REST::OrientDB.new >>>> puts r.class_hierachie( base_class: 'Produit' ).map{|c| "#{c}: \t >>>> #{r.count_documents( o_class: c)} "}.join("\n") >>>> >>>> >>>> With a similar schema I got >>>> >>>> topo@gamma:~/activeOrient$ irb /* call the interactive ruby >>>>>> interpreter /* >>>>> >>>>> 2.2.1 :001 > require './config/boot' >>>>> >>>>> => true >>>>> >>>>> 2.2.1 :002 > r= REST::Model.orientdb = REST::OrientDB.new >>>>> >>>>> => #<REST::OrientDB:0x00000003e08c58 >>>>>> @res=#<RestClient::Resource:0x00000003e6b970 @url=" >>>>>> http://localhost:2480";, @block=nil, @options={:user=>"hctw", >>>>>> :password=>"**"}>, @database="hc_database", @classes=[]> >>>>> >>>>> 2.2.1 :003 > puts r.class_hierachie( base_class: 'Contracts' >>>>>> ).map{|c| "#{c}: \t #{r.count_documents( o_class: c)} "}.join("\n") >>>>> >>>>> /*url: query/hc_database/sql/select COUNT(*) from Forexes */ >>>>> >>>>> /*url: query/hc_database/sql/select COUNT(*) from Futures */ >>>>> >>>>> /*url: query/hc_database/sql/select COUNT(*) from Options */ >>>>> >>>>> /*url: query/hc_database/sql/select COUNT(*) from Stocks */ >>>>> >>>>> Forexes: 1 >>>>> >>>>> Futures: 1 >>>>> >>>>> Options: 2 >>>>> >>>>> Stocks: 60 >>>>> >>>>> => nil >>>>> >>>>> >>>>> >>>> >>>> >>>> On Saturday, July 4, 2015 at 10:10:33 PM UTC+2, @raph wrote: >>>>> >>>>> Hi Lvc@ >>>>> >>>>> I am using OrientDB and I am trying to do something "new" (I found no >>>>> one talking about it) >>>>> >>>>> I have this schema : >>>>> Vertex : >>>>> Produit (abstract class) >>>>> JBoss ( extends from Produit) >>>>> WAS ( extends from Produit) >>>>> Apache ( extends from Produit) >>>>> >>>>> And I want to get this result : >>>>> class count >>>>> ------------------------ >>>>> Jboss x >>>>> Apache y >>>>> WAS z >>>>> >>>>> Where x,y and z are the number of records of each class. >>>>> >>>>> I've tried this query : "select @class, count(*) from Produit" and I >>>>> got this : >>>>> >>>>> class count >>>>> ------------------------ >>>>> Jboss D >>>>> >>>>> where D = x+y+z >>>>> >>>>> Any ideas? >>>>> >>>>> On Wednesday, January 28, 2015 at 8:11:20 PM UTC+1, Lvc@ wrote: >>>>>> >>>>>> You can use the "instanceof" operator: >>>>>> >>>>>> WHERE @this instanceof Node >>>>>> >>>>>> Lvc@ >>>>>> >>>>>> >>>>>> On 28 January 2015 at 19:04, Chris Whalen <[email protected]> wrote: >>>>>> >>>>>>> I am developing a system where (for example): >>>>>>> >>>>>>> *Vertices* >>>>>>> Entity extends V >>>>>>> Document extends Entity >>>>>>> Node extends Entity >>>>>>> Country extends Node >>>>>>> Language extends Node >>>>>>> ... more vertices can be created during run time but they all extend >>>>>>> from the core Entity class or another class that already exists >>>>>>> >>>>>>> *Edges* >>>>>>> ContainedIn extends E >>>>>>> >>>>>>> For example, I want to get a tree structure from a root vertex >>>>>>> (17:0) using the 'ContainedIn' edge. I only want the vertexes that are >>>>>>> of >>>>>>> the 'Node' type. That mean I want back any Node, Country, or Language, >>>>>>> or >>>>>>> any other vertex that has Node as a parent. If there was only a known >>>>>>> set >>>>>>> of possible types, I would simply put in a where clause that checks >>>>>>> against >>>>>>> a list of @class types. Unfortunately, since new classes can and will >>>>>>> be >>>>>>> created by the end user I might not know all the classes that inherit >>>>>>> from >>>>>>> Node. >>>>>>> >>>>>>> *What I know can be done:* >>>>>>> select @rid, Id, Name_ENG, $path from (traverse in('ContainedIn') >>>>>>> from 17:0 where $depth < 4) where @class in ["Node", "Language", >>>>>>> "Country"] >>>>>>> >>>>>>> *What I would like to do:* >>>>>>> select @rid, Id, Name_ENG, $path from (traverse in('ContainedIn') >>>>>>> from 17:0 where $depth < 4) where *@class inheritsFrom "Node"* >>>>>>> >>>>>>> Does anyone have any recommendations on how to build such a query? >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> --- >>>>>>> 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 [email protected]. >>>>>>> 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 [email protected] <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 [email protected] <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 [email protected]. For more options, visit https://groups.google.com/d/optout.
