Something went wrong. Try again.
(READ ONLY) Margin is an open annotation layer for the internet. Powered by the AT Protocol.
margin.at
extension web atproto comments
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157-- name: CreateHighlight :execINSERT INTO highlights (uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cid)VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11)ON CONFLICT(uri) DO UPDATE SET target_source = EXCLUDED.target_source, target_hash = EXCLUDED.target_hash, target_title = EXCLUDED.target_title, selector_json = EXCLUDED.selector_json, color = EXCLUDED.color, tags_json = EXCLUDED.tags_json, indexed_at = EXCLUDED.indexed_at, cid = EXCLUDED.cid;
-- name: GetHighlightByURI :oneSELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE uri = $1;
-- name: GetRecentHighlights :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsORDER BY created_at DESCLIMIT $1 OFFSET $2;
-- name: GetPopularHighlights :manySELECT h.uri, h.author_did, h.target_source, h.target_hash, h.target_title, h.selector_json, h.color, h.tags_json, h.created_at, h.indexed_at, h.cidFROM all_highlights hLEFT JOIN LATERAL ( SELECT COUNT(*) as cnt FROM likes WHERE subject_uri = h.uri) l ON trueLEFT JOIN LATERAL ( SELECT COUNT(*) as cnt FROM replies WHERE root_uri = h.uri) r ON trueWHERE h.created_at > $1 AND (l.cnt + r.cnt) > 0ORDER BY (l.cnt + r.cnt) DESC, h.created_at DESCLIMIT $2 OFFSET $3;
-- name: GetShelvedHighlights :manySELECT h.uri, h.author_did, h.target_source, h.target_hash, h.target_title, h.selector_json, h.color, h.tags_json, h.created_at, h.indexed_at, h.cidFROM all_highlights hWHERE h.created_at < $1 AND h.created_at > $2 AND NOT EXISTS (SELECT 1 FROM likes WHERE subject_uri = h.uri) AND NOT EXISTS (SELECT 1 FROM replies WHERE root_uri = h.uri)ORDER BY RANDOM()LIMIT $3 OFFSET $4;
-- name: GetMarginHighlights :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $1 OFFSET $2;
-- name: GetSembleHighlights :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $1 OFFSET $2;
-- name: GetHighlightsByTag :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE lower(tags_json)::jsonb ? $1ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetMarginHighlightsByTag :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE lower(tags_json)::jsonb ? $1 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetSembleHighlightsByTag :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE lower(tags_json)::jsonb ? $1 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetHighlightsByTagAndAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2ORDER BY created_at DESCLIMIT $3 OFFSET $4;
-- name: GetMarginHighlightsByTagAndAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $3 OFFSET $4;
-- name: GetSembleHighlightsByTagAndAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $3 OFFSET $4;
-- name: GetHighlightsByTargetHash :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE target_hash = $1ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetHighlightsByAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetMarginHighlightsByAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetSembleHighlightsByAuthor :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3;
-- name: GetHighlightsByAuthorAndTargetHash :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE author_did = $1 AND target_hash = $2ORDER BY created_at DESCLIMIT $3 OFFSET $4;
-- name: DeleteHighlight :execDELETE FROM highlights WHERE uri = $1;
-- name: UpdateHighlight :execUPDATE highlightsSET color = $1, tags_json = $2, cid = $3, indexed_at = $4WHERE uri = $5;
-- name: GetHighlightsByURIs :manySELECT uri, author_did, target_source, target_hash, target_title, selector_json, color, tags_json, created_at, indexed_at, cidFROM all_highlightsWHERE uri = ANY($1::text[]);
-- name: GetHighlightURIs :manySELECT uri FROM all_highlights WHERE author_did = $1;