Something went wrong. Try again.
(READ ONLY) Margin is an open annotation layer for the internet. Powered by the AT Protocol.
margin.at
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}