postgres

package
v0.0.0-...-a66885a Latest Latest
Warning

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

 Go to latest Published: Jan 10, 2021 License: MIT Imports: 8 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	DbResultNotFound = "sql: no rows in result set"
	IsProject        = 1
	IsBoard          = 2
)

Variables

This section is empty.

Functions

func NewPostgresDB 

func NewPostgresDB(cfg Config) (*sqlx.DB, error)

Types

type BoardPg 

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

func NewBoardPg 

func NewBoardPg(db *sqlx.DB) *BoardPg

func (*BoardPg) Create 

func (r *BoardPg) Create(userId int, board *models.Board) (int, error)

func (*BoardPg) Delete 

func (r *BoardPg) Delete(boardId int) error

func (*BoardPg) GetAll 

func (r *BoardPg) GetAll(userId, projectId int) ([]*models.Board, error)

func (*BoardPg) GetBoardsCountByOwnerId 

func (r *BoardPg) GetBoardsCountByOwnerId(projectId, ownerId int) (int, error)

func (*BoardPg) GetById 

func (r *BoardPg) GetById(boardId int) (*models.Board, error)

func (*BoardPg) GetMembers 

func (r *BoardPg) GetMembers(boardId int) ([]*models.Member, error)

func (*BoardPg) GetPermissions 

func (r *BoardPg) GetPermissions(userId, boardId int) (*models.Permission, error)

func (*BoardPg) Update 

func (r *BoardPg) Update(boardId int, input *models.UpdateBoard) error

type Config 

type Config struct {
	Host     string
	Port     string
	Username string
	Password string
	DBName   string
	SSLMode  string
}

type LabelPg 

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

func NewLabelPg 

func NewLabelPg(db *sqlx.DB) *LabelPg

func (*LabelPg) Create 

func (r *LabelPg) Create(label *models.Label) (int, error)

func (*LabelPg) CreateInTask 

func (r *LabelPg) CreateInTask(taskId, labelId int) (int, error)

func (*LabelPg) Delete 

func (r *LabelPg) Delete(labelId int) error

func (*LabelPg) DeleteInTask 

func (r *LabelPg) DeleteInTask(taskId, labelId int) error

func (*LabelPg) GetAll 

func (r *LabelPg) GetAll(boardId int) ([]*models.Label, error)

func (*LabelPg) GetAllInTask 

func (r *LabelPg) GetAllInTask(taskId int) ([]*models.Label, error)

func (*LabelPg) GetById 

func (r *LabelPg) GetById(labelId int) (*models.Label, error)

func (*LabelPg) Update 

func (r *LabelPg) Update(labelId int, input *models.UpdateLabel) error

type ObjectParams 

type ObjectParams struct {
	Title   string
	IdTitle string
	Table   string
}

type ObjectPermsPg 

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

func NewObjectPermsPg 

func NewObjectPermsPg(db *sqlx.DB) *ObjectPermsPg

func (*ObjectPermsPg) Create 

func (r *ObjectPermsPg) Create(objectId, objectType int, memberNickname string, permissions *models.Permission) (int, error)

func (*ObjectPermsPg) Delete 

func (r *ObjectPermsPg) Delete(objectId, memberId, ownerProjectId, objectType int) error

func (*ObjectPermsPg) GetById 

func (r *ObjectPermsPg) GetById(objectId, memberId, objectType int) (*models.Permission, error)

func (*ObjectPermsPg) GetByNickname 

func (r *ObjectPermsPg) GetByNickname(objectId, objectType int, memberNickname string) (*models.Permission, error)

func (*ObjectPermsPg) Update 

func (r *ObjectPermsPg) Update(objectId, memberId, ownerProjectId, objectType int, permissions *models.UpdatePermission) error

type ProjectPg 

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

func NewProjectPg 

func NewProjectPg(db *sqlx.DB) *ProjectPg

func (*ProjectPg) Create 

func (r *ProjectPg) Create(project *models.Project) (int, error)

func (*ProjectPg) Delete 

func (r *ProjectPg) Delete(projectId int) error

func (*ProjectPg) GetAll 

func (r *ProjectPg) GetAll(userId int) ([]*models.Project, error)

func (*ProjectPg) GetById 

func (r *ProjectPg) GetById(projectId int) (*models.Project, error)

func (*ProjectPg) GetMembers 

func (r *ProjectPg) GetMembers(projectId int) ([]*models.Member, error)

func (*ProjectPg) GetPermissions 

func (r *ProjectPg) GetPermissions(userId, projectId int) (*models.Permission, error)

func (*ProjectPg) Update 

func (r *ProjectPg) Update(projectId int, input *models.UpdateProject) error

type TaskListPg 

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

func NewTaskListPg 

func NewTaskListPg(db *sqlx.DB) *TaskListPg

func (*TaskListPg) Create 

func (r *TaskListPg) Create(list *models.TaskList) (int, error)

func (*TaskListPg) Delete 

func (r *TaskListPg) Delete(listId int) error

func (*TaskListPg) GetAll 

func (r *TaskListPg) GetAll(boardId int) ([]*models.TaskList, error)

func (*TaskListPg) GetById 

func (r *TaskListPg) GetById(listId int) (*models.TaskList, error)

func (*TaskListPg) Update 

func (r *TaskListPg) Update(listId int, input *models.UpdateTaskList) error

type TaskPg 

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

func NewTaskPg 

func NewTaskPg(db *sqlx.DB) *TaskPg

func (*TaskPg) Create 

func (r *TaskPg) Create(task *models.Task) (int, error)

func (*TaskPg) Delete 

func (r *TaskPg) Delete(taskId int) error

func (*TaskPg) GetAll 

func (r *TaskPg) GetAll(listId int) ([]*models.Task, error)

func (*TaskPg) GetById 

func (r *TaskPg) GetById(taskId int) (*models.Task, error)

func (*TaskPg) Update 

func (r *TaskPg) Update(taskId int, input *models.UpdateTask) error

type UserPg 

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

func NewUserPg 

func NewUserPg(db *sqlx.DB) *UserPg

func (*UserPg) Create 

func (r *UserPg) Create(user *models.User) (int, error)

func (*UserPg) FindToken 

func (r *UserPg) FindToken(input string) error

func (*UserPg) Get 

func (r *UserPg) Get(nickname, password string) (*models.User, error)

func (*UserPg) GetAll 

func (r *UserPg) GetAll() ([]*models.User, error)

func (*UserPg) GetById 

func (r *UserPg) GetById(id int) (*models.User, error)

func (*UserPg) GetByNickname 

func (r *UserPg) GetByNickname(nickname string) (*models.User, error)

func (*UserPg) SignOut 

func (r *UserPg) SignOut(token string) (int, error)

func (*UserPg) Update 

func (r *UserPg) Update(id int, profile *models.UpdateUser) error

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.