db

package
v0.0.0-...-588ec63 Latest Latest
Warning

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

 Go to latest Published: Apr 7, 2024 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

View Source 
const CreateMember = `` /* 179-byte string literal not displayed */
View Source 
const CreateMemberCredentials = `` /* 194-byte string literal not displayed */
View Source 
const CreateProject = `` /* 217-byte string literal not displayed */
View Source 
const CreateProjectMember = `` /* 174-byte string literal not displayed */
View Source 
const CreateTask = `` /* 238-byte string literal not displayed */
View Source 
const CreateTaskGroup = `` /* 253-byte string literal not displayed */
View Source 
const CreateTaskGroupMember = `` /* 182-byte string literal not displayed */
View Source 
const CreateTaskMember = `` /* 165-byte string literal not displayed */
View Source 
const DeleteMemberByID = `-- name: DeleteMemberByID :exec
DELETE FROM member WHERE member_id = $1
`
View Source 
const DeleteMemberCredentialsByID = `-- name: DeleteMemberCredentialsByID :exec
DELETE FROM member_credentials WHERE member_id = $1
`
View Source 
const DeleteProjectByID = `-- name: DeleteProjectByID :exec
DELETE FROM project WHERE project_id = $1
`
View Source 
const DeleteProjectMemberByID = `-- name: DeleteProjectMemberByID :exec
DELETE FROM project_member WHERE member_id = $1 AND project_id = $2
`
View Source 
const DeleteTaskByID = `-- name: DeleteTaskByID :exec
DELETE FROM task WHERE task_id = $1
`
View Source 
const DeleteTaskGroupByID = `-- name: DeleteTaskGroupByID :exec
DELETE FROM task_group WHERE task_group_id = $1
`
View Source 
const DeleteTaskGroupMemberByID = `-- name: DeleteTaskGroupMemberByID :exec
DELETE FROM task_group_member WHERE member_id = $1 AND task_group_id = $2
`
View Source 
const DeleteTaskMemberByID = `-- name: DeleteTaskMemberByID :exec
DELETE FROM task_member WHERE member_id = $1 AND task_id = $2
`
View Source 
const GetAllMemberIDs = `-- name: GetAllMemberIDs :many
SELECT member_id FROM member
`
View Source 
const GetAllMemberProjectIDs = `-- name: GetAllMemberProjectIDs :many
SELECT project_id FROM project_member WHERE member_id = $1
`
View Source 
const GetAllMemberProjects = `` /* 136-byte string literal not displayed */
View Source 
const GetAllMembers = `-- name: GetAllMembers :many
SELECT member_id, email, first_name, last_name, created_at, updated_at FROM member
`
View Source 
const GetAllProjectIDs = `-- name: GetAllProjectIDs :many
SELECT project_id FROM project
`
View Source 
const GetAllProjectMemberIDs = `-- name: GetAllProjectMemberIDs :many
SELECT member_id FROM project_member WHERE project_id = $1
`
View Source 
const GetAllProjectMembers = `` /* 137-byte string literal not displayed */
View Source 
const GetAllProjects = `` /* 142-byte string literal not displayed */
View Source 
const GetAllTaskGroupIDs = `-- name: GetAllTaskGroupIDs :many
SELECT task_group_id FROM task_group WHERE project_id = $1
`
View Source 
const GetAllTaskGroupMemberIDs = `-- name: GetAllTaskGroupMemberIDs :many
SELECT member_id FROM task_group_member WHERE task_group_id = $1
`
View Source 
const GetAllTaskGroupMembers = `` /* 148-byte string literal not displayed */
View Source 
const GetAllTaskGroups = `` /* 192-byte string literal not displayed */
View Source 
const GetAllTaskIDs = `-- name: GetAllTaskIDs :many
SELECT task_id FROM task WHERE task_group_id = $1
`
View Source 
const GetAllTaskMemberIDs = `-- name: GetAllTaskMemberIDs :many
SELECT member_id FROM task_member WHERE task_id = $1
`
View Source 
const GetAllTaskMembers = `-- name: GetAllTaskMembers :many
SELECT member_id, task_id, role, created_at, updated_at FROM task_member WHERE task_id = $1
`
View Source 
const GetAllTasks = `` /* 180-byte string literal not displayed */
View Source 
const GetMemberByID = `` /* 132-byte string literal not displayed */
View Source 
const GetMemberCredentialsByID = `` /* 155-byte string literal not displayed */
View Source 
const GetProjectByID = `` /* 163-byte string literal not displayed */
View Source 
const GetProjectMemberByID = `` /* 155-byte string literal not displayed */
View Source 
const GetTaskByID = `` /* 173-byte string literal not displayed */
View Source 
const GetTaskGroupByID = `` /* 194-byte string literal not displayed */
View Source 
const GetTaskGroupMemberByID = `` /* 166-byte string literal not displayed */
View Source 
const GetTaskMemberByID = `` /* 143-byte string literal not displayed */
View Source 
const UpdateMemberByID = `` /* 147-byte string literal not displayed */
View Source 
const UpdateMemberCredentialsByID = `` /* 165-byte string literal not displayed */
View Source 
const UpdateProjectByID = `` /* 187-byte string literal not displayed */
View Source 
const UpdateProjectMemberByID = `` /* 148-byte string literal not displayed */
View Source 
const UpdateTaskByID = `` /* 190-byte string literal not displayed */
View Source 
const UpdateTaskGroupByID = `` /* 208-byte string literal not displayed */
View Source 
const UpdateTaskGroupMemberByID = `` /* 156-byte string literal not displayed */
View Source 
const UpdateTaskMemberByID = `` /* 139-byte string literal not displayed */

Variables

This section is empty.

Functions

This section is empty.

Types

type CreateMemberCredentialsParams 

type CreateMemberCredentialsParams struct {
	MemberID     int32  `db:"member_id" json:"member_id"`
	PasswordHash string `db:"password_hash" json:"password_hash"`
	PasswordSalt string `db:"password_salt" json:"password_salt"`
}

type CreateMemberParams 

type CreateMemberParams struct {
	Email     string `db:"email" json:"email"`
	FirstName string `db:"first_name" json:"first_name"`
	LastName  string `db:"last_name" json:"last_name"`
}

type CreateProjectMemberParams 

type CreateProjectMemberParams struct {
	MemberID  int32  `db:"member_id" json:"member_id"`
	ProjectID int32  `db:"project_id" json:"project_id"`
	Role      string `db:"role" json:"role"`
}

type CreateProjectParams 

type CreateProjectParams struct {
	ProjectName string      `db:"project_name" json:"project_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

type CreateTaskGroupMemberParams 

type CreateTaskGroupMemberParams struct {
	MemberID    int32  `db:"member_id" json:"member_id"`
	TaskGroupID int32  `db:"task_group_id" json:"task_group_id"`
	Role        string `db:"role" json:"role"`
}

type CreateTaskGroupParams 

type CreateTaskGroupParams struct {
	ProjectID   int32       `db:"project_id" json:"project_id"`
	GroupName   string      `db:"group_name" json:"group_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	Priority    string      `db:"priority" json:"priority"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

type CreateTaskMemberParams 

type CreateTaskMemberParams struct {
	MemberID int32  `db:"member_id" json:"member_id"`
	TaskID   int32  `db:"task_id" json:"task_id"`
	Role     string `db:"role" json:"role"`
}

type CreateTaskParams 

type CreateTaskParams struct {
	TaskGroupID int32       `db:"task_group_id" json:"task_group_id"`
	TaskName    string      `db:"task_name" json:"task_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	Priority    string      `db:"priority" json:"priority"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

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 DeleteProjectMemberByIDParams 

type DeleteProjectMemberByIDParams struct {
	MemberID  int32 `db:"member_id" json:"member_id"`
	ProjectID int32 `db:"project_id" json:"project_id"`
}

type DeleteTaskGroupMemberByIDParams 

type DeleteTaskGroupMemberByIDParams struct {
	MemberID    int32 `db:"member_id" json:"member_id"`
	TaskGroupID int32 `db:"task_group_id" json:"task_group_id"`
}

type DeleteTaskMemberByIDParams 

type DeleteTaskMemberByIDParams struct {
	MemberID int32 `db:"member_id" json:"member_id"`
	TaskID   int32 `db:"task_id" json:"task_id"`
}

type GetProjectMemberByIDParams 

type GetProjectMemberByIDParams struct {
	MemberID  int32 `db:"member_id" json:"member_id"`
	ProjectID int32 `db:"project_id" json:"project_id"`
}

type GetTaskGroupMemberByIDParams 

type GetTaskGroupMemberByIDParams struct {
	MemberID    int32 `db:"member_id" json:"member_id"`
	TaskGroupID int32 `db:"task_group_id" json:"task_group_id"`
}

type GetTaskMemberByIDParams 

type GetTaskMemberByIDParams struct {
	MemberID int32 `db:"member_id" json:"member_id"`
	TaskID   int32 `db:"task_id" json:"task_id"`
}

type Member 

type Member struct {
	MemberID  int32            `db:"member_id" json:"member_id"`
	Email     string           `db:"email" json:"email"`
	FirstName string           `db:"first_name" json:"first_name"`
	LastName  string           `db:"last_name" json:"last_name"`
	CreatedAt pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type MemberCredentials 

type MemberCredentials struct {
	MemberID     int32            `db:"member_id" json:"member_id"`
	PasswordHash string           `db:"password_hash" json:"password_hash"`
	PasswordSalt string           `db:"password_salt" json:"password_salt"`
	CreatedAt    pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt    pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type Project 

type Project struct {
	ProjectID   int32            `db:"project_id" json:"project_id"`
	ProjectName string           `db:"project_name" json:"project_name"`
	Description pgtype.Text      `db:"description" json:"description"`
	Status      string           `db:"status" json:"status"`
	StartDate   pgtype.Date      `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date      `db:"end_date" json:"end_date"`
	CreatedAt   pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt   pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type ProjectMember 

type ProjectMember struct {
	MemberID  int32            `db:"member_id" json:"member_id"`
	ProjectID int32            `db:"project_id" json:"project_id"`
	Role      string           `db:"role" json:"role"`
	CreatedAt pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type Querier 

type Querier interface {
	// Insert a new member into the database
	CreateMember(ctx context.Context, arg CreateMemberParams) (int32, error)
	// Insert a new member's credentials into the database
	CreateMemberCredentials(ctx context.Context, arg CreateMemberCredentialsParams) error
	// Insert a new project into the database
	CreateProject(ctx context.Context, arg CreateProjectParams) (int32, error)
	// Assign a member to a project
	CreateProjectMember(ctx context.Context, arg CreateProjectMemberParams) error
	// Insert a new Task into the database
	CreateTask(ctx context.Context, arg CreateTaskParams) (int32, error)
	// Insert a new Task Group into the database
	CreateTaskGroup(ctx context.Context, arg CreateTaskGroupParams) (int32, error)
	// Insert a new member into a Task Group
	CreateTaskGroupMember(ctx context.Context, arg CreateTaskGroupMemberParams) error
	// Insert a new member into a Task
	CreateTaskMember(ctx context.Context, arg CreateTaskMemberParams) error
	// Delete a member from the database
	DeleteMemberByID(ctx context.Context, memberID int32) error
	// Delete a member's credentials from the database
	DeleteMemberCredentialsByID(ctx context.Context, memberID int32) error
	// Delete a project from the database
	DeleteProjectByID(ctx context.Context, projectID int32) error
	// Remove a member from a project
	DeleteProjectMemberByID(ctx context.Context, arg DeleteProjectMemberByIDParams) error
	// Delete a Task from the database
	DeleteTaskByID(ctx context.Context, taskID int32) error
	// Delete a Task Group from the database
	DeleteTaskGroupByID(ctx context.Context, taskGroupID int32) error
	// Remove a member from a Task Group
	DeleteTaskGroupMemberByID(ctx context.Context, arg DeleteTaskGroupMemberByIDParams) error
	// Remove a member from a Task
	DeleteTaskMemberByID(ctx context.Context, arg DeleteTaskMemberByIDParams) error
	// Get all member IDs from the database
	GetAllMemberIDs(ctx context.Context) ([]int32, error)
	// Get all project IDs assigned to a member
	GetAllMemberProjectIDs(ctx context.Context, memberID int32) ([]int32, error)
	// Get all projects assigned to a member
	GetAllMemberProjects(ctx context.Context, memberID int32) ([]ProjectMember, error)
	// Get all members from the database
	GetAllMembers(ctx context.Context) ([]Member, error)
	// Get all project IDs from the database
	GetAllProjectIDs(ctx context.Context) ([]int32, error)
	// Get all member IDs assigned to a project
	GetAllProjectMemberIDs(ctx context.Context, projectID int32) ([]int32, error)
	// Get all members assigned to a project
	GetAllProjectMembers(ctx context.Context, projectID int32) ([]ProjectMember, error)
	// Get all projects from the database
	GetAllProjects(ctx context.Context) ([]Project, error)
	// Get all Task Group IDs for a project
	GetAllTaskGroupIDs(ctx context.Context, projectID int32) ([]int32, error)
	// Get all member IDs assigned to a Task Group
	GetAllTaskGroupMemberIDs(ctx context.Context, taskGroupID int32) ([]int32, error)
	// Get all members assigned to a Task Group
	GetAllTaskGroupMembers(ctx context.Context, taskGroupID int32) ([]TaskGroupMember, error)
	// Get all Task Groups for a project
	GetAllTaskGroups(ctx context.Context, projectID int32) ([]TaskGroup, error)
	// Get all Task IDs for a Task Group
	GetAllTaskIDs(ctx context.Context, taskGroupID int32) ([]int32, error)
	// Get all member IDs assigned to a Task
	GetAllTaskMemberIDs(ctx context.Context, taskID int32) ([]int32, error)
	// Get all members assigned to a Task
	GetAllTaskMembers(ctx context.Context, taskID int32) ([]TaskMember, error)
	// Get all Tasks for a Task Group
	GetAllTasks(ctx context.Context, taskGroupID int32) ([]Task, error)
	// Get a member by their ID
	GetMemberByID(ctx context.Context, memberID int32) (Member, error)
	// Get a member's credentials by their ID
	GetMemberCredentialsByID(ctx context.Context, memberID int32) (MemberCredentials, error)
	// Get a project by its ID
	GetProjectByID(ctx context.Context, projectID int32) (Project, error)
	// Get a project's member by their ID
	GetProjectMemberByID(ctx context.Context, arg GetProjectMemberByIDParams) (ProjectMember, error)
	// Get a Task by its ID
	GetTaskByID(ctx context.Context, taskID int32) (Task, error)
	// Get a Task Group by its ID
	GetTaskGroupByID(ctx context.Context, taskGroupID int32) (TaskGroup, error)
	// Get a member's Task Group by their ID
	GetTaskGroupMemberByID(ctx context.Context, arg GetTaskGroupMemberByIDParams) (TaskGroupMember, error)
	// Get a member's Task by their ID
	GetTaskMemberByID(ctx context.Context, arg GetTaskMemberByIDParams) (TaskMember, error)
	// Update a member's information
	UpdateMemberByID(ctx context.Context, arg UpdateMemberByIDParams) error
	// Update a member's credentials
	UpdateMemberCredentialsByID(ctx context.Context, arg UpdateMemberCredentialsByIDParams) error
	// Update a project's information
	UpdateProjectByID(ctx context.Context, arg UpdateProjectByIDParams) error
	// Update a project's member information
	UpdateProjectMemberByID(ctx context.Context, arg UpdateProjectMemberByIDParams) error
	// Update a Task's information
	UpdateTaskByID(ctx context.Context, arg UpdateTaskByIDParams) error
	// Update a Task Group's information
	UpdateTaskGroupByID(ctx context.Context, arg UpdateTaskGroupByIDParams) error
	// Update a member's Task Group information
	UpdateTaskGroupMemberByID(ctx context.Context, arg UpdateTaskGroupMemberByIDParams) error
	// Update a member's Task information
	UpdateTaskMemberByID(ctx context.Context, arg UpdateTaskMemberByIDParams) error
}

type Queries 

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

func New 

func New(db DBTX) *Queries

func (*Queries) CreateMember 

func (q *Queries) CreateMember(ctx context.Context, arg CreateMemberParams) (int32, error)

Insert a new member into the database

func (*Queries) CreateMemberCredentials 

func (q *Queries) CreateMemberCredentials(ctx context.Context, arg CreateMemberCredentialsParams) error

Insert a new member's credentials into the database

func (*Queries) CreateProject 

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

Insert a new project into the database

func (*Queries) CreateProjectMember 

func (q *Queries) CreateProjectMember(ctx context.Context, arg CreateProjectMemberParams) error

Assign a member to a project

func (*Queries) CreateTask 

func (q *Queries) CreateTask(ctx context.Context, arg CreateTaskParams) (int32, error)

Insert a new Task into the database

func (*Queries) CreateTaskGroup 

func (q *Queries) CreateTaskGroup(ctx context.Context, arg CreateTaskGroupParams) (int32, error)

Insert a new Task Group into the database

func (*Queries) CreateTaskGroupMember 

func (q *Queries) CreateTaskGroupMember(ctx context.Context, arg CreateTaskGroupMemberParams) error

Insert a new member into a Task Group

func (*Queries) CreateTaskMember 

func (q *Queries) CreateTaskMember(ctx context.Context, arg CreateTaskMemberParams) error

Insert a new member into a Task

func (*Queries) DeleteMemberByID 

func (q *Queries) DeleteMemberByID(ctx context.Context, memberID int32) error

Delete a member from the database

func (*Queries) DeleteMemberCredentialsByID 

func (q *Queries) DeleteMemberCredentialsByID(ctx context.Context, memberID int32) error

Delete a member's credentials from the database

func (*Queries) DeleteProjectByID 

func (q *Queries) DeleteProjectByID(ctx context.Context, projectID int32) error

Delete a project from the database

func (*Queries) DeleteProjectMemberByID 

func (q *Queries) DeleteProjectMemberByID(ctx context.Context, arg DeleteProjectMemberByIDParams) error

Remove a member from a project

func (*Queries) DeleteTaskByID 

func (q *Queries) DeleteTaskByID(ctx context.Context, taskID int32) error

Delete a Task from the database

func (*Queries) DeleteTaskGroupByID 

func (q *Queries) DeleteTaskGroupByID(ctx context.Context, taskGroupID int32) error

Delete a Task Group from the database

func (*Queries) DeleteTaskGroupMemberByID 

func (q *Queries) DeleteTaskGroupMemberByID(ctx context.Context, arg DeleteTaskGroupMemberByIDParams) error

Remove a member from a Task Group

func (*Queries) DeleteTaskMemberByID 

func (q *Queries) DeleteTaskMemberByID(ctx context.Context, arg DeleteTaskMemberByIDParams) error

Remove a member from a Task

func (*Queries) GetAllMemberIDs 

func (q *Queries) GetAllMemberIDs(ctx context.Context) ([]int32, error)

Get all member IDs from the database

func (*Queries) GetAllMemberProjectIDs 

func (q *Queries) GetAllMemberProjectIDs(ctx context.Context, memberID int32) ([]int32, error)

Get all project IDs assigned to a member

func (*Queries) GetAllMemberProjects 

func (q *Queries) GetAllMemberProjects(ctx context.Context, memberID int32) ([]ProjectMember, error)

Get all projects assigned to a member

func (*Queries) GetAllMembers 

func (q *Queries) GetAllMembers(ctx context.Context) ([]Member, error)

Get all members from the database

func (*Queries) GetAllProjectIDs 

func (q *Queries) GetAllProjectIDs(ctx context.Context) ([]int32, error)

Get all project IDs from the database

func (*Queries) GetAllProjectMemberIDs 

func (q *Queries) GetAllProjectMemberIDs(ctx context.Context, projectID int32) ([]int32, error)

Get all member IDs assigned to a project

func (*Queries) GetAllProjectMembers 

func (q *Queries) GetAllProjectMembers(ctx context.Context, projectID int32) ([]ProjectMember, error)

Get all members assigned to a project

func (*Queries) GetAllProjects 

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

Get all projects from the database

func (*Queries) GetAllTaskGroupIDs 

func (q *Queries) GetAllTaskGroupIDs(ctx context.Context, projectID int32) ([]int32, error)

Get all Task Group IDs for a project

func (*Queries) GetAllTaskGroupMemberIDs 

func (q *Queries) GetAllTaskGroupMemberIDs(ctx context.Context, taskGroupID int32) ([]int32, error)

Get all member IDs assigned to a Task Group

func (*Queries) GetAllTaskGroupMembers 

func (q *Queries) GetAllTaskGroupMembers(ctx context.Context, taskGroupID int32) ([]TaskGroupMember, error)

Get all members assigned to a Task Group

func (*Queries) GetAllTaskGroups 

func (q *Queries) GetAllTaskGroups(ctx context.Context, projectID int32) ([]TaskGroup, error)

Get all Task Groups for a project

func (*Queries) GetAllTaskIDs 

func (q *Queries) GetAllTaskIDs(ctx context.Context, taskGroupID int32) ([]int32, error)

Get all Task IDs for a Task Group

func (*Queries) GetAllTaskMemberIDs 

func (q *Queries) GetAllTaskMemberIDs(ctx context.Context, taskID int32) ([]int32, error)

Get all member IDs assigned to a Task

func (*Queries) GetAllTaskMembers 

func (q *Queries) GetAllTaskMembers(ctx context.Context, taskID int32) ([]TaskMember, error)

Get all members assigned to a Task

func (*Queries) GetAllTasks 

func (q *Queries) GetAllTasks(ctx context.Context, taskGroupID int32) ([]Task, error)

Get all Tasks for a Task Group

func (*Queries) GetMemberByID 

func (q *Queries) GetMemberByID(ctx context.Context, memberID int32) (Member, error)

Get a member by their ID

func (*Queries) GetMemberCredentialsByID 

func (q *Queries) GetMemberCredentialsByID(ctx context.Context, memberID int32) (MemberCredentials, error)

Get a member's credentials by their ID

func (*Queries) GetProjectByID 

func (q *Queries) GetProjectByID(ctx context.Context, projectID int32) (Project, error)

Get a project by its ID

func (*Queries) GetProjectMemberByID 

func (q *Queries) GetProjectMemberByID(ctx context.Context, arg GetProjectMemberByIDParams) (ProjectMember, error)

Get a project's member by their ID

func (*Queries) GetTaskByID 

func (q *Queries) GetTaskByID(ctx context.Context, taskID int32) (Task, error)

Get a Task by its ID

func (*Queries) GetTaskGroupByID 

func (q *Queries) GetTaskGroupByID(ctx context.Context, taskGroupID int32) (TaskGroup, error)

Get a Task Group by its ID

func (*Queries) GetTaskGroupMemberByID 

func (q *Queries) GetTaskGroupMemberByID(ctx context.Context, arg GetTaskGroupMemberByIDParams) (TaskGroupMember, error)

Get a member's Task Group by their ID

func (*Queries) GetTaskMemberByID 

func (q *Queries) GetTaskMemberByID(ctx context.Context, arg GetTaskMemberByIDParams) (TaskMember, error)

Get a member's Task by their ID

func (*Queries) UpdateMemberByID 

func (q *Queries) UpdateMemberByID(ctx context.Context, arg UpdateMemberByIDParams) error

Update a member's information

func (*Queries) UpdateMemberCredentialsByID 

func (q *Queries) UpdateMemberCredentialsByID(ctx context.Context, arg UpdateMemberCredentialsByIDParams) error

Update a member's credentials

func (*Queries) UpdateProjectByID 

func (q *Queries) UpdateProjectByID(ctx context.Context, arg UpdateProjectByIDParams) error

Update a project's information

func (*Queries) UpdateProjectMemberByID 

func (q *Queries) UpdateProjectMemberByID(ctx context.Context, arg UpdateProjectMemberByIDParams) error

Update a project's member information

func (*Queries) UpdateTaskByID 

func (q *Queries) UpdateTaskByID(ctx context.Context, arg UpdateTaskByIDParams) error

Update a Task's information

func (*Queries) UpdateTaskGroupByID 

func (q *Queries) UpdateTaskGroupByID(ctx context.Context, arg UpdateTaskGroupByIDParams) error

Update a Task Group's information

func (*Queries) UpdateTaskGroupMemberByID 

func (q *Queries) UpdateTaskGroupMemberByID(ctx context.Context, arg UpdateTaskGroupMemberByIDParams) error

Update a member's Task Group information

func (*Queries) UpdateTaskMemberByID 

func (q *Queries) UpdateTaskMemberByID(ctx context.Context, arg UpdateTaskMemberByIDParams) error

Update a member's Task information

func (*Queries) WithTx 

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

type Task 

type Task struct {
	TaskID      int32            `db:"task_id" json:"task_id"`
	TaskGroupID int32            `db:"task_group_id" json:"task_group_id"`
	TaskName    string           `db:"task_name" json:"task_name"`
	Description pgtype.Text      `db:"description" json:"description"`
	Status      string           `db:"status" json:"status"`
	Priority    string           `db:"priority" json:"priority"`
	StartDate   pgtype.Date      `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date      `db:"end_date" json:"end_date"`
	CreatedAt   pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt   pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type TaskGroup 

type TaskGroup struct {
	TaskGroupID int32            `db:"task_group_id" json:"task_group_id"`
	ProjectID   int32            `db:"project_id" json:"project_id"`
	GroupName   string           `db:"group_name" json:"group_name"`
	Description pgtype.Text      `db:"description" json:"description"`
	Status      string           `db:"status" json:"status"`
	Priority    string           `db:"priority" json:"priority"`
	StartDate   pgtype.Date      `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date      `db:"end_date" json:"end_date"`
	CreatedAt   pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt   pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type TaskGroupMember 

type TaskGroupMember struct {
	MemberID    int32            `db:"member_id" json:"member_id"`
	TaskGroupID int32            `db:"task_group_id" json:"task_group_id"`
	Role        string           `db:"role" json:"role"`
	CreatedAt   pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt   pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type TaskMember 

type TaskMember struct {
	MemberID  int32            `db:"member_id" json:"member_id"`
	TaskID    int32            `db:"task_id" json:"task_id"`
	Role      string           `db:"role" json:"role"`
	CreatedAt pgtype.Timestamp `db:"created_at" json:"created_at"`
	UpdatedAt pgtype.Timestamp `db:"updated_at" json:"updated_at"`
}

type UpdateMemberByIDParams 

type UpdateMemberByIDParams struct {
	MemberID  int32  `db:"member_id" json:"member_id"`
	Email     string `db:"email" json:"email"`
	FirstName string `db:"first_name" json:"first_name"`
	LastName  string `db:"last_name" json:"last_name"`
}

type UpdateMemberCredentialsByIDParams 

type UpdateMemberCredentialsByIDParams struct {
	MemberID     int32  `db:"member_id" json:"member_id"`
	PasswordHash string `db:"password_hash" json:"password_hash"`
	PasswordSalt string `db:"password_salt" json:"password_salt"`
}

type UpdateProjectByIDParams 

type UpdateProjectByIDParams struct {
	ProjectID   int32       `db:"project_id" json:"project_id"`
	ProjectName string      `db:"project_name" json:"project_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

type UpdateProjectMemberByIDParams 

type UpdateProjectMemberByIDParams struct {
	MemberID  int32  `db:"member_id" json:"member_id"`
	ProjectID int32  `db:"project_id" json:"project_id"`
	Role      string `db:"role" json:"role"`
}

type UpdateTaskByIDParams 

type UpdateTaskByIDParams struct {
	TaskID      int32       `db:"task_id" json:"task_id"`
	TaskName    string      `db:"task_name" json:"task_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	Priority    string      `db:"priority" json:"priority"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

type UpdateTaskGroupByIDParams 

type UpdateTaskGroupByIDParams struct {
	TaskGroupID int32       `db:"task_group_id" json:"task_group_id"`
	GroupName   string      `db:"group_name" json:"group_name"`
	Description pgtype.Text `db:"description" json:"description"`
	Status      string      `db:"status" json:"status"`
	Priority    string      `db:"priority" json:"priority"`
	StartDate   pgtype.Date `db:"start_date" json:"start_date"`
	EndDate     pgtype.Date `db:"end_date" json:"end_date"`
}

type UpdateTaskGroupMemberByIDParams 

type UpdateTaskGroupMemberByIDParams struct {
	MemberID    int32  `db:"member_id" json:"member_id"`
	TaskGroupID int32  `db:"task_group_id" json:"task_group_id"`
	Role        string `db:"role" json:"role"`
}

type UpdateTaskMemberByIDParams 

type UpdateTaskMemberByIDParams struct {
	MemberID int32  `db:"member_id" json:"member_id"`
	TaskID   int32  `db:"task_id" json:"task_id"`
	Role     string `db:"role" json:"role"`
}

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.