DataBase

Documentation

Index

• func AddDataToDB(roomName string, username string, data string) error
• func AddTable(db *sql.DB, username string) int
• func AddUserData(userID string, loggedIn string, username string)
• func AuthenticateLogin(db *sql.DB, username string, password string) int
• func AuthenticateSignUp(db *sql.DB, username string, password string) int
• func CheckActiveSession(ID string) ([]util.UserData, error)
• func CheckAdmin(user []util.UserData, roomName string) bool
• func CreateRoom(room util.RoomData) error
• func GetEmails(username string, inbox string) *sql.Rows
• func GetRoomData(roomName string) (*sql.Rows, error)
• func GetRoomsUser(username string) *sql.Rows
• func GetUserData(username string) *sql.Rows
• func GetUserRoomData(roomName string) (*sql.Rows, error)
• func RemoveUserData(userID string, loggedIn string, username string)
• func UpdateDB(data [][]string, username string)

Functions

func AddDataToDB

func AddDataToDB(roomName string, username string, data string) error

func AddTable

func AddTable(db *sql.DB, username string) int

AddTable adds a table for every user to store their data

func AddUserData

func AddUserData(userID string, loggedIn string, username string)

func AuthenticateLogin

func AuthenticateLogin(db *sql.DB, username string, password string) int

AuthenticateLogin returns 0 or 1 based on existance of account in the DB(1) or not(0)

func AuthenticateSignUp

func AuthenticateSignUp(db *sql.DB, username string, password string) int

func CheckActiveSession

func CheckActiveSession(ID string) ([]util.UserData, error)

func CheckAdmin

func CheckAdmin(user []util.UserData, roomName string) bool

func CreateRoom

func CreateRoom(room util.RoomData) error

func GetEmails

func GetEmails(username string, inbox string) *sql.Rows

GetEmails gets all the emails related to the username. inbox arg : 0 -> SentBox, 1-> Inbox

func GetRoomData

func GetRoomData(roomName string) (*sql.Rows, error)

GetRoomData gives all the emails in the room for the given roomName

func GetRoomsUser

func GetRoomsUser(username string) *sql.Rows

GetRoomsUser gives the rooms associated with the user

func GetUserData

func GetUserData(username string) *sql.Rows

GetUserData gets the users session Data from the DB

func GetUserRoomData

func GetUserRoomData(roomName string) (*sql.Rows, error)

GetUserRoomData gives the roomData associated with the roomName

func RemoveUserData

func RemoveUserData(userID string, loggedIn string, username string)

func UpdateDB

func UpdateDB(data [][]string, username string)

UpdateDB is used to handle sent and received emails from and to the users