Package net.sourceforge.squirrel_sql.fw.sql

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

68
69
70
71
72
73
74
75
76
77
78
  }

  @Test
  public void testSetGetProcedureInfo()
  {
    IProcedureInfo value = mockHelper.createMock(IProcedureInfo.class);
   
    mockHelper.replayAll();
    classUnderTest.setProcedureInfo(value);
    assertEquals(value, classUnderTest.getProcedureInfo());
    mockHelper.verifyAll();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    IApplication mockApplication = mockHelper.createMock(IApplication.class);
    IIdentifier mockIdentifier = mockHelper.createMock(IIdentifier.class);
    SessionManager mockSessionManager = mockHelper.createMock(SessionManager.class);
    ISQLConnection mockSqlConnection = mockHelper.createMock(ISQLConnection.class);
    SQLDatabaseMetaData mockMetaData = mockHelper.createMock(SQLDatabaseMetaData.class);
    IProcedureInfo mockProcedureInfo = mockHelper.createMock(IProcedureInfo.class);
   
    expect(mockSessionManager.getSession(mockIdentifier)).andStubReturn(mockSession);
    expect(mockSession.getApplication()).andStubReturn(mockApplication);
    expect(mockSession.getIdentifier()).andStubReturn(mockIdentifier);
    expect(mockApplication.getSessionManager()).andStubReturn(mockSessionManager);
View Full Code Here
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
      for (Iterator<IProcedureInfo> i =
          _schemaInfoCache.getIProcedureInfosForReadOnly().keySet().iterator(); i.hasNext();)
      {

         IProcedureInfo iProcInfo = i.next();
         boolean toAdd = true;
         if (null != catalog && false == catalog.equalsIgnoreCase(iProcInfo.getCatalogName()))
         {
            toAdd = false;
         }

         if (null != schema && false == schema.equalsIgnoreCase(iProcInfo.getSchemaName()))
         {
            toAdd = false;
         }
        
         if(false == filterMatcher.matches(iProcInfo.getSimpleName()))
         {
            toAdd = false;
         }

View Full Code Here
1410
1411
1412
1413
1414
1415
1416
1417
1418
1419
1420
1421
1422
            _schemaInfoCache.clearTables(ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(), types);
            loadTables(ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(), types, 1);
         }
         else if(doi instanceof IProcedureInfo)
         {
            IProcedureInfo pi = (IProcedureInfo) doi;
            _schemaInfoCache.clearStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName());
            loadStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName(), 1);
         }
         else if(DatabaseObjectType.TABLE_TYPE_DBO == doi.getDatabaseObjectType())
         {
            // load all table types with catalog = doi.getCatalog() and schema = doi.getSchema()
            _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, null);
View Full Code Here
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171


         if (dbObjs[i] instanceof IProcedureInfo)
         {
            IProcedureInfo pi = (IProcedureInfo) dbObjs[i];

            if (null == ret)
            {
               ret = prefix + "func" + pi.getSimpleName();
               ret += "," + prefix + "meth" + pi.getSimpleName();

            }
            else
            {
               ret += "," + prefix + "func" + pi.getSimpleName();
               ret += "," + prefix + "meth" + pi.getSimpleName();
            }
         }
         else
         {
            if (null == ret)
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
223
      Vector ret = new Vector();
      for (int i = 0; i < dbObjs.length; i++)
      {
         if (dbObjs[i] instanceof IProcedureInfo)
         {
            IProcedureInfo pi = (IProcedureInfo) dbObjs[i];
            String sFunc = pi.getSimpleName();
            ret.add(sFunc);
         }
      }
      return (String[]) ret.toArray(new String[0]);
   }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
47
  @Before
  public void setUp() throws Exception
  {

    IProcedureInfo mockProcedureInfo = mockHelper.createMock(IProcedureInfo.class);
    expect(mockProcedureInfo.getProcedureType()).andStubReturn(DatabaseMetaData.procedureNoResult);
    IProcedureInfo[] procedures = new IProcedureInfo[] { mockProcedureInfo };
    expect(
      mockSchemaInfo.getStoredProceduresInfos((String)isNull(), eq(TEST_SCHEMA_NAME), isA(ObjFilterMatcher.class)))
      .andStubReturn(procedures);
    classUnderTest = new ProcedureExpander();
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

         StringBuffer script = new StringBuffer();
         for (int i = 0; i < dbObjs.length; i++)
         {
            IProcedureInfo pi = (IProcedureInfo) dbObjs[i];

            ///////////////////////////////////////////////////////////
            // SybaseASE specific code to read procedure definitions.
            String sql =
                "Select text " +
                "from sysobjects inner join syscomments on syscomments.id = sysobjects.id " +
                "where name = '" + pi.getSimpleName().replace(";1", "") + "'";

             ResultSet res = stat.executeQuery(sql);

             while(res.next())
             {
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
            stat = _session.getSQLConnection().prepareStatement(SQL);

            StringBuffer script = new StringBuffer();
            for (int i = 0; i < dbObjs.length; i++) {
                IProcedureInfo pi = (IProcedureInfo) dbObjs[i];
                stat.setString(1, pi.getSimpleName());
                res = stat.executeQuery();
                res.next();
                res.getString("TEXT");

                script.append(res.getString("TEXT"));
View Full Code Here
TOP

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

  • de.ixdb.squirrel_sql.plugins.cache.CdlAccessor
  • de.ixdb.squirrel_sql.plugins.cache.ScriptFunctionCommand
  • net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.procedure.ProcedureColumnsTabTest
  • net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo
  • net.sourceforge.squirrel_sql.plugins.example.ScriptDB2ProcedureAction
  • net.sourceforge.squirrel_sql.plugins.oracle.expander.ProcedureExpanderTest
  • net.sourceforge.squirrel_sql.plugins.SybaseASE.ScriptSybaseASEProcedureAction
    • 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.