SqlServerConnection

SqlServer connection using the default driver.

Implements: IReferenceable, IConfigurable, IOpenable

Description

The SqlServerConnection class allows you to create SqlServer connections using the default driver.

Important points

By defining a connection and sharing it through multiple persistence components you can reduce the number of used database connections.

Configuration parameters

  • connection(s):
    • discovery_key: (optional) a key to retrieve the connection from IDiscovery
    • host: host name or IP address
    • port: port number (default: 8082)
    • uri: resource URI or connection string with all parameters in it
  • credential(s):
    • store_key: (optional) a key to retrieve the credentials from ICredentialStore
    • username: (optional) user name
    • password: (optional) user password
  • options:
    • connect_timeout: (optional) number of milliseconds to wait before timing out when connecting a new client (default: 0)
    • idle_timeout: (optional) number of milliseconds a client must sit idle in the pool and not be checked out (default: 10000)
    • max_pool_size: (optional) maximum number of clients the pool should contain (default: 10)

References

  • *:logger:*:*:1.0 - (optional) ILogger components to pass log messages
  • *:discovery:*:*:1.0 - (optional) IDiscovery services
  • *:credential-store:*:*:1.0 (optional) credential stores to resolve credentials

Fields

Connection

SqlServer connection pool object.

Connection: *sql.DB

ConnectionResolver

Connection resolver.

ConnectionResolver: *SqlServerConnectionResolver

DatabaseName

SqlServer database name.

DatabaseName: string

Logger

Logger.

Logger: *CompositeLogger

Options

Configuration options.

Options: *ConfigParams

Constructors

NewSqlServerConnection

Creates a new instance of the connection component.

NewSqlServerConnection() *SqlServerConnection

Methods

Close

Closes the component and frees used resources.

(c *SqlServerConnection) Close(ctx context.Context, correlationId string) error

  • ctx: context.Context - operation context.
  • correlationId: string - (optional) transaction id used to trace execution through the call chain.
  • returns: error - error or nil if no errors occured.

Configure

Configures the component by passing its configuration parameters.

(c *SqlServerConnection) Configure(ctx context.Context, config *cconf.ConfigParams)

  • ctx: context.Context - operation context.
  • config: *cconf.ConfigParams - configuration parameters to be set.

GetConnection

Gets the connection.

(c *SqlServerConnection) GetConnection() *sql.DB

  • returns: *sql.DB - connection to a SqlServer database

GetDatabaseName

Gets the database name.

(c *SqlServerConnection) GetDatabaseName() string

  • returns: string - database name

IsOpen

Checks if the component is open.

(c *SqlServerConnection) IsOpen() bool

  • returns: bool - true if the component is open and false otherwise.

Open

Opens the component.

(c *SqlServerConnection) Open(ctx context.Context, correlationId string) error

  • ctx: context.Context - operation context.
  • correlationId: string - (optional) transaction id used to trace execution through the call chain.
  • returns: error - error or nil if no errors occured.

SetReferences

Sets references to dependent components.

(c *SqlServerConnection) SetReferences(ctx context.Context, references cref.IReferences)

  • ctx: context.Context - operation context.
  • references: cref.IReferences - references to locate the component’s dependencies.