source: dotfiles/emacs/.emacs.d/.emacs-config.org@ fde9de8

#+TITLE: Emacs configuration
#+AUTHOR: Kirillov <w96k.dev> Mikhail
#+OPTIONS: toc:nil
#+PROPERTY: header-args:elisp :results silent
#+STARTUP: showeverything

* About this Emacs configuration

Configuration uses org-mode to tangle its contents to init.el and then
be used by emacs. I use guix home for my emacs config on gnu guix
system.

If you see :tangle nil it means that snippet is not used anymore, but
it is left because it might be valuable in a future for me.

This configuration is available here:
https://w96k.dev/emacs.html

The git source code is hosted on Sourcehut:
https://git.sr.ht/~w96k/dotfiles/tree/master/item/emacs

The license of emacs config and dotfiles is CC0 which is Public Domain.

** Packets
Only needed when I need to install a package from Melpa and not GNU Guix
#+begin_src elisp :tangle nil
  (require 'package)

  (setq package-archives '(("gnu" . "http://elpa.gnu.org/packages/")
                     ("melpa" . "http://melpa.org/packages/")))

  (when (< emacs-major-version 27)
    (package-initialize))

  (require 'gnutls)
#+end_src

** EXWM

#+begin_src emacs-lisp :tangle nil
  (require 'exwm)
  (require 'exwm-config)
  (exwm-config-example)
#+end_src


** Init.el
#+begin_src emacs-lisp :tangle init.el
  ;; -*- lexical-binding: t -*-

  ;; Show/Hide errors
  ;; (setq debug-on-error nil)
  ;; (setq debug-on-quit nil)

  ;; Timer
  (add-hook 'emacs-startup-hook
            (lambda ()
              (message
               "Emacs ready in %s with %d garbage collections."
               (format "%.2f seconds"
                       (float-time
                        (time-subtract after-init-time before-init-time)))
               gcs-done)))

  ;; Dont ask when following symlinks
  (setq vc-follow-symlinks t)

  ;; Load your custom settings
  (setq custom-file "~/.emacs.d/custom-settings.el")
  (load custom-file t)
#+end_src

* Meta
** About me
#+BEGIN_SRC emacs-lisp :tangle init.el
  ;; Information about me
  (setq user-full-name "Mikhail Kirillov"
        user-mail-address "w96k@runbox.com")
#+END_SRC

** Configuration
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq config-dotfiles-path "/home/w96k/projects/dotfiles/emacs/.emacs.d/"
        config-path "~/.emacs.d/"
        config-name ".emacs-config.org")

  (defun config-visit ()
    (interactive)
    (find-file (concat config-path config-name)))

  (defun config-tangle ()
    (interactive)
    (org-babel-tangle-file (concat config-dotfiles-path config-name))
    ;; Configuration stored in another directory,
    ;; so I need to move files .emacs.d manually
    ;; (rename-file (concat config-dotfiles-path "early-init.el") config-path t)
    (rename-file (concat config-dotfiles-path "init.el") config-path t))
#+END_SRC

* Appereance

** Line numbers
Изначально они отключены, но можно вызвать по клавише F7.
#+BEGIN_SRC emacs-lisp :tangle init.el
  (define-key global-map
    (kbd "<f7>") 'global-display-line-numbers-mode)

  (define-key global-map
    (kbd "<f6>") 'whitespace-mode)
#+END_SRC

* Editing
** Dired
#+BEGIN_SRC emacs-lisp :tangle init.el 
  ;; Show files in KiB
  (setq dired-listing-switches "-hlap"
        dired-kill-when-opening-new-dired-buffer t)

  (customize-set-variable 'global-auto-revert-non-file-buffers t)
  (global-auto-revert-mode 1)
#+END_SRC

** Linter
I use Flymake and Flycheck
*** Flymake
#+BEGIN_SRC emacs-lisp :tangle nil
  (add-hook 'prog-mode-hook 'flymake-mode)

  (require 'psalm)

  (define-prefix-command 'flymake-map)
  (global-set-key (kbd "C-q") 'flymake-map)
  (define-key flymake-map (kbd "n") 'flymake-goto-next-error)
  (define-key flymake-map (kbd "p") 'flymake-goto-prev-error)
  (define-key flymake-map (kbd "l") 'flymake-show-diagnostics-buffer)
  (define-key flymake-map (kbd "e") 'flymake-show-diagnostic)
#+END_SRC

*** Flycheck
#+BEGIN_SRC emacs-lisp :tangle nil
  ;; (require 'psalm)

  (when (package-loaded? "flycheck")

    (defun flycheck-phanclient-start-daemon ()
      "Start the phan daemon"
      (interactive)
      (let* ((default-directory (php-project-get-root-dir))
             (phan-executable (or flycheck-phanclient--phan-executable
                                  (if (file-exists-p "vendor/bin/phan")
                                      (concat default-directory "vendor/bin/phan")
                                    (executable-find "phan"))))
             (cmd (list phan-executable "--daemonize-tcp-port" "4846" "--quick")))
        (apply #'start-process "PhanDaemon" "*phan daemon*" cmd)))

    (flycheck-define-checker php-phanclient
      "Phan"
      :command ("phan_client" "-l" source-original "-f" source)
      :error-patterns
      ((warning line-start (or "Parse" "Fatal" "syntax" "Phan") " error" (any ":" ",") " " (message) " in " (file-name) " on line " line line-end))
      :modes (php-mode php+-mode))

    (add-to-list 'flycheck-checkers 'php-phanclient)

    (flycheck-add-next-checker 'php '(warning . php-phanclient))

    (add-hook 'prog-mode-hook 'flycheck-mode))
#+END_SRC

** Imenu List
#+begin_src emacs-lisp :tangle init.el
  
  (setq imenu-list-focus-after-activation nil
        imenu-list-auto-resize nil
        imenu-list-mode-line-format '()
        imenu-list-size 0.4)
  (global-set-key (kbd "C-x C-d") #'imenu-list-smart-toggle)
#+end_src

** Version Control System
Модуль VC + Magit.

| Operation      | VC                                      | Magit                |
|----------------+-----------------------------------------+----------------------|
| Project status | project-vc-dir (C-x p v)                | magit-status (C-x g) |
| Pull           | vc-update (F, in my case)               | magit-pull (F p)     |
| New branch     | vc-retrieve-tag (C-u B s)               | magit-branch (b c)   |
| Commit         | vc-next-action (C-x v v)                | magit-commit (c c)   |
| Rebase         | shell-command (M-!) + git rebase master | magit-rebase (r p)   |
| Push           | vc-push (P or C-u P)                    | magit-push (P p)     |
| Stash          | mu-vc-git-stash (z)                     | magit-stash (z)      |
| Log            | vc-print-root-log (L)                   | magit-log (l l)      |
https://www.manueluberti.eu//emacs/2021/11/27/vc/

#+BEGIN_SRC emacs-lisp :tangle init.el
    (setq vc-command-messages t)

    (global-set-key "\C-xvB" 'git-branch-next-action)

    ;; Use magit only when built-in VC fails

  (use-package magit
    :defer t
    :bind (("C-x g" . magit-status)))

  (use-package git-timemachine :defer t)
#+END_SRC

** Jumps
#+BEGIN_SRC emacs-lisp :tangle init.el
  ;; Jumps by highlighting symbols on screen
  (use-package avy
    :defer t
    :bind (("M-s M-s"   . avy-goto-char)
           ("M-s s"     . avy-goto-char)
           ("M-s g"     . avy-goto-line)
           ("M-s l"     . avy-goto-char-in-line)
           ("M-s M-l"   . avy-goto-char-in-line)

           ("M-g g"     . avy-goto-line)
           ("M-s M-g"   . avy-goto-line)))

  (use-package link-hint
    :defer t
    :bind (("M-s j" . link-hint-open-link)))

  ;; Jumps to last change
  (use-package goto-chg
    :defer t
    :bind (("C-z" . goto-last-change)
           ("M-z" . goto-last-change-reverse)))

  ;; Jumps using grep and similar tools
  (use-package dumb-jump
    :defer t
    :bind (("C-." . dumb-jump-go)))

#+END_SRC

** Проекты
Использую встроенный project.el
I use built-in project.el
** Ограничение ширины строки
#+BEGIN_SRC emacs-lisp :tangle init.el
  (add-hook 'prog-mode-hook 'display-fill-column-indicator-mode)

  ;;; Set column width to 79 according to pep8 for python
  (add-hook 'python-mode-hook
            (lambda () (set-fill-column 79)))
#+END_SRC

** Ввод парных скобок и кавычек (electric)
#+BEGIN_SRC emacs-lisp :tangle init.el
  ;;; Input of pair delimiters
  (electric-pair-mode)
  (add-hook 'prog-mode-hook 'electric-pair-mode)
  (add-hook 'prog-mode-hook 'electric-indent-mode)
#+END_SRC

** Kill-ring
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package browse-kill-ring
    :defer t
    :bind ("C-M-y" . browse-kill-ring))
#+END_SRC

** Tags
Для прыжков и поиска функций/классов и т.д.
#+BEGIN_SRC emacs-lisp :tangle nil
  (setq path-to-ctags "~/.guix-profile/bin/ctags")
  
  (defun tags-create (dir-name)
    "Create tags file."
    (interactive "DDirectory: ")
    (shell-command
     (format "%s -f TAGS -e -R %s" path-to-ctags
             (directory-file-name dir-name))))
  
  (defun tags-create-python (dir-name)
    "Create tags with python interpreter"
    (interactive "DDirectory: ")
    (shell-command
     (format "%s -f TAGS -e -R --fields=+l --languages=python --python-kinds=-iv $(python -c \"import os, sys; print(' '.join('{}'.format(d) for d in sys.path if os.path.isdir(d)))\") %s" path-to-ctags
             (directory-file-name dir-name))))  
#+END_SRC

** Дебаггер
#+begin_src emacs-lisp :tangle nil
  (when (package-loaded? "realgud")
    (load "~/.emacs.d/site-lisp/realgud-xdebug/realgud-xdebug.el"))
#+end_src

#+begin_src emacs-lisp :tangle nil
  (when (package-loaded? "geben")
    (setq geben-dbgp-default-port 9003))
#+end_src

*** Автодополнение кода и документация
По большей части я использую дефолтный Completion Buffer и Corfu
#+begin_src elisp :tangle nil
  (when (package-loaded? "corfu")
    (progn
      (setq corfu-preview-current 'nil
            corfu-popupinfo-delay t)
      (corfu-mode 1)
      (corfu-popupinfo-mode 1)
      (defun show-default-completion-buffer ()
        (interactive)
        (corfu-quit)
        (corfu-mode -1)
        (completion-at-point)
        (corfu-mode 1)
        (corfu-popupinfo-mode 1))
      (define-key corfu-map (kbd "M-TAB") 'show-default-completion-buffer)
      (define-key corfu-map (kbd "TAB") 'show-default-completion-buffer)
      (define-key corfu-map (kbd "C-M-i") 'show-default-completion-buffer)      
      (corfu-mode -1)
      (add-hook 'prog-mode-hook 'corfu-mode)

      (defun corfu-send-shell (&rest _)
        "Send completion candidate when inside comint/eshell."
        (cond
         ((and (derived-mode-p 'eshell-mode) (fboundp 'eshell-send-input))
          (eshell-send-input))
         ((and (derived-mode-p 'comint-mode)  (fboundp 'comint-send-input))
          (comint-send-input))))

      (advice-add #'corfu-insert :after #'corfu-send-shell)

      (add-hook 'eshell-mode-hook 'corfu-mode)))

#+end_src
*** Агрессивный дефолтный комплит
#+BEGIN_SRC emacs-lisp :tangle nil
  (setq aggressive-completion-delay 0.5)
  (aggressive-completion-mode t)
#+END_SRC
** Полнотекстовый поиск
Для выхода из поиска -- C-c C-q
#+begin_src emacs-lisp :tangle nil
  (load "deft-autoloads")
  
  (define-key global-map
    (kbd "C-c n s") 'deft)
  
  (setq deft-recursive t
        deft-use-filter-string-for-filename t
        deft-default-extension "org md"
        deft-directory "~/projects/at-w96k/content/digarden")
#+end_src

** Визуализирование откатов
При помощи пакета undo-tree   
#+begin_src emacs-lisp :tangle init.el
  (use-package undo-tree
    :defer t
    :hook
    (prog-mode . undo-tree-mode)
    (org-mode . undo-tree-mode))
#+end_src

** Сниппеты
#+begin_src emacs-lisp :tangle nil
  (when (package-loaded? "yasnippet")
    (progn
      (add-hook 'prog-mode-hook #'yas-minor-mode)))
#+end_src

** Клиент LSP
#+begin_src emacs-lisp :tangle init.el
  ;; (with-eval-after-load 'eglot
  ;;   (add-to-list 'eglot-server-programs '((php-mode phps-mode) . ("~/projects/phpactor/bin/phpactor" "language-server" "-vvv")))
  ;;   (add-to-list 'eglot-server-programs '((php-mode phps-mode) . ("intelephense" "--stdio")))

  ;;   ;; No event buffers, disable providers cause a lot of hover traffic. Shutdown unused servers.
  ;;   (setq eglot-events-buffer-size 0
  ;;    eglot-ignored-server-capabilities '(:hoverProvider
  ;;                                        :documentHighlightProvider)
  ;;    eglot-autoshutdown t))

  ;; Show all of the available eldoc information when we want it. This way Flymake errors
  ;; don't just get clobbered by docstrings.        
  (add-hook 'eglot-managed-mode-hook
            (lambda ()
              "Make sure Eldoc will show us all of the feedback at point."
              (setq-local eldoc-documentation-strategy
                          #'eldoc-documentation-compose)))
#+end_src

** Линтеры
#+begin_src emacs-lisp :tangle nil
  (defun my-php-mode-setup ()
    "My PHP-mode hook."
    (require 'flycheck-phpstan)
    (flycheck-mode t))

  (add-hook 'php-mode-hook 'my-php-mode-setup)
#+end_src

#+BEGIN_SRC emacs-lisp :tangle nil
  ;; (add-hook 'php-mode-hook 'flymake-php-load)
   ;; (add-hook 'php-mode-hook 'flymake-phpstan-turn-on)

    ;; (require 'flycheck-phpstan)


  ;;(add-to-list 'auto-mode-alist '("\\.\\(php\\|phtml\\)\\'" . phps-mode))

  ;; (phps-mode-flycheck-setup)

  ;; (setq phps-mode-async-process t)
  ;; (setq phps-mode-async-process-using-async-el t)
#+END_SRC

** Выделение
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package expand-region
    :defer t
    :bind (("C-=" . er/expand-region)))
#+END_SRC

** Сессия
#+BEGIN_SRC emacs-lisp :tangle init.el
  (desktop-save-mode 1)
#+END_SRC
** Скроллинг
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq scroll-margin 0)
#+END_SRC
** Поиск
*** Isearch
#+begin_src emacs-lisp :tangle init.el
  (with-eval-after-load 'isearch
    (define-key isearch-mode-map "\C-h" 'isearch-delete-char)
    (define-key isearch-mode-map "\C-ch" 'isearch-help-for-help))
#+end_src

*** Подсчёт кандидатов
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package anzu
    :config
    (global-anzu-mode t))
#+END_SRC
*** Swiper (не используется)
#+BEGIN_SRC emacs-lisp :result nil :tangle nil
  (load "swiper-autoloads")
  (global-set-key (kbd "C-s") 'swiper)

  (setq swiper-include-line-number-in-search t
        swiper-use-visual-line t
        swiper-stay-on-quit t)
#+END_SRC
** Which function
#+begin_src emacs-lisp :tangle init.el
  (which-function-mode t)
#+end_src

** Подсказка биндов
Пакет Which-key
#+begin_src elisp :tangle nil
  (load "which-key-autoloads")
  (which-key-setup-side-window-right)
  (which-key-mode)

  (setq which-key-side-window-max-width 0.5
        which-key-show-remaining-keys t
        which-key-max-display-columns 50
        which-key-max-description-length 35
        which-key-sort-order 'which-key-local-then-key-order
        which-key-idle-delay 0.25)
#+end_src

** Права суперпользователя
Sudo-edit
#+begin_src emacs-lisp :tangle init.el
  (use-package sudo-edit
    :defer t)
#+end_src

** Промежуточный код
Показывает собранное состояние будь то собранный куски на ассемблере
или байт-код при помощи пакета RMSbolt.
#+begin_src emacs-lisp :tangle init.el
  (use-package rmsbolt
    :defer t
    :hook (prog-mode . rmsbolt-mode))
#+end_src

** Быстрый запуск программы
#+begin_src emacs-lisp :tangle nil
  ;; (when (package-loaded? "quickrun")
  ;;   (define-key global-map (kbd "C-c C-c") 'quickrun))
#+end_src


* Языки программирования
** Common Lisp
*** REPL
#+BEGIN_SRC emacs-lisp :tangle nil
  (load "sly-autoloads")

  (setq sly-lisp-implementations
        '((clisp ("clisp"))
          (cmucl ("cmucl" "-quiet"))
          (sbcl ("/opt/sbcl/bin/sbcl") :coding-system utf-8-unix)))
#+END_SRC

** Ruby
#+BEGIN_SRC emacs-lisp :tangle nil
  (when (package-loaded? "inf-ruby")
    (add-hook 'ruby-mode-hook 'inf-ruby-minor-mode))

  (when (package-loaded? "inf-ruby")
    (add-hook 'ruby-mode-hook 'robe-mode))
#+END_SRC

** Scheme
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq geiser-active-implementations '("guile"))
#+END_SRC

** Python
*** Автодополнение и линт
#+BEGIN_SRC emacs-lisp :tangle nil
  (when (package-loaded? "anaconda-mode")
    (progn
      (add-hook 'python-mode-hook 'anaconda-mode)
      (add-hook 'python-mode-hook 'anaconda-eldoc-mode)))

  ;; (when (load "flymake" t)
  ;;   (defun flymake-pylint-init ()
  ;;     (let* ((temp-file (flymake-init-create-temp-buffer-copy
  ;;                   'flymake-create-temp-inplace))
  ;;       (local-file (file-relative-name
  ;;                    temp-file
  ;;                    (file-name-directory buffer-file-name))))
  ;;       (list "epylint" (list local-file))))

  ;;   (add-to-list 'flymake-allowed-file-name-masks
  ;;           '("\\.py\\'" flymake-pylint-init)))

  ;; (add-hook 'python-mode-hook 'flymake-mode)
#+END_SRC
*** Прыжки в функции стандартной библиотеки на си
** SML
#+BEGIN_SRC emacs-lisp :tangle nil
  (add-hook 'sml-mode-hook 'sml-mode)
#+END_SRC

** PHP
*** PHP-Mode
Необходимо скачать и распаковать мануал PHP (в формате html) в
директорию ~~/.emacs.d/php-manual/~.
#+begin_src emacs-lisp :tangle nil
  ;; (add-to-list 'load-path "~/.emacs.d/site-lisp/realgud-xdebug/")
  ;; (require 'realgud-xdebug)

  ;; (defun init-php-mode ()
  ;;   (eglot-ensure))
  
  (with-eval-after-load 'php-mode

    ;; (add-hook 'php-mode-hook #'init-php-mode)
    )

  (when (package-loaded? "php-mode")
    (progn
      (add-hook 'php-mode-hook 'php-enable-symfony2-coding-style)
      (setq lsp-intelephense-php-version "8.1.16")
      (defvar phpactor-executable "~/.bin/phpactor")
      (custom-set-variables '(lsp-phpactor-path "~/usr/local/bin/phpactor"))

      (add-hook 'php-mode-hook 
                '(lambda ()
                   ;; (require 'yasnippet)
                   ;; (require 'yasnippet-snippets)

                   (set-fill-column 120)

                   ;; (make-local-variable 'eldoc-documentation-function)
                   ;; (setq eldoc-documentation-function
                   ;;       'phpactor-hover)
                   ;; (yas-minor-mode t)
                   (define-key php-mode-map (kbd "C-c h") 'php-quickhelp-at-point)))

      (setq php-manual-path
            "~/php/php-manual/"
            php-quickhelp-dir "~/php/php-manual/"
            php-quickhelp--dest "~/.emacs.d/php-manual/php_manual_en.json")


      ;; (add-hook 'php-mode-hook 
      ;;                '(lambda ()
      ;;                   ;; (auto-complete-mode t)

      ;;                   ;; (require 'ac-php)
      ;;                   (require 'php-quickhelp)
      ;;                   (require 'company)
      ;;                   (company-mode t)
      ;;                   (require 'company-php)
      ;;                   (require 'company-quickhelp)

      ;;                   (require 'yasnippet)
      ;;                   (require 'yasnippet-snippets)

      ;;                   (set (make-local-variable 'company-backends)
      ;;                        '((company-ac-php-backend company-dabbrev-code)
      ;;                          php-quickhelp-company-php
      ;;                          company-capf company-files))

      ;;                   (company-quickhelp-mode t)

      ;;                   (define-key php-mode-map (kbd "C-M-i") 'company-complete)
      ;;                   (define-key company-mode-map (kbd "M-TAB") 'company-complete)

      ;;                   ;; (setq ac-sources '(ac-source-php php-quickhelp-company-php))
      ;;                   ;; (setq eldoc-documentation-function
      ;;                   ;;       'php-quickhelp-eldoc-func)

      ;;                   (yas-minor-mode t)

      ;;                   ;; (define-key php-mode-map (kbd "C-M-i") 'auto-complete)
      ;;                   ;; (define-key ac-mode-map (kbd "M-TAB") 'auto-complete)

      ;;                   (define-key php-mode-map (kbd "C-c H")
      ;;                               'php-local-manual-search)

      ;;                   (define-key php-mode-map (kbd "C-c h") 'php-quickhelp-at-point)
      ;;                   (define-key company-mode-map (kbd "C-c h") 'php-quickhelp-at-point)

      ;;                   ;; (define-key php-mode-map (kbd "C-c t") 'ac-php-show-tip)

      ;;                   ;; Jump to definition (optional)
      ;;                   (define-key php-mode-map
      ;;                               (kbd "M-.") 'ac-php-find-symbol-at-point)

      ;;                   ;; Return back (optional)
      ;;                   (define-key php-mode-map
      ;;                               (kbd "M-,") 'ac-php-location-stack-back)))
      ))
#+end_src

*** Composer
#+begin_src emacs-lisp :tangle init.el
  (setq composer-executable-bin "~/.bin/composer")
#+end_src

*** Flymake PHP
*** REPL
*** LSP сервер
PHPactor
#+begin_src emacs-lisp :tangle nil
  (setq phpactor-executable "~/.bin/phpactor")
  (custom-set-variables '(lsp-phpactor-path "~/.bin/phpactor"))

  (use-package phpactor :ensure t)
  (use-package company-phpactor :ensure t)



  ;; (with-eval-after-load 'php-mode
  ;;   (define-key php-mode-map (kbd "M-.") #'phpactor-goto-definition)
  ;;   (define-key php-mode-map (kbd "M-?") #'phpactor-find-references))
#+end_src

*** Transient меню    
#+begin_src emacs-lisp :tangle nil
  (require 'transient)
  (define-transient-command php-menu ()
    "Php"
    [["Class"
      ("cc" "Copy" phpactor-copy-class)
      ("cn" "New" phpactor-create-new-class)
      ("cr" "Move" phpactor-move-class)
      ("ci" "Inflect" phpactor-inflect-class)
      ("n"  "Namespace" phpactor-fix-namespace)]
     ["Properties"
      ("a"  "Accessor" phpactor-generate-accessors)
      ("pc" "Constructor" phpactor-complete-constructor)
      ("pm" "Add missing props" phpactor-complete-properties)
      ("r" "Rename var locally" phpactor-rename-variable-local)
      ("R" "Rename var in file" phpactor-rename-variable-file)]
    ["Extract"
      ("ec" "constant" phpactor-extract-constant)
      ("ee" "expression" phpactor-extract-expression)
      ("em"  "method" phpactor-extract-method)]
    ["Methods"
      ("i" "Implement Contracts" phpactor-implement-contracts)
      ("m"  "Generate method" phpactor-generate-method)]
    ["Navigate"
      ("x" "List refs" phpactor-list-references)
      ("X" "Replace refs" phpactor-replace-references)
      ("."  "Goto def" phpactor-goto-definition)]
    ["Phpactor"
      ("s" "Status" phpactor-status)
      ("u" "Install" phpactor-install-or-update)]])
#+end_src
* Языки декларирования
** SQL
 to install lsp-server called sqls
https://emacs-lsp.github.io/lsp-mode/page/lsp-sqls/
#+BEGIN_SRC emacs-lisp :tangle nil
  ;; Empty for now (was using emacsql)
  (setq lsp-sqls-server "~/go/bin/sqls")

  ;; (setq lsp-sqls-workspace-config-path nil)

  (setq lsp-sqls-connections
        '(((driver . "mysql") (dataSourceName . "dbuser:mangoworms@tcp(localhost:3306)/profile24"))))
#+END_SRC

The main way to interact with SQL is using org-mode
#+begin_src emacs-lisp :tangle nil
  (when (package-loaded? "org-sql")
    (setq org-sql-files "~/projects/profile24/org"))

  (add-hook 'sql-interactive-mode-hook
          (lambda ()
            (sql-connect "profile24")
            (toggle-truncate-lines t)))

  (setq sql-connection-alist
      '((profile24
         (sql-product 'mysql)
         (sql-server "localhost")
         (sql-user "dbuser")
         (sql-password "123456")
         (sql-database "testdb")
         (sql-port 3306))))
#+end_src


** Веб шаблоны
*** Web-mode
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package web-mode
    :defer t
    :config
    (add-to-list 'auto-mode-alist '("\\.html?\\'" . web-mode))
    (add-to-list 'auto-mode-alist '("\\.twig.html\\'" . web-mode))
    (setq web-mode-markup-indent-offset 2)
    (setq web-mode-enable-auto-pairing t)
    (setq web-mode-enable-css-colorization t)
    (setq web-mode-enable-block-face t)
    (setq web-mode-enable-current-element-highlight t))
#+END_SRC

** Org
*** Org-mode
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package org
    :defer t
    :config
    (org-babel-do-load-languages
     'org-babel-load-languages
     '((R . t)
       (ditaa . t)
       (dot . t)
       ;; (php . t)
       (emacs-lisp . t)
       (gnuplot . t)
       (haskell . nil)
       (latex . t)
       ;;(ledger . t)
       (ocaml . nil)
       (octave . t)
       (python . t)
       (ruby . t)
       (screen . nil)
       (shell . t)
       (sql . t)
       (js . t)))
    (setq org-default-notes-file "~/Documents/todo.org"
        system-time-locale "C"
        org-use-speed-commands t
        org-adapt-indentation nil
        org-return-follows-link t
        org-agenda-include-diary t
        org-display-remote-inline-images 'download
        org-agenda-start-with-log-mode t
        org-image-actual-width (list 400)
        org-hide-emphasis-markers t
        org-outline-path-complete-in-steps nil
        org-src-tab-acts-natively t
        org-id-track-globally t
        org-confirm-babel-evaluate nil)
    (setq org-todo-keywords
        (quote ((sequence "TODO(t)"
                          "MIGRATE(m)"
                          "IN PROGRESS(p)" 
                          "DONE(d)")
                (sequence "BLOCKED(w@/!)"
                          "HOLD(h@/!)" "|"
                          "CANCELLED(c@/!)"
                          "PHONE"
                          "MEETING"
                          "NEED CLARIFICATION(t)"
                          ))))
    (setq org-todo-keyword-faces
        (quote (("TODO" :foreground "red" :weight bold)
                ("NEXT" :foreground "blue" :weight bold)
                ("DONE" :foreground "forest green" :weight bold)
                ("WAITING" :foreground "orange" :weight bold)
                ("HOLD" :foreground "magenta" :weight bold)
                ("CANCELLED" :foreground "forest green" :weight bold)
                ("MEETING" :foreground "forest cyan" :weight bold)
                ("PHONE" :foreground "blue" :weight bold))))
    :bind
    ("C-c l" . org-store-link)
    ("C-c a" . org-agenda)
    ("C-c c" . org-capture)
    )

  (defun org-babel-edit-prep:sql (babel-info)
    (setq-local buffer-file-name (->> babel-info caddr (alist-get :tangle)))
    (setq-local lsp-buffer-uri (->> babel-info caddr (alist-get :tangle) lsp--path-to-uri))
    (setq-local lsp-headerline-breadcrumb-enable nil)
    (lsp))

  ;; (global-set-key (kbd "M-f") 'org-metaright)
  ;; (global-set-key (kbd "M-b") 'org-metaleft)
  ;; (global-set-key (kbd "M-p") 'org-metaup)
  ;; (global-set-key (kbd "M-n") 'org-metadown)
#+END_SRC


*** Org-ref
#+begin_src emacs-lisp :tangle nil
  (load "org-ref-autoloads")
  
  (setq reftex-default-bibliography '("~/Documents/bibliography/references.bib"))
  
  ;; see org-ref for use of these variables
  (setq org-ref-bibliography-notes "~/Documents/bibliography/notes.org"
        org-ref-default-bibliography '("~/Documents/Bibliography/references.bib")
        org-ref-pdf-directory "~/Documents/bibliography/bibtex-pdfs/")
#+end_src

*** Org-roam
#+begin_src emacs-lisp :tangle init.el
  (use-package org-roam
    :defer t
    :bind
    ("C-c n l" . org-roam-node-insert)
    ("C-c n b" . org-roam-buffer-toggle)
    ("C-c n f" . org-roam-node-find)
    ("C-c n t t" . org-roam-tag-add)
    ("C-c n t r" . org-roam-tag-remove)
    ("C-c n i" . org-roam-jump-to-index)
    ("C-c n g" . org-roam-graph)
    ("C-c n d" . org-roam-db-build-cache)
    ("C-c n r" . org-roam-node-random)
    ("C-c n j" . org-roam-dailies-find-date)
    :config
    (setq org-roam-directory (file-truename "~/Zettelkasten")
        org-roam-v2-ack t
        org-roam-completion-everywhere t
        org-roam-index-file (concat org-roam-directory "/20210409054712-жизнь.org")
        org-roam-dailies-directory (concat org-roam-directory "journals/"))

    (org-roam-db-autosync-mode t))

  (defun org-roam-jump-to-index ()
    "Stub of recreating the function from V1"
    (interactive)
    (let
        ((org-roam-index org-roam-index-file))
      (find-file org-roam-index)))

  (use-package org
    :defer t
    :config
    (customize-set-variable 'org-link-descriptive t)

    (add-to-list 'org-agenda-files
               "~/Documents/todo.org")

    (setq org-directory "~/Documents"
        org-default-notes-file (concat org-directory "/todo.org")))
#+end_src

** YAML
#+begin_src emacs-lisp :tangle init.el
  (use-package yaml-mode
    :defer t)
#+end_src

* Коммуникации
** Gnus
#+begin_src emacs-lisp :tangle init.el
  
#+end_src

** Telega
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package telega
    :bind (("C-c t" . telega-prefix-map)))
#+END_SRC

** Mastodon
#+begin_src emacs-lisp :tangle init.el
  (use-package mastodon
    :defer t
    :config
    (setq mastodon-active-user "w96k"
          mastodon-instance-url "https://fosstodon.org/"))
#+end_src

* Разное
** *Highlight
#+BEGIN_SRC emacs-lisp :tangle init.el
  (use-package highlight
    :defer t)
#+end_src
** Минорные твики дефолтного имакса
*** Короткие ответы на вопросы
#+begin_src emacs-lisp :tangle init.el
  (if (boundp 'use-short-answers)
    (setq use-short-answers t)
  (advice-add 'yes-or-no-p :override #'y-or-n-p))
#+end_src

*** Не сохранять дубликаты в killring

*** Подсвечивать текущую строку
#+begin_src emacs-lisp :tangle nil
  (global-hl-line-mode t)
#+end_src

*** Автодополнение в echo при M-x и других командах
#+begin_src emacs-lisp :tangle init.el
  (icomplete-mode t)
#+end_src
*** Проверять орфографию
#+begin_src emacs-lisp :tangle init.el
  (flyspell-mode t)
#+end_src

*** Не спрашивать о несуществующих буферах
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq-default confirm-nonexistent-file-or-buffer t)
#+END_SRC

*** Переключение буферов
#+BEGIN_SRC emacs-lisp :tangle init.el
  (global-set-key (kbd "M-o")  'mode-line-other-buffer)
#+END_SRC

*** Минорные твики
#+begin_src emacs-lisp :tangle init.el
  ;; (setq redisplay-dont-pause t)

  (setq select-enable-clipboard t
        select-enable-primary t)

  (setq completions-detailed nil)

  (setq kill-buffer-delete-auto-save-files t)
  (setq next-error-message-highlight t)

  (setq mode-line-compact 'long)

  (setq completions-group t)

  ;;(set-frame-parameter nil 'internal-border-width 0)

  ;; (set-window-buffer nil (current-buffer))

  (setq default-directory "~/"
        custom-safe-themes t
        delete-old-versions t
        enable-local-variables t)
#+end_src

*** Shell
#+begin_src emacs-lisp :tangle init.el
  (setq ansi-color-for-comint-mode t)
  (setq shell-command-prompt-show-cwd t)
#+end_src

*** Переменная PATH в eshell
#+BEGIN_SRC emacs-lisp :tangle nil
  (setq exec-path-from-shell-variables
        '("PATH" "MANPATH"))

  (when (and (memq window-system '(mac ns x))
             (not (eq system-type 'berkeley-unix)))
    (exec-path-from-shell-initialize))
#+END_SRC

*** Отображение номера колонки
#+BEGIN_SRC emacs-lisp :tangle init.el
  (column-number-mode)
#+END_SRC

*** nobreak символы
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq nobreak-char-display nil)
#+END_SRC

*** Меню
*** Сохранять временные файлы не в той же директории
#+BEGIN_SRC emacs-lisp :tangle init.el
  (defvar backup-dir "~/.emacs.d/backups/")

  (setq
   backup-by-copying t
   backup-directory-alist
   '(("~/.emacs.d/backups/"))
   version-control nil)
#+END_SRC

*** Календарь
Делаем начало недели в понедельник.
#+BEGIN_SRC emacs-lisp :tangle init.el
  (setq calendar-week-start-day 1)
#+END_SRC

*** Вернуться в предыдущий буфер
#+BEGIN_SRC emacs-lisp :tangle nil
  (define-key global-map (kbd "C-q C-q") 'previous-buffer)
  (define-key global-map (kbd "C-S-q C-S-q") 'next-buffer)
#+END_SRC
*** Смена раскладки (EN / RU) и поддержка биндов на других языках
Работает на C-\
#+begin_src elisp :tangle init.el
  (set-input-method "russian-computer")
  (toggle-input-method)
#+end_src

*** Требовать создания последней пустой строки
#+begin_src emacs-lisp :tangle init.el
  (setq require-final-newline t)
#+end_src

*** Стирать текст на C-h как в Bash
И переназначаем старые бинды
#+begin_src emacs-lisp :tangle nil
  (define-key global-map (kbd "C-h") 'delete-backward-char)
  (define-key global-map (kbd "C-c h") 'help-command)
#+end_src

*** Поддержка CamelCase в навигации
#+begin_src emacs-lisp :tangle init.el
  (global-subword-mode 1)
#+end_src

*** Kills
#+begin_src emacs-lisp :tangle init.el
  (use-package whole-line-or-region
    :bind (("C-k" . kill-region)
           ("C-w" . backward-kill-word))
    :config
    (whole-line-or-region-global-mode))
#+end_src


** Браузер
#+begin_src emacs-lisp :tangle nil
  (setq browse-url-browser-function #'eww-browse-url)

  (add-hook 'eww-mode-hook
            (lambda ()
              (set-fill-column 80)
              (display-fill-column-indicator-mode)
              (visual-fill-column-mode)))
#+end_src

** Tramp
#+begin_src emacs-lisp :tangle nil
  (add-to-list 'tramp-remote-path 'tramp-own-remote-path)
#+end_src

** Docker
#+begin_src emacs-lisp :tangle init.el
  (use-package docker :defer t)
  (use-package docker-compose-mode :defer t)
#+end_src
** Debian
Инструменты для работы с пакетным менеджером Debian'а apt'ом и смежными
инструментами.
#+begin_src elisp :tangle nil
  (load "debian-el-autoloads")
  (load "dpkg-dev-el-autoloads")
#+end_src

** Guix
#+begin_src emacs-lisp :tangle init.el
  ;; (use-package geiser-guile :defer t)

  (use-package guix
    :defer t
    :config
    (setq geiser-guile-binary "guile")
    (with-eval-after-load 'geiser-guile
      (progn
        (add-to-list 'geiser-guile-load-path "~/projects/guix/")))

    (let ((guix-copyright "~/projects/guix/etc/copyright.el"))
      (if (file-exists-p guix-copyright)
        (load-file "~/projects/guix/etc/copyright.el")))

    (setq copyright-names-regexp
        (format "%s <%s>" user-full-name user-mail-address)))
#+end_src

** Nix
#+begin_src emacs-lisp :tangle init.el
  (use-package nix)
#+end_src

** Direnv
#+BEGIN_SRC emacs-lisp :tangle nil
  (when (package-loaded? "direnv")
      (direnv-mode))
#+END_SRC

** Баг-трекеры
*** Debbugs
** PDF

** Увеличение/уменьшение шрифта
#+BEGIN_SRC emacs-lisp :tangle nil
  (defun zoom-in ()
    (interactive)
    (let ((x (+ (face-attribute 'default :height)
                10)))
      (set-face-attribute 'default nil :height x)
      (set-face-attribute 'mode-line nil :height x)
      (set-face-attribute 'mode-line-inactive nil :height x)
      (set-face-attribute 'mode-line-position-face nil :height x)))
  
  (defun zoom-out ()
    (interactive)
    (let ((x (- (face-attribute 'default :height)
                10)))
      (set-face-attribute 'default nil :height x)
      (set-face-attribute 'mode-line nil :height x)
      (set-face-attribute 'mode-line-inactive nil :height x)
      (set-face-attribute 'mode-line-position-face nil :height x)))
  
  (define-key global-map (kbd "C-=") 'zoom-in)
  (define-key global-map (kbd "C-+") 'zoom-out)
  
#+END_SRC

** Автокомплит у yes-or-no
** Полный экран
Открывать Emacs на полный экран
#+begin_src emacs-lisp :tangle nil
  (add-to-list 'default-frame-alist '(fullscreen . maximized))
#+end_src

** Фуллскрин
Отображать ровно столько строчек, сколько вмещает экран.

Не работает с native-comp.

#+begin_src elisp :tangle nil
  (toggle-frame-fullscreen)

  (defun fullscreen ()
  "Fullscreen."
  (interactive)
  (x-send-client-message nil 0 nil "_NET_WM_STATE" 32
                         ;; if first parameter is '1', can't toggle fullscreen status
                         '(1 "_NET_WM_STATE_FULLSCREEN" 0)))
#+end_src
** Удаление буфера и файла
#+begin_src elisp :tangle init.el
  (defun delete-file-and-buffer ()
    "Kill the current buffer and deletes the file it is visiting."
    (interactive)
    (let ((filename (buffer-file-name)))
      (if filename
          (if (y-or-n-p (concat "Do you really want to delete file " filename " ?"))
              (progn
                (delete-file filename)
                (message "Deleted file %s." filename)
                (kill-buffer)))
        (message "Not a file visiting buffer!"))))
#+end_src

** Длинные строки
#+begin_src emacs-lisp :tangle nil
  ;; Better support for files with long lines
  (setq-default bidi-paragraph-direction 'left-to-right)
  (setq-default bidi-inhibit-bpa t)
  (global-so-long-mode 1)
#+end_src

** Make shebang (#!) file executable when saved
#+begin_src emacs-lisp :tangle init.el
  (add-hook 'after-save-hook #'executable-make-buffer-file-executable-if-script-p)
#+end_src

** Enable savehist-mode for command history
#+begin_src emacs-lisp :tangle init.el
  (savehist-mode 1)
#+end_src

** Ignore case sensitive in completions, search and etc
#+begin_src emacs-lisp :tangle init.el
  (setq completion-ignore-case t
        read-buffer-completion-ignore-case t
        read-file-name-completion-ignore-case t)
#+end_src

** Make scripts executable automatically
#+begin_src emacs-lisp :tangle init.el
  (add-hook 'after-save-hook
            'executable-make-buffer-file-executable-if-script-p)
#+end_src

** F1 for M-x shell and F2 for grep
#+begin_src emacs-lisp :tangle init.el
  (global-set-key (kbd "<f1>") 'shell)
  (global-set-key (kbd "<f2>") 'rgrep)
#+end_src

** Hippie expand
#+begin_src emacs-lisp :tangle init.el
  (global-set-key [remap dabbrev-expand] 'hippie-expand)
#+end_src