database

Documentation

Overview

The package database handles the methods and definition to manipulate a database.

Index

• func InitialMigration(db *sql.DB) error
• type Counter
• type CreateCredentialParams
• type CreateUserParams
• type Credential
• type DBTX
• type DeleteCredentialParams
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateCounter(ctx context.Context, userID string) error
  • func (q *Queries) CreateCredential(ctx context.Context, arg CreateCredentialParams) error
  • func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)
  • func (q *Queries) DeleteCredential(ctx context.Context, arg DeleteCredentialParams) error
  • func (q *Queries) GetCounter(ctx context.Context, userID string) (Counter, error)
  • func (q *Queries) GetCredentialsByUser(ctx context.Context, userID []byte) ([]Credential, error)
  • func (q *Queries) GetUser(ctx context.Context, id []byte) (User, error)
  • func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error)
  • func (q *Queries) IncrementCounter(ctx context.Context, userID string) (int64, error)
  • func (q *Queries) UpdateCredential(ctx context.Context, arg UpdateCredentialParams) error
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type UpdateCredentialParams
• type User

Functions

func InitialMigration

func InitialMigration(db *sql.DB) error

InitialMigration migrate a sqlite3 database if necessary.

Types

type Counter

type Counter struct {
	UserID string
	Count  int64
}

type CreateCredentialParams

type CreateCredentialParams struct {
	ID              []byte
	PublicKey       []byte
	AttestationType string
	Transport       []byte
	Flags           []byte
	Authenticator   []byte
	UserID          []byte
}

type CreateUserParams

type CreateUserParams struct {
	ID          []byte
	Name        string
	DisplayName string
}

type Credential

type Credential struct {
	ID              []byte
	PublicKey       []byte
	AttestationType string
	Transport       []byte
	Flags           []byte
	Authenticator   []byte
	UserID          []byte
}

type DBTX

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type DeleteCredentialParams

type DeleteCredentialParams struct {
	ID     []byte
	UserID []byte
}

type Queries

type Queries struct {
	// contains filtered or unexported fields
}

func New

func New(db DBTX) *Queries

func (*Queries) CreateCounter

func (q *Queries) CreateCounter(ctx context.Context, userID string) error

func (*Queries) CreateCredential

func (q *Queries) CreateCredential(ctx context.Context, arg CreateCredentialParams) error

func (*Queries) CreateUser

func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error)

func (*Queries) DeleteCredential

func (q *Queries) DeleteCredential(ctx context.Context, arg DeleteCredentialParams) error

func (*Queries) GetCounter

func (q *Queries) GetCounter(ctx context.Context, userID string) (Counter, error)

func (*Queries) GetCredentialsByUser

func (q *Queries) GetCredentialsByUser(ctx context.Context, userID []byte) ([]Credential, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id []byte) (User, error)

Self-Hosted users

func (*Queries) GetUserByName

func (q *Queries) GetUserByName(ctx context.Context, name string) (User, error)

func (*Queries) IncrementCounter

func (q *Queries) IncrementCounter(ctx context.Context, userID string) (int64, error)

func (*Queries) UpdateCredential

func (q *Queries) UpdateCredential(ctx context.Context, arg UpdateCredentialParams) error

func (*Queries) WithTx

func (q *Queries) WithTx(tx *sql.Tx) *Queries

type UpdateCredentialParams

type UpdateCredentialParams struct {
	PublicKey       []byte
	AttestationType string
	Transport       []byte
	Flags           []byte
	Authenticator   []byte
	ByID            []byte
}

type User

type User struct {
	ID          []byte
	Name        string
	DisplayName string
}