Replace bulk text in a database with a specific character

[ekaak348]

- Can I open a Logseq SQLite DB file in Python and replace a specific character with another one?
- Or is there another way to do the above?

[TheSnakePolyglot]

You should try using the CLI. It gets installed automatically when you install Logseq. Read more about it here https://github.com/logseq/logseq/tree/master/docs/cli

[ekaak348]

Thanks for reply

[nicholas-greenwood]

yes, python can drive the current cli suggested above. read :block/title with logseq query, replace the character, then run logseq upsert block --graph GRAPH --id ID --content "NEW TEXT". this is for ordinary block text

avoid direct sqlite replacement because the graph uses datascript storage. export the db and assets and test on a copy first

[ekaak348]

Thanks for reply