Examples of IDatabaseObjectInfo

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

76
77
78
79
80
81
82
83
84
85
86
    final IApplication app = getApplication();
    if (_tree != null)
    {
      // Ensure that the proper type of Object is selected in the Object
      // Tree.
      IDatabaseObjectInfo selectedObjects[] =  _tree.getSelectedDatabaseObjects();
      int objectTotal = selectedObjects.length;

      if ((objectTotal == 1)
        && (selectedObjects[0].getDatabaseObjectType()
          == DatabaseObjectType.TABLE))
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

82
83
84
85
86
87
88
89
90
91
92
  public void actionPerformed(ActionEvent evt)
  {
    if (_tree != null)
    {
      // Ensure that the proper type of Object is selected in the Object Tree before allowing the SQL Filter to be activated.
      final IDatabaseObjectInfo selObjs[] =  _tree.getSelectedDatabaseObjects();
      final int objectTotal = selObjs.length;

      if ( (objectTotal == 1) &&
              (
                      (selObjs[0].getDatabaseObjectType() == DatabaseObjectType.TABLE) ||
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
    public List<ObjectTreeNode> createChildren(ISession session,
                                               ObjectTreeNode parentNode)
        throws SQLException
    {
        final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
        final IDatabaseObjectInfo parentDbinfo = parentNode
                .getDatabaseObjectInfo();
        final SQLDatabaseMetaData md = session.getSQLConnection()
                .getSQLMetaData();
        final String schemaName = parentDbinfo.getSchemaName();

        if (triggerExtractor != null) {
            IDatabaseObjectInfo triggerParentInfo =
                new TriggerParentInfo(parentDbinfo, schemaName, md);
            ObjectTreeNode triggerChild =
                new ObjectTreeNode(session, triggerParentInfo);
            TriggerParentExpander expander = new TriggerParentExpander();
            expander.setTableTriggerExtractor(triggerExtractor);
            triggerChild.addExpander(expander);
            childNodes.add(triggerChild);
        }
        if (indexExtractor != null) {
            IDatabaseObjectInfo triggerParentInfo =
                new IndexParentInfo(parentDbinfo, schemaName, md);
            ObjectTreeNode triggerChild =
                new ObjectTreeNode(session, triggerParentInfo);
            IndexParentExpander expander = new IndexParentExpander();
            expander.setTableIndexExtractor(indexExtractor);
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
   * @return A list of <TT>ObjectTreeNode</TT> objects representing the child nodes for the passed node.
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSimpleName();

    IDatabaseObjectInfo seqInfo =
      new DatabaseObjectInfo(catalogName, schemaName, _inodeFactory.getParentLabelForType(_dbObjType),
        _dbObjType, md);
    ObjectTreeNode node = new ObjectTreeNode(session, seqInfo);
    node.addExpander(_inodeFactory.createExpander(_dbObjType));
    childNodes.add(node);
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
   *      nodes for the passed node.
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
    throws SQLException
  {
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = conn.getSQLMetaData();

    boolean supportsCatalogs = false;
    try
    {
      supportsCatalogs = md.supportsCatalogs();
    }
    catch (SQLException ex)
    {
      s_log.debug("DBMS doesn't support 'supportsCatalogs()", ex);
    }

    boolean supportsSchemas = false;
    try
    {
      supportsSchemas = md.supportsSchemas();
    }
    catch (SQLException ex)
    {
      s_log.debug("DBMS doesn't support 'supportsSchemas()", ex);
    }

    List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();

    if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.SESSION)
    {
      // If a driver says it supports schemas/catalogs but doesn't
      // provide schema/catalog nodes, try to get other nodes.
      List<ObjectTreeNode> addedChildren = new ArrayList<ObjectTreeNode>();
      if (supportsCatalogs)
      {
        addedChildren = createCatalogNodes(session, md);
        childNodes.addAll(addedChildren);
      }
//      else if (supportsSchemas)
      if (addedChildren.size() == 0 && supportsSchemas)
      {
        addedChildren = createSchemaNodes(session, md, null);
        childNodes.addAll(addedChildren);
      }
//      else
      if (addedChildren.size() == 0)
      {
        childNodes.addAll(createObjectTypeNodes(session, null, null));
      }
    }
    else if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.CATALOG)
    {
      // If a driver says it supports schemas but doesn't
      // provide schema nodes, try to get other nodes.
      final String catalogName = parentDbinfo.getSimpleName();
      List<ObjectTreeNode> addedChildren = new ArrayList<ObjectTreeNode>();
      if (supportsSchemas)
      {
        addedChildren = createSchemaNodes(session, md, catalogName);
        childNodes.addAll(addedChildren);
      }
      //else
      if (addedChildren.size() == 0)
      {
        childNodes.addAll(createObjectTypeNodes(session, catalogName, null));
      }
    }
    else if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.SCHEMA)
    {
      final String catalogName = parentDbinfo.getCatalogName();
      final String schemaName = parentDbinfo.getSimpleName();
      childNodes.addAll(createObjectTypeNodes(session, catalogName, schemaName));
    }

    return childNodes;
  }
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
         CatalogFilterMatcher filterMatcher = new CatalogFilterMatcher(session.getProperties());

      for (int i = 0; i < catalogs.length; ++i)
      {
            IDatabaseObjectInfo dbo = new DatabaseObjectInfo(null, null,
                                 catalogs[i],
                                 DatabaseObjectType.CATALOG,
                                 md);
            if (filterMatcher.matches(dbo.getSimpleName()))
            {
          childNodes.add(new ObjectTreeNode(session, dbo));
        }
      }
    }
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

223
224
225
226
227
228
229
230
231
232
233
234
235
236
         SchemaFilterMatcher filterMatcher = new SchemaFilterMatcher(session.getProperties());

      for (int i = 0; i < schemas.length; ++i)
      {
            IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null,
                                    schemas[i],
                                    DatabaseObjectType.SCHEMA, md);
            if(filterMatcher.matches(dbo.getSimpleName()))
            {
               childNodes.add(new ObjectTreeNode(session, dbo));
        }
      }
    }
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
      // Add table types to list.
      if (_tableTypes.length > 0)
      {
        for (int i = 0; i < _tableTypes.length; ++i)
        {
          IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                          schemaName, _tableTypes[i],
                          DatabaseObjectType.TABLE_TYPE_DBO, md);
          ObjectTreeNode child = new ObjectTreeNode(session, dbo);
          list.add(child);
        }
      }
      else
      {
        s_log.debug("List of table types is empty so trying null table type to load all tables");
        IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                        schemaName, null,
                        DatabaseObjectType.TABLE_TYPE_DBO, md);
        ObjectTreeNode child = new ObjectTreeNode(session, dbo);
        child.setUserObject("TABLE");
        list.add(child);
      }

      // Add stored proc parent node.
      boolean supportsStoredProcs = false;
      try
      {
        supportsStoredProcs = md.supportsStoredProcedures();
      }
      catch (SQLException ex)
      {
        s_log.debug("DBMS doesn't support 'supportsStoredProcedures()'", ex);
      }
      if (supportsStoredProcs)
      {
        IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                          schemaName, "PROCEDURE",
                          DatabaseObjectType.PROC_TYPE_DBO, md);
        ObjectTreeNode child = new ObjectTreeNode(session, dbo);
        list.add(child);
      }

      // Add UDT parent node.
      {
        IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName,
                      schemaName, "UDT",
                      DatabaseObjectType.UDT_TYPE_DBO, md);
        ObjectTreeNode child = new ObjectTreeNode(session, dbo);
        list.add(child);
      }
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
        throws SQLException
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    final String schemaName = parentDbinfo.getSchemaName();
    final String catalogName = parentDbinfo.getCatalogName();
    final IDatabaseObjectInfo tableInfo = ((TriggerParentInfo) parentDbinfo).getTableInfo();
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      String tableName = tableInfo.getSimpleName();
      String query = triggerExtractor.getTableTriggerQuery();
      if (s_log.isDebugEnabled())
      {
        s_log.debug("Getting triggers for table " + tableName + " in schema " + schemaName
              + " and catalog " + catalogName + " - Running query: " + query);
View Full Code Here

Examples of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

82
83
84
85
86
87
88
89
90
91
92
93
94
95
    final IDatabaseObjectInfo[] dbObjs = _api.getSelectedDatabaseObjects();

    // Get all the selected object names and place in a comma separated list.
    for (int i = 0; i < dbObjs.length; i++)
    {
      final IDatabaseObjectInfo doi = dbObjs[i];
      final String name = _copyType == ICopyTypes.SIMPLE_NAME
                  ? doi.getSimpleName()
                  : doi.getQualifiedName();
      buf.append(name).append(", ");
    }
    if (buf.length() > 0)
    {
      buf.setLength(buf.length() - 2);  // Remove trailing ", ".
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.