org.firebirdsql.squirrel.tab.TriggerDetailsTab Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of firebird Show documentation
Firebird Plugin
The newest version!
package org.firebirdsql.squirrel.tab;
/*
 * Copyright (C) 2002 Colin Bell
 * [email protected]
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
import java.sql.PreparedStatement;
import java.sql.SQLException;

import net.sourceforge.squirrel_sql.client.session.ISession;
import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.BasePreparedStatementTab;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.util.StringManager;
import net.sourceforge.squirrel_sql.fw.util.StringManagerFactory;
import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;
/**
 * This class will display the details for a Firebird trigger.
 *
 * @author Colin Bell
 */
public class TriggerDetailsTab extends BasePreparedStatementTab
{
	private static final StringManager s_stringMgr =
		StringManagerFactory.getStringManager(TriggerDetailsTab.class);


	/**
	 * This interface defines locale specific strings. This should be
	 * replaced with a property file.
	 */
	private interface i18n
	{
		// i18n[firebird.trigDetails=Details]
		String TITLE = s_stringMgr.getString("firebird.trigDetails");
		// i18n[firebird.triggerDetails=Display trigger details]
		String HINT = s_stringMgr.getString("firebird.triggerDetails");
	}

	/** SQL that retrieves the data. */
	private static String SQL =
		"select rdb$trigger_name, " +
        "rdb$trigger_sequence, " +
        "case rdb$trigger_type " +
        "  when 1 then 'BEFORE INSERT' " +
        "  when 2 then 'AFTER INSERT' " +
        "  when 3 then 'BEFORE UPDATE' " +
        "  when 4 then 'AFTER UPDATE' " +
        "  when 5 then 'BEFORE DELETE' " +
        "  when 6 then 'AFTER DELETE' " +
        "  else 'UNKNOWN TYPE' || rdb$trigger_type " +
        "end as rdb$trigger_type, " +
        "case rdb$trigger_inactive " +
        "  when 0 then 'ACTIVE' " +
        "  when 1 then 'INACTIVE' " +
        "  else 'UNKNOWN' " +
        "end as rdb$trigger_active, " +
		"rdb$description " +
		"from rdb$triggers where " +
		"  rdb$trigger_name = ?";

	/** Logger for this class. */
	private final static ILogger s_log =
		LoggerController.createLogger(TriggerDetailsTab.class);

	public TriggerDetailsTab()
	{
		super(i18n.TITLE, i18n.HINT, true);
	}

	protected PreparedStatement createStatement() throws SQLException
	{
		ISession session = getSession();
        if (s_log.isDebugEnabled()) {
            s_log.debug("Preparing SQL: "+SQL);
        }        
		PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);
		IDatabaseObjectInfo doi = getDatabaseObjectInfo();
        if (s_log.isDebugEnabled()) {
            s_log.debug("setString param: "+doi.getSimpleName());
        }        
        pstmt.setString(1, doi.getSimpleName());
		return pstmt;
	}
}