Cliente Firebird JavaScript para Node.js.
Cliente Firebird assíncrono puramente JavaScript para Node.js ajustado para suportar firebird 2.1. baseado completamente no node-firebird
Firebird nas redes sociais
Instalação
npm install plasoft-firebird --save
Utilização
var Firebird = ;
Métodos
-
Firebird.escape(value) -> return {String}
- prevent for SQL Injections -
Firebird.attach(options, function(err, db))
attach a database -
Firebird.create(options, function(err, db))
create a database -
Firebird.attachOrCreate(options, function(err, db))
attach or create database -
Firebird.pool(max, options, function(err, db)) -> return {Object}
create a connection pooling
Connection types
Connection options
var options = {}; optionshost = '127.0.0.1'; optionsport = 3050; optionsdatabase = 'database.fdb'; optionsuser = 'SYSDBA'; optionspassword = 'masterkey';
Classic
Firebird;
Pooling
// 5 = the number is count of opened sockets var pool = Firebird; // Get a free pool pool; // Destroy pool pool;
Database object (db)
Methods
-
db.query(query, [params], function(err, result))
- classic query, returns Array of Object -
db.execute(query, [params], function(err, result))
- classic query, returns Array of Array -
db.sequentially(query, [params], function(row, index), function(err))
- sequentially query -
db.detach(function(err))
detach a database -
db.transaction(isolation, function(err, transaction))
create transaction
Transaction methods
-
transaction.query(query, [params], function(err, result))
- classic query, returns Array of Object -
transaction.execute(query, [params], function(err, result))
- classic query, returns Array of Array -
transaction.commit(function(err))
commit current transaction -
transaction.rollback(function(err))
rollback current transaction
Examples
PARAMETRIZED QUERIES
Parameters
Firebird;
BLOB (stream)
Firebird;
BLOB (buffer)
Firebird;
READING BLOBS (ASYNCHRONOUS)
Firebird;
STREAMING A BIG DATA
Firebird;
TRANSACTIONS
Transaction types:
-
Firebird.ISOLATION_READ_UNCOMMITTED
-
Firebird.ISOLATION_READ_COMMITED
-
Firebird.ISOLATION_REPEATABLE_READ
-
Firebird.ISOLATION_SERIALIZABLE
-
Firebird.ISOLATION_READ_COMMITED_READ_ONLY
Firebird;
EVENTS
Firebird;
Escaping query values
var sql1 = 'SELECT * FROM TBL_USER WHERE ID>' + Firebird; var sql2 = 'SELECT * FROM TBL_USER WHERE NAME=' + Firebird; var sql3 = 'SELECT * FROM TBL_USER WHERE CREATED<=' + Firebird; var sql4 = 'SELECT * FROM TBL_USER WHERE NEWSLETTER=' + Firebird; // or db.escape() console; console; console; console;
Service Manager functions
-
backup
-
restore
-
fixproperties
-
serverinfo
-
database validation
-
commit transaction
-
rollback transaction
-
recover transaction
-
database stats
-
users infos
-
user actions (add modify remove)
-
get firebird file log
-
tracing
// each row : fctname : [params], typeofreturn var fbsvc = "backup" : "options" "stream" "nbackup" : "options" "stream" "restore" : "options" "stream" "nrestore" : "options" "stream" "setDialect": "database""dialect" "stream" "setSweepinterval": "database""sweepinterval" "stream" "setCachebuffer" : "database""nbpagebuffers" "stream" "BringOnline" : "database" "stream" "Shutdown" : "database""shutdown""shutdowndelay""shutdownmode" "stream" "setShadow" : "database""activateshadow" "stream" "setForcewrite" : "database""forcewrite" "stream" "setReservespace" : "database""reservespace" "stream" "setReadonlyMode" : "database" "stream" "setReadwriteMode" : "database" "stream" "validate" : "options" "stream" "commit" : "database" "transactid" "stream" "rollback" : "database" "transactid" "stream" "recover" : "database" "transactid" "stream" "getStats" : "options" "stream" "getLog" : "options" "stream" "getUsers" : "username" "object" "addUser" : "username" "password" "options" "stream" "editUser" : "username" "options" "stream" "removeUser" : "username""rolename" "stream" "getFbserverInfos" : "options" "options" "object" "startTrace" : "options" "stream" "suspendTrace" : "options" "stream" "resumeTrace" : "options" "stream" "stopTrace" : "options" "stream" "getTraceList" : "options" "stream" "hasActionRunning" : "options" "object"
Backup Service example
Firebird
getLog and getFbserverInfos Service examples with use of stream and object return
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);
});
});
Charset for database connection is always UTF-8
node-firebird doesn't let you chose the charset connection, it will always use UTF8.
Node is unicode, no matter if your database is using another charset to store string or blob, Firebird will transliterate automatically.
This is why you should use Firebird 2.5 server at least.
Firebird 3.0 Support
Firebird new wire protocol is not supported yet so
for Firebird 3.0 you need to add the following in firebird.conf
AuthServer = Legacy_Auth
WireCrypt = Disabled