Changeset 313ec50 in dotfiles

Timestamp:

Oct 27, 2022, 6:10:48 PM (2 years ago)

Author:

w96k <w96k@…>

Branches:

master

Children:

ee24a4b

Parents:

a198d42

Message:

Emacs: Add SQL lsp and org support

File:

• emacs/.emacs.d/.emacs-config.org (modified) (1 diff)

emacs/.emacs.d/.emacs-config.org

@@ -1240 +1240 @@
   (add-hook 'sql-mode-hook 'lsp)
   (setq lsp-sqls-server "~/go/bin/sqls")
+
+  (setq lsp-sqls-workspace-config-path nil)
+
+  (setq lsp-sqls-connections
+        '(((driver . "mysql") (dataSourceName . "dbuser:mangoworms@tcp(192.168.2206.6:3306)/profile24"))))
+
+  (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))
 #+END_SRC
 
 The main way to interact with SQL is using org-mode
-#+begin_src emacs-lisp
+#+begin_src emacs-lisp :tangle init.el
   (when (package-loaded? "org-sql")
     (setq org-sql-files "~/projects/profile24/org"))
+
+  (setq sql-connection-alist
+      '((pool-a
+         (sql-product 'mysql)
+         (sql-server "192.168.220.6")
+         (sql-user "dbuser")
+         (sql-password "mangoworms")
+         (sql-database "profile24")
+         (sql-port 3306))))
 #+end_src