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
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 =
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
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
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