Skip to content

Delete the corresponding data in the database attributes table after deleting the doc #9875

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
3 tasks done
makediff opened this issue Dec 14, 2023 · 0 comments
Closed
3 tasks done
Assignees
Milestone

Comments

@makediff
Copy link

makediff commented Dec 14, 2023

删除文档后数据库 attributes 表自定义属性没有清理

Is there an existing issue for this?

  • I have searched the existing issues

Can the issue be reproduced with the default theme (daylight/midnight)?

  • I was able to reproduce the issue with the default theme

Could the issue be due to extensions?

  • I've ruled out the possibility that the extension is causing the problem.

Describe the problem

  1. 通过程序的方式,给doc添加自定义属性,比如 custom-wucainoteid。
  2. 按照此方式,创建多个doc,并给多个doc添加自定义属性。
  3. 通过思源编辑器左边的树目录,同时选中这些doc,然后删除。
  4. 通过程序查询,发现 attributes 表里刚才添加的这些属性依然能查询到。
  5. 重新启动思源编辑器,依然能查询到这些 attributes。
  6. 尝试重新构建 index,发现就没有问题了。

Expected result

期望的结果是
批量删除doc的时候,清理这些doc对应在attributes表里的记录。

Screenshot or screen recording presentation

No response

Version environment

- Version: Version 2.11.1 (2.11.1)
- Operating System:  MacOs Apple M1
- Browser (if used):

Log file

没有

More information

No response

@88250 88250 changed the title 自定义属性没有清理 删除文档时自定义属性没有清理 Dec 14, 2023
@88250 88250 self-assigned this Dec 14, 2023
@88250 88250 changed the title 删除文档时自定义属性没有清理 删除文档后数据库 attributes 表自定义属性没有清理 Dec 14, 2023
@88250 88250 added this to the 2.11.3 milestone Dec 14, 2023
@88250 88250 changed the title 删除文档后数据库 attributes 表自定义属性没有清理 Clean the corresponding data in the database attributes table after deleting the doc Dec 14, 2023
@88250 88250 changed the title Clean the corresponding data in the database attributes table after deleting the doc Delete the corresponding data in the database attributes table after deleting the doc Dec 15, 2023
88250 added a commit that referenced this issue Dec 15, 2023

Verified

This commit was signed with the committer’s verified signature.
…r deleting the doc #9875
@88250 88250 closed this as completed Dec 15, 2023
EightDoor added a commit to EightDoor/siyuan that referenced this issue Dec 15, 2023

Verified

This commit was signed with the committer’s verified signature.
* commit '969a8d24fcdc648b3f88d28d47280869f4974396':
  🎨 Improve web page clip code block content conversion siyuan-note#9896
  🐛 Create doc failed on non-Windows siyuan-note#9890
  🐛 fix siyuan-note#9850
  🎨 Add Relation and Rollup column to database table view siyuan-note#9888
  🐛 Do not remove .tmp file when listing doc tree https://ld246.com/article/1702621572239
  ♻️ Refactor database table view
  🐛 fix siyuan-note#9891
  🎨 delete row by keydown
  🎨 fix siyuan-note#9886
  🎨 siyuan-note#9886
  🎨 Enable or disable all CSS and JS code snippets siyuan-note#9860
  🎨 Database table view template columns support reference date columns siyuan-note#9887
  🎨 fix siyuan-note#9878
  ⬆️ Upgrade kernel deps
  🎨 Delete the corresponding data in the database attributes table after deleting the doc siyuan-note#9875
  ⬆️ Upgrade Lute
  🎨 Add internal kernel API `/api/block/getTailChildBlocks` siyuan-note#9884
  🎨 siyuan-note#9882
  🐛
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants