database

Documentation

Index

• type Author
• type Component
• type CreateAuthorParams
• type CreateProjectParams
• type CreateStateParams
• type DBTX
• type DeleteAuthorParams
• type DeleteProjectRow
• type Project
• type Querier
• type Queries
  • func New(db DBTX) *Queries
  • func (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)
  • func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (Project, error)
  • func (q *Queries) CreateState(ctx context.Context, arg CreateStateParams) (State, error)
  • func (q *Queries) DeleteAuthor(ctx context.Context, arg DeleteAuthorParams) (string, error)
  • func (q *Queries) DeleteProject(ctx context.Context, id uuid.UUID) (DeleteProjectRow, error)
  • func (q *Queries) GetAuthorID(ctx context.Context, username string) (uuid.UUID, error)
  • func (q *Queries) GetAuthors(ctx context.Context) ([]Author, error)
  • func (q *Queries) GetProjects(ctx context.Context) ([]Project, error)
  • func (q *Queries) GetProjectsByAuthor(ctx context.Context, author uuid.UUID) ([]Project, error)
  • func (q *Queries) GetStatesByProject(ctx context.Context, project uuid.UUID) ([]State, error)
  • func (q *Queries) WithTx(tx *sql.Tx) *Queries
• type State

Types

type Author

type Author struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Username  string    `json:"username"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
	Password  string    `json:"password"`
}

type Component

type Component struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Project   uuid.UUID `json:"project"`
	State     uuid.UUID `json:"state"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type CreateAuthorParams

type CreateAuthorParams struct {
	ID       uuid.UUID `json:"id"`
	Name     string    `json:"name"`
	Username string    `json:"username"`
	Password string    `json:"password"`
}

type CreateProjectParams

type CreateProjectParams struct {
	ID          uuid.UUID      `json:"id"`
	Name        string         `json:"name"`
	Author      uuid.UUID      `json:"author"`
	Description sql.NullString `json:"description"`
}

type CreateStateParams

type CreateStateParams struct {
	ID      uuid.UUID `json:"id"`
	Name    string    `json:"name"`
	Project uuid.UUID `json:"project"`
}

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 DeleteAuthorParams

type DeleteAuthorParams struct {
	Username string `json:"username"`
	Password string `json:"password"`
}

type DeleteProjectRow

type DeleteProjectRow struct {
	Name   string    `json:"name"`
	Author uuid.UUID `json:"author"`
}

type Project

type Project struct {
	ID          uuid.UUID      `json:"id"`
	Name        string         `json:"name"`
	Author      uuid.UUID      `json:"author"`
	Description sql.NullString `json:"description"`
	CreatedAt   time.Time      `json:"created_at"`
	UpdatedAt   time.Time      `json:"updated_at"`
}

type Querier

type Querier interface {
	CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)
	CreateProject(ctx context.Context, arg CreateProjectParams) (Project, error)
	CreateState(ctx context.Context, arg CreateStateParams) (State, error)
	DeleteAuthor(ctx context.Context, arg DeleteAuthorParams) (string, error)
	DeleteProject(ctx context.Context, id uuid.UUID) (DeleteProjectRow, error)
	GetAuthorID(ctx context.Context, username string) (uuid.UUID, error)
	GetAuthors(ctx context.Context) ([]Author, error)
	GetProjects(ctx context.Context) ([]Project, error)
	GetProjectsByAuthor(ctx context.Context, author uuid.UUID) ([]Project, error)
	GetStatesByProject(ctx context.Context, project uuid.UUID) ([]State, error)
}

type Queries

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

func New

func New(db DBTX) *Queries

func (*Queries) CreateAuthor

func (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error)

func (*Queries) CreateProject

func (q *Queries) CreateProject(ctx context.Context, arg CreateProjectParams) (Project, error)

func (*Queries) CreateState

func (q *Queries) CreateState(ctx context.Context, arg CreateStateParams) (State, error)

func (*Queries) DeleteAuthor

func (q *Queries) DeleteAuthor(ctx context.Context, arg DeleteAuthorParams) (string, error)

func (*Queries) DeleteProject

func (q *Queries) DeleteProject(ctx context.Context, id uuid.UUID) (DeleteProjectRow, error)

func (*Queries) GetAuthorID

func (q *Queries) GetAuthorID(ctx context.Context, username string) (uuid.UUID, error)

func (*Queries) GetAuthors

func (q *Queries) GetAuthors(ctx context.Context) ([]Author, error)

func (*Queries) GetProjects

func (q *Queries) GetProjects(ctx context.Context) ([]Project, error)

func (*Queries) GetProjectsByAuthor

func (q *Queries) GetProjectsByAuthor(ctx context.Context, author uuid.UUID) ([]Project, error)

func (*Queries) GetStatesByProject

func (q *Queries) GetStatesByProject(ctx context.Context, project uuid.UUID) ([]State, error)

func (*Queries) WithTx

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

type State

type State struct {
	ID        uuid.UUID `json:"id"`
	Name      string    `json:"name"`
	Project   uuid.UUID `json:"project"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}