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]>: > 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]>: > >> 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]. >> 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. > -- --- 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.
