1 | public class H2TableIndexExtractorImpl implements ITableIndexExtractor {↵ | | 1 | public class PostgresTableIndexExtractorImpl implements ITableIndexExtractor {↵
|
|
2 | ↵ | | 2 | ↵
|
3 | /** Logger for this class */↵ | | 3 | /** Logger for this class */↵
|
4 | private final static ILogger s_log = ↵ | | 4 | private final static ILogger s_log = ↵
|
5 | LoggerController.createLogger(H2TableIndexExtractorImpl.class);↵ | | 5 | LoggerController.createLogger(PostgresTableIndexExtractorImpl.class);↵
|
6 | ↵ | | 6 | ↵
|
7 | /** The query that finds the indexes for a given table */↵ | | 7 | /** The query that finds the indexes for a given table */↵
|
8 | private static final String query = ↵ | | 8 | private static final String query = ↵
|
9 | "SELECT INDEX_NAME " +↵ | | 9 | "↵
|
10 | "FROM INFORMATION_SCHEMA.INDEXES " +↵ | | |
|
11 | "WHERE TABLE_SCHEMA↵ | | 10 | select indexname " +↵
|
| | | 11 | "from pg_catalog.pg_indexes " +↵
|
12 | = ? " +↵ | | 12 | "where schemaname = ? " +↵
|
13 | "AND TABLE_NAME = ? ";↵ | | 13 | "and tablename = ? ";↵
|
14 | ↵ | | 14 | ↵
|
15 | /**↵ | | 15 | /**↵
|
16 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)↵ | | 16 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)↵
|
17 | */↵ | | 17 | */↵
|
18 | public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)↵ | | 18 | public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)↵
|
19 | throws SQLException ↵ | | 19 | throws SQLException ↵
|
20 | {↵ | | 20 | {↵
|
21 | if (s_log.isDebugEnabled()) {↵ | | 21 | if (s_log.isDebugEnabled()) {↵
|
22 | s_log.debug("Binding schema name "+dbo.getSchemaName()+↵ | | 22 | s_log.debug("Binding schema name "+dbo.getSchemaName()+↵
|
23 | " as first bind value");↵ | | 23 | " as first bind value");↵
|
24 | s_log.debug("Binding table name "+dbo.getSimpleName()+↵ | | 24 | s_log.debug("Binding table name "+dbo.getSimpleName()+↵
|
25 | " as second bind value"); ↵ | | 25 | " as second bind value"); ↵
|
26 | } ↵ | | 26 | } ↵
|
27 | pstmt.setString(1, dbo.getSchemaName());↵ | | 27 | pstmt.setString(1, dbo.getSchemaName());↵
|
28 | pstmt.setString(2, dbo.getSimpleName());↵ | | 28 | pstmt.setString(2, dbo.getSimpleName());↵
|
29 | }↵ | | 29 | }↵
|
|
30 | /**↵ | | 30 | /**↵
|
31 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#getTableIndexQuery()↵ | | 31 | * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#getTableIndexQuery()↵
|
32 | */↵ | | 32 | */↵
|
33 | public String getTableIndexQuery() {↵ | | 33 | public String getTableIndexQuery() {↵
|
34 | return query | | 34 | return query
|