database

package
v0.0.0-...-5f3fc13 Latest Latest
Warning

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

 Go to latest Published: Aug 13, 2022 License: MIT Imports: 14 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func NewMigrateInstance 

func NewMigrateInstance(config *config.Config) (*migrate.Migrate, error)

func NullStringToPtr 

func NullStringToPtr(value sql.NullString) *string

func NullTimeToTimestamppb 

func NullTimeToTimestamppb(value sql.NullTime) *timestamppb.Timestamp

func PtrToNullString 

func PtrToNullString(value *string) sql.NullString

Types

type AddUserToOutingParams 

type AddUserToOutingParams struct {
	OutingID int32
	UserID   int32
}

type CreateOutingParams 

type CreateOutingParams struct {
	Title string
	Date  time.Time
	Slug  string
}

type CreatePhotoParams 

type CreatePhotoParams struct {
	Path      string
	Title     sql.NullString
	CreatorID int32
	OutingID  int32
}

type CreateUserParams 

type CreateUserParams struct {
	Username     string
	PasswordHash []byte
	DisplayName  sql.NullString
	AvatarUrl    sql.NullString
}

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 Outing 

type Outing struct {
	ID        int32
	Title     string
	Date      time.Time
	CreatedAt time.Time
	UpdatedAt sql.NullTime
	Slug      string
}

type OutingUser 

type OutingUser struct {
	OutingID int32
	UserID   int32
}

type Photo 

type Photo struct {
	ID        int32
	Path      string
	Title     sql.NullString
	CreatedAt time.Time
	UpdatedAt sql.NullTime
	CreatorID int32
	OutingID  int32
}

type Queries 

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

func Connect 

func Connect(config *config.Config) (*Queries, error)

func New 

func New(db DBTX) *Queries

func (*Queries) AddUserToOuting 

func (q *Queries) AddUserToOuting(ctx context.Context, arg AddUserToOutingParams) error

func (*Queries) CreateOuting 

func (q *Queries) CreateOuting(ctx context.Context, arg CreateOutingParams) (Outing, error)

func (*Queries) CreatePhoto 

func (q *Queries) CreatePhoto(ctx context.Context, arg CreatePhotoParams) (Photo, error)

func (*Queries) CreateUser 

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

func (*Queries) DeletePhoto 

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

func (*Queries) GetOuting 

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

func (*Queries) GetOutingBySlug 

func (q *Queries) GetOutingBySlug(ctx context.Context, slug string) (Outing, error)

func (*Queries) GetPhoto 

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

func (*Queries) GetUser 

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

func (*Queries) GetUserByUsername 

func (q *Queries) GetUserByUsername(ctx context.Context, username string) (User, error)

func (*Queries) ListOutings 

func (q *Queries) ListOutings(ctx context.Context) ([]Outing, error)

func (*Queries) ListPhotosForOuting 

func (q *Queries) ListPhotosForOuting(ctx context.Context, outingID int32) ([]Photo, error)

func (*Queries) ListUserOutings 

func (q *Queries) ListUserOutings(ctx context.Context, userID int32) ([]Outing, error)

func (*Queries) ListUserPhotos 

func (q *Queries) ListUserPhotos(ctx context.Context, creatorID int32) ([]Photo, error)

func (*Queries) ListUsers 

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

func (*Queries) ListUsersForOuting 

func (q *Queries) ListUsersForOuting(ctx context.Context, outingID int32) ([]User, error)

func (*Queries) RemoveUserFromOuting 

func (q *Queries) RemoveUserFromOuting(ctx context.Context, arg RemoveUserFromOutingParams) error

func (*Queries) UpdateOuting 

func (q *Queries) UpdateOuting(ctx context.Context, arg UpdateOutingParams) (Outing, error)

func (*Queries) UpdatePhoto 

func (q *Queries) UpdatePhoto(ctx context.Context, arg UpdatePhotoParams) (Photo, error)

func (*Queries) UpdateUser 

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

func (*Queries) UserInOuting 

func (q *Queries) UserInOuting(ctx context.Context, arg UserInOutingParams) (bool, error)

func (*Queries) WithTx 

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

type RemoveUserFromOutingParams 

type RemoveUserFromOutingParams struct {
	OutingID int32
	UserID   int32
}

type UpdateOutingParams 

type UpdateOutingParams struct {
	Date  time.Time
	Title string
	ID    int32
}

type UpdatePhotoParams 

type UpdatePhotoParams struct {
	Title sql.NullString
	ID    int32
}

type UpdateUserParams 

type UpdateUserParams struct {
	DisplayName  sql.NullString
	AvatarUrl    sql.NullString
	PasswordHash []byte
	ID           int32
}

type User 

type User struct {
	ID           int32
	Username     string
	PasswordHash []byte
	DisplayName  sql.NullString
	AvatarUrl    sql.NullString
	CreatedAt    time.Time
	UpdatedAt    sql.NullTime
}

type UserInOutingParams 

type UserInOutingParams struct {
	OutingID int32
	UserID   int32
}

Source Files

View all Source files

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.