Example #1
0
def build_sql_tab(parent):
    '''
    Builds "SQL" tab subtree of widgets

    Parameters:
        parent (Widget): Parent widget of tab subtree

    Returns:
        Widget: Subtree of widgets
    '''
    sql = Tab('SQL', parent, ord('q'))
    sql.resize(height = 22)

    input_group = sql.content_region
    input_group.scale(width = -38)

    translator = DatasigTranslator(input_group)
    translator.map_output('DB_RAW_QUERY', text = 'raw')

    form = Form(translator, text = '')

    text_in = TextBox('Input', form, ord('i'))
    text_in.scale(height = -2)
    text_in.linked_label.embellish(' ', ' ').offset(x = 2)

    translator = DatasigTranslator(form)
    translator.map_output('UI_SUBMIT')

    submit = Button('Submit', translator, ord('s'))
    submit.move(y = 16)

    translator = DatasigTranslator(form)
    translator.map_output('UI_CLEAR_FORM')

    reset = Button('Reset', translator, ord('r'))
    reset.move(x = 12, y = 16)

    output_group = sql.content_region
    output_group.scale(width = -38).offset(x = 38)

    form = Form(output_group)

    translator = DatasigTranslator(form)
    translator.map_input('UI_RAW_QUERY', result = 'text')
    translator.map_focus('UI_RAW_QUERY')

    text_out = TextBox('Output', translator, ord('o'))
    text_out.read_only()
    text_out.scale(height = -2)
    text_out.linked_label.embellish(' ', ' ').offset(x = 2)

    translator = DatasigTranslator(form)
    translator.map_output('UI_CLEAR_FORM')

    clear = Button('Clear', translator, ord('c'))
    clear.move(y = 16)

    return sql
Example #2
0
def build_table_tab(parent):
    '''
    Builds "Table" tab subtree of widgets

    Parameters:
        parent (Widget): Parent widget of tab subtree

    Returns:
        Widget: Subtree of widgets
    '''
    table = Tab('Table', parent, ord('t'))
    table.resize(height = 22)
    table_group = table.content_region

    translator = DatasigTranslator(table_group)
    translator.map_input('UI_TABLE_LIST', tables = 'options')
    translator.map_output('DB_SET_TABLE', option = 'table')
    translator.map_request('DB_LIST_TABLES')

    table_list = SelectField('Table List', translator, ord('t'))
    table_list.auto_expand()
    table_list.limit_options(5)
    table_list.resize(width = 30)
    table_list.align('CENTER')
    table_list.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    tab_group = table.content_region.scale(height = -3).offset(y = 3)

    content_tab = VertTab('Content', tab_group, ord('c'))
    structure_tab = VertTab('Structure', tab_group, ord('s'))

    content_tab_group = content_tab.content_region
    content_tab_group.outset(1).scale(width = -2).offset(x = 2)

    structure_tab_group = structure_tab.content_region
    structure_tab_group.outset(1).scale(width = -2).offset(x = 2)

    translator = DatasigTranslator(content_tab_group)
    translator.map_input('UI_TABLE_CONTENT', table_content = 'table')
    translator.map_request('DB_TABLE_CONTENT')

    table_content = Table('Inspect Table', translator, ord('i'))
    table_content.linked_label.hide()
    table_content.add_signal_handler('UI_SET_TABLE', table_content.request)

    translator = DatasigTranslator(structure_tab_group)
    translator.map_input('UI_TABLE_STRUCTURE', table_structure = 'table')
    translator.map_request('DB_TABLE_STRUCTURE')

    table_structure = Table('Inspect Table', translator, ord('i'))
    table_structure.linked_label.hide()
    table_structure.add_signal_handler('UI_SET_TABLE', table_structure.request)

    return table
Example #3
0
def build_home_tab(parent):
    '''
    Builds "Home" tab subtree of widgets

    Parameters:
        parent (Widget): Parent widget of tab subtree

    Returns:
        Widget: Subtree of widgets
    '''
    home = Tab('Home', parent, ord('h'))
    home.resize(height = 22)

    title = Text('Title', home, style = 'title')
    title.add_raw(title_string)
    title.resize(48, 14)
    title.align('CENTER')
    title.offset(0, 3)

    translator = DatasigTranslator(home)
    translator.map_output('UI_PROMPT_CONFIRM')

    form = Form(
        translator,
        prompt = 'Are you sure you want to exit?',
        sigconfirm = signals.Signal('UI_EXIT')
    )

    translator = DatasigTranslator(form)
    translator.map_output('UI_SUBMIT')

    exit = Button('Exit', translator, ord('e'))
    exit.align('CENTER')
    exit.offset(0, 18)

    return home
Example #4
0
def build_database_tab(parent):
    '''
    Builds "Database" tab subtree of widgets

    Parameters:
        parent (Widget): Parent widget of tab subtree

    Returns:
        Widget: Subtree of widgets
    '''
    database = Tab('Database', parent, ord('d'))
    database.resize(height = 22)
    database_group = database.content_region

    translator = DatasigTranslator(database_group)
    translator.map_input('UI_DATABASE_LIST', databases = 'options')
    translator.map_output('DB_SET_DATABASE', option = 'database')
    translator.map_request('DB_LIST_DATABASES')

    database_list = SelectField('Database List', translator, ord('d'))
    database_list.auto_expand()
    database_list.resize(width = 30)
    database_list.align('CENTER')
    database_list.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    tab_group = database.content_region.scale(height = -3).offset(y = 3)

    import_tab = VertTab('Import', tab_group, ord('i'))
    export_tab = VertTab('Export', tab_group, ord('e'))

    import_tab_group = import_tab.content_region
    export_tab_group = export_tab.content_region

    translator = DatasigTranslator(import_tab_group)
    translator.map_output('DB_IMPORT_DATABASE')

    form = Form(
        translator,
        pathname = '', filename = '', clean = False
    )

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'pathname')

    import_path = TextField('Path', translator, ord('p'))
    import_path.scale(width = -12).offset(x = 12)
    import_path.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'filename')

    import_file = TextField('Filename', translator, ord('f'))
    import_file.scale(width = -12).offset(12, 3)
    import_file.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', enabled = 'clean')

    overwrite = FlipSwitch('Overwrite Existing', translator, ord('o'))
    overwrite.offset(32, 6)
    overwrite.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('UI_SUBMIT')

    import_button = Button('Import', translator, ord('i'))
    import_button.offset(12, 10)

    translator = DatasigTranslator(export_tab_group)
    translator.map_output('DB_EXPORT_DATABASE')

    form = Form(
        translator,
        pathname = '', filename = '', plain = False, schema = False
    )

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'pathname')

    export_path = TextField('Path', translator, ord('p'))
    export_path.scale(width = -12).offset(x = 12)
    export_path.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'filename')

    export_file = TextField('Filename', translator, ord('f'))
    export_file.scale(width = -12).offset(12, 3)
    export_file.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', enabled = 'plain')

    plaintext = FlipSwitch('Plain Text', translator, ord('t'))
    plaintext.offset(24, 6)
    plaintext.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', enabled = 'schema')

    schema_only = FlipSwitch('Schema Only', translator, ord('s'))
    schema_only.offset(50, 6)
    schema_only.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('UI_SUBMIT')

    export_button = Button('Export', translator, ord('e'))
    export_button.offset(12, 10)

    return database
Example #5
0
def build_server_tab(parent):
    '''
    Builds "Server" tab subtree of widgets

    Parameters:
        parent (Widget): Parent widget of tab subtree

    Returns:
        Widget: Subtree of widgets
    '''
    offset = [0, 3]
    input_field_size = 30
    button_offset = 25

    server = Tab('Server', parent, ord('s'))
    server.resize(height = 22)

    translator = DatasigTranslator(server)
    translator.map_output('DB_CONNECT')

    form = Form(
        translator,
        hostname = None, port = None, username = None, password = None
    )

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'hostname')

    hostname = TextField('Host Name', translator, ord('h'))
    hostname.resize(width = input_field_size)
    hostname.align('CENTER')
    hostname.offset(*offset)
    hostname.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', number = 'port')

    port = NumericField('Port Number', translator, ord('n'))
    port.resize(width = input_field_size)
    port.align('CENTER')
    port.move(y = 3)
    port.offset(*offset)
    port.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'username')

    username = TextField('User Name', translator, ord('u'))
    username.resize(width = input_field_size)
    username.align('CENTER')
    username.move (y = 6)
    username.offset(*offset)
    username.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('DATASIG_OUT', text = 'password')

    password = TextField('Password', translator, ord('p'))
    password.resize(width = input_field_size)
    password.align('CENTER')
    password.move (y = 9)
    password.offset(*offset)
    password.obscure()
    password.linked_label.embellish(suffix = ': ').to_center(cross = True).shift(-1)

    translator = DatasigTranslator(form)
    translator.map_output('UI_SUBMIT')

    offset[0] = button_offset
    connect = Button('Connect', translator, ord('c'))
    connect.move(y = 13)
    connect.offset(*offset)

    translator = DatasigTranslator(server)
    translator.map_output('DB_DISCONNECT')

    offset[0] += 16
    disconnect = Button('Disconnect', translator, ord('d'))
    disconnect.move(y = 13)
    disconnect.offset(*offset)

    return server