dumbo / dumbo.ini

[dumbo]
theme = dark
;~ theme = light
use256 = True
; looks for a matching db_[name] section below
db = local


[db_local]
user =
password =
host =
; don't show the following
;~ tablefilters = pg_, sql_
; main db
dbname = django

; looks for a matching dbtype_[name] section below
type = postgres


[theme_dark]
# name             fg       bg    mono    fg256   bg256
; main frame
header          = black, light gray, , g90, g20
left            = , , , g70, g10
right           = , , , g80,
footer          = black, light gray, , g70, g20
logo            = dark gray,   ,  ,       g30,

; listbox
body            = , , standout, g70, g10
selected        = white, dark red, underline, g90, #800
focus           = white, dark blue, standout, g90, #008
selected focus  = white, dark magenta, standout, #fff, #707
dirmark         = , , standout

; logging
debug           = light blue, black, underline, #69f, g20
info            = light green, black, underline, #0b0, g20
warning         = yellow, black, underline, #cc0, g20
error           = light red, black, underline, #c00, g20
critical        = white, dark red, underline, #fff, #800

[theme_light]
# name             fg       bg    mono    fg256   bg256
; main frame
header          = black, light gray, , g00, g70
left            = , , , g10, g80
right           = , , , g20,
footer          = black, light gray, , g20, g70
logo            = dark gray,   ,  ,       g70,

; listbox
body            = , , standout, g10, g80
selected        = white, dark red, underline, g90, #800
focus           = white, dark blue, standout, g90, #008
selected focus  = white, dark magenta, standout, #fff, #707
dirmark         = , , standout

; logging
debug           = dark blue, light gray, underline, #008, g70
info            = dark green, light gray, underline, #060, g70
warning         = brown, light gray, underline, #880, g70
error           = dark red, light gray, underline, #800, g70
critical        = white, dark red, underline, #fff, #800


[dbtype_postgres]
module = psycopg2
query_databases = select datname from pg_database;
query_table = select * from %s %s;
query_tables = select tablename from pg_tables
    where tablename not like 'pg_%' and tablename not like 'sql_%';
query_tablecols = select
        ordinal_position,
        column_name,
        data_type,
        column_default,
        is_nullable,
        character_maximum_length,
        numeric_precision
    from
        information_schema.columns
    where
        table_name = '%s'
    order by
        ordinal_position;
query_tablecols2 = select
        ordinal_position,column_name
    from
        information_schema.key_column_usage
    where
        table_name = '%s' and constraint_name like '%%_pkey';
query_update = update only %(tbname)s
    set
        %(pair)s
    where
        %(where)s ; commit;
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.