sqlserver

package
v0.1.3 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 27, 2026 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func OpenDatabase added in v0.1.0

func OpenDatabase(connUrl string, databaseName string) (*sql.DB, error)

func QuoteIdentifier added in v0.1.0

func QuoteIdentifier(name string) string

QuoteIdentifier quotes an identifier (table name, column name, etc.) for use in SQL Server. SQL Server uses square brackets for quoting: [identifier] Any closing brackets within the identifier are escaped by doubling them: ] -> ]]

func QuoteLiteral added in v0.1.0

func QuoteLiteral(s string) string

QuoteLiteral quotes a string literal for use in SQL Server. Single quotes are escaped by doubling them: ' -> ” The N prefix ensures proper Unicode handling.

Types

type Database

type Database struct {
	Name      string `json:"name"`
	Collation string `json:"collation,omitempty"`

	// Do not error if trying to create a database that already exists
	// Instead, read the existing and return
	UseExisting bool `json:"useExisting"`
}

func (Database) Key added in v0.1.0

func (d Database) Key() string

type DatabaseAccess added in v0.1.0

type DatabaseAccess struct {
	Database string `json:"database"`
	Login    string `json:"login"`
}

func (DatabaseAccess) Key added in v0.1.0

type DatabaseAccessKey added in v0.1.0

type DatabaseAccessKey struct {
	Database string
	Login    string
}

type DatabaseAccesses added in v0.1.0

type DatabaseAccesses struct {
	DbOpener DbOpener
}

func (*DatabaseAccesses) Create added in v0.1.0

func (*DatabaseAccesses) Drop added in v0.1.0

func (r *DatabaseAccesses) Drop(key DatabaseAccessKey) (bool, error)

func (*DatabaseAccesses) Read added in v0.1.0

func (*DatabaseAccesses) Update added in v0.1.0

type Databases added in v0.1.0

type Databases struct {
	DbOpener DbOpener
}

func (*Databases) Create added in v0.1.0

func (d *Databases) Create(obj Database) (*Database, error)

func (*Databases) Drop added in v0.1.0

func (d *Databases) Drop(key string) (bool, error)

func (*Databases) Read added in v0.1.0

func (d *Databases) Read(key string) (*Database, error)

func (*Databases) Update added in v0.1.0

func (d *Databases) Update(key string, obj Database) (*Database, error)

type DbOpener added in v0.1.0

type DbOpener interface {
	OpenDatabase(dbName string) (*sql.DB, error)
}

type Login added in v0.1.0

type Login struct {
	Name     string `json:"name"`
	Password string `json:"password,omitempty"`

	// Do not error if trying to create a database that already exists
	// Instead, read the existing and return
	UseExisting bool `json:"useExisting"`
}

func (Login) Key added in v0.1.0

func (l Login) Key() string

type Logins added in v0.1.0

type Logins struct {
	DbOpener DbOpener
}

func (*Logins) Create added in v0.1.0

func (r *Logins) Create(obj Login) (*Login, error)

func (*Logins) Drop added in v0.1.0

func (r *Logins) Drop(key string) (bool, error)

func (*Logins) Read added in v0.1.0

func (r *Logins) Read(key string) (*Login, error)

func (*Logins) Update added in v0.1.0

func (r *Logins) Update(key string, obj Login) (*Login, error)

type Store added in v0.1.0

type Store struct {
	Databases      *Databases
	Logins         *Logins
	DatabaseAccess *DatabaseAccesses

	sync.Mutex
	// contains filtered or unexported fields
}

func NewStore added in v0.1.0

func NewStore(connUrl string) *Store

func (*Store) Close added in v0.1.0

func (s *Store) Close()

func (*Store) ConnectionUrl added in v0.1.0

func (s *Store) ConnectionUrl() string

func (*Store) OpenDatabase added in v0.1.0

func (s *Store) OpenDatabase(dbName string) (*sql.DB, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL