1 | public class FirebirdTableTriggerExtractorImpl implements ITableTriggerExtractor {↵ | | 1 | public class InformixTableTriggerExtractorImpl implements ITableTriggerExtractor {↵
|
|
2 | /** Logger for this class */↵ | | 2 | /** Logger for this class */↵
|
3 | private final static ILogger s_log = ↵ | | 3 | private final static ILogger s_log = ↵
|
4 | LoggerController.createLogger(FirebirdTableTriggerExtractorImpl.class);↵ | | 4 | LoggerController.createLogger(InformixTableTriggerExtractorImpl.class);↵
|
5 | ↵ | | 5 | ↵
|
6 | /** The query that finds the triggers for a given table */↵ | | 6 | /** The query that finds the triggers for a given table */↵
|
7 | private static String SQL = ↵ | | 7 | private static String query = ↵
|
8 | "select " +↵ | | 8 | "select T1.trigname " +↵
|
9 | "cast(rdb$trigger_name as varchar(31)) as rdb$trigger_name " +↵ | | 9 | "↵
|
10 | "from rdb$triggers " +↵ | | |
|
11 | "where rdb$relation_name = ? ";↵ | | |
|
| | | 10 | from informix.systriggers AS T1, informix.systables AS T2 " +↵
|
| | | 11 | "where T2.tabid = T1.tabid " +↵
|
| | | 12 | "and T2.tabname = ? ";↵
|
| | | 13 | ↵
|
12 | ↵ | | 14 | ↵
|
13 | /**↵ | | 15 | /**↵
|
14 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)↵ | | 16 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)↵
|
15 | */↵ | | 17 | */↵
|
16 | public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) ↵ | | 18 | public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) ↵
|
17 | throws SQLException ↵ | | 19 | throws SQLException ↵
|
18 | {↵ | | 20 | {↵
|
19 | if (s_log.isDebugEnabled()) {↵ | | 21 | if (s_log.isDebugEnabled()) {↵
|
20 | s_log.debug("Binding table name "+dbo.getSimpleName()+↵ | | 22 | s_log.debug("Binding table name "+dbo.getSchemaName()+↵
|
21 | " as first bind value"); ↵ | | 23 | " as first bind value"); ↵
|
22 | } ↵ | | 24 | } ↵
|
23 | pstmt.setString(1, dbo.getSimpleName()); ↵ | | 25 | pstmt.setString(1, dbo.getSimpleName());↵
|
24 | }↵ | | 26 | }↵
|
|
|
25 | /**↵ | | 27 | /**↵
|
26 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()↵ | | 28 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()↵
|
27 | */↵ | | 29 | */↵
|
28 | public String getTableTriggerQuery() {↵ | | 30 | public String getTableTriggerQuery() {↵
|
29 | return SQL | | 31 | return query
|