database

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Database interface {
	AcquireFunc(context.Context, func(*pgxpool.Conn) error) error
	BeginTx(context.Context, pgx.TxOptions) (pgx.Tx, error)
	Begin(context.Context) (pgx.Tx, error)
	Ping(context.Context) error
}

type GetNoteAccessRow struct {
	UserID uuid.UUID
	Access NotesAccessLevel
}

type GetNoteRow struct {
	NoteID    uuid.UUID
	CreatedAt pgtype.Timestamptz
	CreatedBy uuid.NullUUID
	UpdatedAt pgtype.Timestamptz
	UpdatedBy uuid.NullUUID
	Title     string
	Body      string
}

type GetNoteTagsParams struct {
	UserID uuid.UUID
	NoteID uuid.UUID
}

type GetTagAccessRow struct {
	UserID uuid.UUID
	Access NotesAccessLevel
}

type GetUserNoteAccessParams struct {
	NoteID uuid.UUID
	UserID uuid.UUID
}

type GetUserTagAccessParams struct {
	TagID  uuid.UUID
	UserID uuid.UUID
}

type ListNotesParams struct {
	UserID     uuid.UUID
	LastNoteID uuid.NullUUID
	PageSize   int64
}

type ListNotesRow struct {
	NoteID uuid.UUID
	Title  string
}

type ListTagsParams struct {
	UserID       uuid.UUID
	LastTagID    uuid.NullUUID
	SearchString string
	PageSize     int64
}

type ListTagsRow struct {
	TagID  uuid.UUID
	Name   string
	Access NotesAccessLevel
}

type NotesAccessLevel string

type NotesTag struct {
	TagID uuid.UUID
	Name  string
}

type NotesUser struct {
	UserID     uuid.UUID
	Name       string
	CreatedAt  pgtype.Timestamptz
	LastSignIn pgtype.Timestamptz
	Active     bool
}

type NullNotesAccessLevel struct {
	NotesAccessLevel NotesAccessLevel
	Valid            bool // Valid is true if NotesAccessLevel is not NULL
}

type Queries struct {
}

type SaveNoteParams struct {
	NoteID    uuid.UUID
	CreatedAt pgtype.Timestamptz
	CreatedBy uuid.NullUUID
	UpdatedAt pgtype.Timestamptz
	UpdatedBy uuid.NullUUID
	Title     string
	Body      string
}

type SaveTagParams struct {
	TagID uuid.UUID
	Name  string
}

type SaveUserParams struct {
	UserID     uuid.UUID
	Name       string
	CreatedAt  pgtype.Timestamptz
	LastSignIn pgtype.Timestamptz
	Active     bool
}

type SearchNotesWithTagParams struct {
	UserID     uuid.UUID
	TagID      uuid.UUID
	LastNoteID uuid.NullUUID
	PageSize   int64
}

type SearchNotesWithTagRow struct {
	NoteID uuid.UUID
	Title  string
}

type SearchNotesWithTextAndTagParams struct {
	TextSearch string
	UserID     uuid.UUID
	TagID      uuid.UUID
	LastRank   pgtype.Float4
	PageSize   int64
}

type SearchNotesWithTextAndTagRow struct {
	NoteID uuid.UUID
	Title  string
	Rank   float32
	Match  pgtype.Text
}

type SearchNotesWithTextParams struct {
	TextSearch string
	UserID     uuid.UUID
	LastRank   pgtype.Float4
	PageSize   int64
}

type SearchNotesWithTextRow struct {
	NoteID uuid.UUID
	Title  string
	Rank   float32
	Match  pgtype.Text
}

type SetNoteAccessParams struct {
	Column1 uuid.NullUUID
	Column2 NullNotesAccessLevel
	Column3 uuid.NullUUID
}

type SetNoteTagsParams struct {
	Column1 uuid.NullUUID
	Column2 uuid.NullUUID
}

type SetTagAccessParams struct {
	Column1 uuid.NullUUID
	Column2 NullNotesAccessLevel
	Column3 uuid.NullUUID
}