storage

Documentation

Index

• func MigrateDb(DB *Database, cfg *config.MySQL)
• type Database
  • func OpenDB(cfg *config.MySQL) *Database
  • func (DB *Database) GetDefaultEntranceWorld() (uuid.UUID, bool)
  • func (DB *Database) GetGuestUserTypeId(typename string) uuid.UUID
  • func (DB *Database) GetParentWorld(sid uuid.UUID) (uuid.UUID, error)
  • func (DB *Database) GetRandomWorld() (uuid.UUID, bool)
  • func (DB *Database) GetUserInfo(id uuid.UUID) (string, uuid.UUID)
  • func (DB *Database) GetUserLastKnownPosition(UserId, WorldId uuid.UUID) (uuid.UUID, cmath.Vec3, bool)
  • func (DB *Database) GetUserName(id uuid.UUID) string
  • func (DB *Database) GetUserSpawnPosition(uid uuid.UUID, URL *url.URL) (uuid.UUID, uuid.UUID, cmath.Vec3, error)
  • func (DB *Database) GetUserSpawnPositionInWorld(uid, worldId uuid.UUID) (uuid.UUID, cmath.Vec3)
  • func (DB *Database) GetUsersIDsByType(typeid uuid.UUID) ([]uuid.UUID, error)
  • func (DB *Database) GetWorldByURL(URL *url.URL) (uuid.UUID, bool)
  • func (DB *Database) GetWorldDefauleSpawnPositon(WorldId uuid.UUID) (uuid.UUID, cmath.Vec3, bool)
  • func (DB *Database) GetastUserWorld(uid uuid.UUID) (uuid.UUID, bool)
  • func (DB *Database) InsertOnline(userId, spaceId uuid.UUID)
  • func (DB *Database) QuerySingleAuxById(tables []string, id []byte) (map[string]interface{}, error)
  • func (DB *Database) QuerySingleByBinId(table string, id []byte) (map[string]interface{}, error)
  • func (DB *Database) QuerySingleByField(table string, field string, ref interface{}) (map[string]interface{}, error)
  • func (DB *Database) QuerySingleByUUID(table string, id uuid.UUID) (map[string]interface{}, error)
  • func (DB *Database) QueryWorldConfig(id uuid.UUID) (map[string]interface{}, error)
  • func (DB *Database) RemoveDynamicWorldMembership(userId, worldId uuid.UUID)
  • func (DB *Database) RemoveFromUsers(userId uuid.UUID)
  • func (DB *Database) RemoveManyFromUsers(ids []uuid.UUID) error
  • func (DB *Database) RemoveOnline(userId, worldId uuid.UUID)
  • func (DB *Database) UpdateHighFives(sender, target uuid.UUID)
  • func (DB *Database) WriteLastKnownPosition(userId, worldId, anchorId uuid.UUID, vector *cmath.Vec3, ...)

Functions

func MigrateDb

func MigrateDb(DB *Database, cfg *config.MySQL)

Types

type Database

type Database struct {
	*sqlx.DB
}

func OpenDB

func OpenDB(cfg *config.MySQL) *Database

func (*Database) GetDefaultEntranceWorld

func (DB *Database) GetDefaultEntranceWorld() (uuid.UUID, bool)

func (*Database) GetGuestUserTypeId

func (DB *Database) GetGuestUserTypeId(typename string) uuid.UUID

func (*Database) GetParentWorld

func (DB *Database) GetParentWorld(sid uuid.UUID) (uuid.UUID, error)

func (*Database) GetRandomWorld

func (DB *Database) GetRandomWorld() (uuid.UUID, bool)

func (*Database) GetUserInfo

func (DB *Database) GetUserInfo(id uuid.UUID) (string, uuid.UUID)

func (*Database) GetUserLastKnownPosition

func (DB *Database) GetUserLastKnownPosition(UserId, WorldId uuid.UUID) (uuid.UUID, cmath.Vec3, bool)

func (*Database) GetUserName

func (DB *Database) GetUserName(id uuid.UUID) string

func (*Database) GetUserSpawnPosition

func (DB *Database) GetUserSpawnPosition(uid uuid.UUID, URL *url.URL) (uuid.UUID, uuid.UUID, cmath.Vec3, error)

func (*Database) GetUserSpawnPositionInWorld

func (DB *Database) GetUserSpawnPositionInWorld(uid, worldId uuid.UUID) (uuid.UUID, cmath.Vec3)

func (*Database) GetUsersIDsByType

func (DB *Database) GetUsersIDsByType(typeid uuid.UUID) ([]uuid.UUID, error)

func (*Database) GetWorldByURL

func (DB *Database) GetWorldByURL(URL *url.URL) (uuid.UUID, bool)

func (*Database) GetWorldDefauleSpawnPositon

func (DB *Database) GetWorldDefauleSpawnPositon(WorldId uuid.UUID) (uuid.UUID, cmath.Vec3, bool)

func (*Database) GetastUserWorld

func (DB *Database) GetastUserWorld(uid uuid.UUID) (uuid.UUID, bool)

func (*Database) InsertOnline

func (DB *Database) InsertOnline(userId, spaceId uuid.UUID)

func (*Database) QuerySingleAuxById

func (DB *Database) QuerySingleAuxById(tables []string, id []byte) (map[string]interface{}, error)

func (*Database) QuerySingleByBinId

func (DB *Database) QuerySingleByBinId(table string, id []byte) (map[string]interface{}, error)

func (*Database) QuerySingleByField

func (DB *Database) QuerySingleByField(table string, field string, ref interface{}) (map[string]interface{}, error)

func (*Database) QuerySingleByUUID

func (DB *Database) QuerySingleByUUID(table string, id uuid.UUID) (map[string]interface{}, error)

func (*Database) QueryWorldConfig

func (DB *Database) QueryWorldConfig(id uuid.UUID) (map[string]interface{}, error)

func (*Database) RemoveDynamicWorldMembership

func (DB *Database) RemoveDynamicWorldMembership(userId, worldId uuid.UUID)

func (*Database) RemoveFromUsers

func (DB *Database) RemoveFromUsers(userId uuid.UUID)

func (*Database) RemoveManyFromUsers

func (DB *Database) RemoveManyFromUsers(ids []uuid.UUID) error

func (*Database) RemoveOnline

func (DB *Database) RemoveOnline(userId, worldId uuid.UUID)

func (*Database) UpdateHighFives

func (DB *Database) UpdateHighFives(sender, target uuid.UUID)

func (*Database) WriteLastKnownPosition

func (DB *Database) WriteLastKnownPosition(
	userId, worldId, anchorId uuid.UUID, vector *cmath.Vec3, timeOffset time.Duration,
)