Dernière activité 2 weeks ago Unlisted

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

atareao's Avatar atareao a révisé ce gist 2 weeks ago. Aller à la révision

1 file changed, 35 insertions

myclirc(fichier créé)

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