/Javascript/Node.js/Node js firebird example

Node js firebird example

var sql1 = 'SELECT * FROM TBL_USER WHERE ID>' + Firebird.escape(1);var sql2 = 'SELECT * FROM TBL_USER WHERE NAME=' + Firebird.escape('Pe\'er');var sql3 = 'SELECT * FROM TBL_USER WHERE CREATED<=' + Firebird.escape(new Date());var sql4 = 'SELECT * FROM TBL_USER WHERE NEWSLETTER=' + Firebird.escape(true); // or db.escape() console.log(sql1);console.log(sql2);console.log(sql3);console.log(sql4);

Source: npmjs.com

Node js firebird example

fb.attach(_connection, function(err, svc) {    if (err)        return;    // all function that return a stream take two optional parameter    // optread => byline or buffer  byline use isc_info_svc_line and buffer use isc_info_svc_to_eof    // buffersize => is the buffer for service manager it can't exceed 8ko (i'm not sure)     svc.getLog({optread:'buffer', buffersize:2048}, function (err, data) {            // data is a readablestream that contain the firebird.log file            console.log(err);            data.on('data', function (data) {                console.log(data.toString());            });            data.on('end', function() {                console.log('finish');            });        });     // an other exemple to use function that return object    svc.getFbserverInfos(            {            "dbinfo" : true,            "fbconfig" : true,            "svcversion" : true,            "fbversion" : true,            "fbimplementation" : true,            "fbcapatibilities" : true,            "pathsecuritydb" : true,            "fbenv" : true,            "fbenvlock" : true,            "fbenvmsg" : true        }, {}, function (err, data) {            console.log(err);            console.log(data);        });});

Source: npmjs.com

Node js firebird example

Firebird.attach(options, function(err, db) {     if (err)        throw err;     // db = DATABASE    db.query('SELECT * FROM TABLE', function(err, result) {        // IMPORTANT: close the connection        db.detach();    }); });

Source: npmjs.com

Node js firebird example

const options = {...}; // Classic configuration with manager = trueFirebird.attach(options, function(err, svc) {    if (err)        return;    svc.backup(        {            database:'/DB/MYDB.FDB',            files: [                    {                     filename:'/DB/MYDB.FBK',                     sizefile:'0'                    }                   ]        },        function(err, data) {            data.on('data', line => console.log(line));            data.on('end', () => svc.detach());        }    );});

Source: npmjs.com

Node js firebird example

Firebird.attach(options, function(err, db) {     if (err)        throw err;     // db = DATABASE    // INSERT STREAM as BLOB    db.query('INSERT INTO USERS (ID, ALIAS, FILE) VALUES(?, ?, ?)', [1, 'Peter', fs.createReadStream('/users/image.jpg')], function(err, result) {        // IMPORTANT: close the connection        db.detach();    });});

Source: npmjs.com

Node js firebird example

Firebird.attach(options, function(err, db) {     if (err)        throw err;     // db = DATABASE    db.transaction(Firebird.ISOLATION_READ_COMMITED, function(err, transaction) {        transaction.query('INSERT INTO users VALUE(?,?)', [1, 'Janko'], function(err, result) {             if (err) {                transaction.rollback();                return;            }             transaction.commit(function(err) {                if (err)                    transaction.rollback();                else                    db.detach();            });        });    });});

Source: npmjs.com

Node js firebird example

AuthServer = Srp, Legacy_AuthWireCrypt = DisabledUserManager = Legacy_UserManager

Source: npmjs.com

Node js firebird example

var { GDSCode } = require('node-firebird/lib/gdscodes');/*...*/db.query('insert into my_table(id, name) values (?, ?)', [1, 'John Doe'],    function (err) {        if(err.gdscode == GDSCode.UNIQUE_KEY_VIOLATION){            console.log('constraint name:'+ err.gdsparams[0]);            console.log('table name:'+ err.gdsparams[0]);            /*...*/        }        /*...*/    });

Source: npmjs.com

Node js firebird example

// 5 = the number is count of opened socketsvar pool = Firebird.pool(5, options); // Get a free poolpool.get(function(err, db) {     if (err)        throw err;     // db = DATABASE    db.query('SELECT * FROM TABLE', function(err, result) {        // IMPORTANT: release the pool connection        db.detach();    });}); // Destroy poolpool.destroy();

Source: npmjs.com

Node js firebird example

Firebird.attach(options, function(err, db) {     if (err)        throw err;     // db = DATABASE    // INSERT BUFFER as BLOB    db.query('INSERT INTO USERS (ID, ALIAS, FILE) VALUES(?, ?, ?)', [1, 'Peter', fs.readFileSync('/users/image.jpg')], function(err, result) {        // IMPORTANT: close the connection        db.detach();    });});

Source: npmjs.com

Similar codes

0 vote291 views1 answer
Create directory when writing to file in nodejs
Javascript Node.js
0 vote277 views1 answer
Node js request download file
Javascript Node.js
1 vote283 views2 answers
Node get root directory
Javascript Node.js
0 vote280 views1 answer
How to load and parse the json data in node js
Javascript Node.js
2 votes275 views3 answers
How to read a csv file in nodejs
Javascript Node.js
4 votes283 views1 answer
How to check file extension in node js
Javascript Node.js
2 votes281 views1 answer
Sleep in nodejs?
Javascript Node.js
0 vote280 views1 answer
How to use a fixed time zone in nodejs
Javascript Node.js
0 vote268 views2 answers
Decode jwt token nodejs
Javascript Node.js
2 votes266 views1 answer
Promise syntax in node js
Javascript Node.js