github.com/soulteary/pocket-bookcase@v0.0.0-20240428065142-0b5a9a0fc98a/internal/database/migrations/sqlite/0002_denormalize_content.up.sql (about)

     1  UPDATE bookmark
     2  SET has_content = bc.has_content FROM (SELECT docid, content <> '' AS has_content FROM bookmark_content) AS bc
     3  WHERE bookmark.id = bc.docid;