orientjs - how to perform bulk insert

Question

orientdb.insert()
        .into('User')
        .set({name: 'John', surname: 'Smith'})
        .all()
        .then(function(result) {
  ...
}, function(error){
  ...
})

This is the way to insert a single vertex in OrientDb via orientjs. How to insert multiple objects at once?

The following query

orientdb.insert()
        .into('User')
        .set([{name: 'John', surname: 'Smith'}, {name: 'Harry', surname: 'Potter'}])
        .all()
        .then(function(result) {
      ...
    }, function(error){
      ...
    })

inserts only the last element ({name: 'Harry', surname: 'Potter'})

You could use batch script https://github.com/orientechnologies/orientjs#batch-script — wolf4ood, Mar 25 '16 at 12:36

score 2 · Answer 1 · answered Apr 09 '16 at 10:37

You could also use the LET statement:

var OrientDB = require('orientjs');

var server = OrientDB({
    host: 'localhost',
    port: 2424,
    username: 'root',
    password: 'root'
});

var db = server.use({
    name: 'OrientJStest',
    username: 'root',
    password: 'root'
});

db.let('insert',function(i) {
            i
                .insert()
                .into('Person')
                .set({'name':'John'});
        })
        .let('insert2',function(i2) {
            i2
                .insert()
                .into('Person')
                .set({'name':'Harry'});
        })
        .commit()
        .all();

db.select().from('Person').all()
    .then(function (vertex) {
        console.log('Vertexes found: ',vertex);
});

OUTPUT:

Vertexes found:  [ { '@type': 'd',
    '@class': 'Person',
    name: 'John',
    '@rid': { [String: '#12:0'] cluster: 12, position: 0 },
    '@version': 1 },
  { '@type': 'd',
    '@class': 'Person',
    name: 'Harry',
    '@rid': { [String: '#12:1'] cluster: 12, position: 1 },
    '@version': 1 } ]

OUTPUT (STUDIO):

Hope it helps

Hi @fiction, did you have a chance to try my solution ? – LucaS Apr 18 '16 at 20:31 — LucaS, Apr 18 '16 at 20:31

score 1 · Answer 2 · answered Mar 23 '16 at 14:53

1

Try this

var OrientDB = require('orientjs');

var server = OrientDB({
    host: 'localhost',
    port: 2424,
    username: 'root',
    password: 'root'
})

var db = server.use({
  name: 'mydb',
  username: 'admin',
  password: 'admin'
})

db.query('insert into User2(name) values ("John"),("Harry")').then(function (response) {
    console.log(response);
});

server.close();

This is the result that I get

Hope it helps

answered Mar 23 '16 at 14:53

Michela Bonizzi

2,622
1
9
16

this is not a bulk – Felice Pollano Mar 08 '18 at 10:07

orientjs - how to perform bulk insert

2 Answers2