Documentation ¶
Index ¶
- func Connect() (db *sql.DB)
- func CountTableColumns(table string) int
- func CreateTable(number int) (db *sql.DB)
- func DeleteBoard(email, board string)
- func DeleteProject(email, board, project string)
- func DeleteWorkspace(value [2]string)
- func FindAccount(email, password string) (string, string, string, bool)
- func FindBoard(email, board string) string
- func FindDepartment(email string) [2]string
- func FindMember(email, password string) ([4]string, bool)
- func FindProfile(email string) bool
- func FindProject(email, board, project string) string
- func FindRole(email string) [2]string
- func FindWorkspace(email string) string
- func FindWorkspaceName(email, name string) string
- func InsertBoard(email, board string)
- func InsertDepartment(email, department string)
- func InsertMemberData(email string)
- func InsertProfileData(value [5]string)
- func InsertProject(email, board, project, person, status, date string)
- func InsertRole(email, role string)
- func InsertSignupData(value [4]string)
- func InsertWorkspaceData(value [2]string)
- func ListProfileInfo(email string) string
- func ListUserInfo(email, password string) string
- func UpdateBoard(email, oldBoard, newBoard string)
- func UpdateDepartment(email, dep string)
- func UpdateMember(value [8]string, email, password string, isSet bool)
- func UpdateProfile(value [4]string, email string)
- func UpdateProject(value [3]string, boardName, projectName string)
- func UpdateRole(email, role string)
- func UpdateUser(value [4]string, email, password string)
- func UpdateWorkspace(value [3]string)
- type ProfileCredentials
- type UserCredentials
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func CountTableColumns ¶
CountTableColumns counts the number of columns in a table in the MySQL database
func CreateTable ¶
CreateTable creates a table in the MySQL database using SQL queries from a file
func DeleteBoard ¶
func DeleteBoard(email, board string)
func DeleteProject ¶
func DeleteProject(email, board, project string)
func DeleteWorkspace ¶
func DeleteWorkspace(value [2]string)
func FindAccount ¶
FindAccount finds an account with the given email and password. It returns the email, password, status, and a boolean indicating if the account was found.
func FindBoard ¶
FindBoard finds a board with the given email and board name. It returns the board name if found, otherwise an empty string.
func FindDepartment ¶
FindDepartment finds the department associated with the given email. It returns the email and department as a string array.
func FindMember ¶
FindMember finds a member with the given email and password. It returns member credentials and a boolean indicating if the member was found.
func FindProfile ¶
FindProfile checks if a profile exists for the given email. It returns a boolean indicating if the profile exists.
func FindProject ¶
func FindRole ¶
FindRole finds the role associated with the given email. It returns the email and role as a string array.
func FindWorkspace ¶
FindWorkspace finds workspaces associated with the given email. It returns a string containing the list of workspace names.
func FindWorkspaceName ¶
FindWorkspaceName finds the workspace with the given email and name. It returns the workspace name if found, otherwise an empty string.
func InsertBoard ¶
func InsertBoard(email, board string)
InsertBoard inserts board data into the database.
func InsertDepartment ¶
func InsertDepartment(email, department string)
InsertDepartment inserts department data into the database.
func InsertMemberData ¶
func InsertMemberData(email string)
InsertMemberData inserts member data into the database.
func InsertProfileData ¶
func InsertProfileData(value [5]string)
InsertProfileData inserts profile data into the database.
func InsertProject ¶
func InsertProject(email, board, project, person, status, date string)
func InsertRole ¶
func InsertRole(email, role string)
InsertRole inserts role data into the database.
func InsertSignupData ¶
func InsertSignupData(value [4]string)
InsertSignupData inserts signup data into the database.
func InsertWorkspaceData ¶
func InsertWorkspaceData(value [2]string)
InsertWorkspaceData inserts workspace data into the database.
func ListProfileInfo ¶
ListProfileInfo lists profile information for the given email. It returns an empty string.
func ListUserInfo ¶
ListUserInfo lists user information for the given email and password. It returns an empty string.
func UpdateBoard ¶
func UpdateBoard(email, oldBoard, newBoard string)
UpdateBoard updates board information in the Boards table
func UpdateDepartment ¶
func UpdateDepartment(email, dep string)
UpdateDepartment updates department information in the Departments table
func UpdateMember ¶
UpdateMember updates member information in the Members table
func UpdateProfile ¶
UpdateProfile updates profile information in the Profiles table
func UpdateProject ¶
func UpdateRole ¶
func UpdateRole(email, role string)
UpdateRole updates role information in the Roles table
func UpdateUser ¶
UpdateUser updates user information in the Signup table
func UpdateWorkspace ¶
func UpdateWorkspace(value [3]string)
UpdateWorkspace updates workspace information in the Workspaces table