Last active 2 weeks ago Unlisted

Archivo de configuracion de ejemplo para MyCLI con DSNs, colores, favoritos y opciones avanzadas

myclirc Raw
1[main]
2smart_completion = True
3multi_line = False
4destructive_warning = True
5history_file = ~/.mycli-history
6log_file = ~/.mycli.log
7log_level = INFO
8timing = True
9table_format = mysql_unicode
10syntax_style = monokai
11key_bindings = emacs
12wider_completion_menu = False
13enable_pager = True
14auto_vertical_output = True
15use_keyring = True
16null_string = <null>
17numeric_alignment = right
18binary_display = hex
19keyword_casing = auto
20min_completion_trigger = 1
21
22[alias_dsn]
23local = mysql://root@localhost:3306/mydb
24prod = mysql://admin@prod-server:3306/mydb
25desarrollo = mysql://dev@dev-server:3306/mydb
26
27[colors]
28completion-menu.completion.current = bg:#ffffff #000000
29output.header = #00ff5f bold
30bottom-toolbar = bg:#222222 #aaaaaa
31
32[favorite_queries]
33tablas = SELECT TABLE_NAME, TABLE_ROWS FROM information_schema.TABLES WHERE TABLE_SCHEMA='$1'
34conexiones = SELECT * FROM information_schema.PROCESSLIST
35tamanos = SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)' FROM information_schema.TABLES WHERE table_schema = '$1' ORDER BY (data_length + index_length) DESC