Beispiel #1
0
def Navigation(params=None, page=None):
    p = Page()

    with p.nav({'class': 'navbar navbar-default'}):
        with p.div({'class': 'container-fluid'}):
            with p.div({'class': 'navbar-header'}):
                with p.button({
                        'type': 'button',
                        'class': 'navbar-toggle collapsed',
                        'data-toggle': 'collapse',
                        'data-target': '#navbar',
                        'aria-expanded': 'false',
                        'aria-controls': 'navbar'
                }):
                    with p.span({'class': 'sr-only'}):
                        p.content('Toggle navigation')
                    with p.span({'class': 'icon-bar'}):
                        pass
                    with p.span({'class': 'icon-bar'}):
                        pass
                    with p.span({'class': 'icon-bar'}):
                        pass

                with p.a({'class': 'navbar-brand', 'href': '/'}):
                    p.content('pgui')

            with p.div({'id': 'navbar', 'class': 'navbar-collapse collapse'}):
                with p.ul({'class': 'nav navbar-nav'}):
                    for i, page in enumerate(pages.index.PAGES, 1):
                        active = page['name'] == page and 'active' or ''
                        with p.li({'class': active}):
                            with p.a({
                                    'id': 'page-%s' % i,
                                    'href': '/%s' % page['name']
                            }):
                                with p.span({
                                        'class':
                                        'glyphicon glyphicon-%s' % page['icon']
                                }):
                                    pass
                                p.content(' %s' % page['name'].title())

                with p.ul({'class': 'nav navbar-nav navbar-right'}):
                    with p.li():
                        with p.a({'href': '/logout'}):
                            with p.span(
                                {'class': 'glyphicon glyphicon-log-out'}):
                                p.content(' Logout')

    return p
Beispiel #2
0
def Navigation(params=None, page=None):
    p = Page()

    with p.nav({'class': 'navbar navbar-default'}):
        with p.div({'class': 'container-fluid'}):
            with p.div({'class': 'navbar-header'}):
                with p.button({'type': 'button',
                               'class': 'navbar-toggle collapsed',
                               'data-toggle': 'collapse',
                               'data-target': '#navbar',
                               'aria-expanded': 'false',
                               'aria-controls': 'navbar'}):
                    with p.span({'class': 'sr-only'}):
                        p.content('Toggle navigation')
                    with p.span({'class': 'icon-bar'}): pass
                    with p.span({'class': 'icon-bar'}): pass
                    with p.span({'class': 'icon-bar'}): pass

                with p.a({'class': 'navbar-brand', 'href': '/'}):
                    p.content('pgui')

            with p.div({'id': 'navbar', 'class': 'navbar-collapse collapse'}):
                with p.ul({'class': 'nav navbar-nav'}):
                    for i, page in enumerate(pages.index.PAGES, 1):
                        active = page['name'] == page and 'active' or ''
                        with p.li({'class': active}):
                            with p.a({'id': 'page-%s' % i, 'href': '/%s' % page['name']}):
                                with p.span({'class': 'glyphicon glyphicon-%s' % page['icon']}): pass
                                p.content(' %s' % page['name'].title())

                with p.ul({'class': 'nav navbar-nav navbar-right'}):
                    with p.li():
                        with p.a({'href': '/logout'}):
                            with p.span({'class': 'glyphicon glyphicon-log-out'}):
                                p.content(' Logout')

    return p
Beispiel #3
0
def Query(params=None):
    handle_params(params)
    p = Page()

    # Header
    p.add_page(Header(title='Query',
                      js=['static/pages/query.js',
                          'static/pages/query_completion.js',
                          'static/pages/keywords.js',
                          'static/lib/springy/springy.js',
                          'static/lib/springy/springyui.js'],
                      css=['static/pages/query.css']))
    with p.script():
        p.content('PGUI.QUERY.keymap = "%s";' % current_user.keymap)
    p.add_page(Navigation(page='query'))

    with p.div({'class': 'container-fluid'}):
        # Modal dialog for displaying previous queries
        with p.div({'class': 'modal fade', 'id': 'query-history-dialog', 'tabindex': '-1', 'role': 'dialog', 'aria-labelledby': 'Query History'}):
            with p.div({'class': 'modal-dialog', 'role': 'document'}):
                with p.div({'class': 'modal-content'}):
                    with p.div({'class': 'modal-header'}):
                        with p.button({'type': 'button', 'class': 'close', 'data-dismiss': 'modal', 'aria-label': 'Close'}):
                            with p.span({'aria-hidden': 'true'}):
                                p.content('×')
                        with p.h4({'class': 'modal-title', 'id': 'query-history-label'}):
                            p.content('Query history')

                    with p.div({'clas': 'modal-body'}):
                        with p.div({'id': 'query-history'}): pass

        # Tab bar controls
        with p.div({'id': 'query-panel', 'role': 'tabpanel'}):
            with p.ul({'id': 'query-nav-tabs', 'class': 'nav nav-tabs', 'role': 'tablist'}):
                with p.li({'role': 'presentation'}):
                    with p.a({'id': 'show-query-history', 'href': 'javascript:void(0);'}):
                        with p.span({'class': 'add-tab glyphicon glyphicon-camera', 'aria-hidden': 'true'}): pass
                with p.li({'role': 'presentation'}):
                    with p.a({'id': 'add-tab', 'href': 'javascript:void(0);'}):
                        with p.span({'class': 'add-tab glyphicon glyphicon-plus', 'aria-hidden': 'true'}): pass
            # Tab bar contents
            with p.div({'id': 'query-tab-panes', 'class': 'tab-content'}): pass

    # Footer
    p.add_page(Footer())

    return p
Beispiel #4
0
def Index(params=None):
    """
    Renders the index page which displays some generic connections
    information and links to all the activated modules.
    """
    handle_params(params)
    p = Page()

    # Header
    p.add_page(Header(title='Index'))
    p.add_page(Navigation(page='index'))

    with p.div({'class': 'container-fluid'}):
        # Connection information
        data, params = [], defaultdict(str)
        param_keys = ('server_version', 'server_encoding', 'client_encoding', 'is_superuser', 'TimeZone')
        with pg_connection(*current_user.get_config()) as (con, cur, err):
            for k in param_keys:
                params[k] = con.get_parameter_status(k)
            with pg_log_err('list databases'):
                cur.execute(query('list-databases'))
                data = cur.fetchall()

        with p.div({'class': 'row'}):
            with p.div({'class': 'col-md-2'}):
                with p.div({'class': 'btn-group'}):
                    with p.button({'class': 'btn btn-default dropdown-toggle', 'data-toggle': 'dropdown', 'aria-expanded': 'false'}):
                        p.content('Switch database <span class="caret"></span>')
                    with p.ul({'class': 'dropdown-menu', 'role': 'menu'}):
                        for n, d in enumerate(data):
                            with p.li():
                                with p.a({'href': 'index?database=%s' % d[0]}):
                                    p.content(d[0])
                            if n < len(data) - 1:
                                with p.li({'class': 'divider'}): pass

            with p.div({'class': 'col-md-4 small'}):
                p.content('<strong>%s</strong>' % current_user.database)
                p.content('<br>%s@%s:%s' % (current_user.name, current_user.host, current_user.port))

            with p.div({'class': 'col-md-6 small'}):
                with p.ul({'class': 'list-inline'}):
                    for k, v in sorted(params.items()):
                        with p.li():
                            p.content('%s: %s' % (k, v))

        with p.hr(): pass

        # Modules
        cols = 12
        col_size = 4
        col = 0
        for page in PAGES[1:]:
            if col == 0:
                with p.div({'class': 'row'}, close=False): pass

            with p.div({'class': 'col-md-%s' % col_size}):
                with p.a({'href': '/%s' % page['name']}):
                    with p.div({'class': 'page-link'}):
                        with p.span({'class': 'page-icon glyphicon glyphicon-%s' % page['icon']}): pass
                        with p.h3():
                            p.content(page['caption'])
                        p.content(page['desc'])

            col = (col + col_size) % cols
            if col == 0:
                p.close('div')

    p.add_page(Footer())

    return p
Beispiel #5
0
def Structure(params=None):
    handle_params(params)
    p = Page()

    # Header
    p.add_page(Header(title='Structure',
                      js=['static/pages/structure.js'],
                      css=['static/pages/structure.css']))
    p.add_page(Navigation(page='structure'))

    with p.div({'class': 'container-fluid'}):
        schemas, schema_cols, table_data, table_cols = get_data()

        with p.ul():
            for schema in schemas:
                with p.div({'class': 'panel panel-default'}):
                    with p.div({'class': 'panel-heading'}):
                        with p.div({'class': 'row'}):
                            with p.div({'class': 'col-md-2'}):
                                with p.a({'class': 'btn btn-success btn-xs schema-btn',
                                          'data-toggle': 'collapse',
                                          'href': '#%s' % schema[0],
                                          'aria-expanded': 'false',
                                          'aria-controls': schema[0]}):
                                    p.content('%s - %s' % (schema[0], schema[1]))

                            with p.div({'class': 'col-md-10'}):
                                with p.ul({'class': 'list-inline'}):
                                    for i, col in enumerate(schema_cols, 2):
                                        with p.li():
                                            p.content('<strong>%s</strong> %s' % (schema[i], col))

                    with p.div({'class': 'panel-body'}):
                        with p.div({'class': 'row collapse', 'id': schema[0]}):
                            with p.div({'class': 'col-md-2'}):
                                with p.div({'class': 'well'}):
                                    with p.b():
                                        p.content('Tables')

                                    with p.ul():
                                        for table in table_data[schema[0]]:
                                            with p.li():
                                                with p.a({'href': '#', 'onclick': 'PGUI.STRUCTURE.show_table_details(\'%s\', \'%s\'); return false;' % (schema[0], table)}):
                                                    p.content(table)

                            with p.div({'class': 'col-md-10'}):
                                for table in table_data[schema[0]]:
                                    with p.div({'id': 'table-details-%s-%s' % (schema[0], table), 'class': 'table-details table-details-%s' % schema[0]}):
                                        data = table_data[schema[0]][table]
                                        with p.p():
                                            p.content('Table size: ')
                                            with p.b():
                                                p.content(data['table-size'])

                                        with p.table({'class': 'table table-condensed'}):
                                            with p.tr():
                                                for tc in table_cols:
                                                    with p.th():
                                                        p.content(tc)
                                                with p.th({'id': 'col-size-header-%s-%s' % (schema[0], table)}):
                                                    with p.a({'href': '#',
                                                              'onclick': 'PGUI.STRUCTURE.get_col_size(\'%s\', \'%s\'); return false;' % (schema[0], table)}):
                                                        p.content('Get column sizes')

                                            for row in zip(*data['column-data'].values()):
                                                with p.tr():
                                                    for col in row:
                                                        with p.td():
                                                            p.content(col)
                                                    with p.td({'id': 'col-size-%s-%s-%s' % (schema[0], table, row[0])}):
                                                        pass

    p.add_page(Footer())

    return p
Beispiel #6
0
def Index(params=None):
    """
    Renders the index page which displays some generic connections
    information and links to all the activated modules.
    """
    handle_params(params)
    p = Page()

    # Header
    p.add_page(Header(title='Index'))
    p.add_page(Navigation(page='index'))

    with p.div({'class': 'container-fluid'}):
        # Connection information
        data, params = [], defaultdict(str)
        param_keys = ('server_version', 'server_encoding', 'client_encoding',
                      'is_superuser', 'TimeZone')
        with pg_connection(*current_user.get_config()) as (con, cur, err):
            for k in param_keys:
                params[k] = con.get_parameter_status(k)
            with pg_log_err('list databases'):
                cur.execute(query('list-databases'))
                data = cur.fetchall()

        with p.div({'class': 'row'}):
            with p.div({'class': 'col-md-2'}):
                with p.div({'class': 'btn-group'}):
                    with p.button({
                            'class': 'btn btn-default dropdown-toggle',
                            'data-toggle': 'dropdown',
                            'aria-expanded': 'false'
                    }):
                        p.content(
                            'Switch database <span class="caret"></span>')
                    with p.ul({'class': 'dropdown-menu', 'role': 'menu'}):
                        for n, d in enumerate(data):
                            with p.li():
                                with p.a({'href': 'index?database=%s' % d[0]}):
                                    p.content(d[0])
                            if n < len(data) - 1:
                                with p.li({'class': 'divider'}):
                                    pass

            with p.div({'class': 'col-md-4 small'}):
                p.content('<strong>%s</strong>' % current_user.database)
                p.content(
                    '<br>%s@%s:%s' %
                    (current_user.name, current_user.host, current_user.port))

            with p.div({'class': 'col-md-6 small'}):
                with p.ul({'class': 'list-inline'}):
                    for k, v in sorted(params.items()):
                        with p.li():
                            p.content('%s: %s' % (k, v))

        with p.hr():
            pass

        # Modules
        cols = 12
        col_size = 4
        col = 0
        for page in PAGES[1:]:
            if col == 0:
                with p.div({'class': 'row'}, close=False):
                    pass

            with p.div({'class': 'col-md-%s' % col_size}):
                with p.a({'href': '/%s' % page['name']}):
                    with p.div({'class': 'page-link'}):
                        with p.span({
                                'class':
                                'page-icon glyphicon glyphicon-%s' %
                                page['icon']
                        }):
                            pass
                        with p.h3():
                            p.content(page['caption'])
                        p.content(page['desc'])

            col = (col + col_size) % cols
            if col == 0:
                p.close('div')

    p.add_page(Footer())

    return p
Beispiel #7
0
def Query(params=None):
    handle_params(params)
    p = Page()

    # Header
    p.add_page(
        Header(title='Query',
               js=[
                   'static/pages/query.js', 'static/pages/query_completion.js',
                   'static/pages/keywords.js', 'static/lib/springy/springy.js',
                   'static/lib/springy/springyui.js'
               ],
               css=['static/pages/query.css']))
    with p.script():
        p.content('PGUI.QUERY.keymap = "%s";' % current_user.keymap)
    p.add_page(Navigation(page='query'))

    with p.div({'class': 'container-fluid'}):
        # Modal dialog for displaying previous queries
        with p.div({
                'class': 'modal fade',
                'id': 'query-history-dialog',
                'tabindex': '-1',
                'role': 'dialog',
                'aria-labelledby': 'Query History'
        }):
            with p.div({'class': 'modal-dialog', 'role': 'document'}):
                with p.div({'class': 'modal-content'}):
                    with p.div({'class': 'modal-header'}):
                        with p.button({
                                'type': 'button',
                                'class': 'close',
                                'data-dismiss': 'modal',
                                'aria-label': 'Close'
                        }):
                            with p.span({'aria-hidden': 'true'}):
                                p.content('&times;')
                        with p.h4({
                                'class': 'modal-title',
                                'id': 'query-history-label'
                        }):
                            p.content('Query history')

                    with p.div({'clas': 'modal-body'}):
                        with p.div({'id': 'query-history'}):
                            pass

        # Tab bar controls
        with p.div({'id': 'query-panel', 'role': 'tabpanel'}):
            with p.ul({
                    'id': 'query-nav-tabs',
                    'class': 'nav nav-tabs',
                    'role': 'tablist'
            }):
                with p.li({'role': 'presentation'}):
                    with p.a({
                            'id': 'show-query-history',
                            'href': 'javascript:void(0);'
                    }):
                        with p.span({
                                'class': 'add-tab glyphicon glyphicon-camera',
                                'aria-hidden': 'true'
                        }):
                            pass
                with p.li({'role': 'presentation'}):
                    with p.a({'id': 'add-tab', 'href': 'javascript:void(0);'}):
                        with p.span({
                                'class': 'add-tab glyphicon glyphicon-plus',
                                'aria-hidden': 'true'
                        }):
                            pass
            # Tab bar contents
            with p.div({'id': 'query-tab-panes', 'class': 'tab-content'}):
                pass

    # Footer
    p.add_page(Footer())

    return p