Database Management

local databases = client:ListDatabases()
for i, dbName in ipairs(databases) do
    print(i .. ". " .. dbName)
end

-- ⚠️ DANGER: Deletes entire database
local success = db:Drop()

local collections = db:ListCollections()
for i, name in ipairs(collections) do
    print(i .. ". " .. name)
end

local success = db:CreateCollection("new_collection")

-- ⚠️ Permanently deletes collection and all data
local success = db:DropCollection("old_collection")

local stats = db:Stats("players")
if stats then
    print("Documents:", stats.count)
    print("Size:", stats.size, "bytes")
    print("Avg doc size:", stats.avgObjSize, "bytes")
end

-- List all databases
local dbs = client:ListDatabases()
print("Total databases:", #dbs)
-- Get collection count
local cols = db:ListCollections()
print("Collections in this database:", #cols)

-- Cleanup old test data
local function CleanupTestData()
    -- Drop test collections
    db:DropCollection("test_players")
    db:DropCollection("test_items")
    print("Cleanup complete")
end