blockly里新写的key无法正常显示在koishi的仓库里，且偶尔无法被正常调取（更新：判断可能是数据库显示问题）

Blockly
1

我也不知道是blockly还是koishi的问题，刷新重登都没用。
blockly是0.5.5

写入了约81条key，但只能正常显示33条：

image
image2649×1149 134 KB

此外，执行命令调取key对应值时，时不时就无法调取

J5J}CHXY9H8VR_5U@%NG~17
J5J}CHXY9H8VR_5U@%NG~171057×527 20.4 KB

ML@VTS5EPOFQQ)@IOT5A
ML@VTS5EPOFQQ)@IOT5A831×367 8.7 KB

但是在查看key值时好像又是正常的

image
image1177×1118 81.5 KB

log如下：

log

2023-02-19 18:27:10 [W] command 求签 试试
Error: no such column: NaN
at f.handleError (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:91:290)
at f.prepare (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:90:46)
at SQLiteDriver.#exec (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:208:28)
at SQLiteDriver.#all (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:220:12)
at SQLiteDriver.get (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:274:18)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:97:40)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:216:33)
at DatabaseService.get (C:\dev\koishi-app\node_modules@minatojs\core\src\driver.ts:139:22)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2023-02-19 18:27:16 [W] sqlite > SELECT key, value FROM blockly_key_value vdapmmoj WHERE key = NaN
2023-02-19 18:27:16 [W] command 求签 试试
Error: no such column: NaN
at f.handleError (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:91:290)
at f.prepare (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:90:46)
at SQLiteDriver.#exec (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:208:28)
at SQLiteDriver.#all (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:220:12)
at SQLiteDriver.get (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:274:18)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:97:40)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:216:33)
at DatabaseService.get (C:\dev\koishi-app\node_modules@minatojs\core\src\driver.ts:139:22)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2023-02-19 18:27:22 [I] blockly Loading 5 plugin(s)
2023-02-19 18:27:22 [I] blockly Loaded 5 plugin(s)
2023-02-19 18:27:32 [W] sqlite > SELECT key, value FROM blockly_key_value dmghcmbe WHERE key = NaN
2023-02-19 18:27:32 [W] command 求签 试试
Error: no such column: NaN
at f.handleError (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:91:290)
at f.prepare (C:\dev\koishi-app\node_modules@minatojs\sql.js\dist\sql-wasm.js:90:46)
at SQLiteDriver.#exec (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:208:28)
at SQLiteDriver.#all (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:220:12)
at SQLiteDriver.get (C:\dev\koishi-app\node_modules@minatojs\driver-sqlite\src\index.ts:274:18)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:97:40)
at Selection.execute (C:\dev\koishi-app\node_modules@minatojs\core\src\selection.ts:216:33)
at DatabaseService.get (C:\dev\koishi-app\node_modules@minatojs\core\src\driver.ts:139:22)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)

块如下

块

插件名称: 求签系统
导出时间: 2023/2/21 18:53:29
-=-=-=-=–=-=-=-=- BEGIN KOISHI BLOCKLY BLOCK V1 -=-=–=-=-=–=-=–=-=-=-
H4sIAAAAAAAAA+VZaXOiShT9LamEKhP3BQSnUgYU3HBJXJMvFkIrGAVlcfvgb38X
NBqJOMzEmnn1XhWlDfbtc/rc2/d2I5ZmsERigXRD0VRoZeIh+Bxo0tq+wZxfBxNN
fDeO9xNBHVnCCHWOVrHQaT+c2XU11zPkPEgkRG06FVQJWnZfRdo/RjdIHAzNURPn
ipNETH5Mtdv7Piu7S5jEncEdPuF0OmXfoJWpC01TMNGR1UzQhSkygdMJAxUe7qEw
FsdIDiOhQWAUjjEx+wkVw8g8xqYxOm0/2UHraG4pOnJImrqFQqdzMUxdUUf9A6Q9
eDof+uOIGJ53cBOJoYIm0icfuUkAPOVA5jGG/aALblBnlvnJTBDNvUc/uf54+4nQ
O1r3F8LEQv2lrjh+OHErp93ICYyIdahmj3mExkuFJrrC00c/Fy6MdrwxZEHSlmdR
TfC8G4peKE+BwGvofcFWwe1vhXLdDE73vdy6tNhe60OXnYQ7IbwnOkJmX9BH1hSp
X6B5LTUcNVZExSAlWhExnA2t2w0P6J1VbIe5h3UU/O2Zyz+C6DZYji+esyMaNM7U
qoQZ8THzY0RAA8do3GnEMCZ3BVHSPMMWJRhinu/hr3RIS4BXwuXRRVniB1lcV8hv
IjGLAKOZwWWhYS6fDevWqvHvNe9UQuCJf28q8bmwCYxO2n6zSXCOG6+4wuEHYdKX
kDgBbrZR37BlOufyXIgr3ZfZu/AMS+dWz71IpP5UIva9XAoDs2RuapnCjkdsNZ2o
xiOG26Enm+YsE40ul8vIMhnR9FE0TlFUdCWb08muB5ZkwdyhtlMiZn/tzZ3p5+zL
dg+0Y0dBPllHj+a7+wObJOsRpB36JXZQ3RvEU/U8m+NjfkS/tLC4DU1S6xzY3M+z
rRCXXOtjlv6FbNNs0bmKHxY6Mi1d7U+RYUCdd/NA4vJR5TitUaTEjfhSaTSpN+x8
Xhc11dzN5KeYdoLrjzVFdcM1rNd6HWbw1Og9wNddeLFd98VO5Xx47SYPYZrTrB1w
0sMndD7vyyUGqGBHv4cayx82qWdrBHlipCopHpYALidTgwr2OZcCWtzXqkMrxV53
C0FXhMEE9SEi3JAhPAg5DOfISjIwd7IFky3yTeXNK8dC+PqN3hPGCT+MjzsBHQlf
0jK/yNS3ifcxAfWJG/PV3HD1tol6hMt3tgGV8bChT1pqe9spQSGWM1ldspIegpwU
QwqjUhjNHmsgNGgOY6jjT/6qoh/f3ZVIZRnIAsOW3hzOW3yvapnytfzm//JdVwu8
qK+FQrQLlPva2E7w8fITFCgBO6mtqfSxtqbS1H+gtjJxh8TfKala4YasL+paIdrc
3jbaTVA/Im2wP19SwQegOOGsBWik7CckiTHJSyXVY7T5/Jp12JvZzhg6x/edAfj7
tdlUpsh22HTmdlbb7CvvQapajCr8AOwadJYnnz3m8GnEeBxzJV2bjK864apKfeXL
wg0UuqEb5mnGlwL3i5EosYl17SSR+d4O/ELYJjVRMoaBVbETNu7WOJcJKK2/ErSu
xXtIJVeNPy+Q78faVDBl2AgqpgyZC06WLplbbW1t4O3+orvqzotR0gQ82evMW2/s
raCie1Ojj80LldfhpVrTgZNNTwtwsbxtE+zKlKM5yOtcGz2UI1EPTrV2FTse+y6X
VQdzqknWRHNjQjVqqfxLPNPMdIgpWDLNWNrIHvq55S91Snm2lv/uVJPjZY94Cihk
XZPj7fvVLRjnS5enSqR8z9Xb75ni2qjep7T162S2jQwFdCs9/F2v8xw7wKODwYJ+
eQFvlCbWMzEMX8HrfjZTVVjPDD6zYDMcuocNJlxQYfKkOQijjehB4rip+qgKRzrM
d+WYATzXsGmNwOzHD61Wjsaj7QA89qoH1xYFBikQqLOZmltoPvKKTNvCJELETwW5
XFPPbSJ3a6pZf/mucExkFunAkBzKwlh4lxbTpWRNT18WjTzz3ugqfsykytxjZJPL
ZlMdZGcZqyV3tr486OZypVP3kLqRt2KsPcKBziYcjNxDULHgWAo7n+yucfau1CIF
iOWe+hTQ881uVhxypcpHdv0DJ++RvcfoC19i/Lb5kK63m10wsTIBgFk35nEtFfGQ
wjIcD/88Ij52VbbBmS3Vg53hSpX0sxBqM3Q0VgguZCH4dWn8yoH/J68XtOYC3XWr
vCxtWHlc7wztk+MMS5y+WrjCQf05Pl3AwoMxwwj1+EkjRxfeqgGvNzv/g6N6o/26
7vGFcbku2a+WhazC93Cvt/unSfTixvD3r8PJ9YO25yF6ohhf/yjR4imiZImv2cE8
G5+XX5blJubxz9U5t2ndbTQfX5fylRuA1G+7+RL3+Ih9HKrtvrOJNVLUMOxdhKM0
EjJEXZkdDsmuv14un7qhAcWHYZwGY7/m3rGyrAMvUSIFfJAUwgNEJsIpiSTDVAI+
CGjhOImnSSTuEP8BuUpCYu4cAAA=
-=-=–=-=-=–=-=-=-=- END KOISHI BLOCKLY BLOCK V1 -=-=–=-=-=–=-=–=-=-=-

编译后

import { h } from “koishi”
export const name = “求签系统”
export const using =
export async function apply(ctx){
ctx.database.extend(“blockly_key_value”,{
key: “string”,
value: “string”
},{
primary: “key”
})

ctx.command(‘写签 <参数名称:string> <参数名称:string>’).action(async ({session},…args)=>{
await ctx.database.upsert(‘blockly_key_value’,[{key:(args[0]),value:(args[1])}],[‘key’])

});

ctx.command(‘检查签 <参数名称:string>’).action(async ({session},…args)=>{
{
let 第几签 = args[0];
return ([session.content,第几签,(await ctx.database.get(‘blockly_key_value’,{key:第几签}))[0]?.value].join(‘’));
}

});

ctx.command(‘求签 <参数名称:string>’).action(async ({session},…args)=>{
{
let 时间戳 = Math.round(new Date() / 1000), qq = session.messageId;
{
let 求签数 = (qq + 时间戳) % 81 + 1;
return ([h(‘at’,{ id: (session.userId) }),session.content,(await ctx.database.get(‘blockly_key_value’,{key:求签数}))[0]?.value].join(‘’));
}
}

});

}

补充：而且在koishi的数据库那点插入还会冒出这个东西：

image
image1972×349 29.1 KB

添加数据失败：Error: UNIQUE constraint failed: blockly_key_value.key

更新：不反馈签的问题已经基本解决，但是已经写入的签不能在数据库中完全显示的问题仍然没有解决。
如图：

image
image1783×1350 314 KB

在我删除前面的一些条目后，后面无法显示的条目就可以正常显现了。但是仅限于此，只能显示33条，后面的虽然可以调用但是没法显示。

1 个赞
2

cc @TimeBather

你把块和编译完的代码也放一下?

3

我也遇到了这个问题，koishi数据库里显示不了全部的key。

4

感觉更像是dataview的bug（