[Squirrel-sql-commits] sql12/plugins/sybase/src/net/sourceforge/squirrel_sql/plugins/SybaseASE/exp SybaseTableIndexExtractorImpl.java, NONE, 1.1 SybaseTableTriggerExtractorImpl.java, NONE, 1.1

[Rob M. <man...@us...>]

Update of /cvsroot/squirrel-sql/sql12/plugins/sybase/src/net/sourceforge/squirrel_sql/plugins/SybaseASE/exp
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv23279/plugins/sybase/src/net/sourceforge/squirrel_sql/plugins/SybaseASE/exp

Added Files:
	SybaseTableIndexExtractorImpl.java 
	SybaseTableTriggerExtractorImpl.java 
Log Message:
Added new trigger and index nodes beneath tables in the tree.  Also, added trigger source tab for triggers.

--- NEW FILE: SybaseTableIndexExtractorImpl.java ---
/*
 * Copyright (C) 2007 Rob Manning
 * man...@us...
 *
 * 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
 */
package net.sourceforge.squirrel_sql.plugins.SybaseASE.exp;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;

/**
 * Provides the query and parameter binding behavior for DB2's index catalog.
 *  
 * @author manningr
 */
public class SybaseTableIndexExtractorImpl implements ITableIndexExtractor {

    
    /** Logger for this class */
    private final static ILogger s_log = 
        LoggerController.createLogger(SybaseTableIndexExtractorImpl.class);
                
    /** The query that finds the indexes for a given table */
    private static final String query = 
        "SELECT sysindexes.name " +
        "FROM dbo.sysindexes " +
        "inner join sysobjects on  sysindexes.id = sysobjects.id " +
        "where sysobjects.loginame = ? and " +
        "sysobjects.name = ? and " +
        "sysindexes.name != ? ";
        
    /**
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
     */
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)
        throws SQLException 
    {
        if (s_log.isDebugEnabled()) {
            s_log.debug("Binding schema name "+dbo.getCatalogName()+
                        " as first bind value");
            s_log.debug("Binding table name "+dbo.getSimpleName()+
                        " as second bind value");
            s_log.debug("Binding table name "+dbo.getSimpleName()+
                        " as third bind value");            
            
        }                        
        pstmt.setString(1, dbo.getCatalogName());
        pstmt.setString(2, dbo.getSimpleName());
        pstmt.setString(3, dbo.getSimpleName());
    }

    /**
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#getTableIndexQuery()
     */
    public String getTableIndexQuery() {
        return query;
    }

}

--- NEW FILE: SybaseTableTriggerExtractorImpl.java ---
/*
 * Copyright (C) 2007 Rob Manning
 * man...@us...
 *
 * 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
 */
package net.sourceforge.squirrel_sql.plugins.SybaseASE.exp;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor;
import net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo;
import net.sourceforge.squirrel_sql.fw.util.log.ILogger;
import net.sourceforge.squirrel_sql.fw.util.log.LoggerController;

/**
 * Provides the query and parameter binding behavior for Sybase's trigger catalog.
 *  
 * @author manningr
 */
public class SybaseTableTriggerExtractorImpl implements ITableTriggerExtractor {

    /** Logger for this class */
    private final static ILogger s_log = 
        LoggerController.createLogger(SybaseTableTriggerExtractorImpl.class);
                
    /** The query that finds the triggers for a given table */
    private static String query = 
        "SELECT triggers.name " +
        "FROM sysobjects tables , sysobjects triggers " +
        "where triggers.type = 'TR' " +
        "and triggers.deltrig = tables.id " +
        "and tables.loginame = ? " +
        "and tables.name = ? ";
    
    // trigger source
//        "SELECT text " +
//        "FROM dbo.sysobjects " +
//        "inner join syscomments on syscomments.id = sysobjects.id " +
//        "where loginame = ? " +
//        "and name = ? " +
//        "and type = 'TR' ";        
            
    /**
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
     */
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) 
        throws SQLException 
    {
        if (s_log.isDebugEnabled()) {
            s_log.debug("Binding catalog name "+dbo.getCatalogName()+
                        " as first bind value");            
            s_log.debug("Binding table name "+dbo.getSimpleName()+
                        " as second bind value");
        }        
        pstmt.setString(1, dbo.getCatalogName());
        pstmt.setString(2, dbo.getSimpleName());
                
    }

    /**
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()
     */
    public String getTableTriggerQuery() {
        return query;
    }

}