How to perform bulk operations with help of SQL Agent?

Fri Aug 18 2017 09:53:24 GMT+0200 (CEST), Peter Širka

How to perform bulk operations in SQL Agent?

// .limit() paginates Array by 50 items
some_array.limit(50, function(items, next) {

    var sql = DB();
    var builder = [];

    // Creates raw SQL queries
    for (var i = 0, length = items.length; i < length; i++) {
        var item = items[i];
        builder.push('INSERT INTO tbl_products (id, name, price) VALUES({0},{1},{2})'.format(sql.escape(item.id), sql.escape(item.name), sql.escape(item.price)));
    }

    // Runs one big query
    sql.query(builder.join('\n'));
    sql.exec(function(err) {
        err && console.error(err);

        // Process next 50 pieces
        next();
    });

}, () => console.log('DONE'));

Tags

Follow us

Latest blogs
Total.js Platform has a new direction
Wed Aug 01 2018 13:46:17 GMT+0200 (CEST)
Total.js: Incubators, partners and sponsors
Wed Aug 01 2018 13:30:49 GMT+0200 (CEST)
Total.js v3.0.0
Wed Aug 01 2018 13:24:21 GMT+0200 (CEST)
Flow v5.1
Thu Jun 28 2018 19:22:41 GMT+0200 (CEST)
Total.js Dashboard v6.0
Mon Apr 23 2018 16:05:59 GMT+0200 (CEST)

Latest comments
Not only for Total.js. You can communicate with different websocket servers.
Peter Širka
Mon Apr 23 2018 20:08:20 GMT+0200 (CEST)
Is WEBSOCKETCLIENT only for internal ws connections between totaljs apps?
Stelios Stephanua
Fri Mar 16 2018 06:04:22 GMT+0100 (CET)
Total.js is amazing! ;)
Leonardo Hessel
Tue Dec 19 2017 19:51:15 GMT+0100 (CET)

Pixabay

Read more

Total.js Platform has a new direction

Business: We have changed the direction for Total.js platform. Currently all Total.js premium products are free.

Wed Aug 01 2018 13:46:17 GMT+0200 (CEST)
Total.js: Incubators, partners and sponsors

Business: We are looking for new partners, sponsors and incubators which can help us to grow!

Wed Aug 01 2018 13:30:49 GMT+0200 (CEST)
Total.js v3.0.0

News: I have released a new version of Total.js framework. New version brings two awesome features and a lot of improvements.

Wed Aug 01 2018 13:24:21 GMT+0200 (CEST)
Flow v5.1

News: This version of Flow brings three new great features and small UI improvements.

Thu Jun 28 2018 19:22:41 GMT+0200 (CEST)
Total.js Dashboard v6.0

Products: I have published a new version of Dashboard. New version brings new improvements and features.

Mon Apr 23 2018 16:05:59 GMT+0200 (CEST)
Flow v5.0.0

News: I have released a new version of Total.js Flow v5.0.0 with great new features and improvements.

Mon Apr 16 2018 12:32:11 GMT+0200 (CEST)