sqlc

package
v0.0.0-...-4ee422c Latest Latest
Warning

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

 Go to latest Published: Jan 31, 2025 License: Apache-2.0 Imports: 5 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type ActivateOnlyVersionParams 

type ActivateOnlyVersionParams struct {
	Filename string `db:"filename"`
	Version  int    `db:"version"`
}

type AssignUserToClassParams 

type AssignUserToClassParams struct {
	ClassUuid uuid.UUID `db:"class_uuid"`
	ID        string    `db:"id"`
}

type CountAllSessionsForUserParams 

type CountAllSessionsForUserParams struct {
	QuizActive bool   `db:"quiz_active"`
	UserID     string `db:"user_id"`
}

type CreateOrReplaceAnswerParams 

type CreateOrReplaceAnswerParams struct {
	Sha1    string `db:"sha1"`
	Content string `db:"content"`
	Valid   bool   `db:"valid"`
}

type CreateOrReplaceClassParams 

type CreateOrReplaceClassParams struct {
	Uuid uuid.UUID `db:"uuid"`
	Name string    `db:"name"`
}

type CreateOrReplaceQuestionParams 

type CreateOrReplaceQuestionParams struct {
	Sha1         string         `db:"sha1"`
	Position     int64          `db:"position"`
	Content      string         `db:"content"`
	Code         sql.NullString `db:"code"`
	CodeLanguage sql.NullString `db:"code_language"`
}

type CreateOrReplaceQuizParams 

type CreateOrReplaceQuizParams struct {
	Sha1      string `db:"sha1"`
	Name      string `db:"name"`
	Filename  string `db:"filename"`
	Version   int    `db:"version"`
	Duration  int    `db:"duration"`
	CreatedAt string `db:"created_at"`
}

type CreateOrReplaceSessionAnswerParams 

type CreateOrReplaceSessionAnswerParams struct {
	SessionUuid  uuid.UUID `db:"session_uuid"`
	QuestionSha1 string    `db:"question_sha1"`
	AnswerSha1   string    `db:"answer_sha1"`
	Checked      bool      `db:"checked"`
}

type CreateOrReplaceSessionParams 

type CreateOrReplaceSessionParams struct {
	Uuid     uuid.UUID `db:"uuid"`
	QuizSha1 string    `db:"quiz_sha1"`
	UserID   string    `db:"user_id"`
}

type CreateOrReplaceUserParams 

type CreateOrReplaceUserParams struct {
	ID      string `db:"id"`
	Login   string `db:"login"`
	Name    string `db:"name"`
	Picture string `db:"picture"`
	RoleID  int8   `db:"role_id"`
}

type CreateQuizClassVisibilityParams 

type CreateQuizClassVisibilityParams struct {
	ClassUuid uuid.UUID `db:"class_uuid"`
	QuizSha1  string    `db:"quiz_sha1"`
}

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 DeleteQuizClassVisibilityParams 

type DeleteQuizClassVisibilityParams struct {
	ClassUuid uuid.UUID `db:"class_uuid"`
	QuizSha1  string    `db:"quiz_sha1"`
}

type FindAllActiveQuizParams 

type FindAllActiveQuizParams struct {
	Limit  int64 `db:"limit"`
	Offset int64 `db:"offset"`
}

type FindAllClassesParams 

type FindAllClassesParams struct {
	Limit  int64 `db:"limit"`
	Offset int64 `db:"offset"`
}

type FindAllQuizSessionsParams 

type FindAllQuizSessionsParams struct {
	Limit   int64  `db:"limit"`
	Offset  int64  `db:"offset"`
	ClassId string `db:"classId"`
	UserId  string `db:"userId"`
}

type FindAllSessionsAnswerForSessionParams 

type FindAllSessionsAnswerForSessionParams struct {
	SessionUuid uuid.UUID `db:"session_uuid"`
	UserID      string    `db:"user_id"`
}

type FindAllSessionsAnswerForSessionRow 

type FindAllSessionsAnswerForSessionRow struct {
	QuizSha1     string      `db:"quiz_sha1"`
	QuestionSha1 string      `db:"question_sha1"`
	AnswerSha1   string      `db:"answer_sha1"`
	SessionUuid  uuid.UUID   `db:"session_uuid"`
	UserID       string      `db:"user_id"`
	Checked      bool        `db:"checked"`
	Column7      interface{} `db:"column_7"`
}

type FindAllSessionsForUserParams 

type FindAllSessionsForUserParams struct {
	QuizActive bool   `db:"quiz_active"`
	UserID     string `db:"user_id"`
	Limit      int64  `db:"limit"`
	Offset     int64  `db:"offset"`
}

type FindAllSessionsParams 

type FindAllSessionsParams struct {
	QuizActive bool  `db:"quiz_active"`
	Limit      int64 `db:"limit"`
	Offset     int64 `db:"offset"`
}

type FindQuizFullBySha1Params 

type FindQuizFullBySha1Params struct {
	Sha1 string `db:"sha1"`
	ID   string `db:"id"`
}

type FindQuizFullBySha1Row 

type FindQuizFullBySha1Row struct {
	QuizSha1             string         `db:"quiz_sha1"`
	QuizFilename         string         `db:"quiz_filename"`
	QuizName             string         `db:"quiz_name"`
	QuizVersion          int            `db:"quiz_version"`
	QuizCreatedAt        string         `db:"quiz_created_at"`
	QuizDuration         int            `db:"quiz_duration"`
	QuizActive           bool           `db:"quiz_active"`
	QuestionSha1         string         `db:"question_sha1"`
	QuestionContent      string         `db:"question_content"`
	QuestionPosition     int            `db:"question_position"`
	QuestionCode         sql.NullString `db:"question_code"`
	QuestionCodeLanguage sql.NullString `db:"question_code_language"`
	AnswerSha1           string         `db:"answer_sha1"`
	AnswerContent        string         `db:"answer_content"`
	AnswerValid          bool           `db:"answer_valid"`
}

type LinkAnswerParams 

type LinkAnswerParams struct {
	QuestionSha1 string `db:"question_sha1"`
	AnswerSha1   string `db:"answer_sha1"`
}

type LinkQuestionParams 

type LinkQuestionParams struct {
	QuizSha1     string `db:"quiz_sha1"`
	QuestionSha1 string `db:"question_sha1"`
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) ActivateOnlyVersion 

func (q *Queries) ActivateOnlyVersion(ctx context.Context, arg ActivateOnlyVersionParams) error

func (*Queries) AssignUserToClass 

func (q *Queries) AssignUserToClass(ctx context.Context, arg AssignUserToClassParams) error

func (*Queries) ClearClassUsers 

func (q *Queries) ClearClassUsers(ctx context.Context, classUuid uuid.UUID) error

func (*Queries) CountAllActiveQuiz 

func (q *Queries) CountAllActiveQuiz(ctx context.Context) (int64, error)

func (*Queries) CountAllActiveQuizForUser 

func (q *Queries) CountAllActiveQuizForUser(ctx context.Context, id string) (int64, error)

func (*Queries) CountAllClasses 

func (q *Queries) CountAllClasses(ctx context.Context) (int64, error)

func (*Queries) CountAllSessions 

func (q *Queries) CountAllSessions(ctx context.Context, quizActive bool) (int64, error)

func (*Queries) CountAllSessionsForUser 

func (q *Queries) CountAllSessionsForUser(ctx context.Context, arg CountAllSessionsForUserParams) (int64, error)

func (*Queries) CountClassById 

func (q *Queries) CountClassById(ctx context.Context, argUuid uuid.UUID) (int64, error)

func (*Queries) CreateOrReplaceAnswer 

func (q *Queries) CreateOrReplaceAnswer(ctx context.Context, arg CreateOrReplaceAnswerParams) error

func (*Queries) CreateOrReplaceClass 

func (q *Queries) CreateOrReplaceClass(ctx context.Context, arg CreateOrReplaceClassParams) error

func (*Queries) CreateOrReplaceQuestion 

func (q *Queries) CreateOrReplaceQuestion(ctx context.Context, arg CreateOrReplaceQuestionParams) error

func (*Queries) CreateOrReplaceQuiz 

func (q *Queries) CreateOrReplaceQuiz(ctx context.Context, arg CreateOrReplaceQuizParams) error

func (*Queries) CreateOrReplaceSession 

func (q *Queries) CreateOrReplaceSession(ctx context.Context, arg CreateOrReplaceSessionParams) error

func (*Queries) CreateOrReplaceSessionAnswer 

func (q *Queries) CreateOrReplaceSessionAnswer(ctx context.Context, arg CreateOrReplaceSessionAnswerParams) error

func (*Queries) CreateOrReplaceUser 

func (q *Queries) CreateOrReplaceUser(ctx context.Context, arg CreateOrReplaceUserParams) error

func (*Queries) CreateQuizClassVisibility 

func (q *Queries) CreateQuizClassVisibility(ctx context.Context, arg CreateQuizClassVisibilityParams) error

func (*Queries) DeleteClassById 

func (q *Queries) DeleteClassById(ctx context.Context, argUuid uuid.UUID) error

func (*Queries) DeleteQuizClassVisibility 

func (q *Queries) DeleteQuizClassVisibility(ctx context.Context, arg DeleteQuizClassVisibilityParams) error

func (*Queries) FindActiveUserById 

func (q *Queries) FindActiveUserById(ctx context.Context, id string) (UserClassView, error)

func (*Queries) FindAllActiveQuiz 

func (q *Queries) FindAllActiveQuiz(ctx context.Context, arg FindAllActiveQuizParams) ([]QuizClassView, error)

func (*Queries) FindAllClasses 

func (q *Queries) FindAllClasses(ctx context.Context, arg FindAllClassesParams) ([]StudentClass, error)

func (*Queries) FindAllQuizSessions 

func (q *Queries) FindAllQuizSessions(ctx context.Context, arg FindAllQuizSessionsParams) ([]QuizSessionView, error)

func (*Queries) FindAllQuizSessionsForUser 

func (q *Queries) FindAllQuizSessionsForUser(ctx context.Context, arg FindAllQuizSessionsParams) ([]QuizSessionView, error)

func (*Queries) FindAllSessions 

func (q *Queries) FindAllSessions(ctx context.Context, arg FindAllSessionsParams) ([]SessionView, error)

func (*Queries) FindAllSessionsAnswerForSession 

func (q *Queries) FindAllSessionsAnswerForSession(ctx context.Context, arg FindAllSessionsAnswerForSessionParams) ([]FindAllSessionsAnswerForSessionRow, error)

func (*Queries) FindAllSessionsForUser 

func (q *Queries) FindAllSessionsForUser(ctx context.Context, arg FindAllSessionsForUserParams) ([]SessionView, error)

func (*Queries) FindAllUser 

func (q *Queries) FindAllUser(ctx context.Context) ([]UserClassView, error)

func (*Queries) FindQuizByFilenameAndLatestVersion 

func (q *Queries) FindQuizByFilenameAndLatestVersion(ctx context.Context, filename string) (Quiz, error)

func (*Queries) FindQuizFullBySha1 

func (q *Queries) FindQuizFullBySha1(ctx context.Context, arg FindQuizFullBySha1Params) ([]FindQuizFullBySha1Row, error)

func (*Queries) FindQuizSessionByUuid 

func (q *Queries) FindQuizSessionByUuid(ctx context.Context, sessionUuid uuid.UUID) ([]QuizSessionDetailView, error)

func (*Queries) FindUserById 

func (q *Queries) FindUserById(ctx context.Context, id string) (UserClassView, error)

func (*Queries) LinkAnswer 

func (q *Queries) LinkAnswer(ctx context.Context, arg LinkAnswerParams) error

func (*Queries) LinkQuestion 

func (q *Queries) LinkQuestion(ctx context.Context, arg LinkQuestionParams) error

func (*Queries) Ping 

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

func (*Queries) UpdateUserActive 

func (q *Queries) UpdateUserActive(ctx context.Context, arg UpdateUserActiveParams) error

func (*Queries) UpdateUserClass 

func (q *Queries) UpdateUserClass(ctx context.Context, arg UpdateUserClassParams) error

func (*Queries) UpdateUserInfo 

func (q *Queries) UpdateUserInfo(ctx context.Context, arg UpdateUserInfoParams) error

func (*Queries) UpdateUserRole 

func (q *Queries) UpdateUserRole(ctx context.Context, arg UpdateUserRoleParams) error

func (*Queries) WithTx 

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

type Quiz 

type Quiz struct {
	Sha1      string `db:"sha1"`
	Name      string `db:"name"`
	Filename  string `db:"filename"`
	Version   int    `db:"version"`
	Active    bool   `db:"active"`
	CreatedAt string `db:"created_at"`
	Duration  int    `db:"duration"`
}

type QuizAnswer 

type QuizAnswer struct {
	Sha1    string `db:"sha1"`
	Valid   bool   `db:"valid"`
	Content string `db:"content"`
}

type QuizAnswerCountView 

type QuizAnswerCountView struct {
	QuizSha1       string `db:"quiz_sha1"`
	CheckedAnswers int    `db:"checked_answers"`
}

type QuizClassView 

type QuizClassView struct {
	Sha1      string    `db:"sha1"`
	Name      string    `db:"name"`
	Filename  string    `db:"filename"`
	Version   int       `db:"version"`
	Active    bool      `db:"active"`
	CreatedAt string    `db:"created_at"`
	Duration  int       `db:"duration"`
	ClassUuid uuid.UUID `db:"class_uuid"`
	ClassName string    `db:"class_name"`
}

type QuizClassVisibility 

type QuizClassVisibility struct {
	ClassUuid uuid.UUID `db:"class_uuid"`
	QuizSha1  string    `db:"quiz_sha1"`
}

type QuizQuestion 

type QuizQuestion struct {
	Sha1         string         `db:"sha1"`
	Position     int64          `db:"position"`
	Content      string         `db:"content"`
	Code         sql.NullString `db:"code"`
	CodeLanguage sql.NullString `db:"code_language"`
}

type QuizQuestionAnswer 

type QuizQuestionAnswer struct {
	QuestionSha1 string `db:"question_sha1"`
	AnswerSha1   string `db:"answer_sha1"`
}

type QuizQuestionQuiz 

type QuizQuestionQuiz struct {
	QuizSha1     string `db:"quiz_sha1"`
	QuestionSha1 string `db:"question_sha1"`
}

type QuizSessionDetailView 

type QuizSessionDetailView struct {
	SessionUuid          uuid.UUID      `db:"session_uuid"`
	UserID               string         `db:"user_id"`
	RemainingSec         int            `db:"remaining_sec"`
	QuizSha1             string         `db:"quiz_sha1"`
	QuizName             string         `db:"quiz_name"`
	QuizDuration         int            `db:"quiz_duration"`
	CheckedAnswers       int            `db:"checked_answers"`
	Results              int            `db:"results"`
	QuestionSha1         string         `db:"question_sha1"`
	QuestionPosition     int            `db:"question_position"`
	QuestionContent      string         `db:"question_content"`
	QuestionCode         sql.NullString `db:"question_code"`
	QuestionCodeLanguage sql.NullString `db:"question_code_language"`
	AnswerSha1           string         `db:"answer_sha1"`
	AnswerContent        string         `db:"answer_content"`
	AnswerChecked        bool           `db:"answer_checked"`
	AnswerValid          bool           `db:"answer_valid"`
}

type QuizSessionView 

type QuizSessionView struct {
	QuizSha1       string    `db:"quiz_sha1"`
	QuizName       string    `db:"quiz_name"`
	QuizFilename   string    `db:"quiz_filename"`
	QuizVersion    int       `db:"quiz_version"`
	QuizDuration   int       `db:"quiz_duration"`
	QuizCreatedAt  string    `db:"quiz_created_at"`
	SessionUuid    uuid.UUID `db:"session_uuid"`
	UserID         string    `db:"user_id"`
	UserName       string    `db:"user_name"`
	UserPicture    string    `db:"user_picture"`
	ClassUuid      uuid.UUID `db:"class_uuid"`
	ClassName      string    `db:"class_name"`
	RemainingSec   int       `db:"remaining_sec"`
	CheckedAnswers int       `db:"checked_answers"`
	Results        int       `db:"results"`
}

type Role 

type Role struct {
	ID   int8   `db:"id"`
	Name string `db:"name"`
}

type Session 

type Session struct {
	Uuid      uuid.UUID `db:"uuid"`
	QuizSha1  string    `db:"quiz_sha1"`
	UserID    string    `db:"user_id"`
	CreatedAt time.Time `db:"created_at"`
}

type SessionAnswer 

type SessionAnswer struct {
	SessionUuid  uuid.UUID `db:"session_uuid"`
	QuestionSha1 string    `db:"question_sha1"`
	AnswerSha1   string    `db:"answer_sha1"`
	Checked      bool      `db:"checked"`
}

type SessionResponseView 

type SessionResponseView struct {
	QuizSha1     string      `db:"quiz_sha1"`
	QuestionSha1 string      `db:"question_sha1"`
	AnswerSha1   string      `db:"answer_sha1"`
	SessionUuid  uuid.UUID   `db:"session_uuid"`
	UserID       string      `db:"user_id"`
	Checked      bool        `db:"checked"`
	Result       interface{} `db:"result"`
}

type SessionView 

type SessionView struct {
	Uuid           uuid.UUID `db:"uuid"`
	QuizSha1       string    `db:"quiz_sha1"`
	QuizName       string    `db:"quiz_name"`
	QuizActive     bool      `db:"quiz_active"`
	UserID         string    `db:"user_id"`
	UserName       string    `db:"user_name"`
	UserPicture    string    `db:"user_picture"`
	RemainingSec   int       `db:"remaining_sec"`
	CheckedAnswers int       `db:"checked_answers"`
	Results        int       `db:"results"`
}

type StudentClass 

type StudentClass struct {
	Uuid uuid.UUID `db:"uuid"`
	Name string    `db:"name"`
}

type UpdateUserActiveParams 

type UpdateUserActiveParams struct {
	Active bool   `db:"active"`
	ID     string `db:"id"`
}

type UpdateUserClassParams 

type UpdateUserClassParams struct {
	ClassUuid uuid.UUID `db:"class_uuid"`
	ID        string    `db:"id"`
}

type UpdateUserInfoParams 

type UpdateUserInfoParams struct {
	Login   string `db:"login"`
	Name    string `db:"name"`
	Picture string `db:"picture"`
	ID      string `db:"id"`
}

type UpdateUserRoleParams 

type UpdateUserRoleParams struct {
	RoleID int8   `db:"role_id"`
	ID     string `db:"id"`
}

type User 

type User struct {
	ID        string    `db:"id"`
	Login     string    `db:"login"`
	Name      string    `db:"name"`
	Picture   string    `db:"picture"`
	Active    bool      `db:"active"`
	RoleID    int8      `db:"role_id"`
	ClassUuid uuid.UUID `db:"class_uuid"`
}

type UserClassView 

type UserClassView struct {
	ID        string    `db:"id"`
	Login     string    `db:"login"`
	Name      string    `db:"name"`
	Picture   string    `db:"picture"`
	Active    bool      `db:"active"`
	RoleID    int8      `db:"role_id"`
	ClassUuid uuid.UUID `db:"class_uuid"`
	ClassName string    `db:"class_name"`
}

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.