db

package
v0.0.5 Latest Latest
Warning

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

 Go to latest Published: Sep 7, 2026 License: MIT Imports: 9 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func IntConvert 

func IntConvert[From, To ~int | ~int8 | ~int16 | ~int32 | ~int64 |
	~uint | ~uint8 | ~uint16 | ~uint32 | ~uint64 |
	~float32 | ~float64](src From) To

func IntPtrConvert 

func IntPtrConvert[From, To ~int | ~int32 | ~int64 | ~float32 | ~float64](src *From) *To

example: IntPtrConvert[int64, int32](dbRow.Age)

func NullBoolToPtr 

func NullBoolToPtr(n sql.NullBool) *bool

func NullBytesToPtr 

func NullBytesToPtr(b []byte) *[]byte

--- Bytes Converters ---

func NullFloat64ToPtr 

func NullFloat64ToPtr(n sql.NullFloat64) *float64

func NullInt32ToPtr 

func NullInt32ToPtr(n sql.NullInt32) *int32

--- Nullable SQL Type Converters ---

func NullInt64ToPtr 

func NullInt64ToPtr(n sql.NullInt64) *int64

func NullStringToPtr 

func NullStringToPtr(n sql.NullString) *string

func NullTimeToProto 

func NullTimeToProto(n sql.NullTime) *timestamppb.Timestamp

--- Time Converters ---

func OptionalWithFallback 

func OptionalWithFallback[T any](val *T, fallback T) T

OptionalWithFallback chooses fallback if optional value is nil

func ProtoToNullTime 

func ProtoToNullTime(t *timestamppb.Timestamp) sql.NullTime

func ProtoToTime 

func ProtoToTime(t *timestamppb.Timestamp) time.Time

A nil pointer returns a zero time.Time{}

func PtrBytesToNullString 

func PtrBytesToNullString(p *[]byte) sql.NullString

PtrBytesToNullString converts *[]byte to sql.NullString for MySQL compatibility

func PtrToNullBool 

func PtrToNullBool(p *bool) sql.NullBool

func PtrToNullBytes 

func PtrToNullBytes(b *[]byte) []byte

func PtrToNullFloat64 

func PtrToNullFloat64(p *float64) sql.NullFloat64

func PtrToNullInt32 

func PtrToNullInt32(p *int32) sql.NullInt32

func PtrToNullInt64 

func PtrToNullInt64(p *int64) sql.NullInt64

func PtrToNullString 

func PtrToNullString(p *string) sql.NullString

func SQLiteBoolPtrToInt64Ptr 

func SQLiteBoolPtrToInt64Ptr(b *bool) *int64

SQLiteBoolPtrToInt64Ptr converts *bool to *int64 for nullable columns via sqlc.narg

func SQLiteBoolToInt 

func SQLiteBoolToInt(b bool) int64

func SQLiteInt64PtrToBoolPtr 

func SQLiteInt64PtrToBoolPtr(i *int64) *bool

SQLiteInt64PtrToBoolPtr is the inverse of SQLiteBoolPtrToInt64Ptr.

func SQLiteIntToBool 

func SQLiteIntToBool(i int64) bool

--- SQLite bool converters ---

func TimeToProto 

func TimeToProto(t time.Time) *timestamppb.Timestamp

TimeToProto converts time.Time to timestamppb.Timestamp pointer

Types

type Audit 

type Audit struct {
	ID        int32     `json:"ID"`
	Action    string    `json:"action"`
	MatchID   int32     `json:"match_id"`
	Detail    string    `json:"detail"`
	CreatedAt time.Time `json:"created_at"`
}

func AuditFromSQL 

func AuditFromSQL(db *internal.Audit) *Audit

func (*Audit) AuditToSQL 

func (m *Audit) AuditToSQL() *internal.Audit

type CreateAuditParams 

type CreateAuditParams struct {
	Action    string     `json:"action"`
	MatchID   int32      `json:"match_id"`
	Detail    string     `json:"detail"`
	CreatedAt *time.Time `json:"created_at"`
}

type CreateMatchParams 

type CreateMatchParams struct {
	White    string     `json:"white"`
	Black    string     `json:"black"`
	Result   string     `json:"result"`
	Opening  *string    `json:"opening"`
	Moves    int32      `json:"moves"`
	PlayedAt *time.Time `json:"played_at"`
}

type CreatePlayerParams added in v0.0.3 

type CreatePlayerParams struct {
	Name   string  `json:"name"`
	Rating int32   `json:"rating"`
	Title  *string `json:"title"`
}

type DBTX 

type DBTX = internal.DBTX

type Match 

type Match struct {
	ID        int32     `json:"ID"`
	White     string    `json:"white"`
	Black     string    `json:"black"`
	Result    string    `json:"result"`
	Opening   *string   `json:"opening"`
	Moves     int32     `json:"moves"`
	PlayedAt  time.Time `json:"played_at"`
	CreatedAt time.Time `json:"created_at"`
}

func MatchFromSQL 

func MatchFromSQL(db *internal.Match) *Match

func (*Match) MatchToSQL 

func (m *Match) MatchToSQL() *internal.Match

func (*Match) ToProto 

func (m *Match) ToProto() *pb.Match

ToProto converts Match to proto format

type Player added in v0.0.3 

type Player struct {
	Name     string    `json:"name"`
	Rating   int32     `json:"rating"`
	Title    *string   `json:"title"`
	JoinedAt time.Time `json:"joined_at"`
}

func PlayerFromSQL added in v0.0.3 

func PlayerFromSQL(db *internal.Player) *Player

func (*Player) PlayerToSQL added in v0.0.3 

func (m *Player) PlayerToSQL() *internal.Player

func (*Player) ToProto added in v0.0.3 

func (m *Player) ToProto() *pb.Player

ToProto converts Player to proto format

type Queries 

type Queries internal.Queries

func New 

func New(db DBTX) *Queries

func (*Queries) CreateAudit 

func (q *Queries) CreateAudit(ctx context.Context, arg CreateAuditParams) (int32, error)

func (*Queries) CreateMatch 

func (q *Queries) CreateMatch(ctx context.Context, arg CreateMatchParams) (int32, error)

func (*Queries) CreatePlayer added in v0.0.3 

func (q *Queries) CreatePlayer(ctx context.Context, arg CreatePlayerParams) error

func (*Queries) DeleteAllMatch added in v0.0.3 

func (q *Queries) DeleteAllMatch(ctx context.Context) error

func (*Queries) DeleteMatch 

func (q *Queries) DeleteMatch(ctx context.Context, id int32) error

func (*Queries) GetMatchByID 

func (q *Queries) GetMatchByID(ctx context.Context, id int32) (*Match, error)

func (*Queries) GetPlayerByName added in v0.0.5 

func (q *Queries) GetPlayerByName(ctx context.Context, name string) (*Player, error)

func (*Queries) ListAllAudit 

func (q *Queries) ListAllAudit(ctx context.Context) ([]*Audit, error)

func (*Queries) ListAllMatch 

func (q *Queries) ListAllMatch(ctx context.Context) ([]*Match, error)

func (*Queries) ListAllPlayer added in v0.0.3 

func (q *Queries) ListAllPlayer(ctx context.Context) ([]*Player, error)

func (*Queries) WithTx 

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

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.