Luigi, That absolutely answers my question, yes! Thanks very much!
Patrick On Wednesday, March 25, 2015 at 2:26:34 AM UTC-6, Luigi Dell'Aquila wrote: > > Hi Patrick, > > this is the query that gives you the list of existing classes > > select expand(classes) from metadata:schema > > I hope it helps > > Luigi > > > > > > 2015-03-24 21:09 GMT+01:00 Patrick Hoeffel <[email protected] > <javascript:>>: > >> Luigi, >> >> Good answer for determining if a document exists, but how determine is a >> class exists (using SQL)? >> >> Thanks, >> >> Patrick >> >> >> On Monday, March 23, 2015 at 1:31:49 AM UTC-6, Luigi Dell'Aquila wrote: >>> >>> Hi >>> >>> Upsert is just a keyword in the UPDATE statement, eg. >>> >>> update V set id = '12', name = 'foo' upsert where id = '12' >>> >>> you can find all the docs here http://www.orientechnologies.com/docs/ >>> last/SQL-Update.html >>> >>> Luigi >>> >>> >>> 2015-03-22 0:17 GMT+01:00 pumplerod <[email protected]>: >>> >>>> Is there example usage of this? When I try and use upsert all I get is >>>> an error. >>>> >>>> I have a class Locale which I only want to add if the specified locale >>>> does not already exist... >>>> >>>> upsert into Locale set type='state' name='TX' where type='state' name= >>>> 'TX' >>>> >>>> >>>> The error states that there is no command executor for command request: >>>> sql.upsert >>>> >>>> >>>> On Wednesday, February 4, 2015 at 9:08:04 AM UTC-6, Luigi Dell'Aquila >>>> wrote: >>>>> >>>>> Hi Artem, >>>>> >>>>> have you tried with UPSERT? >>>>> Here you can find all the references: >>>>> >>>>> http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL >>>>> -Update.html >>>>> >>>>> Regards >>>>> >>>>> Luigi >>>>> >>>>> >>>>> 2015-02-04 13:25 GMT+01:00 Artem Shoobovych <[email protected]>: >>>>> >>>>>> Hi there! >>>>>> >>>>>> Lately, I've been playing with OrientDB of 1.7.10 and now 2.0.1. And >>>>>> currently I am stuck with poor SQL syntax or my misunderstanding of it. >>>>>> >>>>>> What I want is to create an instance of a class if it does not exist. >>>>>> I tried different solutions, like `ifnull`, `first` and `if`. But it >>>>>> seems >>>>>> to work only on existing values. >>>>>> >>>>>> For example, let us have a class `City` with only one instance - >>>>>> `{"name": "Lisboa"}`. >>>>>> >>>>>> These do not work: >>>>>> >>>>>> select if(count(select City where name = "Krakow") < 1, null, >>>>>> (insert >>>>>> into City set name = "Krakow" return @rid)) >>>>>> >>>>>> >>>>>> select ifnull((select @rid from City where name = "Krakow"), (insert >>>>>> into City set name = "Krakow" return @rid)) >>>>>> >>>>>> >>>>>> select first((select @rid from City where name = "Krakow"), (insert >>>>>> into City set name = "Krakow")) >>>>>> >>>>>> >>>>>> I believe I need some kind of `exists` operator: >>>>>> >>>>>> select if( exists(select from City where name = "Krakow"), ( >>>>>> select @rid from City where name = "Krakow"), (insert into City set >>>>>> name = "Krakow")) >>>>>> >>>>>> >>>>>> Are there any possibility for this except stored functions? >>>>>> >>>>>> 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 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] <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.
