Package net.sourceforge.squirrel_sql.fw.sql

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

1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
     * This adds a node to the tree that says "Loading..." in order to give
     * feedback to the user.
     */
    private ObjectTreeNode showLoadingNode()
    {
      IDatabaseObjectInfo doi = new DatabaseObjectInfo(null, null,
                "Loading...", DatabaseObjectType.OTHER,
                _session.getSQLConnection().getSQLMetaData());
      ObjectTreeNode loadingNode = new ObjectTreeNode(_session, doi);
      _parentNode.add(loadingNode);
      fireStructureChanged(_parentNode);
View Full Code Here
84
85
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
114
115
116
117
118
119
120
   */
  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 catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();
    final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());

    final String sequenceParentQuerySql = extractor.getSequenceParentQuery();
    if (s_log.isDebugEnabled()) {
      s_log.debug("createChildren: running sequence parent query for sequence children: "
        + sequenceParentQuerySql);
    }

    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      pstmt = conn.prepareStatement(sequenceParentQuerySql);   
      extractor.bindParameters(pstmt, parentDbinfo, filterMatcher);

      rs = pstmt.executeQuery();
      while (rs.next())
      {
        final IDatabaseObjectInfo si =
          new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.SEQUENCE,
            md);
        if (filterMatcher.matches(si.getSimpleName()))
        {
          childNodes.add(new ObjectTreeNode(session, si));
        }
      }
    }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
   */
  public List<ObjectTreeNode> createChildren(ISession session,
                                               ObjectTreeNode parentNode)
    throws SQLException
  {
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();

    return createProcedureNodes(session, catalogName, schemaName);
  }
View Full Code Here
83
84
85
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
114
115
   *         Thrown if an SQL error occurs.
   */
  public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode)
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
    final IDatabaseObjectInfo tableInfo = ((IndexParentInfo) parentDbinfo).getTableInfo();

    final ISQLConnection conn = session.getSQLConnection();
    final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try
    {
      String query = extractor.getTableIndexQuery();
      if (s_log.isDebugEnabled())
      {
        s_log.debug("Running query for index extraction: " + query);
      }
      pstmt = conn.prepareStatement(query);
      extractor.bindParamters(pstmt, tableInfo);
      rs = pstmt.executeQuery();
      while (rs.next())
      {
        String indexName = rs.getString(1);
        String cat = parentDbinfo.getCatalogName();
        String schema = parentDbinfo.getSchemaName();
        String tableName = tableInfo.getSimpleName();
        // This info is merely a placeholder in the tree that we can use to get index name and
        // parent name more easily. We probably should create a IndexColumnInfo that has this
        // extra info in it.
        String columnName = null;
        boolean nonUnique = true;
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
  {
    final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();
    Statement stmt = null;
    try
    {
      final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();
      final ISQLConnection conn = session.getSQLConnection();
      final String catalogName = parentDbinfo.getCatalogName();
      final String schemaName = parentDbinfo.getSchemaName();
      final String tableType = parentDbinfo.getSimpleName();

      String[] types = tableType != null ? new String[] { tableType } : null;
      session.getSchemaInfo().waitTillTablesLoaded();
      final ITableInfo[] tables =
        session.getSchemaInfo().getITableInfos(catalogName, schemaName,
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
  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 String catalogName = parentDbinfo.getCatalogName();
    final String schemaName = parentDbinfo.getSchemaName();

      ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());

      IUDTInfo[] udts =
         conn.getSQLMetaData().getUDTs(catalogName, schemaName, filterMatcher.getSqlLikeMatchString(), null);
View Full Code Here
311
312
313
314
315
316
317
318
   *
   * @return a String array of bind variable values
   */
  protected String[] getBindValues()
  {
    final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
    return new String[] { doi.getSchemaName(), doi.getSimpleName() };
  }
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
    * Expands the specified tree node.
    *
    * @param node the tree node to expand
    */   
    public void expandNode(ObjectTreeNode node) {
        IDatabaseObjectInfo info = node.getDatabaseObjectInfo();
        TreePath path = getTreePath(info.getCatalogName(),
                                    info.getSchemaName(),
                                    new FilterMatcher(info.getSimpleName(), null));   
        _tree.fireTreeExpanded(path);
    }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    public void testMatchKeyPrefixDeletedRows() {
        Map<String, Object> map = new HashMap<String, Object>();
        String tableKey = "table(100)";
        map.put(tableKey, null);
       
        IDatabaseObjectInfo dbInfo =
            FwTestUtil.getEasyMockDatabaseObjectInfo("catalog",
                                                   "schema",
                                                   "table",
                                                   "schema.table",
                                                   DatabaseObjectType.TABLE);
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
  }

  @Test
  public void testCanPasteTo() throws Exception
  {
    IDatabaseObjectInfo mockDboInfo = mockHelper.createMock(IDatabaseObjectInfo.class);
    boolean canPasteTo = false;
    DatabaseObjectType t = DatabaseObjectType.DATABASE_TYPE_DBO;
    for (Field f : t.getClass().getFields())
    {
      if (Modifier.isPublic(f.getModifiers()))
      {
        Object o = f.get(t);
        expect(mockDboInfo.getDatabaseObjectType()).andStubReturn((DatabaseObjectType) (o));
        mockHelper.replayAll();
        canPasteTo = canPasteTo || classUnderTest.canPasteTo(mockDboInfo);
        mockHelper.resetAll();
      }
    }
View Full Code Here
TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo

  • net.sourceforge.squirrel_sql.client.session.action.CopyObjectNameCommand
  • net.sourceforge.squirrel_sql.client.session.action.EditWhereColsAction
  • net.sourceforge.squirrel_sql.client.session.action.SQLFilterAction
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.SchemaExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TableWithChildNodesExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.TriggerParentExpander
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader
  • net.sourceforge.squirrel_sql.plugins.db2.tab.TableSourceTab
  • net.sourceforge.squirrel_sql.plugins.mssql.gui.GenerateSqlDialog
    • Copyright © 2018 www.massapicom. 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.