| 1 |
[main] |
| 2 |
|
| 3 |
# Multi-line mode allows breaking up the sql statements into multiple lines. If |
| 4 |
# this is set to True, then the end of the statements must have a semi-colon. |
| 5 |
# If this is set to False then sql statements can't be split into multiple |
| 6 |
# lines. End of line (return) is considered as the end of the statement. |
| 7 |
multi_line = False |
| 8 |
|
| 9 |
# Destructive warning mode will alert you before executing a sql statement |
| 10 |
# that may cause harm to the database such as "drop table", "drop database" |
| 11 |
# or "shutdown". |
| 12 |
destructive_warning = True |
| 13 |
|
| 14 |
# log_file location. |
| 15 |
# In Unix/Linux: ~/.config/litecli/log |
| 16 |
# In Windows: %USERPROFILE%\AppData\Local\dbcli\litecli\log |
| 17 |
# %USERPROFILE% is typically C:\Users\{username} |
| 18 |
log_file = default |
| 19 |
|
| 20 |
# Default log level. Possible values: "CRITICAL", "ERROR", "WARNING", "INFO" |
| 21 |
# and "DEBUG". "NONE" disables logging. |
| 22 |
log_level = INFO |
| 23 |
|
| 24 |
# Log every query and its results to a file. Enable this by uncommenting the |
| 25 |
# line below. |
| 26 |
# audit_log = ~/.litecli-audit.log |
| 27 |
|
| 28 |
# Default pager. |
| 29 |
# By default '$PAGER' environment variable is used |
| 30 |
# pager = less -SRXF |
| 31 |
|
| 32 |
# Table format. Possible values: |
| 33 |
# ascii, double, github, psql, plain, simple, grid, fancy_grid, pipe, orgtbl, |
| 34 |
# rst, mediawiki, html, latex, latex_booktabs, textile, moinmoin, jira, |
| 35 |
# vertical, tsv, csv. |
| 36 |
# Recommended: ascii |
| 37 |
table_format = ascii |
| 38 |
|
| 39 |
# Syntax coloring style. Possible values (many support the "-dark" suffix): |
| 40 |
# manni, igor, xcode, vim, autumn, vs, rrt, native, perldoc, borland, tango, emacs, |
| 41 |
# friendly, monokai, paraiso, colorful, murphy, bw, pastie, paraiso, trac, default, |
| 42 |
# fruity. |
| 43 |
# Screenshots at http://mycli.net/syntax |
| 44 |
syntax_style = default |
| 45 |
|
| 46 |
# Keybindings: Possible values: emacs, vi. |
| 47 |
# Emacs mode: Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL. |
| 48 |
# When Vi mode is enabled you can use modal editing features offered by Vi in the REPL. |
| 49 |
key_bindings = emacs |
| 50 |
|
| 51 |
# Enabling this option will show the suggestions in a wider menu. Thus more items are suggested. |
| 52 |
wider_completion_menu = False |
| 53 |
|
| 54 |
# Autocompletion is on by default. This can be truned off by setting this |
| 55 |
# option to False. Pressing tab will still trigger completion. |
| 56 |
autocompletion = True |
| 57 |
|
| 58 |
# litecli prompt |
| 59 |
# \D - The full current date |
| 60 |
# \d - Database name |
| 61 |
# \f - File basename of the "main" database |
| 62 |
# \m - Minutes of the current time |
| 63 |
# \n - Newline |
| 64 |
# \P - AM/PM |
| 65 |
# \R - The current time, in 24-hour military time (0-23) |
| 66 |
# \r - The current time, standard 12-hour time (1-12) |
| 67 |
# \s - Seconds of the current time |
| 68 |
# \x1b[...m - insert ANSI escape sequence |
| 69 |
prompt = "\t :\d> " |
| 70 |
prompt_continuation = "-> " |
| 71 |
|
| 72 |
# Show/hide the informational toolbar with function keymap at the footer. |
| 73 |
show_bottom_toolbar = True |
| 74 |
|
| 75 |
# Skip intro info on startup and outro info on exit |
| 76 |
less_chatty = False |
| 77 |
|
| 78 |
# Use alias from --login-path instead of host name in prompt |
| 79 |
login_path_as_host = False |
| 80 |
|
| 81 |
# Cause result sets to be displayed vertically if they are too wide for the current window, |
| 82 |
# and using normal tabular format otherwise. (This applies to statements terminated by ; or \G.) |
| 83 |
auto_vertical_output = False |
| 84 |
|
| 85 |
# keyword casing preference. Possible values "lower", "upper", "auto" |
| 86 |
keyword_casing = auto |
| 87 |
|
| 88 |
# disabled pager on startup |
| 89 |
enable_pager = True |
| 90 |
[colors] |
| 91 |
completion-menu.completion.current = "bg:#ffffff #000000" |
| 92 |
completion-menu.completion = "bg:#008888 #ffffff" |
| 93 |
completion-menu.meta.completion.current = "bg:#44aaaa #000000" |
| 94 |
completion-menu.meta.completion = "bg:#448888 #ffffff" |
| 95 |
completion-menu.multi-column-meta = "bg:#aaffff #000000" |
| 96 |
scrollbar.arrow = "bg:#003333" |
| 97 |
scrollbar = "bg:#00aaaa" |
| 98 |
selected = "#ffffff bg:#6666aa" |
| 99 |
search = "#ffffff bg:#4444aa" |
| 100 |
search.current = "#ffffff bg:#44aa44" |
| 101 |
bottom-toolbar = "bg:#222222 #aaaaaa" |
| 102 |
bottom-toolbar.off = "bg:#222222 #888888" |
| 103 |
bottom-toolbar.on = "bg:#222222 #ffffff" |
| 104 |
search-toolbar = noinherit bold |
| 105 |
search-toolbar.text = nobold |
| 106 |
system-toolbar = noinherit bold |
| 107 |
arg-toolbar = noinherit bold |
| 108 |
arg-toolbar.text = nobold |
| 109 |
bottom-toolbar.transaction.valid = "bg:#222222 #00ff5f bold" |
| 110 |
bottom-toolbar.transaction.failed = "bg:#222222 #ff005f bold" |
| 111 |
|
| 112 |
# style classes for colored table output |
| 113 |
output.header = "#00ff5f bold" |
| 114 |
output.odd-row = "" |
| 115 |
output.even-row = "" |
| 116 |
Token.Menu.Completions.Completion.Current = "bg:#00aaaa #000000" |
| 117 |
Token.Menu.Completions.Completion = "bg:#008888 #ffffff" |
| 118 |
Token.Menu.Completions.MultiColumnMeta = "bg:#aaffff #000000" |
| 119 |
Token.Menu.Completions.ProgressButton = "bg:#003333" |
| 120 |
Token.Menu.Completions.ProgressBar = "bg:#00aaaa" |
| 121 |
Token.Output.Header = bold |
| 122 |
Token.Output.OddRow = "" |
| 123 |
Token.Output.EvenRow = "" |
| 124 |
Token.SelectedText = "#ffffff bg:#6666aa" |
| 125 |
Token.SearchMatch = "#ffffff bg:#4444aa" |
| 126 |
Token.SearchMatch.Current = "#ffffff bg:#44aa44" |
| 127 |
Token.Toolbar = "bg:#222222 #aaaaaa" |
| 128 |
Token.Toolbar.Off = "bg:#222222 #888888" |
| 129 |
Token.Toolbar.On = "bg:#222222 #ffffff" |
| 130 |
Token.Toolbar.Search = noinherit bold |
| 131 |
Token.Toolbar.Search.Text = nobold |
| 132 |
Token.Toolbar.System = noinherit bold |
| 133 |
Token.Toolbar.Arg = noinherit bold |
| 134 |
Token.Toolbar.Arg.Text = nobold |
| 135 |
[favorite_queries] |
| 136 |
q_param = select * from test where name=? |
| 137 |
sh_param = select * from test where id=$1 |
| 138 |
[startup_commands] |
| 139 |
commands = create table startupcommands(a text), insert into startupcommands values('abc') |