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.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882// Code generated by sqlc. DO NOT EDIT.// versions:// sqlc v1.31.1// source: bookmarks.sql
package sqlcdb
import ( "context" "time")
const createBookmark = `-- name: CreateBookmark :execINSERT INTO bookmarks (uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cid)VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)ON CONFLICT(uri) DO UPDATE SET source = EXCLUDED.source, source_hash = EXCLUDED.source_hash, title = EXCLUDED.title, description = EXCLUDED.description, tags_json = EXCLUDED.tags_json, indexed_at = EXCLUDED.indexed_at, cid = EXCLUDED.cid`
type CreateBookmarkParams struct { Uri string `json:"uri"` AuthorDid string `json:"authorDid"` Source string `json:"source"` SourceHash string `json:"sourceHash"` Title *string `json:"title"` Description *string `json:"description"` TagsJson *string `json:"tagsJson"` CreatedAt time.Time `json:"createdAt"` IndexedAt time.Time `json:"indexedAt"` Cid *string `json:"cid"`}
func (q *Queries) CreateBookmark(ctx context.Context, arg CreateBookmarkParams) error { _, err := q.db.Exec(ctx, createBookmark, arg.Uri, arg.AuthorDid, arg.Source, arg.SourceHash, arg.Title, arg.Description, arg.TagsJson, arg.CreatedAt, arg.IndexedAt, arg.Cid, ) return err}
const deleteBookmark = `-- name: DeleteBookmark :execDELETE FROM bookmarks WHERE uri = $1`
func (q *Queries) DeleteBookmark(ctx context.Context, uri string) error { _, err := q.db.Exec(ctx, deleteBookmark, uri) return err}
const getBookmarkByURI = `-- name: GetBookmarkByURI :oneSELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE uri = $1`
func (q *Queries) GetBookmarkByURI(ctx context.Context, uri string) (AllBookmark, error) { row := q.db.QueryRow(ctx, getBookmarkByURI, uri) var i AllBookmark err := row.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ) return i, err}
const getBookmarkURIs = `-- name: GetBookmarkURIs :manySELECT uri FROM all_bookmarks WHERE author_did = $1`
func (q *Queries) GetBookmarkURIs(ctx context.Context, authorDid string) ([]string, error) { rows, err := q.db.Query(ctx, getBookmarkURIs, authorDid) if err != nil { return nil, err } defer rows.Close() var items []string for rows.Next() { var uri string if err := rows.Scan(&uri); err != nil { return nil, err } items = append(items, uri) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getBookmarksByAuthor = `-- name: GetBookmarksByAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetBookmarksByAuthorParams struct { AuthorDid string `json:"authorDid"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetBookmarksByAuthor(ctx context.Context, arg GetBookmarksByAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getBookmarksByAuthor, arg.AuthorDid, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getBookmarksByTag = `-- name: GetBookmarksByTag :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE lower(tags_json)::jsonb ? $1ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetBookmarksByTagParams struct { TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetBookmarksByTag(ctx context.Context, arg GetBookmarksByTagParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getBookmarksByTag, arg.TagsJson, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getBookmarksByTagAndAuthor = `-- name: GetBookmarksByTagAndAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2ORDER BY created_at DESCLIMIT $3 OFFSET $4`
type GetBookmarksByTagAndAuthorParams struct { AuthorDid string `json:"authorDid"` TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetBookmarksByTagAndAuthor(ctx context.Context, arg GetBookmarksByTagAndAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getBookmarksByTagAndAuthor, arg.AuthorDid, arg.TagsJson, arg.Limit, arg.Offset, ) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getBookmarksByTargetHash = `-- name: GetBookmarksByTargetHash :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE source_hash = $1ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetBookmarksByTargetHashParams struct { SourceHash string `json:"sourceHash"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetBookmarksByTargetHash(ctx context.Context, arg GetBookmarksByTargetHashParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getBookmarksByTargetHash, arg.SourceHash, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getBookmarksByURIs = `-- name: GetBookmarksByURIs :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE uri = ANY($1::text[])`
func (q *Queries) GetBookmarksByURIs(ctx context.Context, dollar_1 []string) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getBookmarksByURIs, dollar_1) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getMarginBookmarks = `-- name: GetMarginBookmarks :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $1 OFFSET $2`
type GetMarginBookmarksParams struct { Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetMarginBookmarks(ctx context.Context, arg GetMarginBookmarksParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getMarginBookmarks, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getMarginBookmarksByAuthor = `-- name: GetMarginBookmarksByAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetMarginBookmarksByAuthorParams struct { AuthorDid string `json:"authorDid"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetMarginBookmarksByAuthor(ctx context.Context, arg GetMarginBookmarksByAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getMarginBookmarksByAuthor, arg.AuthorDid, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getMarginBookmarksByTag = `-- name: GetMarginBookmarksByTag :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE lower(tags_json)::jsonb ? $1 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetMarginBookmarksByTagParams struct { TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetMarginBookmarksByTag(ctx context.Context, arg GetMarginBookmarksByTagParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getMarginBookmarksByTag, arg.TagsJson, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getMarginBookmarksByTagAndAuthor = `-- name: GetMarginBookmarksByTagAndAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2 AND uri NOT LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $3 OFFSET $4`
type GetMarginBookmarksByTagAndAuthorParams struct { AuthorDid string `json:"authorDid"` TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetMarginBookmarksByTagAndAuthor(ctx context.Context, arg GetMarginBookmarksByTagAndAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getMarginBookmarksByTagAndAuthor, arg.AuthorDid, arg.TagsJson, arg.Limit, arg.Offset, ) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getPopularBookmarks = `-- name: GetPopularBookmarks :manySELECT b.uri, b.author_did, b.source, b.source_hash, b.title, b.description, b.tags_json, b.created_at, b.indexed_at, b.cidFROM all_bookmarks bLEFT JOIN LATERAL ( SELECT COUNT(*) as cnt FROM likes WHERE subject_uri = b.uri) l ON trueLEFT JOIN LATERAL ( SELECT COUNT(*) as cnt FROM replies WHERE root_uri = b.uri) r ON trueWHERE b.created_at > $1 AND (l.cnt + r.cnt) > 0ORDER BY (l.cnt + r.cnt) DESC, b.created_at DESCLIMIT $2 OFFSET $3`
type GetPopularBookmarksParams struct { CreatedAt time.Time `json:"createdAt"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetPopularBookmarks(ctx context.Context, arg GetPopularBookmarksParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getPopularBookmarks, arg.CreatedAt, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getRecentBookmarks = `-- name: GetRecentBookmarks :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksORDER BY created_at DESCLIMIT $1 OFFSET $2`
type GetRecentBookmarksParams struct { Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetRecentBookmarks(ctx context.Context, arg GetRecentBookmarksParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getRecentBookmarks, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getSembleBookmarks = `-- name: GetSembleBookmarks :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $1 OFFSET $2`
type GetSembleBookmarksParams struct { Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetSembleBookmarks(ctx context.Context, arg GetSembleBookmarksParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getSembleBookmarks, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getSembleBookmarksByAuthor = `-- name: GetSembleBookmarksByAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetSembleBookmarksByAuthorParams struct { AuthorDid string `json:"authorDid"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetSembleBookmarksByAuthor(ctx context.Context, arg GetSembleBookmarksByAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getSembleBookmarksByAuthor, arg.AuthorDid, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getSembleBookmarksByTag = `-- name: GetSembleBookmarksByTag :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE lower(tags_json)::jsonb ? $1 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $2 OFFSET $3`
type GetSembleBookmarksByTagParams struct { TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetSembleBookmarksByTag(ctx context.Context, arg GetSembleBookmarksByTagParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getSembleBookmarksByTag, arg.TagsJson, arg.Limit, arg.Offset) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getSembleBookmarksByTagAndAuthor = `-- name: GetSembleBookmarksByTagAndAuthor :manySELECT uri, author_did, source, source_hash, title, description, tags_json, created_at, indexed_at, cidFROM all_bookmarksWHERE author_did = $1 AND lower(tags_json)::jsonb ? $2 AND uri LIKE '%network.cosmik%'ORDER BY created_at DESCLIMIT $3 OFFSET $4`
type GetSembleBookmarksByTagAndAuthorParams struct { AuthorDid string `json:"authorDid"` TagsJson *string `json:"tagsJson"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetSembleBookmarksByTagAndAuthor(ctx context.Context, arg GetSembleBookmarksByTagAndAuthorParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getSembleBookmarksByTagAndAuthor, arg.AuthorDid, arg.TagsJson, arg.Limit, arg.Offset, ) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const getShelvedBookmarks = `-- name: GetShelvedBookmarks :manySELECT b.uri, b.author_did, b.source, b.source_hash, b.title, b.description, b.tags_json, b.created_at, b.indexed_at, b.cidFROM all_bookmarks bWHERE b.created_at < $1 AND b.created_at > $2 AND NOT EXISTS (SELECT 1 FROM likes WHERE subject_uri = b.uri) AND NOT EXISTS (SELECT 1 FROM replies WHERE root_uri = b.uri)ORDER BY RANDOM()LIMIT $3 OFFSET $4`
type GetShelvedBookmarksParams struct { CreatedAt time.Time `json:"createdAt"` CreatedAt_2 time.Time `json:"createdAt2"` Limit int32 `json:"limit"` Offset int32 `json:"offset"`}
func (q *Queries) GetShelvedBookmarks(ctx context.Context, arg GetShelvedBookmarksParams) ([]AllBookmark, error) { rows, err := q.db.Query(ctx, getShelvedBookmarks, arg.CreatedAt, arg.CreatedAt_2, arg.Limit, arg.Offset, ) if err != nil { return nil, err } defer rows.Close() var items []AllBookmark for rows.Next() { var i AllBookmark if err := rows.Scan( &i.Uri, &i.AuthorDid, &i.Source, &i.SourceHash, &i.Title, &i.Description, &i.TagsJson, &i.CreatedAt, &i.IndexedAt, &i.Cid, ); err != nil { return nil, err } items = append(items, i) } if err := rows.Err(); err != nil { return nil, err } return items, nil}
const updateBookmark = `-- name: UpdateBookmark :execUPDATE bookmarksSET title = $1, description = $2, tags_json = $3, cid = $4, indexed_at = $5WHERE uri = $6`
type UpdateBookmarkParams struct { Title *string `json:"title"` Description *string `json:"description"` TagsJson *string `json:"tagsJson"` Cid *string `json:"cid"` IndexedAt time.Time `json:"indexedAt"` Uri string `json:"uri"`}
func (q *Queries) UpdateBookmark(ctx context.Context, arg UpdateBookmarkParams) error { _, err := q.db.Exec(ctx, updateBookmark, arg.Title, arg.Description, arg.TagsJson, arg.Cid, arg.IndexedAt, arg.Uri, ) return err}