sql

package

Go to main page

Versions in this module

v0

v0.6.0

Dec 7, 2022

Changes in this version

type Connection

+ GetPermissions func(ctx context.Context, principalId GenericServerPrincipalId) ServerPermissions

+ GrantPermission func(ctx context.Context, principalId GenericServerPrincipalId, ...)

+ RevokePermission func(ctx context.Context, principalId GenericServerPrincipalId, permission string)

+ type GenericServerPrincipalId int

+ const EmptyServerPrincipalId

+ type ServerPermission struct

+ Name string

+ WithGrantOption bool

+ type ServerPermissions map[string]ServerPermission

+ type ServerPrincipalType int

+ const SERVER_ROLE

+ const SQL_LOGIN

+ const UNKNOWN

+ type ServerRole interface

+ AddMember func(ctx context.Context, id GenericServerPrincipalId)

+ Drop func(ctx context.Context)

+ GetId func(ctx context.Context) ServerRoleId

+ GetMembers func(ctx context.Context) ServerRoleMembers

+ GetSettings func(ctx context.Context) ServerRoleSettings

+ HasMember func(ctx context.Context, id GenericServerPrincipalId) bool

+ RemoveMember func(ctx context.Context, id GenericServerPrincipalId)

+ Rename func(ctx context.Context, name string)

+ func CreateServerRole(ctx context.Context, conn Connection, settings ServerRoleSettings) ServerRole

+ func GetServerRole(_ context.Context, conn Connection, id ServerRoleId) ServerRole

+ func GetServerRoleByName(ctx context.Context, conn Connection, name string) ServerRole

+ type ServerRoleId GenericServerPrincipalId

+ type ServerRoleMember struct

+ Id GenericServerPrincipalId

+ Name string

+ Type ServerPrincipalType

+ type ServerRoleMembers map[GenericServerPrincipalId]ServerRoleMember

+ type ServerRoleSettings struct

+ Name string

+ OwnerId GenericServerPrincipalId

+ type ServerRoles map[ServerRoleId]ServerRole

+ func GetServerRoles(ctx context.Context, conn Connection) ServerRoles

+ type SqlLoginId GenericServerPrincipalId

type SqlLoginSettings

+ PrincipalId SqlLoginId

v0.5.0

Oct 31, 2022

Changes in this version

type Database

+ GetPermissions func(ctx context.Context, id GenericDatabasePrincipalId) DatabasePermissions

+ GrantPermission func(ctx context.Context, id GenericDatabasePrincipalId, ...)

+ RevokePermission func(ctx context.Context, id GenericDatabasePrincipalId, permissionName string)

+ UpdatePermission func(ctx context.Context, id GenericDatabasePrincipalId, ...)

+ type DatabasePermission struct

+ Name string

+ WithGrantOption bool

+ type DatabasePermissions map[string]DatabasePermission

type Schema

+ GetPermissions func(ctx context.Context, id GenericDatabasePrincipalId) SchemaPermissions

+ GrantPermission func(ctx context.Context, id GenericDatabasePrincipalId, ...)

+ RevokePermission func(ctx context.Context, id GenericDatabasePrincipalId, permission string)

+ UpdatePermission func(ctx context.Context, id GenericDatabasePrincipalId, ...)

+ type SchemaPermission struct

+ Name string

+ WithGrantOption bool

+ type SchemaPermissions map[string]SchemaPermission

v0.4.0

Oct 24, 2022

Changes in this version

+ func GetSchemas(ctx context.Context, db Database) map[SchemaId]Schema

type Database

+ Exec func(ctx context.Context, script string)

+ Query func(ctx context.Context, query string) []map[string]string

+ type Schema interface

+ ChangeOwner func(_ context.Context, ownerId GenericDatabasePrincipalId)

+ Drop func(context.Context)

+ GetDb func(context.Context) Database

+ GetId func(context.Context) SchemaId

+ GetName func(context.Context) string

+ GetOwnerId func(context.Context) GenericDatabasePrincipalId

+ func CreateSchema(ctx context.Context, db Database, name string, ownerId T) Schema

+ func GetSchema(_ context.Context, db Database, id SchemaId) Schema

+ func GetSchemaByName(ctx context.Context, db Database, name string) Schema

+ type SchemaId int

v0.3.0

Oct 14, 2022

v0.2.0

Sep 29, 2022

Changes in this version

+ type AADObjectId string

type DatabasePrincipalType

+ const AZUREAD_USER

type UserSettings

+ AADObjectId AADObjectId

+ Type UserType

+ type UserType int

+ const USER_TYPE_AZUREAD

+ const USER_TYPE_SQL

+ const USER_TYPE_UKNOWN

v0.1.1

Jul 19, 2022

Changes in this version

type Connection

+ IsAzure func(context.Context) bool

v0.1.0

Jul 6, 2022

Changes in this version

+ const NullDatabaseId

+ func GetDatabaseRoles(ctx context.Context, db Database) map[DatabaseRoleId]DatabaseRole

+ func GetDatabases(ctx context.Context, conn Connection) map[DatabaseId]Database

+ func GetSqlLogins(ctx context.Context, conn Connection) map[LoginId]SqlLogin

+ func GetUsers(ctx context.Context, db Database) map[UserId]User

+ func WithConnection(ctx context.Context, connectionFactory func(context.Context) *sql.DB, ...) T

+ type Connection interface

+ type ConnectionAuth interface

+ type ConnectionAuthAzure struct

+ ClientId string

+ ClientSecret string

+ TenantId string

+ type ConnectionAuthSql struct

+ Password string

+ Username string

+ type ConnectionDetails struct

+ Auth ConnectionAuth

+ Database string

+ Host string

+ func (cd ConnectionDetails) Open(ctx context.Context) (Connection, diag.Diagnostics)

+ type Database interface

+ Drop func(context.Context)

+ Exists func(context.Context) bool

+ GetConnection func(context.Context) Connection

+ GetId func(context.Context) DatabaseId

+ GetSettings func(context.Context) DatabaseSettings

+ Rename func(_ context.Context, name string)

+ SetCollation func(_ context.Context, collation string)

+ func CreateDatabase(ctx context.Context, conn Connection, settings DatabaseSettings) Database

+ func GetDatabase(_ context.Context, conn Connection, id DatabaseId) Database

+ func GetDatabaseByName(ctx context.Context, conn Connection, name string) Database

+ type DatabaseId int

+ type DatabasePrincipalId interface

+ type DatabasePrincipalType int

+ const DATABASE_ROLE

+ const SQL_USER

+ const UNONOWN

+ type DatabaseRole interface

+ AddMember func(_ context.Context, memberId GenericDatabasePrincipalId)

+ ChangeOwner func(_ context.Context, ownerId GenericDatabasePrincipalId)

+ Drop func(context.Context)

+ GetDb func(context.Context) Database

+ GetId func(context.Context) DatabaseRoleId

+ GetMembers func(_ context.Context) map[GenericDatabasePrincipalId]DatabaseRoleMember

+ GetName func(context.Context) string

+ GetOwnerId func(context.Context) GenericDatabasePrincipalId

+ HasMember func(_ context.Context, memberId GenericDatabasePrincipalId) bool

+ RemoveMember func(_ context.Context, memberId GenericDatabasePrincipalId)

+ Rename func(_ context.Context, name string)

+ func CreateDatabaseRole(ctx context.Context, db Database, name string, ownerId T) DatabaseRole

+ func GetDatabaseRole(_ context.Context, db Database, id DatabaseRoleId) DatabaseRole

+ func GetDatabaseRoleByName(ctx context.Context, db Database, name string) DatabaseRole

+ type DatabaseRoleId GenericDatabasePrincipalId

+ type DatabaseRoleMember struct

+ Id GenericDatabasePrincipalId

+ Name string

+ Type DatabasePrincipalType

+ type DatabaseSettings struct

+ Collation string

+ Name string

+ type GenericDatabasePrincipalId int

+ const EmptyDatabasePrincipalId

+ type LoginId string

+ const NullLoginId

+ type NumericObjectId interface

+ type ObjectId interface

+ type SqlLogin interface

+ Drop func(ctx context.Context)

+ Exists func(context.Context) bool

+ GetId func(context.Context) LoginId

+ GetSettings func(context.Context) SqlLoginSettings

+ UpdateSettings func(ctx context.Context, settings SqlLoginSettings)

+ func CreateSqlLogin(ctx context.Context, conn Connection, settings SqlLoginSettings) SqlLogin

+ func GetSqlLogin(_ context.Context, conn Connection, id LoginId) SqlLogin

+ func GetSqlLoginByName(ctx context.Context, conn Connection, name string) SqlLogin

+ type SqlLoginSettings struct

+ CheckPasswordExpiration bool

+ CheckPasswordPolicy bool

+ DefaultDatabaseId DatabaseId

+ DefaultLanguage string

+ MustChangePassword bool

+ Name string

+ Password string

+ type StringObjectId interface

+ type User interface

+ Drop func(context.Context)

+ GetDatabaseId func(context.Context) DatabaseId

+ GetId func(context.Context) UserId

+ GetSettings func(context.Context) UserSettings

+ UpdateSettings func(context.Context, UserSettings)

+ func CreateUser(ctx context.Context, db Database, settings UserSettings) User

+ func GetUser(_ context.Context, db Database, id UserId) User

+ func GetUserByName(ctx context.Context, db Database, name string) User

+ type UserId GenericDatabasePrincipalId

+ type UserSettings struct

+ LoginId LoginId

+ Name string

v0.0.1-alpha

May 31, 2022

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