modules/common/profiles/dev/sql.nix


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100

{
  config,
  lib,
  pkgs,
  ...
}:
with lib; let
  cfg = config.nixfiles.modules.profiles.dev.sql;
in {
  options.nixfiles.modules.profiles.dev.sql.enable =
    mkEnableOption "SQL stuff and database management tools"
    // {
      default = config.nixfiles.modules.profiles.dev.enable;
    };

  config = mkIf cfg.enable {
    hm = {
      home.packages = with pkgs; [
        pgcli
        litecli
      ];

      xdg = let
        mainSection = {
          destructive_warning = "True";
          enable_pager = "True";
          keyword_casing = "auto";
          less_chatty = "True";
          log_file = "/dev/null";
          log_level = "CRITICAL";
          multi_line = "False";
          syntax_style = "default";
          table_format = "fancy_grid";
        };

        colorsSection = with config.colors.withHashtag; {
          "arg-toolbar" = "noinherit bold";
          "arg-toolbar.text" = "nobold";
          "bottom-toolbar" = "bg:${base01} ${base06}";
          "bottom-toolbar.off" = "bg:${base01} ${base02}";
          "bottom-toolbar.on" = "bg:${base01} ${base07}";
          "bottom-toolbar.transaction.failed" = "bg:${base01} ${base08} bold";
          "bottom-toolbar.transaction.valid" = "bg:${base01} ${base0B} bold";
          "completion-menu.completion" = "bg:${base01} ${base06}";
          "completion-menu.completion.current" = "bg:${base06} ${base01}";
          "completion-menu.meta.completion" = "bg:${base01} ${base13}";
          "completion-menu.meta.completion.current" = "bg:${base09} ${base01}";
          "completion-menu.multi-column-meta" = "bg:${base09} ${base01}";
          "scrollbar" = "bg:${base01}";
          "scrollbar.arrow" = "bg:${base01}";
          "search" = "bg:${base17} ${base07}";
          "search-toolbar" = "noinherit bold";
          "search-toolbar.text" = "nobold";
          "search.current" = "bg:${base14} ${base07}";
          "selected" = "bg:${base0D} ${base07}";
          "system-toolbar" = "noinherit bold";
        };

        mkCliConfig = {
          name,
          custom,
        }: {
          "${name}/config" = {
            text = generators.toINI {} {
              main = mainSection // custom;
              colors = mapAttrs (_: v: "'${v}'") colorsSection;
            };
          };
        };
      in {
        configFile = mkMerge (map mkCliConfig [
          {
            name = "pgcli";
            custom = {
              prompt = "'\\u@\\h:\\d> '";
              multi_line_mode = "psql";
              on_error = "STOP";
              auto_expand = "True";
              expand = "True";
              keyring = "False";
              vi = "True";
              casing_file = "/dev/null";
              history_file = "/dev/null";
            };
          }
          {
            name = "litecli";
            custom = {
              prompt = "'\\d> '";
              prompt_continuation = "'-> '";
              auto_vertical_output = "True";
              key_bindings = "vi";
              audit_log = "/dev/null";
            };
          }
        ]);
      };
    };
  };
}