sqlite

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 Family struct {
	Subject string
	Family  string
	Valid   bool
}

type InsertFamilyParams struct {
	Subject string
	Family  string
	Valid   bool
}

type InsertSecretParams struct {
	Subject string
	Secret  string
}

type InsertSubjectParams struct {
	Username string
	Subject  string
}

type InsertUserParams struct {
	Username string
	Password string
}

type Querier interface {
	//InsertFamily
	//
	//  INSERT OR REPLACE INTO families (subject, family, valid) VALUES (?, ?, ?)
	InsertFamily(ctx context.Context, arg InsertFamilyParams) error
	//InsertSecret
	//
	//  INSERT OR REPLACE INTO secrets (subject, secret) VALUES (?, ?)
	InsertSecret(ctx context.Context, arg InsertSecretParams) error
	//InsertSubject
	//
	//  INSERT INTO subjects (username, subject) VALUES (?, ?)
	InsertSubject(ctx context.Context, arg InsertSubjectParams) error
	//InsertUser
	//
	//  INSERT INTO users (username, password) VALUES (?, ?)
	InsertUser(ctx context.Context, arg InsertUserParams) error
	//InvalidateUser
	//
	//  UPDATE families SET valid = FALSE WHERE subject = ?
	InvalidateUser(ctx context.Context, subject string) error
	//SelectFamily
	//
	//  SELECT valid FROM families WHERE subject = ? AND family = ?
	SelectFamily(ctx context.Context, arg SelectFamilyParams) (bool, error)
	//SelectPasswordByUsername
	//
	//  SELECT password FROM users WHERE username = ?
	SelectPasswordByUsername(ctx context.Context, username string) (string, error)
	//SelectSecret
	//
	//  SELECT secret FROM secrets WHERE subject = ?
	SelectSecret(ctx context.Context, subject string) (string, error)
	//SelectSubjectByUsername
	//
	//  SELECT subject FROM subjects WHERE username = ?
	SelectSubjectByUsername(ctx context.Context, username string) (string, error)
}

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

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

type Secret struct {
	Subject string
	Secret  string
}

type SelectFamilyParams struct {
	Subject string
	Family  string
}

type Subject struct {
	Username string
	Subject  string
}

type User struct {
	Username string
	Password string
}