Muupi Emacs

;;; After Prot is Me
;; More settings
(setopt auto-save-default nil)
(setopt column-number-mode t)
(setopt create-lockfiles nil) ;; http://xahlee.info/emacs/emacs/emacs_auto-save_backup.html
(setopt indent-tabs-mode nil)
(setopt inhibit-startup-message t)
(setopt make-backup-files nil)
(setopt mouse-autoselect-window t)
(setopt scroll-conservatively 101)
(setopt tab-bar-show 1) ; [2025年05月11日 Sun 03:37] Only show tab bar when more than 1 tab exists.
(electric-pair-mode 1)
(global-auto-revert-mode 1)
(recentf-mode 1)
(save-place-mode 1)
(winner-mode 1)
;; .common-lisp files
(add-to-list 'auto-mode-alist '("\\.common-lisp\\'" . common-lisp-mode))

(use-package ace-window
 :ensure t
 :config
 (global-set-key (kbd "M-o") 'ace-window)
 (setopt ace-window-display-mode nil))

(use-package consult
 :ensure t
 ;; Replace bindings. Lazily loaded by `use-package'.
 :bind (;; C-c bindings in `mode-specific-map'
 ("C-c M-x" . consult-mode-command)
 ("C-c h" . consult-history)
 ("C-c k" . consult-kmacro)
 ("C-c m" . consult-man)
 ("C-c i" . consult-info)
 ([remap Info-search] . consult-info)
 ;; C-x bindings in `ctl-x-map'
 ("C-x M-:" . consult-complex-command) ;; orig. repeat-complex-command
 ("C-x b" . consult-buffer) ;; orig. switch-to-buffer
 ("C-x 4 b" . consult-buffer-other-window) ;; orig. switch-to-buffer-other-window
 ("C-x 5 b" . consult-buffer-other-frame) ;; orig. switch-to-buffer-other-frame
 ("C-x t b" . consult-buffer-other-tab) ;; orig. switch-to-buffer-other-tab
 ("C-x r b" . consult-bookmark) ;; orig. bookmark-jump
 ("C-x p b" . consult-project-buffer) ;; orig. project-switch-to-buffer
 ;; Custom M-# bindings for fast register access
 ("M-#" . consult-register-load)
 ("M-'" . consult-register-store) ;; orig. abbrev-prefix-mark (unrelated)
 ("C-M-#" . consult-register)
 ;; Other custom bindings
 ("M-y" . consult-yank-pop) ;; orig. yank-pop
 ;; M-g bindings in `goto-map'
 ("M-g e" . consult-compile-error)
 ("M-g f" . consult-flymake) ;; Alternative: consult-flycheck
 ("M-g g" . consult-goto-line) ;; orig. goto-line
 ("M-g M-g" . consult-goto-line) ;; orig. goto-line
 ("M-g o" . consult-outline) ;; Alternative: consult-org-heading
 ("M-g m" . consult-mark)
 ("M-g k" . consult-global-mark)
 ("M-g i" . consult-imenu)
 ("M-g I" . consult-imenu-multi)
 ;; M-s bindings in `search-map'
 ("M-s d" . consult-find) ;; Alternative: consult-fd
 ("M-s c" . consult-locate)
 ("M-s g" . consult-grep)
 ("M-s G" . consult-git-grep)
 ("M-s r" . consult-ripgrep)
 ("M-s l" . consult-line)
 ("M-s L" . consult-line-multi)
 ("M-s k" . consult-keep-lines)
 ("M-s u" . consult-focus-lines)
 ;; Isearch integration
 ("M-s e" . consult-isearch-history)
 :map isearch-mode-map
 ("M-e" . consult-isearch-history) ;; orig. isearch-edit-string
 ("M-s e" . consult-isearch-history) ;; orig. isearch-edit-string
 ("M-s l" . consult-line) ;; needed by consult-line to detect isearch
 ("M-s L" . consult-line-multi) ;; needed by consult-line to detect isearch
 ;; Minibuffer history
 :map minibuffer-local-map
 ("M-s" . consult-history) ;; orig. next-matching-history-element
 ("M-r" . consult-history)) ;; orig. previous-matching-history-element
 ;; Enable automatic preview at point in the *Completions* buffer. This is
 ;; relevant when you use the default completion UI.
 :hook (completion-list-mode . consult-preview-at-point-mode)
 ;; The :init configuration is always executed (Not lazy)
 :init
 ;; Tweak the register preview for `consult-register-load',
 ;; `consult-register-store' and the built-in commands. This improves the
 ;; register formatting, adds thin separator lines, register sorting and hides
 ;; the window mode line.
 (advice-add #'register-preview :override #'consult-register-window)
 (setq register-preview-delay 0.5)
 ;; Use Consult to select xref locations with preview
 (setq xref-show-xrefs-function #'consult-xref
 xref-show-definitions-function #'consult-xref)
 ;; Configure other variables and modes in the :config section,
 ;; after lazily loading the package.
 :config
 ;; Optionally configure preview. The default value
 ;; is 'any, such that any key triggers the preview.
 ;; (setq consult-preview-key 'any)
 ;; (setq consult-preview-key "M-.")
 ;; (setq consult-preview-key '("S-<down>" "S-<up>"))
 ;; For some commands and buffer sources it is useful to configure the
 ;; :preview-key on a per-command basis using the `consult-customize' macro.
 (consult-customize
 consult-theme :preview-key '(:debounce 0.2 any)
 consult-ripgrep consult-git-grep consult-grep consult-man
 consult-bookmark consult-recent-file consult-xref
 consult--source-bookmark consult--source-file-register
 consult--source-recent-file consult--source-project-recent-file
 ;; :preview-key "M-."
 :preview-key '(:debounce 0.4 any))
 ;; Optionally configure the narrowing key.
 ;; Both < and C-+ work reasonably well.
 (setq consult-narrow-key "<") ;; "C-+"
 ;; Optionally make narrowing help available in the minibuffer.
 ;; You may want to use `embark-prefix-help-command' or which-key instead.
 ;; (keymap-set consult-narrow-map (concat consult-narrow-key " ?") #'consult-narrow-help)
 )

(use-package corfu-terminal
 :ensure t
 :config
 (unless (display-graphic-p)
 (corfu-terminal-mode 1)))

(use-package editorconfig
 :ensure t
 :config
 (editorconfig-mode 1))

(use-package jq-mode
 :ensure t
 :defer t)

(use-package magit
 :ensure t
 :defer t)

;; https://blog.bitsandbobs.net/blog/emacs-markdown-live-preview/
(use-package markdown-mode
 :ensure t
 :mode ("\\.md\\'" . gfm-mode)
 :commands (markdown-mode gfm-mode)
 :config
 (if (executable-find "pandoc")
 (setq markdown-command "pandoc -t html5")))

(use-package olivetti
 :ensure t
 :config
 (setopt olivetti-body-width 0.75))
(defun greentext ()
 "Highlight >greentext in current buffer."
 (interactive)
 (highlight-lines-matching-regexp "^\s*>" 'hi-green-b))
(use-package org
 :ensure nil
 :hook ((org-mode . olivetti-mode)
 (org-mode . greentext))
 :config
 (setopt
 org-indent-mode t
 org-auto-align-tags nil
 org-tags-column 0
 org-edit-src-content-indentation 0 ; INFO: This is a must-have for src blocks.
 org-imenu-depth 4)
 ;; https://www.reddit.com/r/emacs/comments/1es353x/comment/li5ufbo/
 ;; - removed /italic/.
 ;; - I might remove _underline_ too.
 (setq-default org-emphasis-alist '(("*" bold)
 ("_" underline)
 ("=" org-verbatim verbatim)
 ("~" org-code verbatim)
 ("+" (:strike-through t))))
 ;; keybinding
 (global-set-key (kbd "C-c l") 'org-store-link)
 ;; org-babel
 (setq org-confirm-babel-evaluate nil)
 (org-babel-do-load-languages
 'org-babel-load-languages '(
 (emacs-lisp . t)
 (jq . t)
 (lisp . t) ; I needed this.
 (perl . t)
 (shell . t)
 (sql . t)
 ))
 (setq org-babel-lisp-eval-fn #'sly-eval)
 )

(use-package paredit
 :ensure t
 :defer t)

(use-package prog-mode
 :ensure nil
 :hook ((prog-mode . hs-minor-mode) ; This makes things foldable without installing extras.
 (prog-mode . hl-line-mode))
 )

;; If you already have your own Emacs config but are keen to give
;; Common Lisp a try, just copy this sly config into your own.
;; It will make sly's window placement more predictable.
(use-package sly
 :ensure t
 :config
 (let ((patterns '(("\\*sly-mrepl"
 (display-buffer-in-side-window)
 (side . bottom)
 (slot . 0)
 (window-height . 18))
 ("\\*sly-db"
 (display-buffer-in-side-window)
 (side . bottom)
 (slot . 1))
 ("\\*sly-inspector"
 (display-buffer-in-side-window)
 (side . right)
 (slot . 1)
 (window-width . 80))
 ("\\*sly-description"
 (display-buffer-in-side-window)
 (side . right)
 (slot . 0)
 (window-width . 80)))))
 (cl-loop for p in patterns
 do (add-to-list 'display-buffer-alist p)))
 (setopt inferior-lisp-program "/usr/bin/sbcl"))

(use-package undo-fu
 :ensure t
 :config
 (global-unset-key (kbd "C-z"))
 (global-set-key (kbd "C-z") 'undo-fu-only-undo)
 (global-set-key (kbd "C-S-z") 'undo-fu-only-redo)
 (global-set-key (kbd "C-.") 'undo-fu-only-redo)
 (global-set-key (kbd "<f7>") 'undo-fu-only-undo)
 (global-set-key (kbd "<f9>") 'undo-fu-only-redo))

(use-package which-key
 :ensure t
 :config
 (which-key-mode 1))

(use-package yasnippet
 :ensure t
 :config
 (yas-global-mode 1))
(use-package yasnippet-snippets
 :ensure t)

(let ((mono-spaced-font "Monospace")
 (proportionately-spaced-font "Sans"))
 (set-face-attribute 'default nil :family mono-spaced-font :height 100)
 (set-face-attribute 'fixed-pitch nil :family mono-spaced-font :height 1.0)
 (set-face-attribute 'variable-pitch nil :family proportionately-spaced-font :height 1.0))

;; This has many useful functions, but today, we just want `-compose'.
;; https://github.com/magnars/dash.el
(use-package dash
 :ensure t)
(use-package sql
 :ensure nil
 :config
 ;; [2025年05月13日 Tue 06:27] MariaDB prompts were getting accidentally deleted without this.
 ;; https://emacs.stackexchange.com/a/14158/37580
 (setopt comint-prompt-read-only t)
 (add-to-list
 'sql-product-alist
 '(sqlite :name "SQLite"
 :free-software t
 :font-lock sql-mode-sqlite-font-lock-keywords
 :sqli-program sql-sqlite-program
 :sqli-options sql-sqlite-options
 :sqli-login sql-sqlite-login-params
 :sqli-comint-func sql-comint-sqlite
 :list-all ".tables"
 :list-table ".schema %s"
 :completion-object sql-sqlite-completion-object
 :prompt-regexp "^sqlite> "
 :prompt-length 8
 :prompt-cont-regexp "^ \\.\\.\\.> "
 :input-filter sql-placeholders-filter))
 (add-to-list
 'sql-product-alist
 '(mariadb :name "MariaDB"
 :free-software t
 :font-lock sql-mode-mariadb-font-lock-keywords
 :sqli-program sql-mariadb-program
 :sqli-options sql-mariadb-options
 :sqli-login sql-mariadb-login-params
 :sqli-comint-func sql-comint-mariadb
 :list-all "SHOW TABLES;"
 :list-table "DESCRIBE %s;"
 :prompt-regexp "^MariaDB \\[.*]> "
 :prompt-cont-regexp "^ [\"'`-]> "
 :syntax-alist ((35 . "< b"))
 :input-filter (-compose sql-remove-tabs-filter sql-placeholders-filter))))
;; This provides perfect and aesthetic SQL indentation
;; especially for multiline statements. Hit TAB and
;; it'll line things up beautifully.
;; Highly recommended.
(use-package sql-indent
 :ensure t
 :hook ((sql-mode . sqlind-minor-mode)))
;; This automatically capitalizes SQL keywords and functions as you type.
;; This is nice when it works, but it is imperfect.
;; Try it out.
;; If you don't like it, remove it.
(use-package sqlup-mode
 :ensure t
 :hook ((sql-mode . sqlup-mode)
 (sql-interactive-mode . sqlup-mode))
 :config
 (setq sqlup-blacklist '("name" "user" "binary" "changes"
 "check" "connection" "open" "output"
 "parameter" "read" "schema" "session"
 "system")))

-- list users with names shorter than `n`
SELECTid,username,LENGTH(username)ASlenFROMusersWHERELENGTH(username)<=&n-- placeholders start with &
ORDERBYlenDESC;

;; Setting up named connections.
(setq sql-connection-alist `(("muupi"
 (sql-product 'mariadb)
 (sql-user ,(getenv "MUUPI_UNAME"))
 (sql-password ,(getenv "MUUPI_PASSWD"))
 (sql-server "localhost")
 (sql-database "muupi"))))