model

Documentation

Index

• Constants
• Variables
• func CreateActionLink(db gfsql.DB, action *Action, user *User) error
• func CreateRoleAction(db gfsql.DB, role *Role, action *Action) error
• func CreateRoleLink(db gfsql.DB, role *Role, user *User) error
• func DeleteActionByID(db gfsql.DB, serviceIID uint32, actionID string) error
• func DeleteActionByIID(db gfsql.DB, serviceIID uint32, actionIID uint32) error
• func DeleteActionLink(db gfsql.DB, action *Action, user *User) error
• func DeleteRoleAction(db gfsql.DB, role *Role, action *Action) error
• func DeleteRoleByID(db gfsql.DB, teamIID uint32, roleID string) error
• func DeleteRoleByIID(db gfsql.DB, roleIID uint32) error
• func DeleteRoleLink(db gfsql.DB, role *Role, user *User) error
• func DeleteServiceByID(db gfsql.DB, serviceID string) error
• func DeleteServiceByIID(db gfsql.DB, serviceIID uint32) error
• func DeleteTeamByID(db gfsql.DB, teamID string) error
• func DeleteTeamByIID(db gfsql.DB, teamIID uint32) error
• func DeleteUserByID(db gfsql.DB, teamIID uint32, userID string) error
• func DeleteUserByIID(db gfsql.DB, userIID uint32) error
• func UpsertActionLink(db gfsql.DB, action *Action, user *User) error
• type Action
  • func CreateAction(db gfsql.DB, serviceIID uint32, actionID string) (*Action, error)
  • func GetAction(db gfsql.DB, serviceIID uint32, actionID string) (*Action, error)
  • func (action *Action) Delete(db gfsql.DB) error
• type ActionLink
  • func GetActionLink(db gfsql.DB, action *Action, user *User) (*ActionLink, error)
  • func (actionLink *ActionLink) Validate() error
• type Password
• type Role
  • func CreateRole(db gfsql.DB, teamIID uint32, roleID string) (*Role, error)
  • func GetRole(db gfsql.DB, teamIID uint32, roleID string) (*Role, error)
  • func (role *Role) Delete(db gfsql.DB) error
• type RoleAction
  • func GetRoleActions(db gfsql.DB, role *Role) ([]RoleAction, error)
• type RoleLink
• type Service
  • func CreateService(db gfsql.DB, serviceID string) (*Service, error)
  • func GetService(db gfsql.DB, serviceID string) (*Service, error)
  • func (service *Service) Delete(db gfsql.DB) error
• type Session
  • func GetSession(db gfsql.DB, userIID uint32, sessionID string) (*Session, error)
  • func (session *Session) Delete(db gfsql.DB) error
  • func (session *Session) Validate() error
• type Team
  • func CreateTeam(db gfsql.DB, teamID string) (*Team, error)
  • func GetTeam(db gfsql.DB, teamID string) (*Team, error)
  • func (team *Team) Delete(db gfsql.DB) error
• type User
  • func CreateUser(db gfsql.DB, teamIID uint32, userID string) (*User, error)
  • func GetUser(db gfsql.DB, teamIID uint32, userID string) (*User, error)
  • func (user *User) Delete(db gfsql.DB) error
  • func (user *User) MatchPassword(db gfsql.DB, password string) error
  • func (user *User) UpdatePassword(db gfsql.DB, password string) error

Constants

const ExpirationInterval = 1 * 24 * -1

1 day

const SqlCreateAction = "INSERT INTO `actions` (`service_iid`, `id`) VALUE (:service_iid, :action_id)"

const SqlCreateActionLink = "INSERT `action_links` (`action_iid`, `user_iid`) VALUE (:action_iid, :user_iid)"

const SqlCreateRole = "INSERT INTO `roles` (`team_iid`,`id`) VALUE (:team_iid, :role_id)"

const SqlCreateRoleAction = "INSERT INTO `role_actions` (`role_iid`, `action_iid`) VALUE (:role_iid, :action_iid)"

const SqlCreateRoleLink = "INSERT `role_links` (`role_iid`, `user_iid`) VALUE (:role_iid, :user_iid)"

const SqlCreateService = "INSERT INTO `services` (`id`) VALUE (:service_id)"

const SqlCreateTeam = "INSERT INTO `teams` (`id`) VALUE (:team_id)"

const SqlCreateUser = "INSERT INTO `users` (`team_iid`,`id`) VALUE (:team_iid, :user_id)"

const SqlDecrementActionLinkCount = "UPDATE `action_links` SET count = count - 1 WHERE `action_iid` = :action_iid and `user_iid` = :user_iid"

support role

const SqlDeleteActionByID = "DELETE FROM `actions` WHERE `id` = :action_id and `service_iid` = :service_iid"

const SqlDeleteActionByIID = "DELETE FROM `actions` WHERE `iid` = :action_iid and `service_iid` = :service_iid"

const SqlDeleteActionLink = "DELETE FROM `action_links` WHERE `action_iid` = :action_iid and `user_iid` = :user_iid"

const SqlDeleteRoleAction = "DELETE FROM `role_actions` WHERE `action_iid` = :action_iid and `role_iid` = :role_iid"

const SqlDeleteRoleByID = "DELETE FROM `roles` WHERE `team_iid` = :team_iid and `id` = :role_id"

const SqlDeleteRoleByIID = "DELETE FROM `roles` WHERE `iid` = :role_iid"

const SqlDeleteRoleLink = "DELETE FROM `role_links` WHERE `role_iid` = :role_iid and `user_iid` = :user_iid"

const SqlDeleteServiceByID = "DELETE FROM `services` WHERE `id` = :service_id"

const SqlDeleteServiceByIID = "DELETE FROM `services` WHERE `iid` = :service_iid"

const SqlDeleteSession = "DELETE FROM `sessions` WHERE `session` = :session_id and `user_iid` = :user_iid"

const SqlDeleteTeamByID = "DELETE FROM `teams` WHERE `id` = :team_id"

const SqlDeleteTeamByIID = "DELETE FROM `teams` WHERE `iid` = :team_iid"

const SqlDeleteUserByID = "DELETE FROM `users` WHERE `team_iid` = :team_iid and `id` = :user_id"

const SqlDeleteUserByIID = "DELETE FROM `users` WHERE `iid` = :user_iid"

const SqlGetActionByID = "SELECT `iid`, `service_iid`, `id` FROM `actions` WHERE `id` = :action_id and `service_iid` = :service_iid"

const SqlGetActionLink = "SELECT `action_iid`, `user_iid`, `count` FROM `action_links` WHERE `action_iid` = :action_iid and `user_iid` = :user_iid"

const SqlGetPasswordByID = "" /* 184-byte string literal not displayed */

const SqlGetPasswordByIID = "SELECT `password` FROM `passwords` WHERE `user_iid` = :user_iid"

const SqlGetRoleActions = "SELECT `role_iid`, `action_iid` FROM `role_actions` WHERE `role_iid` = :role_iid"

const SqlGetRoleByID = "SELECT `iid`, `team_iid`, `id` FROM `roles` WHERE `team_iid` = :team_iid and `id` = :role_id"

const SqlGetServiceByID = "SELECT `iid`, `id` FROM `services` WHERE `id` = :service_id"

const SqlGetSession = "SELECT `session`, `update_date`, `user_iid` FROM `sessions` WHERE `session` = :session_id and `user_iid` = :user_iid"

const SqlGetTeamByID = "SELECT iid, id FROM `teams` WHERE `id` = :team_id"

const SqlGetUserByID = "SELECT `iid`, `team_iid`, `id` FROM `users` WHERE `team_iid` = :team_iid and `id` = :user_id"

const SqlUpsertActionLink = "" /* 126-byte string literal not displayed */

const SqlUpsertPasswordByID = SqlUpsertPasswordInsertBase + "`users`.`team_iid` = :team_iid and `users`.`id` = :user_id " + SqlUpsertPasswordUpdateBase

const SqlUpsertPasswordByIID = SqlUpsertPasswordInsertBase + "`users`.`iid` = :user_iid " + SqlUpsertPasswordUpdateBase

const SqlUpsertPasswordInsertBase = "INSERT INTO `passwords` (`user_iid`,`password`) SELECT `users`.`iid`, :password as password FROM `users` WHERE "

const SqlUpsertPasswordUpdateBase = "ON DUPLICATE KEY UPDATE `passwords`.`password` = :password"

Variables

var ErrDuplicate = errors.New("duplicate")

Functions

func CreateActionLink

func CreateActionLink(db gfsql.DB, action *Action, user *User) error

func CreateRoleAction

func CreateRoleAction(db gfsql.DB, role *Role, action *Action) error

func CreateRoleLink

func CreateRoleLink(db gfsql.DB, role *Role, user *User) error

func DeleteActionByID

func DeleteActionByID(db gfsql.DB, serviceIID uint32, actionID string) error

func DeleteActionByIID

func DeleteActionByIID(db gfsql.DB, serviceIID uint32, actionIID uint32) error

func DeleteActionLink

func DeleteActionLink(db gfsql.DB, action *Action, user *User) error

func DeleteRoleAction

func DeleteRoleAction(db gfsql.DB, role *Role, action *Action) error

func DeleteRoleByID

func DeleteRoleByID(db gfsql.DB, teamIID uint32, roleID string) error

func DeleteRoleByIID

func DeleteRoleByIID(db gfsql.DB, roleIID uint32) error

func DeleteRoleLink

func DeleteRoleLink(db gfsql.DB, role *Role, user *User) error

func DeleteServiceByID

func DeleteServiceByID(db gfsql.DB, serviceID string) error

func DeleteServiceByIID

func DeleteServiceByIID(db gfsql.DB, serviceIID uint32) error

func DeleteTeamByID

func DeleteTeamByID(db gfsql.DB, teamID string) error

func DeleteTeamByIID

func DeleteTeamByIID(db gfsql.DB, teamIID uint32) error

func DeleteUserByID

func DeleteUserByID(db gfsql.DB, teamIID uint32, userID string) error

func DeleteUserByIID

func DeleteUserByIID(db gfsql.DB, userIID uint32) error

func UpsertActionLink

func UpsertActionLink(db gfsql.DB, action *Action, user *User) error

Types

type Action

type Action struct {
	IID        uint32 `db:"iid"`
	ServiceIID uint32 `db:"service_iid"`
	ID         string `db:"id"`
}

func CreateAction

func CreateAction(db gfsql.DB, serviceIID uint32, actionID string) (*Action, error)

func GetAction

func GetAction(db gfsql.DB, serviceIID uint32, actionID string) (*Action, error)

func (*Action) Delete

func (action *Action) Delete(db gfsql.DB) error

type ActionLink

type ActionLink struct {
	ActionIID uint32 `db:"action_iid"`
	UserIID   uint32 `db:"user_iid"`
	Count     uint32 `db:"count"`
}

func GetActionLink

func GetActionLink(db gfsql.DB, action *Action, user *User) (*ActionLink, error)

func (*ActionLink) Validate

func (actionLink *ActionLink) Validate() error

type Password

type Password struct {
	Password string `db:"password"`
}

type Role

type Role struct {
	IID     uint32 `db:"iid"`
	TeamIID uint32 `db:"team_iid"`
	ID      string `db:"id"`
}

func CreateRole

func CreateRole(db gfsql.DB, teamIID uint32, roleID string) (*Role, error)

func GetRole

func GetRole(db gfsql.DB, teamIID uint32, roleID string) (*Role, error)

func (*Role) Delete

func (role *Role) Delete(db gfsql.DB) error

type RoleAction

type RoleAction struct {
	RoleIID   uint32 `db:"role_iid"`
	ActionIID uint32 `db:"action_iid"`
}

func GetRoleActions

func GetRoleActions(db gfsql.DB, role *Role) ([]RoleAction, error)

type RoleLink

type RoleLink struct {
	RoleIID uint32 `db:"role_iid"`
	UserIID uint32 `db:"user_iid"`
}

type Service

type Service struct {
	IID uint32 `db:"iid"`
	ID  string `db:"id"`
}

func CreateService

func CreateService(db gfsql.DB, serviceID string) (*Service, error)

func GetService

func GetService(db gfsql.DB, serviceID string) (*Service, error)

func (*Service) Delete

func (service *Service) Delete(db gfsql.DB) error

type Session

type Session struct {
	SessionID  string    `db:"session"`
	UpdateDate time.Time `db:"update_date"`
	UserIID    uint32    `db:"user_iid"`
}

func GetSession

func GetSession(db gfsql.DB, userIID uint32, sessionID string) (*Session, error)

func (*Session) Delete

func (session *Session) Delete(db gfsql.DB) error

func (*Session) Validate

func (session *Session) Validate() error

type Team

type Team struct {
	IID uint32 `db:"iid"`
	ID  string `db:"id"`
}

func CreateTeam

func CreateTeam(db gfsql.DB, teamID string) (*Team, error)

func GetTeam

func GetTeam(db gfsql.DB, teamID string) (*Team, error)

func (*Team) Delete

func (team *Team) Delete(db gfsql.DB) error

type User

type User struct {
	IID     uint32 `db:"iid"`
	TeamIID uint32 `db:"team_iid"`
	ID      string `db:"id"`
}

func CreateUser

func CreateUser(db gfsql.DB, teamIID uint32, userID string) (*User, error)

func GetUser

func GetUser(db gfsql.DB, teamIID uint32, userID string) (*User, error)

func (*User) Delete

func (user *User) Delete(db gfsql.DB) error

func (*User) MatchPassword

func (user *User) MatchPassword(db gfsql.DB, password string) error

func (*User) UpdatePassword

func (user *User) UpdatePassword(db gfsql.DB, password string) error