kody / LiteCLI Config

# vi: ft=dosini [main] # Multi-line mode allows breaking up the sql statements into multiple lines. If # this is set to True, then the end of the statements must have a semi-colon. # If this is set to False then sql statements can't be split into multiple # lines. End of line (return) is considered as the end of the statement. multi_line = True # Destructive warning mode will alert you before executing a sql statement # that may cause harm to the database such as "drop table", "drop database" # or "shutdown". destructive_warning = True # log_file location. # In Unix/Linux: ~/.config/litecli/log # In Windows: %USERPROFILE%\AppData\Local\dbcli\litecli\log # %USERPROFILE% is typically C:\Users\{username} log_file = default # Default log level. Possible values: "CRITICAL", "ERROR", "WARNING", "INFO" # and "DEBUG". "NONE" disables logging. log_level = INFO # Log every query and its results to a file. Enable this by uncommenting the # line below. # audit_log = ~/.litecli-audit.log # Default pager. # By default '$PAGER' environment variable is used pager = less -SRXF # Table format. Possible values: # ascii, double, github, psql, plain, simple, grid, fancy_grid, pipe, orgtbl, # rst, mediawiki, html, latex, latex_booktabs, textile, moinmoin, jira, # vertical, tsv, csv. # Recommended: ascii table_format = psql_unicode # Syntax coloring style. Possible values (many support the "-dark" suffix): # manni, igor, xcode, vim, autumn, vs, rrt, native, perldoc, borland, tango, emacs, # friendly, monokai, paraiso, colorful, murphy, bw, pastie, paraiso, trac, default, # fruity. # Screenshots at http://mycli.net/syntax syntax_style = pastie-dark # Keybindings: Possible values: emacs, vi. # Emacs mode: Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL. # When Vi mode is enabled you can use modal editing features offered by Vi in the REPL. key_bindings = emacs # Enabling this option will show the suggestions in a wider menu. Thus more items are suggested. wider_completion_menu = True # Autocompletion is on by default. This can be truned off by setting this # option to False. Pressing tab will still trigger completion. autocompletion = True # litecli prompt # \D - The full current date # \d - Database name # \f - File basename of the "main" database # \m - Minutes of the current time # \n - Newline # \P - AM/PM # \R - The current time, in 24-hour military time (0-23) # \r - The current time, standard 12-hour time (1-12) # \s - Seconds of the current time # \x1b[...m - insert ANSI escape sequence prompt = '\d> ' prompt_continuation = '-> ' # Show/hide the informational toolbar with function keymap at the footer. show_bottom_toolbar = True # Skip intro info on startup and outro info on exit less_chatty = False # Use alias from --login-path instead of host name in prompt login_path_as_host = False # Cause result sets to be displayed vertically if they are too wide for the current window, # and using normal tabular format otherwise. (This applies to statements terminated by ; or \G.) auto_vertical_output = False # keyword casing preference. Possible values "lower", "upper", "auto" keyword_casing = upper # disabled pager on startup enable_pager = True # Custom colors for the completion menu, toolbar, etc. [colors] completion-menu.completion.current = 'bg:#ffffff #000000' completion-menu.completion = 'bg:#008888 #ffffff' completion-menu.meta.completion.current = 'bg:#44aaaa #000000' completion-menu.meta.completion = 'bg:#448888 #ffffff' completion-menu.multi-column-meta = 'bg:#aaffff #000000' scrollbar.arrow = 'bg:#003333' scrollbar = 'bg:#00aaaa' selected = '#ffffff bg:#6666aa' search = '#ffffff bg:#4444aa' search.current = '#ffffff bg:#44aa44' bottom-toolbar = 'bg:#222222 #aaaaaa' bottom-toolbar.off = 'bg:#222222 #888888' bottom-toolbar.on = 'bg:#222222 #ffffff' search-toolbar = 'noinherit bold' search-toolbar.text = 'nobold' system-toolbar = 'noinherit bold' arg-toolbar = 'noinherit bold' arg-toolbar.text = 'nobold' bottom-toolbar.transaction.valid = 'bg:#222222 #00ff5f bold' bottom-toolbar.transaction.failed = 'bg:#222222 #ff005f bold' # style classes for colored table output output.header = "#00ff5f bold" output.odd-row = "" output.even-row = "" # Favorite queries. [favorite_queries] # Startup commands # litecli commands or sqlite commands to be executed on startup. # some of them will require you to have a database attached. # they will be executed in the same order as they appear in the list. [startup_commands] #commands = ".tables", "pragma foreign_keys = ON;" commands = ".tables"