cohabdb

package
v0.0.0-...-52de14c Latest Latest
Warning

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

Go to latest
Published: Nov 19, 2023 License: MIT Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func CreateTables

func CreateTables(ctx context.Context, db *sql.DB) error

func Open

func Open(filename string) (*sql.DB, error)

func OpenInMemory

func OpenInMemory() (*sql.DB, error)

Types

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 InsertSessionParams

type InsertSessionParams struct {
	ID     int64
	UserID int64
}

type InsertUserParams

type InsertUserParams struct {
	Sub     string
	Name    sql.NullString
	Picture sql.NullString
}

type Querier

type Querier interface {
	ExpireSession(ctx context.Context, id int64) error
	GetSession(ctx context.Context, id int64) (Session, error)
	GetToken(ctx context.Context, id int64) (sql.NullString, error)
	GetUser(ctx context.Context, id int64) (User, error)
	GetUserBySession(ctx context.Context, id int64) (User, error)
	InsertSession(ctx context.Context, arg InsertSessionParams) (Session, error)
	InsertUser(ctx context.Context, arg InsertUserParams) (User, error)
	UpdateContactGroupsJSON(ctx context.Context, arg UpdateContactGroupsJSONParams) error
	UpdateGoogleForceApproval(ctx context.Context, arg UpdateGoogleForceApprovalParams) error
	UpdateSelectedResourceName(ctx context.Context, arg UpdateSelectedResourceNameParams) error
	UpdateTokenBySession(ctx context.Context, arg UpdateTokenBySessionParams) error
	UpsertSession(ctx context.Context, arg UpsertSessionParams) (Session, error)
	UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) ExpireSession

func (q *Queries) ExpireSession(ctx context.Context, id int64) error

func (*Queries) GetSession

func (q *Queries) GetSession(ctx context.Context, id int64) (Session, error)

func (*Queries) GetToken

func (q *Queries) GetToken(ctx context.Context, id int64) (sql.NullString, error)

func (*Queries) GetUser

func (q *Queries) GetUser(ctx context.Context, id int64) (User, error)

func (*Queries) GetUserBySession

func (q *Queries) GetUserBySession(ctx context.Context, id int64) (User, error)

func (*Queries) InsertSession

func (q *Queries) InsertSession(ctx context.Context, arg InsertSessionParams) (Session, error)

func (*Queries) InsertUser

func (q *Queries) InsertUser(ctx context.Context, arg InsertUserParams) (User, error)

func (*Queries) UpdateContactGroupsJSON

func (q *Queries) UpdateContactGroupsJSON(ctx context.Context, arg UpdateContactGroupsJSONParams) error

func (*Queries) UpdateGoogleForceApproval

func (q *Queries) UpdateGoogleForceApproval(ctx context.Context, arg UpdateGoogleForceApprovalParams) error

func (*Queries) UpdateSelectedResourceName

func (q *Queries) UpdateSelectedResourceName(ctx context.Context, arg UpdateSelectedResourceNameParams) error

func (*Queries) UpdateTokenBySession

func (q *Queries) UpdateTokenBySession(ctx context.Context, arg UpdateTokenBySessionParams) error

func (*Queries) UpsertSession

func (q *Queries) UpsertSession(ctx context.Context, arg UpsertSessionParams) (Session, error)

func (*Queries) UpsertUser

func (q *Queries) UpsertUser(ctx context.Context, arg UpsertUserParams) (User, error)

func (*Queries) WithTx

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

type Session

type Session struct {
	ID                   int64
	UserID               int64
	CreatedAt            int64
	IsLoggedIn           bool
	GoogleForceApproval  bool
	ContactGroupsJson    sql.NullString
	SelectedResourceName sql.NullString
}

type UpdateContactGroupsJSONParams

type UpdateContactGroupsJSONParams struct {
	ContactGroupsJson sql.NullString
	ID                int64
}

type UpdateGoogleForceApprovalParams

type UpdateGoogleForceApprovalParams struct {
	GoogleForceApproval bool
	ID                  int64
}

type UpdateSelectedResourceNameParams

type UpdateSelectedResourceNameParams struct {
	SelectedResourceName sql.NullString
	ID                   int64
}

type UpdateTokenBySessionParams

type UpdateTokenBySessionParams struct {
	Token sql.NullString
	ID    int64
}

type UpsertSessionParams

type UpsertSessionParams struct {
	ID     int64
	UserID int64
}

type UpsertUserParams

type UpsertUserParams struct {
	Sub     string
	Name    sql.NullString
	Picture sql.NullString
}

type User

type User struct {
	ID      int64
	Sub     string
	Name    sql.NullString
	Picture sql.NullString
	Token   sql.NullString
}

Jump to

Keyboard shortcuts

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