Can documentation requests go into the issue tracker on github?
On Thursday, May 7, 2015 at 5:09:01 PM UTC-4, Colin wrote:
>
> Good find and good suggestion!
>
> -Colin
>
> Orient Technologies
>
> The Company behind OrientDB
>
>
> On Thursday, May 7, 2015 at 3:47:09 PM UTC-5, Wayne Werner wrote:
>>
>> This took me a helluva long time to find... should get this into the
>> select documentation!
>>
>> On Wednesday, September 11, 2013 at 7:02:32 AM UTC-4, Lvc@ wrote:
>>>
>>> Hi all,
>>> starting from today (develop branch and 1.6.0-SNAPSHOT on sonatype
>>> repository) we've new query the schema and indexes by introducing the new
>>> target prefix "*metadata*" where you can get:
>>>
>>> - *schema*, to get classes and properties
>>> - *indexmanager*, to get information about indexes
>>>
>>> Get all the configured classes:
>>>
>>> select expand(classes) from metadata:schema
>>>
>>>
>>> ----+-----------+---------+----------------+----------+--------+--------+----------+----------+------------+----------
>>> # |name
>>> |shortName|defaultClusterId|strictMode|abstract|overSize|clusterIds|properties|customFields|superClass
>>>
>>> ----+-----------+---------+----------------+----------+--------+--------+----------+----------+------------+----------
>>> 0 |UserGroup |null |13 |false |false |0.0
>>> |[1] |[2] |null |V
>>> 1 |WallPost |null |15 |false |false |0.0
>>> |[1] |[4] |null |V
>>> 2 |Owner |null |12 |false |false |0.0
>>> |[1] |[1] |null |E
>>> 3 |OTriggered |null |-1 |false |true |0.0
>>> |[1] |[0] |null |null
>>> 4 |E |E |10 |false |false |0.0
>>> |[1] |[0] |null |null
>>> 5 |OUser |null |5 |false |false |0.0
>>> |[1] |[4] |null |OIdentity
>>> 6 |OSchedule |null |7 |false |false |0.0
>>> |[1] |[7] |null |null
>>> 7 |ORestricted|null |-1 |false |true |0.0
>>> |[1] |[4] |null |null
>>> 8 |AssignedTo |null |11 |false |false |0.0
>>> |[1] |[1] |null |E
>>> 9 |V |null |9 |false |false |2.0
>>> |[1] |[0] |null |null
>>> 10 |OFunction |null |6 |false |false |0.0
>>> |[1] |[5] |null |null
>>> 11 |ORole |null |4 |false |false |0.0
>>> |[1] |[4] |null |OIdentity
>>> 12 |ORIDs |null |8 |false |false |0.0
>>> |[1] |[0] |null |null
>>> 13 |OIdentity |null |-1 |false |true |0.0
>>> |[1] |[0] |null |null
>>> 14 |User |null |14 |false |false |0.0
>>> |[1] |[2] |null |V
>>>
>>> ----+-----------+---------+----------------+----------+--------+--------+----------+----------+------------+----------
>>>
>>> Get all the configured properties for the class OUser:
>>>
>>> select expand(properties) from (
>>> select expand(classes) from metadata:schema
>>> ) where name = 'OUser'
>>>
>>>
>>> ----+--------+----+---------+--------+-------+----+----+------+------------+-----------
>>> # |name |type|mandatory|readonly|notNull|min |max
>>> |regexp|customFields|linkedClass
>>>
>>> ----+--------+----+---------+--------+-------+----+----+------+------------+-----------
>>> 0 |status |7 |true |false |true |null|null|null |null
>>> |null
>>> 1 |roles |15 |false |false |false |null|null|null |null
>>> |ORole
>>> 2 |password|7 |true |false |true |null|null|null |null
>>> |null
>>> 3 |name |7 |true |false |true |null|null|null |null
>>> |null
>>>
>>> ----+--------+----+---------+--------+-------+----+----+------+------------+-----------
>>>
>>> Get all the configured indexes:
>>>
>>> select expand(indexes) from metadata:indexmanager
>>>
>>>
>>> ----+------+------+--------+---------+---------+------------------------------------+------------------------------------------------------
>>> # |@RID |mapRid|clusters|type |name |indexDefinition
>>> |indexDefinitionClass
>>>
>>> ----+------+------+--------+---------+---------+------------------------------------+------------------------------------------------------
>>> 0 |#-1:-1|#2:0 |[0] |DICTIO...|dictio...|{keyTypes:[1]}
>>> |com.orientechnologies.orient.core.index.OSimpleKeyI...
>>> 1 |#-1:-1|#1:1 |[1] |UNIQUE
>>> |OUser....|{className:OUser,field:name,keyTy...|com.orientechnologies.orient.core.index.OPropertyIn...
>>> 2 |#-1:-1|#1:0 |[1] |UNIQUE
>>> |ORole....|{className:ORole,field:name,keyTy...|com.orientechnologies.orient.core.index.OPropertyIn...
>>>
>>> ----+------+------+--------+---------+---------+------------------------------------+------------------------------------------------------
>>>
>>> Hope this simple addition will be useful for some users ;-)
>>>
>>> For more information:
>>> https://github.com/orientechnologies/orientdb/issues/1668
>>>
>>> Luca Garulli
>>> CEO at Orient Technologies
>>> the Company behind OrientDB
>>> http://about.me/luca.garulli
>>>
>>>
--
---
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.
