Exemple #1
0
 private void evaluate_unrestricted_nothread(
     final String sql, final int maxDisplayedRowCount, boolean isUpdatable) {
   closeLastExecution();
   SwingUtilities.invokeLater(
       new Runnable() {
         @Override
         public void run() {
           startButton.setVisible(false);
           stopButton.setVisible(true);
           stopButton.setToolTipText("Query started on " + Utils.formatDateTimeTZ(new Date()));
         }
       });
   QueryExecutor queryExecutor;
   synchronized (STATEMENT_EXECUTOR_CREATOR_LOCK) {
     queryExecutor = queryExecutorCreator.createQueryExecutor(executionContextName);
     lastStatementExecutor = queryExecutor;
   }
   QueryExecution queryExecution;
   try {
     queryExecution =
         queryExecutor.execute(
             sql,
             isUsingMaxRowCount ? MAX_ROW_COUNT : Integer.MAX_VALUE,
             maxDisplayedRowCount,
             isUpdatable);
   } finally {
     SwingUtilities.invokeLater(
         new Runnable() {
           @Override
           public void run() {
             startButton.setVisible(true);
             stopButton.setVisible(false);
             stopButton.setToolTipText(null);
           }
         });
   }
   final QueryExecutionResult[] results = queryExecution.getResults();
   final long executionDuration = queryExecution.getExecutionDuration();
   SwingUtilities.invokeLater(
       new Runnable() {
         @Override
         public void run() {
           for (QueryExecutionResult result : results) {
             if (result instanceof QueryExecutionMessageResult) {
               QueryExecutionMessageResult messageResult = (QueryExecutionMessageResult) result;
               setMessage(addResultPane(), messageResult.getMessage(), messageResult.isError());
             } else if (result instanceof StatementExecutionResultSetResult) {
               addResultTable(sql, executionDuration, (StatementExecutionResultSetResult) result);
             } else {
               throw new IllegalStateException(
                   "Unknown result class: " + result.getClass().getName());
             }
           }
         }
       });
 }
Exemple #2
0
 void closeLastExecution() {
   synchronized (STATEMENT_EXECUTOR_CREATOR_LOCK) {
     if (lastStatementExecutor != null) {
       lastStatementExecutor.stopExecution();
       lastStatementExecutor = null;
     }
   }
 }
Exemple #3
0
 private CompletionCandidate[] getFilteredWords(int wordStart, String word) {
   List<CompletionCandidate> candidateList = new ArrayList<CompletionCandidate>();
   // Here can add more candidates depending on magic word start.
   if (candidateList.isEmpty()) {
     QueryExecutor queryExecutor = queryExecutorCreator.createQueryExecutor(executionContextName);
     for (String s : queryExecutor.getTableNames()) {
       candidateList.add(new CompletionCandidate(KeyWordType.TABLE, s));
     }
     for (String s : queryExecutor.getTableColumnNames()) {
       candidateList.add(new CompletionCandidate(KeyWordType.TABLE_COlUMN, s));
     }
     queryExecutor.stopExecution();
     for (String s :
         new String[] {
           "ALTER", "ASC", "BY", "DESC", "DROP", "FROM", "IN", "INNER", "INSERT", "INTO", "JOIN",
           "LEFT", "NOT", "ORDER", "SELECT", "UPDATE", "WHERE", "AND", "OR", "EXISTS", "HAVING",
           "TOP", "GROUP", "SET",
         }) {
       candidateList.add(new CompletionCandidate(KeyWordType.KEYWORD, s));
     }
   }
   word = word.toUpperCase(Locale.ENGLISH);
   List<CompletionCandidate> filteredCompletionCandidateList =
       new ArrayList<CompletionCandidate>();
   for (CompletionCandidate completionCandidate : candidateList) {
     if (completionCandidate
         .toString()
         .toLowerCase(Locale.ENGLISH)
         .startsWith(word.toLowerCase(Locale.ENGLISH))) {
       filteredCompletionCandidateList.add(completionCandidate);
     }
   }
   Collections.sort(
       filteredCompletionCandidateList,
       new Comparator<CompletionCandidate>() {
         @Override
         public int compare(CompletionCandidate o1, CompletionCandidate o2) {
           return String.CASE_INSENSITIVE_ORDER.compare(o1.toString(), o2.toString());
         }
       });
   return filteredCompletionCandidateList.toArray(new CompletionCandidate[0]);
 }