sql-cli 1.71.0

SQL query tool for CSV/JSON with both interactive TUI and non-interactive CLI modes - perfect for exploration and automation
Documentation 
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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136

return
{
   dir = vim.fn.expand("~/dev/sql-cli/nvim-plugin"),
   name = "sql-cli.nvim",
   lazy = false,
   config = function()
      require('sql-cli').setup({
         debug = true,
         command = vim.fn.expand("~/dev/sql-cli/target/release/sql-cli"),
         output_format = "table",
		  query_history = {
			persist = true,       -- Enable auto save/load
			max_items = 100,      -- Maximum queries to keep
			auto_save = true,     -- Save after each query
		},

        -- FIX Message Syntax Highlighting
        syntax = {
          patterns = {
            -- FIX UTC Timestamps (20250925-07:46:33.333)
            { pattern = [[\<\d\{8\}-\d\{2\}:\d\{2\}:\d\{2\}\.\d\{3\}\>]], group = "FixTimestamp",
              color = { gui = "Blue", cterm = "Blue" } },

            -- Multi-leg trades (ORDER0001.1, ORDER0001.2, etc.)
            { pattern = [[\w\+\.\d\+]], group = "FixMultiLeg",
              color = { gui = "Cyan", cterm = "Cyan", bold = true } },

            -- Message Types (case-insensitive to match Executionreport, etc.)
            { pattern = [[\c\<ExecutionReport\>]], group = "FixExecReport",
              color = { gui = "Green", cterm = "Green", bold = true } },  -- #50fa7b
            { pattern = [[\c\<AllocationReport\>]], group = "FixAllocReport",
              color = { gui = "Cyan", cterm = "Cyan", bold = true } },  -- #8be9fd
            { pattern = [[\c\<NewOrderSingle\>]], group = "FixNewOrder",
              color = { gui = "Yellow", cterm = "Yellow", bold = true } },  -- #f1fa8c
            { pattern = [[\c\<OrderCancelReject\>]], group = "FixCancelReject",
              color = { gui = "Red", cterm = "Red", bold = true } },  -- #ff5555

            -- Order Status (case-insensitive: Pendingnew, Pendingrep, New, Partial, Filled, Cancelled)
            -- Different colors for each state to show what's going on
            { pattern = [[\c\<Pendingnew\>]], group = "FixStatPendingNew",
              color = { gui = "Yellow", cterm = "Yellow" } },  -- #f1fa8c - Warning/waiting
            { pattern = [[\c\<Pendingrep\>]], group = "FixStatPendingRep",
              color = { gui = "Yellow", cterm = "Yellow" } },  -- #f1fa8c - Pending replace
            { pattern = [[\c\<PendingCancel\>]], group = "FixStatPendingCancel",
              color = { gui = "Yellow", cterm = "Yellow" } },  -- #f1fa8c - Pending cancel
            { pattern = [[\c\<New\>]], group = "FixStatNew",
              color = { gui = "Cyan", cterm = "Cyan" } },  -- #8be9fd - Active/submitted
            { pattern = [[\c\<Partial\>]], group = "FixStatPartial",
              color = { gui = "Magenta", cterm = "Magenta" } },  -- #bd93f9 - In progress
            { pattern = [[\c\<Filled\>]], group = "FixStatFilled",
              color = { gui = "Green", cterm = "Green", bold = true } },  -- #50fa7b - Complete
            { pattern = [[\c\<Cancelled\>]], group = "FixStatCanceled",
              color = { gui = "DarkGray", cterm = "DarkGray" } },  -- #6272a4 - Inactive
            { pattern = [[\c\<Canceled\>]], group = "FixStatCanceled2",
              color = { gui = "DarkGray", cterm = "DarkGray" } },  -- US spelling variant
            { pattern = [[\c\<Rejected\>]], group = "FixStatRejected",
              color = { gui = "Red", cterm = "Red", bold = true } },  -- #ff5555 - Error

            -- Side (Buy/Sell) - Green/Red for quick visual
            { pattern = [[\c\<Buy\>]], group = "FixSideBuy",
              color = { gui = "Green", cterm = "Green", bold = true } },  -- #50fa7b
            { pattern = [[\c\<Sell\>]], group = "FixSideSell",
              color = { gui = "Red", cterm = "Red", bold = true } },  -- #ff5555

            -- Bloomberg Yellow Key Codes
            { pattern = [[\c\<Index\>]], group = "BBGIndex",
              color = { gui = "Yellow", cterm = "Yellow", bold = true } },
            { pattern = [[\c\<Comdty\>]], group = "BBGComdty",
              color = { gui = "Yellow", cterm = "Yellow", bold = true } },
            { pattern = [[\c\<Equity\>]], group = "BBGEquity",
              color = { gui = "Cyan", cterm = "Cyan" } },
            { pattern = [[\c\<Govt\>]], group = "BBGGovt",
              color = { gui = "Green", cterm = "Green" } },
            { pattern = [[\c\<Corp\>]], group = "BBGCorp",
              color = { gui = "Magenta", cterm = "Magenta" } },
            { pattern = [[\c\<Curncy\>]], group = "BBGCurncy",
              color = { gui = "Cyan", cterm = "Cyan", bold = true } },

            -- Futures codes (e.g., FVZ5, ESH4) - 2-3 letters + month code + digit
            -- This is conservative to avoid false positives
            { pattern = [[\<[A-Z]\{2,3\}[FGHJKMNQUVXZ]\d\>]], group = "FuturesCode",
              color = { gui = "Yellow", cterm = "Yellow" } },

            -- Exchanges
            { pattern = [[\c\<NYSE\>]], group = "FixExchNYSE",
              color = { gui = "Magenta", cterm = "Magenta" } },  -- #bd93f9
            { pattern = [[\c\<NASDAQ\>]], group = "FixExchNASDAQ",
              color = { gui = "Magenta", cterm = "Magenta" } },  -- #ff79c6
            { pattern = [[\c\<LSE\>]], group = "FixExchLSE",
              color = { gui = "Magenta", cterm = "Magenta" } },  -- #bd93f9

            -- ISO Currency Codes (3 uppercase letters)
            -- Common currencies: USD, EUR, GBP, JPY, CHF, AUD, CAD, HKD, SGD, etc.
            { pattern = [[\<[A-Z]\{3\}\>]], group = "CurrencyCode",
              color = { gui = "Green", cterm = "Green" } },

            -- Instrument Types
            { pattern = [[\c\<NDS\>]], group = "FixInstNDS",
              color = { gui = "Cyan", cterm = "Cyan" } },  -- #00aaff
            { pattern = [[\c\<NFD\>]], group = "FixInstNFD",
              color = { gui = "Yellow", cterm = "Yellow" } },  -- #ffaa00
            { pattern = [[\c\<CDS\>]], group = "FixInstCDS",
              color = { gui = "Magenta", cterm = "Magenta" } },  -- #aa00ff
            { pattern = [[\c\<IRS\>]], group = "FixInstIRS",
              color = { gui = "Green", cterm = "Green" } },  -- #00ffaa
          }
        },
      })

      -- Token Manager Configuration
      -- local token_manager = require('sql-cli.token_manager')
      local multi_token_manager = require('sql-cli.multi_token_manager')

      multi_token_manager.setup({
      JWT_TOKEN = {
        command = "powershell.exe -NoProfile -ExecutionPolicy Bypass -File $HOME\\dev\\sql-cli\\ExportJwt.ps1",
        -- refresh_interval = 840,  -- 14 minutes
         refresh_interval = 20,  -- 20 seconds for testing
         auto_refresh = true,
         debug = true,  -- Enable debug output to see what's happening
      },
      JWT_TOKEN_PROD = {
        command = "powershell.exe -NoProfile -ExecutionPolicy Bypass -File $HOME\\dev\\sql-cli\\ExportJwtProd.ps1",
        refresh_interval = 840,
        auto_refresh = true,
        debug = false,  -- Less verbose for prod token
      },
     })
      -- Create token manager commands
     multi_token_manager.create_commands()

      -- Notify that multi-token manager is configured
     vim.notify("SQL-CLI Multi-Token Manager configured (JWT_TOKEN @ 20s, JWT_TOKEN_PROD @ 840s)", vim.log.levels.INFO)
     vim.notify("Commands: :TokenStatus, :TokenRefreshAll, :TokenRefresh [name]", vim.log.levels.INFO)
   end,
}