orm/examples/cache.lua at develop · TeamMeadows/orm · GitHub

History

72 lines (58 loc) · 1.93 KB

Raw

-- Entity is a basic class, that implements logic to automatically update

---@class YoursPackage: Atomic.Package

local package = current()

local MeadowsORM = package:getDependency("team.meadows.orm")

---@cast MeadowsORM MeadowsORM

local NOT_NULL = MeadowsORM.NOT_NULL

local UNIQUE = MeadowsORM.UNIQUE

local RawSQL = MeadowsORM.RawSQL

local database = MeadowsORM:create("users")

:id()

:column("steam_id", "varchar(32)", NOT_NULL + UNIQUE)

:column("money", "int", NOT_NULL, RawSQL("0"))

:index("steam_id", false, true) -- index also being used for fast search in cache (O(1))

:cache() -- applying cache (TableCache class)

:build()

--- Example №1 - find query

local function loadUser(player)

local user = database:findUnique({

where = {

steam_id = player:SteamID()

cache = true -- inserting found row in cache = true

})

if (not user) then

user = database:create({

data = {

steam_id = player:SteamID()

cache = true -- insering new created row in cache = true

})

end

---@param player Player

---@return YoursPackage.User?

local function getUser(player)

local cache = database:getCache()

-- O(1) user get

return cache:findIndexed("steam_id", player:SteamID())

end

---@param money integer

---@param operation? MeadowsORM.WhereBuilder.WhereCompareIndexes

local function getUsersWithMoney(money, operation)

local cache = database:getCache()

-- O(n) users get

return cache:find("money", money, operation or "eq")

end

local user = getUser(Player(1))

print(user and user:getMoney())

-- find users with money=1000

getUsersWithMoney(1000)

-- find users with money>1000

getUsersWithMoney(1000, "gt") -- gt = greater than

-- find users with money>=1000

getUsersWithMoney(1000, "gte") -- gte = greater than and equals

-- find users with money<1000

getUsersWithMoney(1000, "lt") -- lt = less than

-- find users with money<=1000

getUsersWithMoney(1000, "lte") -- lte = less than and equals

orm/examples/cache.lua at develop · TeamMeadows/orm · GitHub

Uh oh!

Expand file tree

Breadcrumbs

cache.lua

Latest commit

History

Breadcrumbs

cache.lua

File metadata and controls