Nefariously Programmed Mecha

    @tediousjs/connection-string
    TypeScript icon, indicating that this package has built-in type declarations

    0.4.0 • Public • Published

    Connection String Parser

    This node library is designed to allow the parsing of Connection Strings see https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring

    The library also provides the ability to parse SQL Connection Strings.

    Usage

    Parsing connection strings

    The library comes with a generic connection string parser that will parse through valid connections strings and produce a key-value map of the entries in that string. No additional validation is performed.

    const { parseConnectionString } = require('@tediousjs/connection-string');
    
    const connectionString = 'User ID=user;Password=password;Initial Catalog=AdventureWorks;Server=MySqlServer';
    
    const parsed = parseConnectionString(connectionString);
    
    console.log(parsed);

    Output to the console will be:

    {
      "User id": "user",
      "password": "password",
      "initial catalog": "AdventureWorks",
      "server": "MySqlServer"
    }

    Parsing SQL connection strings

    There is a specific helper for parsing SQL connection strings and this comes with a value normaliser and validation. It also has an option to "canonicalise" the properties. For many properties in an SQL connections string, there are aliases, when canonical properties are being used, these aliases will be returned as the canonical property.

    const { parseMssqlConnectionString } = require('@tediousjs/connection-string');
    
    const connectionString = 'User ID=user;Password=password;Initial Catalog=AdventureWorks;Server=MySqlServer';
    
    const parsed = parseConnectionString(connectionString, true);
    
    console.log(parsed);

    Output to console will be:

    {
      "user id": "user",
      "password": "password",
      "initial catalog": "AdventureWorks",
      "data source": "MySqlServer"
    }

    NB: The Server property from the connection string has been re-written to the value Data Source

    Install

    npm i @tediousjs/connection-string

    DownloadsWeekly Downloads

    121,310

    Version

    0.4.0

    License

    MIT

    Unpacked Size

    29.4 kB

    Total Files

    10

    Last publish

    Collaborators

    • arthurschreiber
    • dhensby