sql

package
v0.0.0-...-411bc7b Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Dec 30, 2025 License: AGPL-3.0 Imports: 47 Imported by: 4

Documentation

Index

Constants

View Source 
const (
	AssetContentsFTSCaseInsensitiveInsert = "INSERT INTO asset_contents_fts_case_insensitive (id, name, ext, path, size, updated, content) VALUES %s"
	AssetContentsPlaceholder              = "(?, ?, ?, ?, ?, ?, ?)"
)
View Source 
const (
	HistoriesFTSCaseInsensitiveInsert = "INSERT INTO histories_fts_case_insensitive (id, type, op, title, content, path, created) VALUES %s"
	HistoriesPlaceholder              = "(?, ?, ?, ?, ?, ?, ?)"
)
View Source 
const (
	BlocksInsert                   = "" /* 182-byte string literal not displayed */
	BlocksFTSInsert                = "" /* 186-byte string literal not displayed */
	BlocksFTSCaseInsensitiveInsert = "" /* 203-byte string literal not displayed */
	BlocksPlaceholder              = "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

	SpansInsert      = "INSERT INTO spans (id, block_id, root_id, box, path, content, markdown, type, ial) VALUES %s"
	SpansPlaceholder = "(?, ?, ?, ?, ?, ?, ?, ?, ?)"

	AssetsPlaceholder             = "(?, ?, ?, ?, ?, ?, ?, ?, ?)"
	AttributesPlaceholder         = "(?, ?, ?, ?, ?, ?, ?, ?)"
	RefsPlaceholder               = "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
	FileAnnotationRefsPlaceholder = "(?, ?, ?, ?, ?, ?, ?, ?, ?)"
)

Variables

View Source 
var (
	IndexIgnoreCached bool
)

Functions

func BatchGetBlockAttrs 

func BatchGetBlockAttrs(ids []string) (ret map[string]map[string]string)

func BatchGetBlockAttrsWitTrees 

func BatchGetBlockAttrsWitTrees(ids []string, trees map[string]*parse.Tree) (ret map[string]map[string]string)

func BatchRemoveAssetsQueue 

func BatchRemoveAssetsQueue(hashes []string)

func BatchRemoveTreeQueue 

func BatchRemoveTreeQueue(rootIDs []string)

func CacheRef 

func CacheRef(tree *parse.Tree, refNode *ast.Node)

func ClearCache 

func ClearCache()

func ClearQueue 

func ClearQueue()

func CloseDatabase 

func CloseDatabase()

func DefRefs 

func DefRefs(condition string, limit int) (ret []map[*Block]*Block)

func DeleteAssetContentsByPathQueue 

func DeleteAssetContentsByPathQueue(path string)

func DeleteBoxQueue 

func DeleteBoxQueue(boxID string)

func DeleteBoxRefsQueue 

func DeleteBoxRefsQueue(boxID string)

func DeleteOutdatedHistories 

func DeleteOutdatedHistories(before int64)

func DeleteRefsTreeQueue 

func DeleteRefsTreeQueue(tree *parse.Tree)

func FillAttributeViewNilValue 

func FillAttributeViewNilValue(value *av.Value, typ av.KeyType)

func FlushAssetContentQueue 

func FlushAssetContentQueue()

func FlushAssetContentTxJob 

func FlushAssetContentTxJob()

func FlushHistoryQueue 

func FlushHistoryQueue()

func FlushHistoryTxJob 

func FlushHistoryTxJob()

func FlushQueue 

func FlushQueue()

func FlushTxJob 

func FlushTxJob()

func GetBlockAttrs 

func GetBlockAttrs(id string) (ret map[string]string)

func GetContainerText 

func GetContainerText(container *ast.Node) string

func GetDuplicatedRootIDs 

func GetDuplicatedRootIDs(blocksTable string) (ret []string)

func GetFurtherCollections 

func GetFurtherCollections(attrView *av.AttributeView, cachedAttrViews map[string]*av.AttributeView) (ret map[string]av.Collection)

func GetRefDuplicatedDefRootIDs 

func GetRefDuplicatedDefRootIDs() (ret []string)

func GetRefText 

func GetRefText(defBlockID string) (ret string)

func GetRootUpdated 

func GetRootUpdated() (ret map[string]string, err error)

func GetTemplateKeyRelevantKeys 

func GetTemplateKeyRelevantKeys(attrView *av.AttributeView, templateKey *av.Key) (ret []*av.Key)

func GetTemplateKeysByResolutionOrder 

func GetTemplateKeysByResolutionOrder(attrView *av.AttributeView) (ret []*av.Key, resolved bool)

func IndexAssetContentsQueue 

func IndexAssetContentsQueue(assetContents []*AssetContent)

func IndexHistoriesQueue 

func IndexHistoriesQueue(histories []*History)

func IndexNodeQueue 

func IndexNodeQueue(id string)

func IndexTreeQueue 

func IndexTreeQueue(tree *parse.Tree)

func InitAssetContentDatabase 

func InitAssetContentDatabase(forceRebuild bool)

func InitDatabase 

func InitDatabase(forceRebuild bool) (err error)

func InitHistoryDatabase 

func InitHistoryDatabase(forceRebuild bool)

func NodeStaticContent 

func NodeStaticContent(node *ast.Node, excludeTypes []string, includeTextMarkATitleURL, includeAssetPath, fullAttrView bool) string

func Query 

func Query(stmt string, limit int) (ret []map[string]interface{}, err error)

func QueryAssetContentNoLimit 

func QueryAssetContentNoLimit(stmt string) (ret []map[string]interface{}, err error)

func QueryBlockAliases 

func QueryBlockAliases(rootID string) (ret []string)

func QueryBlockDefIDsByRefText 

func QueryBlockDefIDsByRefText(refText string, excludeIDs []string) (ret []string)

func QueryBlockNamesByRootID 

func QueryBlockNamesByRootID(rootID string) (ret []string)

func QueryBookmarkLabels 

func QueryBookmarkLabels() (ret []string)

func QueryChildDefIDsByRootDefID 

func QueryChildDefIDsByRootDefID(rootDefID string) (ret []string)

func QueryChildRefDefIDsByRootDefID 

func QueryChildRefDefIDsByRootDefID(rootDefID string) (ret map[string][]string)

func QueryHistory 

func QueryHistory(stmt string) (ret []map[string]interface{}, err error)

func QueryNoLimit 

func QueryNoLimit(stmt string) (ret []map[string]interface{}, err error)

func QueryRefCount 

func QueryRefCount(defIDs []string) (ret map[string]int)

func QueryRefIDsByAnnotationID 

func QueryRefIDsByAnnotationID(annotationID string) (refIDs []string)

func QueryRefIDsByDefID 

func QueryRefIDsByDefID(defID string, containChildren bool) (refIDs []string)

func QueryRefRootBlocksByDefRootIDs 

func QueryRefRootBlocksByDefRootIDs(defRootIDs []string) (ret map[string][]*Block)

func QueryRootBlockRefCount 

func QueryRootBlockRefCount() (ret map[string]int)

func QueryRootChildrenRefCount 

func QueryRootChildrenRefCount(defRootID string) (ret map[string]int)

func QueryVirtualRefKeywords 

func QueryVirtualRefKeywords(name, alias, anchor, doc bool, searchIgnoreLines, refSearchIgnoreLines []string) (ret []string)

func RemoveTreePathQueue 

func RemoveTreePathQueue(treeBox, treePathPrefix string)

func RemoveTreeQueue 

func RemoveTreeQueue(rootID string)

func RenameSubTreeQueue 

func RenameSubTreeQueue(tree *parse.Tree)

func RenameTreeQueue 

func RenameTreeQueue(tree *parse.Tree)

func RenderAttributeViewGallery 

func RenderAttributeViewGallery(attrView *av.AttributeView, view *av.View, query string, depth *int, cachedAttrViews map[string]*av.AttributeView) (ret *av.Gallery)

func RenderAttributeViewKanban 

func RenderAttributeViewKanban(attrView *av.AttributeView, view *av.View, query string, depth *int, cachedAttrViews map[string]*av.AttributeView) (ret *av.Kanban)

func RenderAttributeViewTable 

func RenderAttributeViewTable(attrView *av.AttributeView, view *av.View, query string, depth *int, cachedAttrViews map[string]*av.AttributeView) (ret *av.Table)

func RenderGroupView 

func RenderGroupView(attrView *av.AttributeView, view, groupView *av.View, query string) (ret av.Viewable)

func RenderView 

func RenderView(attrView *av.AttributeView, view *av.View, query string) (ret av.Viewable)

func SQLTemplateFuncs 

func SQLTemplateFuncs(templateFuncMap *template.FuncMap)

func SetCaseSensitive 

func SetCaseSensitive(b bool)

func SetIndexAssetPath 

func SetIndexAssetPath(b bool)

func UpdateBlockContentQueue 

func UpdateBlockContentQueue(block *Block)

func UpdateRefsTreeQueue 

func UpdateRefsTreeQueue(tree *parse.Tree)

func UpsertTreeQueue 

func UpsertTreeQueue(tree *parse.Tree)

func Vacuum 

func Vacuum()

func WaitFlushTx 

func WaitFlushTx()

Types

type Asset 

type Asset struct {
	ID      string
	BlockID string
	RootID  string
	Box     string
	DocPath string
	Path    string
	Name    string
	Title   string
	Hash    string
}

func QueryAssetByHash 

func QueryAssetByHash(hash string) (ret *Asset)

type AssetContent 

type AssetContent struct {
	ID      string
	Name    string
	Ext     string
	Path    string
	Size    int64
	Updated int64
	Content string
}

func SelectAssetContentsRawStmt 

func SelectAssetContentsRawStmt(stmt string, page, limit int) (ret []*AssetContent)

func SelectAssetContentsRawStmtNoParse 

func SelectAssetContentsRawStmtNoParse(stmt string, limit int) (ret []*AssetContent)

type Attribute 

type Attribute struct {
	ID      string
	Name    string
	Value   string
	Type    string
	BlockID string
	RootID  string
	Box     string
	Path    string
}

type Block 

type Block struct {
	ID       string
	ParentID string
	RootID   string
	Hash     string
	Box      string
	Path     string
	HPath    string
	Name     string
	Alias    string
	Memo     string
	Tag      string
	Content  string
	FContent string
	Markdown string
	Length   int
	Type     string
	SubType  string
	IAL      string
	Sort     int
	Created  string
	Updated  string
}

func BuildBlockFromNode 

func BuildBlockFromNode(n *ast.Node, tree *parse.Tree) (block *Block)

func GetAllChildBlocks 

func GetAllChildBlocks(rootIDs []string, condition string, limit int) (ret []*Block)

func GetAllRootBlocks 

func GetAllRootBlocks() (ret []*Block)

func GetBlock 

func GetBlock(id string) (ret *Block)

func GetBlocks 

func GetBlocks(ids []string) (ret []*Block)

func GetChildBlocks 

func GetChildBlocks(parentID, condition string, limit int) (ret []*Block)

func QueryBookmarkBlocks 

func QueryBookmarkBlocks() (ret []*Block)

func QueryBookmarkBlocksByKeyword 

func QueryBookmarkBlocksByKeyword(bookmark string) (ret []*Block)

func QueryDefRootBlocksByRefRootID 

func QueryDefRootBlocksByRefRootID(refRootID string) (ret []*Block)

func QueryEmptyContentEmbedBlocks 

func QueryEmptyContentEmbedBlocks() (ret []*Block)

func QueryRootBlockByCondition 

func QueryRootBlockByCondition(condition string, limit int) (ret []*Block)

func SelectBlocksRawStmt 

func SelectBlocksRawStmt(stmt string, page, limit int) (ret []*Block)

func SelectBlocksRawStmtNoParse 

func SelectBlocksRawStmtNoParse(stmt string, limit int) (ret []*Block)

func SelectBlocksRegex 

func SelectBlocksRegex(stmt string, exp *regexp.Regexp, name, alias, memo, ial bool, page, pageSize int) (ret []*Block)

func ToBlocks 

func ToBlocks(result []map[string]interface{}) (ret []*Block)

func (*Block) IsContainerBlock 

func (block *Block) IsContainerBlock() bool

type FileAnnotationRef 

type FileAnnotationRef struct {
	ID           string
	FilePath     string
	AnnotationID string
	BlockID      string
	RootID       string
	Box          string
	Path         string
	Content      string
	Type         string
}

type History 

type History struct {
	ID      string
	Type    int
	Op      string
	Title   string
	Content string
	Created string
	Path    string
}

func SelectHistoriesRawStmt 

func SelectHistoriesRawStmt(stmt string) (ret []*History)

type Ref 

type Ref struct {
	ID               string
	DefBlockID       string
	DefBlockParentID string
	DefBlockRootID   string
	DefBlockPath     string
	BlockID          string
	RootID           string
	Box              string
	Path             string
	Content          string
	Markdown         string
	Type             string
}

func GetRefsCacheByDefID 

func GetRefsCacheByDefID(defID string) (ret []*Ref)

func QueryRefsByDefID 

func QueryRefsByDefID(defBlockID string, containChildren bool) (ret []*Ref)

func QueryRefsByDefIDRefID 

func QueryRefsByDefIDRefID(defBlockID, refBlockID string) (ret []*Ref)

func QueryRefsRecent 

func QueryRefsRecent(onlyDoc bool, typeFilter string, ignoreLines []string) (ret []*Ref)

type Span 

type Span struct {
	ID       string
	BlockID  string
	RootID   string
	Box      string
	Path     string
	Content  string
	Markdown string
	Type     string
	IAL      string
}

func QueryTagSpans 

func QueryTagSpans(p string) (ret []*Span)

func QueryTagSpansByKeyword 

func QueryTagSpansByKeyword(keyword string, limit int) (ret []*Span)

func QueryTagSpansByLabel 

func QueryTagSpansByLabel(label string) (ret []*Span)

func SelectSpansRawStmt 

func SelectSpansRawStmt(stmt string, limit int) (ret []*Span)

type Stat 

type Stat struct {
	Key string `json:"key"`
	Val string `json:"value"`
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.