net.sourceforge.squirrel_sql.plugins.SybaseASE.ScriptSybaseASEViewAction Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of sybase Show documentation
Sybase Plugin
There is a newer version: 3.5.0
package net.sourceforge.squirrel_sql.plugins.SybaseASE;

import java.awt.event.ActionEvent;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import net.sourceforge.squirrel_sql.client.IApplication;
import net.sourceforge.squirrel_sql.client.action.SquirrelAction;
import net.sourceforge.squirrel_sql.client.gui.session.SessionInternalFrame;
import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.sql.ITableInfo;
import net.sourceforge.squirrel_sql.fw.util.Resources;
import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;



public class ScriptSybaseASEViewAction extends SquirrelAction
{
    private static final long serialVersionUID = 1L;

    transient private ISession _session;
   
    /** Logger for this class. */
    transient private final ILogger s_log =
        LoggerController.createLogger(ScriptSybaseASEViewAction.class);
    
   ///////////////////////////////////////////////////////////
   // Sybase ASE specific code to read view definitions.
   private static final String sql =
       "Select text " +
       "from sysobjects inner join syscomments on syscomments.id = sysobjects.id " +
       "where name = ?";


   public ScriptSybaseASEViewAction(IApplication app, Resources rsrc, ISession session)
	{
		super(app, rsrc);
      _session = session;
   }


	public void actionPerformed(ActionEvent evt)
	{
      try
      {
         PreparedStatement stat = _session.getSQLConnection().prepareStatement(sql);

         SessionInternalFrame sessMainFrm = _session.getSessionInternalFrame();
         IDatabaseObjectInfo[] dbObjs = sessMainFrm.getObjectTreeAPI().getSelectedDatabaseObjects();


         StringBuffer script = new StringBuffer();
         for (int i = 0; i < dbObjs.length; i++)
         {
            ITableInfo ti = (ITableInfo) dbObjs[i];

            stat.setString(1, ti.getSimpleName());
            if (s_log.isDebugEnabled()) {
                s_log.debug("Running SQL: "+sql);
                s_log.debug("Bind var value is: "+ti.getSimpleName());
            }
            ResultSet res = stat.executeQuery();

            while(res.next())
            {
                script.append(res.getString("text"));            
            }
            script.append(getStatementSeparator());
            res.close();
            //
            ///////////////////////////////////////////////////////////
         }

         stat.close();

         sessMainFrm.getSQLPanelAPI().appendSQLScript(script.toString());
         sessMainFrm.getSessionPanel().selectMainTab(ISession.IMainPanelTabIndexes.SQL_TAB);
      }
      catch (Exception e)
      {
         s_log.error(
             "Unexpected exception while attempting to get source for view: "+
             e.getMessage(), e);
         
         throw new RuntimeException(e);
      }
   }

   private String getStatementSeparator()
   {
      String statementSeparator = _session.getQueryTokenizer().getSQLStatementSeparator();

      if (1 < statementSeparator.length())
      {
         statementSeparator = "\n" + statementSeparator + "\n";
      }

      return statementSeparator;
   }


}