sql

Documentation

Index

• type Connector
  • func (c Connector) CreateLogin(username string, password string) error
  • func (c Connector) DeleteLogin(username string) error
  • func (c Connector) Execute(command string, args ...interface{}) error
  • func (c Connector) GetLogin(username string) (*Login, error)
  • func (c Connector) Query(query string, scanner func(*sql.Rows) error, args ...interface{}) error
  • func (c Connector) UpdateLogin(username string, password string) error
• type Login

Types

type Connector

type Connector struct {
	ConnectionString string
}

Connector stores connection information for the SQL Server instance and contains instance methods that can run SQL queries and commands

func (Connector) CreateLogin

func (c Connector) CreateLogin(username string, password string) error

CreateLogin connects to the SQL Database to create a login with the provided credentials

func (Connector) DeleteLogin

func (c Connector) DeleteLogin(username string) error

DeleteLogin connects to the SQL Database and removes a login with the provided username, if it exists. If it does not exist, this is a noop.

func (Connector) Execute

func (c Connector) Execute(command string, args ...interface{}) error

Execute an SQL statement and ignore the results

func (Connector) GetLogin

func (c Connector) GetLogin(username string) (*Login, error)

GetLogin reads a login from the SQL Database, if it exists. If it does not, no error is returned, but the returned Login is nil

func (Connector) Query

func (c Connector) Query(query string, scanner func(*sql.Rows) error, args ...interface{}) error

Query the database

func (Connector) UpdateLogin

func (c Connector) UpdateLogin(username string, password string) error

UpdateLogin updates the password of a login, if it exists.

type Login

type Login struct {
	Username    string
	PrincipalID int64
}

Login represents an SQL Server Login