How to insert a vertex with link type property with the orientjs query builder?

Question

I am trying to insert a vertex with orientjs(previously oriento) query builder. My class has a link type property pointing to another class.

I know I can get it to work with a raw query string but I would love to use the query builder.

Here is what I've tried so far :

db.insert()
.into('VertexClassName')
.set({"prop":"value", "linkProperty":"33:1289287"})

db.insert()
.into('VertexClassName')
.set({"prop":"value", "linkProperty":"#33:1289287"})

I get the following error :

Error on saving record in cluster #13

Am I setting properties in the right way ? Could the error be related to somtehing else ? I have sucessfully ran an insert query in the cluster #13 with a raw query string in the studio...

Daniel Gutierrez · Answer 1 · 2015-07-28T15:14:21.333

0

According to the official documentation it seems that the problem might be at the end of your statement

db.insert().into('VertexClassName')
    .set({"prop":"value", "linkProperty":"33:1289287"}).one()
    .then(function (data) {
       // callback
});

Check if your code works adding one() to the pipe line

EDITED: I found this method in orientjs.

db.create('VERTEX', 'V')
.set({
  key: 'value',
  foo: 'bar'
})
.one()
.then(function (vertex) {
  console.log('created vertex', vertex);
});

When using Tinkerpop API they recommend using createVertex instead of insert, because createVertex is intended for graphs and insert for Documents... Could you try with the create() method instead?

edited Jul 28 '15 at 15:14

answered Jul 28 '15 at 12:56

Daniel Gutierrez

58
8

Doesn't change anything – AlexB Jul 28 '15 at 14:20
Could you provide more info, like server creation config?, are you using credentials? Does it work if you execute an insert query insted of using the insert() method? – Daniel Gutierrez Jul 28 '15 at 15:12

score 0 · Answer 2 · edited Jan 16 '16 at 11:45

0

I am using SQL and it worked.

sql = "INSERT INTO Station set linked = (select from LinkedClass where LinkedProb = 'value'), prop = 'value'"

OrientVertex vertex = new OrientVertex();
vertex = graph.command(new OCommandSQL(sql)).execute();

edited Jan 16 '16 at 11:45

Tunaki

132,869
46
340
423

answered Jan 16 '16 at 11:43

Tkaewkunha

394
4
21

score 0 · Answer 3 · answered Jan 08 '17 at 06:42

I don't think that's possible unless you've added a proper field with the right type 'Link' in your schema. (which I rarely do).

Now instead of having the right 'link' type inserted you can do the opposite, store is as a String, and leverage the query functions to use it correctly:

db.insert().into('table').set({prop: '#15:14'}).one();

And it will be converted as String (which is a bit sad) but then you can use that in your queries:

SELECT eval(prop) FROM table;

And it will be 'eval'-ed to a Node RecordID that you can directly use and call functions like expand() on.

For example:

SELECT name FROM (SELECT expand(eval(prop)) FROM table);

Will eval the node stored in the insert(), grab the node, expand it and collect its name property.

If you have a field in the schema however, you can probably do: db.insert().into('table').set({prop: db.rawExpression('eval("#15:14")')}); — nembleton, Jan 08 '17 at 06:47

How to insert a vertex with link type property with the orientjs query builder?

3 Answers3