sqlc

package
v0.0.0-...-b2c0be8 Latest Latest
Warning

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

Go to latest
Published: Apr 14, 2026 License: GPL-2.0 Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type AtcoderSubmission

type AtcoderSubmission struct {
	ID           int64              `json:"id"`
	UserID       int64              `json:"user_id"`
	SubmissionID int64              `json:"submission_id"`
	ProblemID    string             `json:"problem_id"`
	Point        float64            `json:"point"`
	Status       string             `json:"status"`
	At           pgtype.Timestamptz `json:"at"`
}

type AtcoderUser

type AtcoderUser struct {
	ID                   int64  `json:"id"`
	Username             string `json:"username"`
	AvatarUrl            string `json:"avatar_url"`
	Rank                 string `json:"rank"`
	Rating               int32  `json:"rating"`
	HighestRating        int32  `json:"highest_rating"`
	PromotionMessage     string `json:"promotion_message"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

type CodeforcesSubmission

type CodeforcesSubmission struct {
	ID      int64              `json:"id"`
	UserID  int64              `json:"user_id"`
	Problem []byte             `json:"problem"`
	Status  string             `json:"status"`
	At      pgtype.Timestamptz `json:"at"`
}

type CodeforcesUser

type CodeforcesUser struct {
	ID                   int64  `json:"id"`
	Username             string `json:"username"`
	AvatarUrl            string `json:"avatar_url"`
	FriendNum            int32  `json:"friend_num"`
	RatingRecords        []byte `json:"rating_records"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

type CreateAtcoderSubmissionsRawParams

type CreateAtcoderSubmissionsRawParams struct {
	Column1 []int64              `json:"column_1"`
	Column2 []int64              `json:"column_2"`
	Column3 []string             `json:"column_3"`
	Column4 []float64            `json:"column_4"`
	Column5 []string             `json:"column_5"`
	Column6 []pgtype.Timestamptz `json:"column_6"`
}

type CreateAtcoderUserRawParams

type CreateAtcoderUserRawParams struct {
	Username             string `json:"username"`
	AvatarUrl            string `json:"avatar_url"`
	Rank                 string `json:"rank"`
	Rating               int32  `json:"rating"`
	HighestRating        int32  `json:"highest_rating"`
	PromotionMessage     string `json:"promotion_message"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

type CreateCodeforcesSubmissionsRawParams

type CreateCodeforcesSubmissionsRawParams struct {
	Column1 []int64              `json:"column_1"`
	Column2 [][]byte             `json:"column_2"`
	Column3 []string             `json:"column_3"`
	Column4 []pgtype.Timestamptz `json:"column_4"`
}

type CreateCodeforcesUserRawParams

type CreateCodeforcesUserRawParams struct {
	Username             string `json:"username"`
	AvatarUrl            string `json:"avatar_url"`
	FriendNum            int32  `json:"friend_num"`
	RatingRecords        []byte `json:"rating_records"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

type DBTX

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 GetAtcoderSubmissionsAfterParams

type GetAtcoderSubmissionsAfterParams struct {
	UserID int64              `json:"user_id"`
	At     pgtype.Timestamptz `json:"at"`
}

type GetCodeforcesSubmissionsAfterParams

type GetCodeforcesSubmissionsAfterParams struct {
	UserID int64              `json:"user_id"`
	At     pgtype.Timestamptz `json:"at"`
}

type Querier

type Querier interface {
	CreateAtcoderSubmissionsRaw(ctx context.Context, arg CreateAtcoderSubmissionsRawParams) error
	CreateAtcoderUserRaw(ctx context.Context, arg CreateAtcoderUserRawParams) (AtcoderUser, error)
	CreateCodeforcesSubmissionsRaw(ctx context.Context, arg CreateCodeforcesSubmissionsRawParams) error
	CreateCodeforcesUserRaw(ctx context.Context, arg CreateCodeforcesUserRawParams) (CodeforcesUser, error)
	CreateRaceRaw(ctx context.Context, races []byte) error
	GetAtcoderSubmissionsAfter(ctx context.Context, arg GetAtcoderSubmissionsAfterParams) ([]AtcoderSubmission, error)
	GetAtcoderUserByIDRaw(ctx context.Context, id int64) (AtcoderUser, error)
	GetAtcoderUserByUsernameRaw(ctx context.Context, username string) (AtcoderUser, error)
	GetCodeforcesSubmissionsAfter(ctx context.Context, arg GetCodeforcesSubmissionsAfterParams) ([]CodeforcesSubmission, error)
	GetCodeforcesUserByIDRaw(ctx context.Context, id int64) (CodeforcesUser, error)
	GetCodeforcesUserByUsernameRaw(ctx context.Context, username string) (CodeforcesUser, error)
	GetCodeforcesUserLastSubmission(ctx context.Context, userID int64) (CodeforcesSubmission, error)
	GetLastRaceCreatedAt(ctx context.Context) (pgtype.Timestamptz, error)
	GetLastRaceRaw(ctx context.Context) ([]byte, error)
	UpdateAtcoderSubmissionStatisticsRaw(ctx context.Context, arg UpdateAtcoderSubmissionStatisticsRawParams) error
	UpdateCodeforcesRatingRecordsRaw(ctx context.Context, arg UpdateCodeforcesRatingRecordsRawParams) error
	UpdateCodeforcesSubmissionStatisticsRaw(ctx context.Context, arg UpdateCodeforcesSubmissionStatisticsRawParams) error
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAtcoderSubmissionsRaw

func (q *Queries) CreateAtcoderSubmissionsRaw(ctx context.Context, arg CreateAtcoderSubmissionsRawParams) error

func (*Queries) CreateAtcoderUserRaw

func (q *Queries) CreateAtcoderUserRaw(ctx context.Context, arg CreateAtcoderUserRawParams) (AtcoderUser, error)

func (*Queries) CreateCodeforcesSubmissionsRaw

func (q *Queries) CreateCodeforcesSubmissionsRaw(ctx context.Context, arg CreateCodeforcesSubmissionsRawParams) error

func (*Queries) CreateCodeforcesUserRaw

func (q *Queries) CreateCodeforcesUserRaw(ctx context.Context, arg CreateCodeforcesUserRawParams) (CodeforcesUser, error)

func (*Queries) CreateRaceRaw

func (q *Queries) CreateRaceRaw(ctx context.Context, races []byte) error

func (*Queries) GetAtcoderSubmissionsAfter

func (q *Queries) GetAtcoderSubmissionsAfter(ctx context.Context, arg GetAtcoderSubmissionsAfterParams) ([]AtcoderSubmission, error)

func (*Queries) GetAtcoderUserByIDRaw

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

func (*Queries) GetAtcoderUserByUsernameRaw

func (q *Queries) GetAtcoderUserByUsernameRaw(ctx context.Context, username string) (AtcoderUser, error)

func (*Queries) GetCodeforcesSubmissionsAfter

func (q *Queries) GetCodeforcesSubmissionsAfter(ctx context.Context, arg GetCodeforcesSubmissionsAfterParams) ([]CodeforcesSubmission, error)

func (*Queries) GetCodeforcesUserByIDRaw

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

func (*Queries) GetCodeforcesUserByUsernameRaw

func (q *Queries) GetCodeforcesUserByUsernameRaw(ctx context.Context, username string) (CodeforcesUser, error)

func (*Queries) GetCodeforcesUserLastSubmission

func (q *Queries) GetCodeforcesUserLastSubmission(ctx context.Context, userID int64) (CodeforcesSubmission, error)

func (*Queries) GetLastRaceCreatedAt

func (q *Queries) GetLastRaceCreatedAt(ctx context.Context) (pgtype.Timestamptz, error)

func (*Queries) GetLastRaceRaw

func (q *Queries) GetLastRaceRaw(ctx context.Context) ([]byte, error)

func (*Queries) UpdateAtcoderSubmissionStatisticsRaw

func (q *Queries) UpdateAtcoderSubmissionStatisticsRaw(ctx context.Context, arg UpdateAtcoderSubmissionStatisticsRawParams) error

func (*Queries) UpdateCodeforcesRatingRecordsRaw

func (q *Queries) UpdateCodeforcesRatingRecordsRaw(ctx context.Context, arg UpdateCodeforcesRatingRecordsRawParams) error

func (*Queries) UpdateCodeforcesSubmissionStatisticsRaw

func (q *Queries) UpdateCodeforcesSubmissionStatisticsRaw(ctx context.Context, arg UpdateCodeforcesSubmissionStatisticsRawParams) error

func (*Queries) WithTx

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

type Race

type Race struct {
	ID        int64              `json:"id"`
	Races     []byte             `json:"races"`
	CreatedAt pgtype.Timestamptz `json:"created_at"`
}

type UpdateAtcoderSubmissionStatisticsRawParams

type UpdateAtcoderSubmissionStatisticsRawParams struct {
	ID                   int64  `json:"id"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

type UpdateCodeforcesRatingRecordsRawParams

type UpdateCodeforcesRatingRecordsRawParams struct {
	ID            int64  `json:"id"`
	RatingRecords []byte `json:"rating_records"`
}

type UpdateCodeforcesSubmissionStatisticsRawParams

type UpdateCodeforcesSubmissionStatisticsRawParams struct {
	ID                   int64  `json:"id"`
	SubmissionStatistics []byte `json:"submission_statistics"`
}

Jump to

Keyboard shortcuts

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