Re: [orientdb] find_or_create in OrientDB?

2015-03-25 Thread Luigi Dell'Aquila
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 patrick.hoef...@gmail.com: Luigi, Good answer for determining if a document exists, but how determine

Re: [orientdb] find_or_create in OrientDB?

2015-03-24 Thread Patrick Hoeffel
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 =

Re: [orientdb] find_or_create in OrientDB?

2015-03-23 Thread Luigi Dell'Aquila
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 pumple...@gmail.com: Is there example

Re: [orientdb] find_or_create in OrientDB?

2015-03-21 Thread pumplerod
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

Re: [orientdb] find_or_create in OrientDB?

2015-02-04 Thread Luigi Dell'Aquila
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 shybovy...@gmail.com: Hi there! Lately, I've been playing with OrientDB of 1.7.10