private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer() .getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
private String getStatementSeparator() { String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
public static String getStatementSeparator(ISession session) { String statementSeparator = session.getQueryTokenizer().getSQLStatementSeparator(); if (1 < statementSeparator.length()) { statementSeparator = "\n" + statementSeparator + "\n"; } return statementSeparator; }
public boolean isStatementSeparator(char[] buffer, int offset, int len) { _caseInsensitiveStringBuffer.setCharBuffer(buffer, offset, len); String statSep = _sess.getQueryTokenizer().getSQLStatementSeparator(); if(statSep.length() != len) { return false; } // no new here, method is called very often. for(int i=0; i < statSep.length(); ++i) { if(buffer[offset +i] != statSep.charAt(i)) { return false; } } return true; }
public static String createAllSqlsString(ArrayList<String> sqls, ISession session) { String allSqls = ""; String sep = session.getQueryTokenizer().getSQLStatementSeparator(); for (String sql : sqls) { allSqls += sql; if (1 < sep.length()) { allSqls += "\n"; } allSqls += (sep + "\n\n"); } return format(allSqls, session).trim(); }
public static CodeReformatorConfig createConfig(ISession sess) { String statementSep = sess.getQueryTokenizer().getSQLStatementSeparator(); return createConfig(statementSep); }
public static CodeReformatorConfig createConfig(ISession sess) { String statementSep = sess.getQueryTokenizer().getSQLStatementSeparator(); return createConfig(statementSep); }
public void execute() { final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); final StringBuffer buf = new StringBuffer(); buf.append("USE "); buf.append(_catalogName); buf.append(sqlSep + "\n"); buf.append("DBCC SHRINKFILE ("); buf.append(_databaseFileName); buf.append(", TRUNCATEONLY)\n"); buf.append(sqlSep); buf.append("\n"); _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(buf.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } }
public void execute() { if (_dbs.length > 0) { final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); final StringBuffer buf = new StringBuffer(); for (int i = 0; i < _dbs.length; i++) { final IDatabaseObjectInfo ti = _dbs[i]; buf.append("drop database ") .append(ti.getQualifiedName()) .append(" ") .append(sqlSep) .append('\n'); } SQLExecuterTask executer = new SQLExecuterTask(_session, buf.toString(), new DefaultSQLExecuterHandler(_session)); executer.run(); } } }
public void execute() { StringBuffer sqlBuffer = new StringBuffer(); final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); sqlBuffer.append("DBCC INDEXDEFRAG("); sqlBuffer.append(_tableInfo.getCatalogName()); sqlBuffer.append(","); sqlBuffer.append(_tableInfo.getSimpleName()); sqlBuffer.append(","); sqlBuffer.append(_indexName); sqlBuffer.append(")\n"); sqlBuffer.append(sqlSep); sqlBuffer.append(" \n"); _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(sqlBuffer.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } }
public void execute() { StringBuffer sqlBuffer = new StringBuffer(); final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); sqlBuffer.append("DBCC SHOW_STATISTICS(["); sqlBuffer.append(_tableInfo.getCatalogName()); sqlBuffer.append("."); sqlBuffer.append(_tableInfo.getSchemaName()); sqlBuffer.append("."); sqlBuffer.append(_tableInfo.getSimpleName()); sqlBuffer.append("],"); sqlBuffer.append(_indexName); sqlBuffer.append(")\n"); sqlBuffer.append(sqlSep); sqlBuffer.append("\n"); _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(sqlBuffer.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } }
public void execute() { if (_dbs.length > 0) { final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); final StringBuffer buf = new StringBuffer(); for (int i = 0; i < _dbs.length; i++) { final IDatabaseObjectInfo ti = _dbs[i]; buf.append("DBCC SHRINKDATABASE("); buf.append(ti.getSimpleName()); buf.append(",TRUNCATEONLY)"); buf.append("\n"); buf.append(sqlSep); buf.append("\n"); } _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(buf.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } } }
public void execute() { if (_dbs.length > 0) { final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); final StringBuffer buf = new StringBuffer(); for (int i = 0; i < _dbs.length; i++) { final IDatabaseObjectInfo ti = _dbs[i]; buf.append("BACKUP LOG " + ti.getSimpleName() + " WITH TRUNCATE_ONLY\n"); buf.append(sqlSep); buf.append("\n"); } _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(buf.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } } }
public void execute() { final String sqlSep = _session.getQueryTokenizer().getSQLStatementSeparator(); final IObjectTreeAPI api = _session.getSessionInternalFrame().getObjectTreeAPI(); final IDatabaseObjectInfo[] dbObjs = api.getSelectedDatabaseObjects(); // Get the names of all the selected tables in a comma separated list, final StringBuffer cmd = new StringBuffer(512); for (int i = 0; i < dbObjs.length; ++i) { cmd.append("UPDATE STATISTICS "); cmd.append(dbObjs[i].getCatalogName()); cmd.append("."); cmd.append(dbObjs[i].getSchemaName()); cmd.append("."); cmd.append(dbObjs[i].getSimpleName()); cmd.append(" WITH FULLSCAN, ALL\n"); cmd.append(sqlSep); cmd.append("\n"); } if (cmd != null && cmd.length() > 0) { _session.getSessionInternalFrame().getSQLPanelAPI().appendSQLScript(cmd.toString(), true); _session.getSessionInternalFrame().getSQLPanelAPI().executeCurrentSQL(); _session.selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB); } } }
private void onRunHQL() { if (false == _runHQL.isEnabled()) { return; } String hql = _hqlEntryPanelManager.getEntryPanel().getSQLToBeExecuted(); if (null == hql || 0 == hql.trim().length()) { return; } final IQueryTokenizer queryTokenizer = _sess.getQueryTokenizer(); final String statementSeparator = queryTokenizer.getSQLStatementSeparator(); final String startOfLineComment = queryTokenizer.getLineCommentBegin(); QueryTokenizer qt = new QueryTokenizer(statementSeparator, startOfLineComment, true); qt.setScriptToTokenize(hql); while (qt.hasQuery()) { String hqlQuery = qt.nextQuery(); _hibernateTabController.displayObjects(_con, hqlQuery); } }
private void validateSQL() { final ISQLPanelAPI api = _session.getSessionInternalFrame().getSQLPanelAPI(); final String sql = api.getSQLScriptToBeExecuted(); if (sql != null && sql.trim().length() > 0) { final WebServiceSessionProperties wssProps = _plugin.getWebServiceSessionProperties(_session); final String stmtSep= _session.getQueryTokenizer().getSQLStatementSeparator(); final String solComment = _session.getQueryTokenizer().getLineCommentBegin(); final ValidationProps valProps = new ValidationProps(_prefs, wssProps, sql, stmtSep, solComment, _session); new Executor(_session.getApplication(), valProps, _session.getProperties()).execute(); } else { // i18n[sqlval.noSql=No SQL specified] _session.showErrorMessage(s_stringMgr.getString("sqlval.noSql")); } }
private void updateTreeApiForMysql5(ISession session) { if (!DialectFactory.isMySQL5(session.getMetaData())) { return; } String stmtSep = session.getQueryTokenizer().getSQLStatementSeparator(); MysqlProcedureSourceTab procSourceTab = new MysqlProcedureSourceTab(i18n.SHOW_PROCEDURE_SOURCE); _treeAPI.addDetailTab(DatabaseObjectType.PROCEDURE, procSourceTab); // Tab to add to view nodes. MysqlViewSourceTab viewSourceTab = new MysqlViewSourceTab(i18n.SHOW_VIEW_SOURCE, stmtSep); _treeAPI.addDetailTab(DatabaseObjectType.VIEW, viewSourceTab); // Show triggers for tables TableWithChildNodesExpander trigExp = new TableWithChildNodesExpander(); trigExp.setTableTriggerExtractor(new MysqlTableTriggerExtractorImpl()); _treeAPI.addExpander(DatabaseObjectType.TABLE, trigExp); // tabs for triggers _treeAPI.addDetailTab(DatabaseObjectType.TRIGGER, new DatabaseObjectInfoTab()); _treeAPI.addDetailTab(DatabaseObjectType.TRIGGER, new MysqlTriggerDetailsTab()); MysqlTriggerSourceTab trigSourceTab = new MysqlTriggerSourceTab(i18n.SHOW_TRIGGER_SOURCE, stmtSep); _treeAPI.addDetailTab(DatabaseObjectType.TRIGGER, trigSourceTab); }