public IProcedureInfo[] getStoredProceduresInfos(String catalog, String schema, ObjFilterMatcher filterMatcher) { ArrayList<IProcedureInfo> ret = new ArrayList<IProcedureInfo>(); 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; } if (toAdd) { ret.add(iProcInfo); } } return ret.toArray(new IProcedureInfo[ret.size()]); }
public void writeToProcedureCache(IProcedureInfo procedure) { String proc = procedure.getSimpleName(); if (proc.length() > 0) { CaseInsensitiveString ciProc = new CaseInsensitiveString(proc); _procedureNames.put(ciProc ,proc); List<IProcedureInfo> aIProcInfos = _procedureInfosBySimpleName.get(ciProc); if(null == aIProcInfos) { aIProcInfos = new ArrayList<IProcedureInfo>(); _procedureInfosBySimpleName.put(ciProc, aIProcInfos); } aIProcInfos.add(procedure); } _iProcedureInfos.put(procedure, procedure); }
new CodeCompletionStoredProcedureInfo(storedProceduresInfos[i].getSimpleName(), storedProceduresInfos[i].getProcedureType(), _session, catalog,
public void writeToProcedureCache(IProcedureInfo procedure) { String proc = procedure.getSimpleName(); if (proc.length() > 0) { CaseInsensitiveString ciProc = new CaseInsensitiveString(proc); _procedureNames.put(ciProc ,proc); List<IProcedureInfo> aIProcInfos = _procedureInfosBySimpleName.get(ciProc); if(null == aIProcInfos) { aIProcInfos = new ArrayList<IProcedureInfo>(); _procedureInfosBySimpleName.put(ciProc, aIProcInfos); } aIProcInfos.add(procedure); } _iProcedureInfos.put(procedure, procedure); }
void clearStoredProcedures(String catalogName, String schemaName, String simpleName) { for(Iterator<IProcedureInfo> i = _iProcedureInfos.keySet().iterator(); i.hasNext();) { IProcedureInfo pi = i.next(); boolean matches = matchesMetaString(pi.getCatalogName(), catalogName); matches &= matchesMetaString(pi.getSchemaName(), schemaName); matches &= matchesMetaString(pi.getSimpleName(), simpleName); if(matches) { i.remove(); CaseInsensitiveString ciSimpleName = new CaseInsensitiveString(pi.getSimpleName()); List<IProcedureInfo> procedureInfos = _procedureInfosBySimpleName.get(ciSimpleName); procedureInfos.remove(pi); if(0 == procedureInfos.size()) { _procedureInfosBySimpleName.remove(ciSimpleName); _procedureNames.remove(ciSimpleName); } } } }
for (int i = 0; i < dbObjs.length; i++) { IProcedureInfo pi = (IProcedureInfo) dbObjs[i]; stat.setString(1, pi.getSimpleName()); res = stat.executeQuery(); res.next();
void clearStoredProcedures(String catalogName, String schemaName, String simpleName) { for(Iterator<IProcedureInfo> i = _iProcedureInfos.keySet().iterator(); i.hasNext();) { IProcedureInfo pi = i.next(); boolean matches = matchesMetaString(pi.getCatalogName(), catalogName); matches &= matchesMetaString(pi.getSchemaName(), schemaName); matches &= matchesMetaString(pi.getSimpleName(), simpleName); if(matches) { i.remove(); CaseInsensitiveString ciSimpleName = new CaseInsensitiveString(pi.getSimpleName()); List<IProcedureInfo> procedureInfos = _procedureInfosBySimpleName.get(ciSimpleName); procedureInfos.remove(pi); if(0 == procedureInfos.size()) { _procedureInfosBySimpleName.remove(ciSimpleName); _procedureNames.remove(ciSimpleName); } } } }
"Select text " + "from sysobjects inner join syscomments on syscomments.id = sysobjects.id " + "where name = '" + pi.getSimpleName().replace(";1", "") + "'";
public IProcedureInfo[] getStoredProceduresInfos(String catalog, String schema, ObjFilterMatcher filterMatcher) { ArrayList<IProcedureInfo> ret = new ArrayList<IProcedureInfo>(); 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; } if (toAdd) { ret.add(iProcInfo); } } return ret.toArray(new IProcedureInfo[ret.size()]); }
if (!procs[i].getSimpleName().startsWith("dt_")) model.addElement(procs[i]);
_schemaInfoCache.clearStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName()); loadStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName(), 1);
_schemaInfoCache.clearStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName()); loadStoredProcedures(pi.getCatalogName(), pi.getSchemaName(), pi.getSimpleName(), 1);