ps-conecta-firebird-node

0.0.11 • Public • Published

Welcome to ps-conecta-firebird-node 👋

Version Documentation Maintenance License: MIT

Modulo de conexão com o firebird feito pela PrimeSoftware

🏠 Homepage

Install

npm install

Usage

const {Database, conectionType} = require('ps-conecta-firebird-node');
let opts = {
    host: 'ps.com', //#ip do servidor
    port: 3050, //#porta liberada para conexão
    database: '_banco', //#alias do banco de dados
    database_image: '_img', //#alias do banco de imagem
    user: 'SYSDBA', //#Usuario
    password: 'MASTERKEY', //#Senha do usuário
    lowercase_keys: true, //#Se o retorno será em caracteres minisculos
    role: null, //#A role do usuário
    pageSize: 4096, //#O tamanho do paginamento do banco de dados
    conectionType: conectionType.conectaBdSingleton, //#Tipo de conexão com o banco de dados
};

let firebird = new Database(opts);


async function buscaCodigo(){
    return new Promise(async(resolve, reject)=>{
        await firebird.executaQuery("SELECT FIRST 1 OC.CODIGO FROM OC_ATENDIMENTO OC", [], false, false, false).then((res)=>{
            resolve(res);
        }).catch((erro)=>{
            console.log(`Ocorreu um erro ao tentar consultar as informações no banco de dados! Erro: ${erro}.`);
            reject(null);
        })
    })
}

buscaCodigo().then((res)=>{
    console.log(res);
});

Tipos permitidos para conexão

conectionType.conectaBd
conectionType.conectaBdTransaction
conectionType.conectaBdSingleton #Recomendado
conectionType.conectaBdSingletonTransaction

Author

👤 Cassio Fernandes

  • Website: primesoftware.com.br
  • Github: @cassfer

🤝 Contributing

Contributions, issues and feature requests are welcome!
Feel free to check issues page. You can also take a look at the contributing guide.

Show your support

Give a ⭐️ if this project helped you!

📝 License

Copyright © 2021 Cassio Fernandes.
This project is MIT licensed.


This README was generated with ❤️ by readme-md-generator

Readme

Keywords

none

Package Sidebar

Install

npm i ps-conecta-firebird-node

Weekly Downloads

2

Version

0.0.11

License

MIT

Unpacked Size

47.3 kB

Total Files

4

Last publish

Collaborators

  • primesoftwaresi