;;; org-gnosis.el --- Org Note Management System -*- lexical-binding: t; -*- ;; Copyright (C) 2024-2025 Thanos Apollo ;; Author: Thanos Apollo ;; Keywords: extensions ;; URL: https://thanosapollo.org/projects/gnosis ;; Version: 0.0.1 ;; Package-Requires: ((emacs "27.2") (emacsql "4.0.3") (compat "29.1.4.2")) ;; This program is free software; you can redistribute it and/or modify ;; it under the terms of the GNU General Public License as published by ;; the Free Software Foundation, either version 3 of the License, or ;; (at your option) any later version. ;; This program is distributed in the hope that it will be useful, ;; but WITHOUT ANY WARRANTY; without even the implied warranty of ;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the ;; GNU General Public License for more details. ;; You should have received a copy of the GNU General Public License ;; along with this program. If not, see . ;;; Commentary: ;; Under development ;;; Code: (require 'cl-lib) (require 'emacsql-sqlite) (require 'org-element) (defgroup org-gnosis nil "Note Taking System." :group 'external) (defcustom org-gnosis-dir "~/Notes" "Directory with gnosis notes." :type 'directory :group 'org-gnosis) (defcustom org-gnosis-show-tags nil "Display tags with `org-gnosis-find'." :type 'boolean :group 'org-gnosis) (defface org-gnosis-face-tags '((t :inherit font-lock-type-face)) "Face for displaying gnosis with `org-gnosis-find'." :group 'org-gnosis) (defvar org-gnosis-db (emacsql-sqlite-open (locate-user-emacs-file "org-gnosis.db"))) (cl-defun org-gnosis-select (value table &optional (restrictions '1=1) (flatten nil)) "Select VALUE from TABLE, optionally with RESTRICTIONS. Optional argument FLATTEN, when non-nil, flattens the result." (let ((output (emacsql org-gnosis-db `[:select ,value :from ,table :where ,restrictions]))) (if flatten (apply #'append output) output))) (cl-defun org-gnosis--insert-into (table values) "Insert VALUES to TABLE." (emacsql org-gnosis-db `[:insert :into ,table :values ,values])) (defun org-gnosis--delete (table value) "From TABLE use where to delete VALUE." (emacsql org-gnosis-db `[:delete :from ,table :where ,value])) (cl-defun org-gnosis--drop-table (table) "Drop TABLE from `gnosis-db'." (emacsql org-gnosis-db `[:drop-table ,table])) (defun org-gnosis-get-current-node-title () "Return the title of the current node." (when (derived-mode-p 'org-mode) (let* ((parsed-data (org-element-parse-buffer)) (title (org-element-map parsed-data 'keyword (lambda (kw) (when (string-equal (org-element-property :key kw) "TITLE") (org-element-property :value kw))) nil t))) title))) (defun org-gnosis-get-filetags (&optional parsed-data) "Return the filetags of the buffer's PARSED-DATA as a comma-separated string." (let* ((parsed-data (or parsed-data (org-element-parse-buffer))) (filetags (org-element-map parsed-data 'keyword (lambda (kw) (when (string-equal (org-element-property :key kw) "FILETAGS") (org-element-property :value kw))) nil t))) (when filetags (mapconcat 'identity (split-string filetags "[:\s]+" t) ",")))) (defun org-gnosis-process-node (node) "Process a single headline NODE and return information as a list." (let ((title (org-element-property :raw-value node)) (tags (org-element-property :tags node)) (id (org-element-property :ID node)) (children (org-element-contents node))) (when title (list title tags id (org-gnosis-process-children children (1+ (org-element-property :level node))))))) (defun org-gnosis-process-children (nodes level) "Recursively process NODES at a given LEVEL." (let (result) (while nodes (let ((current-node (car nodes)) (current-level (org-element-property :level (car nodes)))) (if (and current-level (= current-level level)) (progn (push (org-gnosis-process-node current-node) result) (setq nodes (cdr nodes))) (setq nodes (cdr nodes))))) (nreverse result))) (defun org-gnosis-get-data--nodes (&optional parsed-data) "Return a hierarchical list of nodes with titles, tags, and IDs from PARSED-DATA." (let ((parsed-data (or parsed-data (org-element-parse-buffer)))) (org-gnosis-process-children (org-element-map parsed-data 'headline #'identity) 1))) (defun org-gnosis-get-data--topic (&optional parsed-data) "Retrieve the title and ID from the current org buffer or given PARSED-DATA." (let* ((parsed-data (or parsed-data (org-element-parse-buffer))) (title (org-element-map parsed-data 'keyword (lambda (kw) (when (string= (org-element-property :key kw) "TITLE") (org-element-property :value kw))) nil t)) (id (org-element-map parsed-data 'property-drawer (lambda (drawer) (org-element-map (org-element-contents drawer) 'node-property (lambda (prop) (when (string= (org-element-property :key prop) "ID") (org-element-property :value prop))) nil t)) nil t)) (tags (org-gnosis-get-filetags))) (list title tags id))) (defun org-gnosis-get--data (file) "Return data for FILE. FILE: File path" (let* ((parsed-data (org-element-parse-buffer)) (topic (org-gnosis-get-data--topic parsed-data)) (nodes (org-gnosis-get-data--nodes parsed-data)) (filename (file-name-nondirectory file))) `(:file ,filename :topic ,topic :nodes ,nodes))) (defun org-gnosis-adjust-title (input) "Adjust the INPUT string to replace id link structures with plain text." (replace-regexp-in-string "\\[\\[id:[^]]+\\]\\[\\(.*?\\)\\]\\]" "\\1" input)) (defun org-gnosis-get-file-info (filename) "Something FILENAME." (with-temp-buffer (insert-file-contents filename) (let* ((data (org-gnosis-get--data filename))) data))) (defun org-gnosis-parse-nodes (nodes top-node-id inherited-tags) "Parse a list of nodes, inheriting tags and associating the top node ID. NODES: list of nodes to parse. TOP-NODE-ID: the ID of the top node to associate with each node. INHERITED-TAGS: tags from the top node to inherit." (cl-loop for (name tags id sub-nodes) in nodes ;; Only include nodes with non-nil id when id append (list (list :node name :tags (append tags inherited-tags) :id id :top-node top-node-id)) ;; Recursively parse sub-nodes, inheriting current node's tags append (org-gnosis-parse-nodes sub-nodes (when id id) (append tags inherited-tags)))) (defun org-gnosis-parse-data-recursive (data &optional initial-tags) "Recursively parse the entire data structure, extracting nodes and details. DATA: List of top-level nodes to start parsing. INITIAL-TAGS: Initial set of tags to inherit." (cl-loop for (node tags id sub-nodes) in data ;; Directly parse sub-nodes, using top-level nodes only if they have valid id append (when id (list (list :node node :tags (append tags initial-tags) :id id :top-node nil))) append (org-gnosis-parse-nodes sub-nodes id (append tags initial-tags)))) (defun org-gnosis-db-sync () "Sync `org-gnosis-db'." (interactive) (let ((files (cl-remove-if-not (lambda (file) (and (string-match-p "^[0-9]" (file-name-nondirectory file)) (not (file-directory-p file)))) (directory-files org-gnosis-dir t nil t)))) (cl-loop for file in files do ;; Add gnosis topic (let* ((data (org-gnosis-get-file-info file)) (file (plist-get data :file)) (topic (org-gnosis-adjust-title (nth 0 (plist-get data :topic)))) (tags (nth 1 (plist-get data :topic))) (hash (nth 2 (plist-get data :topic)))) (emacsql-with-transaction org-gnosis-db (org-gnosis--insert-into 'nodes `([,hash ,file ,topic ,tags]))) ;; Add nodes (cl-loop for node in (org-gnosis-parse-data-recursive (plist-get data :nodes)) do (let ((title (org-gnosis-adjust-title (plist-get node :node))) (tags (plist-get node :tags)) (id (plist-get node :id))) (emacsql-with-transaction org-gnosis-db (org-gnosis--insert-into 'nodes `([,id ,file ,title ,tags]))) (message "ok"))))))) (defun org-gnosis-find--tag-with-tag-prop (lst) "Combine each sublist of strings in LST into a single string." (mapcar (lambda (sublist) (mapconcat (lambda (element) (let ((str (if (stringp element) element (format "%s" element)))) ;; Convert to string if necessary (if (eq element (car sublist)) str (propertize (replace-regexp-in-string "," "#" str) 'face 'org-gnosis-face-tags)))) (cl-remove-if-not #'identity sublist) ;; Remove nil values (format " %s" (propertize "#" 'face 'org-gnosis-face-tags)))) lst)) (defun org-gnosis-find--with-tags () "Select gnosis node with tags." (replace-regexp-in-string " #[^[:space:]]+" "" (completing-read "Select gnosis node: " (org-gnosis-find--tag-with-tag-prop (org-gnosis-select '[title tags] 'nodes))))) (defun org-gnosis-find () "Select gnosis node." (interactive) (let* ((title (if org-gnosis-show-tags (org-gnosis-find--with-tags) (completing-read "Select gnosis node: " (org-gnosis-select 'title 'nodes)))) (file (caar (org-gnosis-select 'file 'nodes `(= title ,title)))) (id (caar (org-gnosis-select 'id 'nodes `(= title ,title))))) (find-file (expand-file-name file org-gnosis-dir) ;; (ignore-errors (org-id-goto id))))) ;; Org-Gnosis Database (defconst org-gnosis-db-version 1) (defconst org-gnosis-db--table-schemata '((nodes ([(id :not-null :primary-key) (file :not-null) (title text) tags])) (refs ([(node-id :not-null) (ref :not-null) (type :not-null)] (:foreign-key [node-id] :references nodes [id] :on-delete :cascade))) (links ([(source :not-null) (dest :not-null)] (:foreign-key [source] :references nodes [id] :on-delete :cascade))))) (defconst org-gnosis-db--table-indices '((refs-node-id refs [node-id]))) (defun org-gnosis-db-init () "Initialize database DB with the correct schema and user version." (unless (length= (emacsql org-gnosis-db [:select name :from sqlite-master :where (= type table)]) 3) (emacsql-with-transaction org-gnosis-db (pcase-dolist (`(,table ,schema) org-gnosis-db--table-schemata) (emacsql org-gnosis-db [:create-table $i1 $S2] table schema)) (pcase-dolist (`(,index-name ,table ,columns) org-gnosis-db--table-indices) (emacsql org-gnosis-db [:create-index $i1 :on $i2 $S3] index-name table columns)) (emacsql org-gnosis-db [:pragma (= user-version org-gnosis-db-version)])))) (org-gnosis-db-init) (provide 'org-gnosis) ;;; org-gnosis.el ends here