Examples of IQueryTokenizer

net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer
This should be implemented to provide script tokenizing behavior that is specific to a database. @author rmmannin

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

      _sqlFetchSizeChk.setSelected(props.getSQLUseFetchSize());
      _sqlFetchSizeField.setInt(props.getSQLFetchSize());


         if(null != _session)
         {
            IQueryTokenizer queryTokenizer = _session.getQueryTokenizer();
            TokenizerSessPropsInteractions qtp = queryTokenizer.getTokenizerSessPropsInteractions();
            if(qtp.isTokenizerDefinesStatementSeparator())
            {
               _stmtSepField.setText(queryTokenizer.getSQLStatementSeparator());
               _stmtSepField.setEditable(false);
            }
            else
            {
               _stmtSepField.setText(props.getSQLStatementSeparator());
               _stmtSepField.setEditable(true);
            }


            if (qtp.isTokenizerDefinesStartOfLineComment())
            {
               _solCommentField.setText(queryTokenizer.getLineCommentBegin());
               _solCommentField.setEditable(false);
            }
            else
            {
               _solCommentField.setText(props.getStartOfLineComment());
               _solCommentField.setEditable(true);
            }


            if (qtp.isTokenizerDefinesStatementSeparator())
            {
               _removeMultiLineComment.setSelected(queryTokenizer.isRemoveMultiLineComment());
               _removeMultiLineComment.setEnabled(false);
            }
            else
            {
               _removeMultiLineComment.setSelected(props.getRemoveMultiLineComment());

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

  }


  @Test(expected = IllegalStateException.class)
  public final void testSetQueryTokenizer()
  {
    IQueryTokenizer customTokenizer1 = FwTestUtil.getEasyMockQueryTokenizer(FIRST_STMT_SEP, "--", true, 0);


    IQueryTokenizer customTokenizer2 = FwTestUtil.getEasyMockQueryTokenizer(SECOND_STMT_SEP, "--", true, 0);


    sessionUnderTest.setQueryTokenizer(customTokenizer1);


    // this should throw an exception - should not allow multiple custom
    // tokenizers to be installed for a single session.

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

  }


  public static ISession getEasyMockSession(ISQLDatabaseMetaData md, ISQLConnection con, boolean replay)
  {
    ISession session = createMock(ISession.class);
    IQueryTokenizer tokenizer = FwTestUtil.getEasyMockQueryTokenizer();
    // IMessageHandler messageHandler = getEasyMockMessageHandler();


    expect(session.getMetaData()).andReturn(md).anyTimes();
    expect(session.getApplication()).andReturn(AppTestUtil.getEasyMockApplication()).anyTimes();
    expect(session.getQueryTokenizer()).andReturn(tokenizer).anyTimes();

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

  @Test
  public final void testGetQueryTokenizer_Default()
  {
    // These should be different since we are providing two different
    // statement separators in SessionProperties
    IQueryTokenizer qt1 = sessionUnderTest.getQueryTokenizer();


    // TODO: Temporary until we sort out a better way to do guido's fix
    // IQueryTokenizer qt2 = sessionUnderTest.getQueryTokenizer();


    assertEquals(FIRST_STMT_SEP, qt1.getSQLStatementSeparator());


    // TODO: Temporary until we sort out a better way to do guido's fix
    // assertEquals(SECOND_STMT_SEP, qt2.getSQLStatementSeparator());
  }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

  }


  @Test
  public final void testGetQueryTokenizer_Custom()
  {
    IQueryTokenizer customTokenizer = FwTestUtil.getEasyMockQueryTokenizer(CUSTOM_STMT_SEP, "--", true, 0);


    sessionUnderTest.setQueryTokenizer(customTokenizer);


    IQueryTokenizer retrievedTokenizer = sessionUnderTest.getQueryTokenizer();


    assertEquals(CUSTOM_STMT_SEP, retrievedTokenizer.getSQLStatementSeparator());
  }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer


  @Test
  public final void testGetQueryTokenizer_CustomAfterGet()
  {
    // This should be a default tokenizer which uses ";" as statement sep
    IQueryTokenizer initialTokenizer = sessionUnderTest.getQueryTokenizer();
    assertEquals(FIRST_STMT_SEP, initialTokenizer.getSQLStatementSeparator());


    IQueryTokenizer customTokenizer = FwTestUtil.getEasyMockQueryTokenizer(CUSTOM_STMT_SEP, "--", true, 0);


    // This should override the default tokenizer
    sessionUnderTest.setQueryTokenizer(customTokenizer);


    IQueryTokenizer retrievedTokenizer = sessionUnderTest.getQueryTokenizer();


    assertEquals(CUSTOM_STMT_SEP, retrievedTokenizer.getSQLStatementSeparator());


    // Check to ensure that the tokenizer received is not the default one that
    // should have been overridden.
    assertNotSame(initialTokenizer, retrievedTokenizer);
  }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

      return getEasyMockQueryTokenizer(";", "--", true, 5);
   }


   public static IQueryTokenizer getEasyMockQueryTokenizer(String sep,
         String solComment, boolean removeMultiLineComment, int queryCount) {
      IQueryTokenizer tokenizer = createMock(IQueryTokenizer.class);
      expect(tokenizer.getSQLStatementSeparator()).andReturn(sep).anyTimes();
      expect(tokenizer.getLineCommentBegin()).andReturn(solComment).anyTimes();
      expect(tokenizer.isRemoveMultiLineComment()).andReturn(removeMultiLineComment)
                                                  .anyTimes();
      expect(tokenizer.getQueryCount()).andReturn(queryCount).anyTimes();
      
      TokenizerSessPropsInteractions tspi = createMock(TokenizerSessPropsInteractions.class);
      expect(tspi.isTokenizerDefinesRemoveMultiLineComment()).andStubReturn(true);
      expect(tspi.isTokenizerDefinesStartOfLineComment()).andStubReturn(true);
      expect(tspi.isTokenizerDefinesStatementSeparator()).andStubReturn(true);
      
      expect(tokenizer.getTokenizerSessPropsInteractions()).andStubReturn(tspi);
      replay(tspi);
      replay(tokenizer);
      return tokenizer;
   }

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

          ISQLPanelAPI api = 
              FrameWorkAcessor.getSQLPanelAPI(_session, _plugin);
          
          String script = api.getSQLScriptToBeExecuted();
          
         IQueryTokenizer qt = _session.getQueryTokenizer();
         qt.setScriptToTokenize(script);
         
         if(false == qt.hasQuery())
         {
            // i18n[CreateTableOfCurrentSQLCommand.noQuery=No query found to create the script from.]
            _session.showErrorMessage(s_stringMgr.getString("CreateTableOfCurrentSQLCommand.noQuery"));
            return;
         }


         ISQLConnection conn = _session.getSQLConnection();
         Statement stmt = null;
         try
         {
            StringBuffer sbCreate = new StringBuffer();
            StringBuffer sbInsert = new StringBuffer();
            StringBuffer sbDrop = new StringBuffer();
            String statSep = ScriptUtil.getStatementSeparator(_session);






            stmt = conn.createStatement();
            stmt.setMaxRows(1);
            String sql = qt.nextQuery();
            ResultSet srcResult = stmt.executeQuery(sql);


            if(isAborted())
            {
               return;

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

    return DialectFactory.isH2(session.getMetaData());
  }


  private void updateTreeApi(ISession session)
  {
    IQueryTokenizer qt = session.getQueryTokenizer();
    String stmtSep = qt.getSQLStatementSeparator();


    _treeAPI = session.getSessionInternalFrame().getObjectTreeAPI();
    // Expanders - trigger and index expanders are added inside the table
    // expander
    _treeAPI.addExpander(DatabaseObjectType.SCHEMA,

View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IQueryTokenizer

  }


  private String getExplainSql(String sql) throws UnsupportedStatementException
  {
    StringBuilder result = new StringBuilder();
    IQueryTokenizer tokenizer = _session.getQueryTokenizer();
    tokenizer.setScriptToTokenize(sql);
    while (tokenizer.hasQuery())
    {
      String query = tokenizer.nextQuery();
      if (query.toLowerCase().startsWith("select"))
      {
        result.append(i18n.EXPLAIN_SQL_PREFIX).append(query).append(tokenizer.getSQLStatementSeparator());
      } else
      {
        throw new UnsupportedStatementException();
      }
    }
    if (s_log.isDebugEnabled())
    {
      s_log.debug("getExplainSql - Input: " + sql);
      s_log.debug("getExplainSql - Querys: " + tokenizer.getQueryCount());
      s_log.debug("getExplainSql - Result: " + result);
    }
    return result.toString();
  }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.