postgres

func (db *PostgresConnection) ChangeDBUserPassword(ctx context.Context, username string, password string) (err error)

func (db *PostgresConnection) Close() (err error)

func (db *PostgresConnection) CreateDBUser(ctx context.Context, username string, password string) (err error)

func (db *PostgresConnection) CreateIssue(ctx context.Context, issue generic.Issue) (issueID *int, err error)

func (db *PostgresConnection) CreateProject(ctx context.Context, project generic.Project) (projectID *int, err error)

func (db *PostgresConnection) CreateTask(ctx context.Context, task generic.Task) (taskID *int, err error)

func (db *PostgresConnection) CreateUser(ctx context.Context, user generic.User) (userID *int, err error)

func (db *PostgresConnection) DeactivateUser(ctx context.Context, userID int) (err error)

func (db *PostgresConnection) DeleteComment(ctx context.Context, commentID int) (err error)

func (db *PostgresConnection) DeleteDBUser(ctx context.Context, username string) (err error)

func (db *PostgresConnection) DeleteIssue(ctx context.Context, issueID int) (err error)

func (db *PostgresConnection) DeleteProject(ctx context.Context, projectID int) (err error)

func (db *PostgresConnection) DeleteTask(ctx context.Context, taskID int) (err error)

func (db *PostgresConnection) DeploySchema() error

func (db *PostgresConnection) EnsureIssueCapability(ctx context.Context, userID, issueID int) (readCapability, editCapability bool, err error)

func (db *PostgresConnection) EnsureProjectCapability(ctx context.Context, userID, projectID int) (readCapability, tasksCapability, issuesCapability, manageCapability bool, err error)

func (db *PostgresConnection) EnsureTaskCapability(ctx context.Context, userID, taskID int) (readCapability, editCapability, manageCapability bool, err error)

func (db *PostgresConnection) EnsureUsersCapability(ctx context.Context, userID int) (manageCapability, directorCapability bool, err error)

func (db *PostgresConnection) GetAllUsers(ctx context.Context) (users []generic.User, err error)

func (db *PostgresConnection) GetProjectIssues(ctx context.Context, projectID int) (issueIDs []int, err error)

func (db *PostgresConnection) GetProjectTasks(ctx context.Context, projectID int) (taskIDs []int, err error)

func (db *PostgresConnection) GetUserByUsername(ctx context.Context, username string) (userID *int, isActive bool, err error)

func (db *PostgresConnection) GetUserIssues(ctx context.Context, userID int) (issueIDs []int, err error)

func (db *PostgresConnection) GetUserProjectTasks(ctx context.Context, userID, projectID int) (taskIDs []int, err error)

func (db *PostgresConnection) GetUserProjects(ctx context.Context, userID int) (projectIDs []int, err error)

func (db *PostgresConnection) GetUserTasks(ctx context.Context, userID int) (taskIDs []int, err error)

func (db *PostgresConnection) PublishComment(ctx context.Context, userID int, taskID int, text string) (commentID *int, err error)

func (db *PostgresConnection) ReadComment(ctx context.Context, commentID int) (comment *generic.Comment, err error)

func (db *PostgresConnection) ReadIssue(ctx context.Context, issueID int) (issue *generic.Issue, err error)

func (db *PostgresConnection) ReadIssueRecursive(ctx context.Context, issueID int) (issue *generic.Issue, err error)

func (db *PostgresConnection) ReadProject(ctx context.Context, projectID int) (project *generic.Project, err error)

func (db *PostgresConnection) ReadProjectRecursive(ctx context.Context, projectID int) (project *generic.Project, err error)

func (db *PostgresConnection) ReadTask(ctx context.Context, taskID int) (task *generic.Task, err error)

func (db *PostgresConnection) ReadTaskRecursive(ctx context.Context, taskID int) (task *generic.Task, err error)

func (db *PostgresConnection) ReadUser(ctx context.Context, userID int) (user *generic.User, err error)

func (db *PostgresConnection) RegisterAttachment(ctx context.Context, attachment string) (err error)

func (db *PostgresConnection) RollbackClose() (err error)

func (db *PostgresConnection) SearchIssues(ctx context.Context, query reqresp.SearchIssues, userID int) (issueIDs []int, err error)

func (db *PostgresConnection) SearchTasks(ctx context.Context, query reqresp.SearchTasks, userID int) (taskIDs []int, err error)

func (db *PostgresConnection) SetRole(ctx context.Context, username, role string, set bool) (err error)

func (db *PostgresConnection) SetUserPermissions(ctx context.Context, userID int, username string, isActive, isAdmin, isDirector bool) (err error)

func (db *PostgresConnection) TasksReport(ctx context.Context, request reqresp.ReportRequest) (perUser []generic.TasksReport, err error)

func (db *PostgresConnection) TimeEfficiencyReport(ctx context.Context, request reqresp.ReportRequest) (perUser []generic.TimeEfficiencyReport, err error)

func (db *PostgresConnection) TrackTaskActivity(ctx context.Context, taskID int, text string, duration int) (err error)

func (db *PostgresConnection) UpdateIssue(ctx context.Context, issueID int, issue generic.Issue) (err error)

func (db *PostgresConnection) UpdateProject(ctx context.Context, projectID int, project generic.Project) (err error)

func (db *PostgresConnection) UpdateTask(ctx context.Context, taskID int, task generic.Task) (err error)

func (db *PostgresConnection) UpdateUser(ctx context.Context, userID int, user generic.User) (err error)