Search in sources :

Example 1 with SQLHistory

use of net.sourceforge.sqlexplorer.history.SQLHistory in project tdq-studio-se by Talend.

the class SQLHistoryView method createPartControl.

/*
     * (non-Javadoc)
     * 
     * @see org.eclipse.ui.IWorkbenchPart#createPartControl(org.eclipse.swt.widgets.Composite)
     */
public void createPartControl(final Composite parent) {
    // MOD gdbu 2011-4-29 bug : 20960
    SQLHistory tem_history = SQLExplorerPlugin.getDefault().getSQLHistory();
    final SQLHistory history = tem_history == null ? new SQLHistory() : tem_history;
    // ~20960
    history.sort(1, SWT.DOWN);
    // $NON-NLS-1$
    PlatformUI.getWorkbench().getHelpSystem().setHelp(parent, SQLExplorerPlugin.PLUGIN_ID + ".SQLHistoryView");
    history.addListener(this);
    Composite composite = new Composite(parent, SWT.NULL);
    GridLayout layout = new GridLayout();
    layout.numColumns = 1;
    layout.marginLeft = 0;
    layout.horizontalSpacing = 0;
    layout.verticalSpacing = 2;
    layout.marginWidth = 0;
    layout.marginHeight = 0;
    composite.setLayout(layout);
    composite.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true));
    // add search box
    _searchBox = new Text(composite, SWT.BORDER);
    _searchBox.setLayoutData(new GridData(SWT.FILL, SWT.TOP, true, false));
    // $NON-NLS-1$
    _searchBox.setText(Messages.getString("SQLHistoryView.SearchText"));
    _searchBox.selectAll();
    SQLHistorySearchListener searchListener = new SQLHistorySearchListener(history);
    _searchBox.addModifyListener(searchListener);
    _searchBox.addMouseListener(new MouseAdapter() {

        public void mouseDown(MouseEvent e) {
            Text searchbox = (Text) e.widget;
            if (searchbox.getText() != null && searchbox.getText().equals(Messages.getString("SQLHistoryView.SearchText"))) {
                searchbox.setText("");
            }
        }
    });
    _tableViewer = new TableViewer(composite, SWT.V_SCROLL | SWT.H_SCROLL | SWT.FULL_SELECTION | SWT.MULTI | SWT.VIRTUAL);
    getSite().setSelectionProvider(_tableViewer);
    _table = _tableViewer.getTable();
    _table.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true));
    _table.setHeaderVisible(true);
    _table.setLinesVisible(true);
    _table.setItemCount(history.getEntryCount());
    _tableViewer.setLabelProvider(new SQLHistoryLabelProvider());
    _tableViewer.setContentProvider(new IStructuredContentProvider() {

        public void dispose() {
        }

        public Object[] getElements(Object inputElement) {
            return SQLExplorerPlugin.getDefault().getSQLHistory().toArray();
        }

        public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {
        }
    });
    _tableViewer.setInput(history);
    // create listener for sorting
    Listener sortListener = new Listener() {

        public void handleEvent(Event e) {
            // determine new sort column and direction
            TableColumn sortColumn = _table.getSortColumn();
            TableColumn currentColumn = (TableColumn) e.widget;
            int dir = _table.getSortDirection();
            if (sortColumn == currentColumn) {
                dir = dir == SWT.UP ? SWT.DOWN : SWT.UP;
            } else {
                _table.setSortColumn(currentColumn);
                dir = SWT.UP;
            }
            sortColumn = _table.getSortColumn();
            TableColumn[] cols = _table.getColumns();
            for (int i = 0; i < cols.length; i++) {
                if (cols[i] == sortColumn) {
                    history.sort(i, dir);
                    break;
                }
            }
            // update data displayed in table
            _table.setSortDirection(dir);
            _tableViewer.refresh();
        }
    };
    String[] columnLabels = new String[] { Messages.getString("SQLHistoryView.Column.SQL"), Messages.getString("SQLHistoryView.Column.Time"), Messages.getString("SQLHistoryView.Column.Connection"), Messages.getString("SQLHistoryView.Column.Executions") };
    _tableViewer.setColumnProperties(columnLabels);
    // add all column headers to our table
    for (int i = 0; i < columnLabels.length; i++) {
        // add column header
        TableColumn column = new TableColumn(_table, SWT.LEFT);
        column.setText(columnLabels[i]);
        column.setMoveable(false);
        column.setResizable(true);
        column.addListener(SWT.Selection, sortListener);
    }
    _tableViewer.refresh();
    // add sizing weights to the different columns
    TableLayout tableLayout = new TableLayout();
    tableLayout.addColumnData(new ColumnWeightData(7, 150));
    tableLayout.addColumnData(new ColumnWeightData(2, 120));
    tableLayout.addColumnData(new ColumnWeightData(1, 50));
    tableLayout.addColumnData(new ColumnWeightData(1, 50));
    _table.setLayout(tableLayout);
    _table.layout();
    // redraw table if view is resized
    parent.addControlListener(new ControlAdapter() {

        public void controlResized(ControlEvent e) {
            super.controlResized(e);
            // reset weights in case of view resizing
            TableLayout tableLayout = new TableLayout();
            tableLayout.addColumnData(new ColumnWeightData(7, 150));
            tableLayout.addColumnData(new ColumnWeightData(2, 120));
            tableLayout.addColumnData(new ColumnWeightData(1, 50));
            tableLayout.addColumnData(new ColumnWeightData(1, 50));
            _table.setLayout(tableLayout);
        }
    });
    // create action bar
    final IToolBarManager toolBarMgr = getViewSite().getActionBars().getToolBarManager();
    final SQLHistoryActionGroup actionGroup = new SQLHistoryActionGroup(this, history, _tableViewer, toolBarMgr);
    _tableViewer.addSelectionChangedListener(new ISelectionChangedListener() {

        public void selectionChanged(SelectionChangedEvent event) {
            actionGroup.refresh();
            toolBarMgr.update(true);
        }
    });
    // add context menus
    final MenuManager menuMgr = new MenuManager("#HistoryPopupMenu");
    menuMgr.setRemoveAllWhenShown(true);
    Menu historyContextMenu = menuMgr.createContextMenu(_table);
    _table.setMenu(historyContextMenu);
    menuMgr.addMenuListener(new IMenuListener() {

        public void menuAboutToShow(IMenuManager manager) {
            toolBarMgr.markDirty();
            actionGroup.fillContextMenu(manager);
        }
    });
    // also add action as default when an entry is doubleclicked.
    final OpenInEditorAction openInEditorAction = new OpenInEditorAction();
    openInEditorAction.setTableViewer(_tableViewer);
    openInEditorAction.setView(this);
    _tableViewer.addDoubleClickListener(new IDoubleClickListener() {

        public void doubleClick(DoubleClickEvent event) {
            openInEditorAction.run();
        }
    });
    // add remove action on delete key
    final RemoveFromHistoryAction removeFromHistoryAction = new RemoveFromHistoryAction();
    removeFromHistoryAction.setTableViewer(_tableViewer);
    _table.addKeyListener(new KeyAdapter() {

        public void keyReleased(KeyEvent e) {
            // delete entry
            if (e.keyCode == SWT.DEL) {
                removeFromHistoryAction.run();
            }
        }
    });
    // Set multi-line tooltip
    final Display display = parent.getDisplay();
    _tipShell = new Shell(parent.getShell(), SWT.ON_TOP);
    GridLayout gridLayout = new GridLayout();
    gridLayout.numColumns = 2;
    gridLayout.marginWidth = 2;
    gridLayout.marginHeight = 2;
    _tipShell.setLayout(gridLayout);
    _tipShell.setBackground(display.getSystemColor(SWT.COLOR_INFO_BACKGROUND));
    _tipLabelText = new Label(_tipShell, SWT.WRAP | SWT.LEFT);
    _tipLabelText.setForeground(display.getSystemColor(SWT.COLOR_INFO_FOREGROUND));
    _tipLabelText.setBackground(display.getSystemColor(SWT.COLOR_INFO_BACKGROUND));
    GridData gridData = new GridData(GridData.FILL_HORIZONTAL | GridData.VERTICAL_ALIGN_CENTER);
    _tipLabelText.setLayoutData(gridData);
    _table.addMouseListener(new MouseAdapter() {

        public void mouseDown(MouseEvent e) {
            if (_tipShell.isVisible()) {
                _tipShell.setVisible(false);
                _tipWidget = null;
            }
        }
    });
    _table.addMouseTrackListener(new MouseTrackAdapter() {

        public void mouseExit(MouseEvent e) {
            if (_tipShell.isVisible())
                _tipShell.setVisible(false);
            _tipWidget = null;
        }

        /*
             * (non-Javadoc)
             * 
             * @see org.eclipse.swt.events.MouseTrackListener#mouseHover(org.eclipse.swt.events.MouseEvent)
             */
        public void mouseHover(MouseEvent event) {
            Point pt = new Point(event.x, event.y);
            Widget widget = event.widget;
            TableItem tableItem = null;
            if (widget instanceof Table) {
                Table table = (Table) widget;
                widget = table.getItem(pt);
            }
            if (widget instanceof TableItem) {
                tableItem = (TableItem) widget;
            }
            if (widget == null) {
                _tipShell.setVisible(false);
                _tipWidget = null;
                return;
            }
            if (widget == _tipWidget)
                return;
            _tipWidget = widget;
            _tipPosition = _table.toDisplay(pt);
            SQLHistoryElement sqlString = (SQLHistoryElement) tableItem.getData();
            String text = TextUtil.getWrappedText(sqlString.getRawSQLString());
            if (text == null || text.equals("")) {
                _tipWidget = null;
                return;
            }
            // Set off the table tooltip as we provide our own
            _table.setToolTipText("");
            _tipLabelText.setText(text);
            _tipShell.pack();
            setHoverLocation(_tipShell, _tipPosition, _tipLabelText.getBounds().height);
            _tipShell.setVisible(true);
        }
    });
    _tableViewer.setSelection(null);
    composite.layout();
    parent.layout();
}
Also used : ColumnWeightData(org.eclipse.jface.viewers.ColumnWeightData) IDoubleClickListener(org.eclipse.jface.viewers.IDoubleClickListener) IMenuListener(org.eclipse.jface.action.IMenuListener) ISelectionChangedListener(org.eclipse.jface.viewers.ISelectionChangedListener) SQLHistoryChangedListener(net.sourceforge.sqlexplorer.history.SQLHistoryChangedListener) Listener(org.eclipse.swt.widgets.Listener) SQLHistorySearchListener(net.sourceforge.sqlexplorer.history.SQLHistorySearchListener) ControlAdapter(org.eclipse.swt.events.ControlAdapter) KeyAdapter(org.eclipse.swt.events.KeyAdapter) TableItem(org.eclipse.swt.widgets.TableItem) Label(org.eclipse.swt.widgets.Label) MouseTrackAdapter(org.eclipse.swt.events.MouseTrackAdapter) Widget(org.eclipse.swt.widgets.Widget) SQLHistoryLabelProvider(net.sourceforge.sqlexplorer.history.SQLHistoryLabelProvider) RemoveFromHistoryAction(net.sourceforge.sqlexplorer.history.actions.RemoveFromHistoryAction) TableViewer(org.eclipse.jface.viewers.TableViewer) Viewer(org.eclipse.jface.viewers.Viewer) SelectionChangedEvent(org.eclipse.jface.viewers.SelectionChangedEvent) SQLHistory(net.sourceforge.sqlexplorer.history.SQLHistory) KeyEvent(org.eclipse.swt.events.KeyEvent) GridLayout(org.eclipse.swt.layout.GridLayout) Shell(org.eclipse.swt.widgets.Shell) SQLHistoryElement(net.sourceforge.sqlexplorer.history.SQLHistoryElement) IDoubleClickListener(org.eclipse.jface.viewers.IDoubleClickListener) OpenInEditorAction(net.sourceforge.sqlexplorer.history.actions.OpenInEditorAction) Menu(org.eclipse.swt.widgets.Menu) TableLayout(org.eclipse.jface.viewers.TableLayout) MouseEvent(org.eclipse.swt.events.MouseEvent) Table(org.eclipse.swt.widgets.Table) Composite(org.eclipse.swt.widgets.Composite) ISelectionChangedListener(org.eclipse.jface.viewers.ISelectionChangedListener) MouseAdapter(org.eclipse.swt.events.MouseAdapter) Text(org.eclipse.swt.widgets.Text) DoubleClickEvent(org.eclipse.jface.viewers.DoubleClickEvent) Point(org.eclipse.swt.graphics.Point) SQLHistorySearchListener(net.sourceforge.sqlexplorer.history.SQLHistorySearchListener) TableColumn(org.eclipse.swt.widgets.TableColumn) Point(org.eclipse.swt.graphics.Point) IMenuListener(org.eclipse.jface.action.IMenuListener) IToolBarManager(org.eclipse.jface.action.IToolBarManager) GridData(org.eclipse.swt.layout.GridData) IStructuredContentProvider(org.eclipse.jface.viewers.IStructuredContentProvider) MenuManager(org.eclipse.jface.action.MenuManager) IMenuManager(org.eclipse.jface.action.IMenuManager) KeyEvent(org.eclipse.swt.events.KeyEvent) MouseEvent(org.eclipse.swt.events.MouseEvent) SelectionChangedEvent(org.eclipse.jface.viewers.SelectionChangedEvent) Event(org.eclipse.swt.widgets.Event) ControlEvent(org.eclipse.swt.events.ControlEvent) DoubleClickEvent(org.eclipse.jface.viewers.DoubleClickEvent) IMenuManager(org.eclipse.jface.action.IMenuManager) ControlEvent(org.eclipse.swt.events.ControlEvent) SQLHistoryActionGroup(net.sourceforge.sqlexplorer.history.actions.SQLHistoryActionGroup) TableViewer(org.eclipse.jface.viewers.TableViewer) Display(org.eclipse.swt.widgets.Display)

Example 2 with SQLHistory

use of net.sourceforge.sqlexplorer.history.SQLHistory in project tdq-studio-se by Talend.

the class SQLExplorerPlugin method start.

/**
 * Initialises the Plugin
 */
@Override
public void start(BundleContext context) throws Exception {
    super.start(context);
    this.bundleContext = context;
    try {
        getLog().addLogListener(new ILogListener() {

            @Override
            public void logging(IStatus status, String plugin) {
                Throwable t = status.getException();
                if (t != null) {
                    System.err.println(t.getMessage());
                    t.printStackTrace(System.err);
                }
            }
        });
        driverManager = new DriverManager();
        // MOD qiongli TDQ-8893.we will don't use the xml file to maintain the ManagedDrivers later.so no need to
        // laod or save the xml files.
        // driverManager.loadDrivers();
        aliasManager = new AliasManager();
        try {
            // $NON-NLS-1$
            resourceBundle = ResourceBundle.getBundle("net.sourceforge.sqlexplorer.test");
        } catch (MissingResourceException x) {
            resourceBundle = null;
        }
        // load SQL History from previous sessions
        _history = new SQLHistory();
    } catch (Exception e) {
        error("Exception during start", e);
        throw e;
    }
}
Also used : AliasManager(net.sourceforge.sqlexplorer.dbproduct.AliasManager) IStatus(org.eclipse.core.runtime.IStatus) MissingResourceException(java.util.MissingResourceException) ILogListener(org.eclipse.core.runtime.ILogListener) DriverManager(net.sourceforge.sqlexplorer.dbproduct.DriverManager) SQLHistory(net.sourceforge.sqlexplorer.history.SQLHistory) PartInitException(org.eclipse.ui.PartInitException) MissingResourceException(java.util.MissingResourceException) SQLCannotConnectException(net.sourceforge.sqlexplorer.SQLCannotConnectException)

Aggregations

SQLHistory (net.sourceforge.sqlexplorer.history.SQLHistory)2 MissingResourceException (java.util.MissingResourceException)1 SQLCannotConnectException (net.sourceforge.sqlexplorer.SQLCannotConnectException)1 AliasManager (net.sourceforge.sqlexplorer.dbproduct.AliasManager)1 DriverManager (net.sourceforge.sqlexplorer.dbproduct.DriverManager)1 SQLHistoryChangedListener (net.sourceforge.sqlexplorer.history.SQLHistoryChangedListener)1 SQLHistoryElement (net.sourceforge.sqlexplorer.history.SQLHistoryElement)1 SQLHistoryLabelProvider (net.sourceforge.sqlexplorer.history.SQLHistoryLabelProvider)1 SQLHistorySearchListener (net.sourceforge.sqlexplorer.history.SQLHistorySearchListener)1 OpenInEditorAction (net.sourceforge.sqlexplorer.history.actions.OpenInEditorAction)1 RemoveFromHistoryAction (net.sourceforge.sqlexplorer.history.actions.RemoveFromHistoryAction)1 SQLHistoryActionGroup (net.sourceforge.sqlexplorer.history.actions.SQLHistoryActionGroup)1 ILogListener (org.eclipse.core.runtime.ILogListener)1 IStatus (org.eclipse.core.runtime.IStatus)1 IMenuListener (org.eclipse.jface.action.IMenuListener)1 IMenuManager (org.eclipse.jface.action.IMenuManager)1 IToolBarManager (org.eclipse.jface.action.IToolBarManager)1 MenuManager (org.eclipse.jface.action.MenuManager)1 ColumnWeightData (org.eclipse.jface.viewers.ColumnWeightData)1 DoubleClickEvent (org.eclipse.jface.viewers.DoubleClickEvent)1