猫史档案馆

console.clear()
db.sql`CREATE TABLE IF NOT EXISTS playerstate (
        userKey CHAR(16) NOT NULL,
        state MEDIUMTEXT NOT NULL--超长的字符串类型MEDIUMTEXT
    )`;//创建表
async function save(entity) {
    if (!entity.player.userKey)return;
    await db.sql`
        INSERT INTO playerstate (userKey,state) --给表添加两个值
        VALUES(${entity.player.userKey},${JSON.stringify(entity)})--将玩家实体对象转换为字符串
        ON CONFLICT(userKey) --当存在时
        DO UPDATE --更新字符串
        SET state=excluded.state,--使用固定名称的“表” excluded
    ` 
}
async function load(entity){
    const info = (await (db.sql`SELECT * FROM playerstate WHERE userKey=${entity.player.userKey} limit 1`))[0]
    if(!info)return null;
    entity=JSON.parse(info)
    return entity
}
async function allPlayerList(){//调用这个函数
    const dict = await db.sql`SELECT * FROM playerstate`
    return dict.map(d => JSON.parse(d.state))
}
world.onPlayerJoin(({entity})=>{load(entity)})
world.onPlayerLeave(({entity})=>{save(entity)})
world.onPress(({ button, entity }) => {button==Box3ButtonType.ACTION1?save(entity):0})

原本我要写一个万能sql代码a

能记录下玩家的全部状态( )

这样就再也不担心sql问题了

但如你所见( )又遇到了一个从未见过的bug ( 恼

报错信息:

typeerror:Converting circular structure to JSON
    --> starting at object with constructor 'Box3Entity'
    |     property 'player' -> object with constructor 'Box喵layer'
    --- property 'cameraEntity' closes the circle

报错行:

        VALUES(${entity.player.userKey},${JSON.stringify(entity)})--将玩家实体对象转换为字符串