用户:
武道熊师查看:0 回复:1 评论:0 创建时间:2021-04-03T09:54:35
async
function
loadplayer
(
entity
){
const
[
data
]
=
await
(
db.sql`
SELECTION
*
FROM
player
WHERE
userKey
=
${
entity
.
player
.
userKey
}
`
);
if
(
data
){
entity
.
blocks
=
data
.
BLOCKS
}
}
async
function
saveplayer
(
entity
){
if
(
entity
.
player
.
userKey
){
await
db.sql`
INSERT
INTO
player
(
BLOCKS
,
userKey
)
VALUES
(
${
entity
.
BLOCKS
}
,
${
entity
.
player
.
userKey
}
)
ON
CONFLICT
(
userKey
)
DO
UPDATE
SET
BLOCKS
=
excluded
.
blocks
`
}
}
async
function
showplayers
(){
console
.
clear
()
const
playerlist
=
await
db.sql`
SELECT
*
FROM
player
`
for
(
const
p
of
playerlist
){
console
.
log
(
JSON
.
stringify
(
p
))
}
}