Socket
Socket
Sign inDemoInstall

@softrams/nodejs-mysql-connector

Package Overview
Dependencies
1
Maintainers
3
Versions
9
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

@softrams/nodejs-mysql-connector


Version published
Maintainers
3
Install size
1.02 MB
Created

Readme

Source

MySQL DB Connector

Wrapper utility to easily manage multiple data sources and pooled connections.

Error Returns

By default, all errors occurring during a query are returned. If you want to be extra-safe in a production environment, you can set HIDE_DB_ERRORS value on the root config passed to the connector on initialization. When you do this, all errors will be logged, but none returned when a query error occurs.

SSL Settings

This connector allows setting SSL connection using a few different options.

You can provide a custom cert:

SSL: {
  CUSTOM_CERT: // custom cert string
}

By default, when specifying an SSL object, the mysql connector will reject unauthorized calls by adding rejectUnauthorized: true. You may override this setting by specifying a value for REJECT_UNAUTHORIZED in your SSL config:

SSL: {
  REJECT_UNAUTHORIZED: false // not recommended
}

Data Typing Options

This connector gives you a few options for configuring how data is returned from the connector. 'typeCast' defaults to true, and converts data from the database to its javascript equivalent. For example, it will convert DATETIME SQL objects to a DATE javascript type. You can also set 'dateStrings' which defaults to false. If you set it to true it will override typeCast and force date returns to be a string instead of a DATE type.

Working within a transaction

As of version 0.1.0 you can utilize sql transactions. Simply call the transactionConnection method to get a transaction connection and then begin the transaction. Then, write as many queries as you want, and when you are done, you can commit the transaction and all of your queries will be saved to the database or you can roll back the transaction and nothing done while inside that transaction will be saved. Some pseudo-code for how you might do that is below:

someMethod = async () => {
    const pool = await dataSource.connect(DATABASE_POOL);
    const transactionConnection = await dataSource.transactionConnection(pool);
    await transactionConnection.beginTransaction();

    try {
      await transactionConnection.execute(SOME_QUERY, []);
      await transactionConnection.execute(SOME_QUERY, []);
      await transactionConnection.execute(SOME_QUERY, []);

      await transactionConnection.commitTransaction();
    } catch (err) {
      await transactionConnection.rollbackTransaction();
      throw err;
    }
  };

Keywords

FAQs

Last updated on 11 Apr 2024

Did you know?

Socket

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Packages

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc