db

package

v0.0.5 Latest Latest Go to latest Published: Sep 7, 2026 License: MIT Imports: 10 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/guntisdev/entlite

Links

Open Source Insights

Documentation ¶

Index ¶

func IntConvert[From, To ...](src From) To
func IntPtrConvert[From, To ~int | ~int32 | ~int64 | ~float32 | ~float64](src *From) *To
func NullBoolToPtr(n sql.NullBool) *bool
func NullBytesToPtr(b []byte) *[]byte
func NullFloat64ToPtr(n sql.NullFloat64) *float64
func NullInt32ToPtr(n sql.NullInt32) *int32
func NullInt64ToPtr(n sql.NullInt64) *int64
func NullStringToPtr(n sql.NullString) *string
func NullTimeToProto(n sql.NullTime) *timestamppb.Timestamp
func OptionalWithFallback[T any](val *T, fallback T) T
func ProtoToNullTime(t *timestamppb.Timestamp) sql.NullTime
func ProtoToTime(t *timestamppb.Timestamp) time.Time
func PtrBytesToNullString(p *[]byte) sql.NullString
func PtrToNullBool(p *bool) sql.NullBool
func PtrToNullBytes(b *[]byte) []byte
func PtrToNullFloat64(p *float64) sql.NullFloat64
func PtrToNullInt32(p *int32) sql.NullInt32
func PtrToNullInt64(p *int64) sql.NullInt64
func PtrToNullString(p *string) sql.NullString
func SQLiteBoolPtrToInt64Ptr(b *bool) *int64
func SQLiteBoolToInt(b bool) int64
func SQLiteInt64PtrToBoolPtr(i *int64) *bool
func SQLiteIntToBool(i int64) bool
func TimeToProto(t time.Time) *timestamppb.Timestamp
type CreateBulkUserParams
type CreateUserParams
type DBTX
type ListActiveParams
type ListUserFilterByAgeNameParams
type ListUserFilterByAgeNameRow
type Queries
- func New(db DBTX) *Queries
- func (q *Queries) CreateBulkUser(ctx context.Context, args []CreateBulkUserParams) ([]int32, error)
- func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (int32, error)
- func (q *Queries) DeleteAllUser(ctx context.Context) error
- func (q *Queries) DeleteUser(ctx context.Context, id int32) error
- func (q *Queries) GetUserByEmail(ctx context.Context, email string) (*User, error)
- func (q *Queries) GetUserByID(ctx context.Context, id int32) (*User, error)
- func (q *Queries) ListActive(ctx context.Context, arg ListActiveParams) ([]*User, error)
- func (q *Queries) ListAllUser(ctx context.Context) ([]*User, error)
- func (q *Queries) ListUserFilterByAgeName(ctx context.Context, arg ListUserFilterByAgeNameParams) ([]*User, int64, error)
- func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (*User, error)
- func (q *Queries) WithTx(tx *sql.Tx) *Queries
type UpdateUserParams
type User
- func UserFromSQL(db *internal.User) *User
- func (m *User) ToProto() *pb.User
- func (m *User) UserToSQL() *internal.User

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 CreateBulkUserParams ¶

type CreateBulkUserParams struct {
	Email       string   `json:"email"`
	Name        string   `json:"name"`
	Age         *int32   `json:"age"`
	Password    string   `json:"password"`
	ApiKey      *[]byte  `json:"api_key"`
	IsActive    *bool    `json:"is_active"`
	LoginCount  *int64   `json:"login_count"`
	Rating      *float64 `json:"rating"`
	Preferences *string  `json:"preferences"`
}

type CreateUserParams ¶

type CreateUserParams struct {
	Email       string   `json:"email"`
	Name        string   `json:"name"`
	Age         *int32   `json:"age"`
	Password    string   `json:"password"`
	ApiKey      *[]byte  `json:"api_key"`
	IsActive    *bool    `json:"is_active"`
	LoginCount  *int64   `json:"login_count"`
	Rating      *float64 `json:"rating"`
	Preferences *string  `json:"preferences"`
}

type DBTX ¶

type DBTX = internal.DBTX

type ListActiveParams ¶ added in v0.0.4

type ListActiveParams struct {
	IsActive bool  `json:"is_active"`
	Offset   int32 `json:"offset"`
	Limit    int32 `json:"limit"`
}

type ListUserFilterByAgeNameParams ¶

type ListUserFilterByAgeNameParams struct {
	MinAge *int32 `json:"min_age"`
	MaxAge *int32 `json:"max_age"`
	Name   string `json:"name"`
	Offset int32  `json:"offset"`
	Limit  int32  `json:"limit"`
}

type ListUserFilterByAgeNameRow ¶ added in v0.0.5

type ListUserFilterByAgeNameRow = internal.ListUserFilterByAgeNameRow

type Queries ¶

type Queries internal.Queries

func New ¶

func New(db DBTX) *Queries

func (*Queries) CreateBulkUser ¶

func (q *Queries) CreateBulkUser(ctx context.Context, args []CreateBulkUserParams) ([]int32, error)

func (*Queries) CreateUser ¶

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

func (*Queries) DeleteAllUser ¶

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

func (*Queries) DeleteUser ¶

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

func (*Queries) GetUserByEmail ¶

func (q *Queries) GetUserByEmail(ctx context.Context, email string) (*User, error)

func (*Queries) GetUserByID ¶

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

func (*Queries) ListActive ¶

func (q *Queries) ListActive(ctx context.Context, arg ListActiveParams) ([]*User, error)

func (*Queries) ListAllUser ¶

func (q *Queries) ListAllUser(ctx context.Context) ([]*User, error)

func (*Queries) ListUserFilterByAgeName ¶

func (q *Queries) ListUserFilterByAgeName(ctx context.Context, arg ListUserFilterByAgeNameParams) ([]*User, int64, error)

func (*Queries) UpdateUser ¶

func (q *Queries) UpdateUser(ctx context.Context, arg UpdateUserParams) (*User, error)

func (*Queries) WithTx ¶

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

type UpdateUserParams ¶

type UpdateUserParams struct {
	Email       string   `json:"email"`
	Name        string   `json:"name"`
	Age         *int32   `json:"age"`
	Password    *string  `json:"password"`
	IsActive    *bool    `json:"is_active"`
	LoginCount  *int64   `json:"login_count"`
	Rating      *float64 `json:"rating"`
	Preferences *string  `json:"preferences"`
	ID          int32    `json:"ID"`
}

type User ¶

type User struct {
	ID          int32     `json:"ID"`
	Email       string    `json:"email"`
	Name        string    `json:"name"`
	Age         *int32    `json:"age"`
	Password    string    `json:"password"`
	ApiKey      []byte    `json:"api_key"`
	IsActive    bool      `json:"is_active"`
	LoginCount  int64     `json:"login_count"`
	Rating      float64   `json:"rating"`
	Preferences string    `json:"preferences"`
	CreatedAt   time.Time `json:"created_at"`
	UpdatedAt   time.Time `json:"updated_at"`
}

func UserFromSQL ¶

func UserFromSQL(db *internal.User) *User

func (*User) ToProto ¶

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

ToProto converts User to proto format

func (*User) UserToSQL ¶

func (m *User) UserToSQL() *internal.User

Source Files ¶

View all Source files

Directories ¶

Path	Synopsis
internal

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