Attachment #97908 for bug #229212

Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.




	 */
	protected Object[] displayTableNodeChildren (Object parent)
	{
		Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getTables();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getTables();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
	}

	protected Object[] displayUDFNodeChildren(Object parent)
    {
		Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUDFs()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getUDFs();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getUDFs();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
    }

    /**

     */
    protected Object[] displayStoredProcedureNodeChildren(Object parent)
    {
    	Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getProcedures()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getProcedures();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getProcedures();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
    }
	
	/**

	 */
	protected Object [] displaySequenceNodeChildren (Object parent)
	{
		Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getSequences()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getSequences();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getSequences();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
	}

	/**

	 */
	protected Object [] displayUDTNodeChildren (Object parent)
	{
		Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUserDefinedTypes()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getUserDefinedTypes();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getUserDefinedTypes();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
	}
	
	/**

	 */
	protected Object [] displayViewsNodeChildren (Object parent)
	{
		Object grandParent = ((IVirtualNode)parent).getParent();
		if(grandParent instanceof Schema)
		{
			Schema schema = (Schema) ((IVirtualNode)parent).getParent();
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));
		}
		else if(grandParent instanceof Database)
		{
			List result = new ArrayList();
			List schemas = ((Database)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getTables();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else if(grandParent instanceof Catalog)
		{
			List result = new ArrayList();
			List schemas = ((Catalog)grandParent).getSchemas();
			for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
				Schema schema = (Schema) iterator.next();
				List udfs = schema.getTables();
				result.addAll(udfs);
			}
			return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		}
		else
		{
			return EMPTY_ELEMENT_ARRAY;
		}
	}
	
	/**

Return to bug 229212

Lines 173-186 Link Here

(-)src/org/eclipse/datatools/connectivity/sqm/server/internal/ui/explorer/providers/content/layout/vnode/ServerExplorerVNodeContentProviderNav.java (-12 / +192 lines)
173	*/	173	*/
174	protected Object[] displayTableNodeChildren (Object parent)	174	protected Object[] displayTableNodeChildren (Object parent)
175	{	175	{
176	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	176	Object grandParent = ((IVirtualNode)parent).getParent();
177	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));	177	if(grandParent instanceof Schema)
		178	{
		179	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		180	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));
		181	}
		182	else if(grandParent instanceof Database)
		183	{
		184	List result = new ArrayList();
		185	List schemas = ((Database)grandParent).getSchemas();
		186	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		187	Schema schema = (Schema) iterator.next();
		188	List udfs = schema.getTables();
		189	result.addAll(udfs);
		190	}
		191	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		192	}
		193	else if(grandParent instanceof Catalog)
		194	{
		195	List result = new ArrayList();
		196	List schemas = ((Catalog)grandParent).getSchemas();
		197	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		198	Schema schema = (Schema) iterator.next();
		199	List udfs = schema.getTables();
		200	result.addAll(udfs);
		201	}
		202	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		203	}
		204	else
		205	{
		206	return EMPTY_ELEMENT_ARRAY;
		207	}
178	}	208	}
179		209
180	protected Object[] displayUDFNodeChildren(Object parent)	210	protected Object[] displayUDFNodeChildren(Object parent)
181	{	211	{
182	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	212	Object grandParent = ((IVirtualNode)parent).getParent();
183	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUDFs()));	213	if(grandParent instanceof Schema)
		214	{
		215	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		216	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUDFs()));
		217	}
		218	else if(grandParent instanceof Database)
		219	{
		220	List result = new ArrayList();
		221	List schemas = ((Database)grandParent).getSchemas();
		222	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		223	Schema schema = (Schema) iterator.next();
		224	List udfs = schema.getUDFs();
		225	result.addAll(udfs);
		226	}
		227	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		228	}
		229	else if(grandParent instanceof Catalog)
		230	{
		231	List result = new ArrayList();
		232	List schemas = ((Catalog)grandParent).getSchemas();
		233	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		234	Schema schema = (Schema) iterator.next();
		235	List udfs = schema.getUDFs();
		236	result.addAll(udfs);
		237	}
		238	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		239	}
		240	else
		241	{
		242	return EMPTY_ELEMENT_ARRAY;
		243	}
184	}	244	}
185		245
186	/**	246	/**
Lines 188-195 Link Here
188	*/	248	*/
189	protected Object[] displayStoredProcedureNodeChildren(Object parent)	249	protected Object[] displayStoredProcedureNodeChildren(Object parent)
190	{	250	{
191	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	251	Object grandParent = ((IVirtualNode)parent).getParent();
192	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getProcedures()));	252	if(grandParent instanceof Schema)
		253	{
		254	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		255	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getProcedures()));
		256	}
		257	else if(grandParent instanceof Database)
		258	{
		259	List result = new ArrayList();
		260	List schemas = ((Database)grandParent).getSchemas();
		261	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		262	Schema schema = (Schema) iterator.next();
		263	List udfs = schema.getProcedures();
		264	result.addAll(udfs);
		265	}
		266	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		267	}
		268	else if(grandParent instanceof Catalog)
		269	{
		270	List result = new ArrayList();
		271	List schemas = ((Catalog)grandParent).getSchemas();
		272	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		273	Schema schema = (Schema) iterator.next();
		274	List udfs = schema.getProcedures();
		275	result.addAll(udfs);
		276	}
		277	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		278	}
		279	else
		280	{
		281	return EMPTY_ELEMENT_ARRAY;
		282	}
193	}	283	}
194		284
195	/**	285	/**
Lines 199-206 Link Here
199	*/	289	*/
200	protected Object [] displaySequenceNodeChildren (Object parent)	290	protected Object [] displaySequenceNodeChildren (Object parent)
201	{	291	{
202	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	292	Object grandParent = ((IVirtualNode)parent).getParent();
203	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getSequences()));	293	if(grandParent instanceof Schema)
		294	{
		295	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		296	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getSequences()));
		297	}
		298	else if(grandParent instanceof Database)
		299	{
		300	List result = new ArrayList();
		301	List schemas = ((Database)grandParent).getSchemas();
		302	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		303	Schema schema = (Schema) iterator.next();
		304	List udfs = schema.getSequences();
		305	result.addAll(udfs);
		306	}
		307	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		308	}
		309	else if(grandParent instanceof Catalog)
		310	{
		311	List result = new ArrayList();
		312	List schemas = ((Catalog)grandParent).getSchemas();
		313	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		314	Schema schema = (Schema) iterator.next();
		315	List udfs = schema.getSequences();
		316	result.addAll(udfs);
		317	}
		318	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		319	}
		320	else
		321	{
		322	return EMPTY_ELEMENT_ARRAY;
		323	}
204	}	324	}
205		325
206	/**	326	/**
Lines 210-217 Link Here
210	*/	330	*/
211	protected Object [] displayUDTNodeChildren (Object parent)	331	protected Object [] displayUDTNodeChildren (Object parent)
212	{	332	{
213	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	333	Object grandParent = ((IVirtualNode)parent).getParent();
214	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUserDefinedTypes()));	334	if(grandParent instanceof Schema)
		335	{
		336	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		337	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getUserDefinedTypes()));
		338	}
		339	else if(grandParent instanceof Database)
		340	{
		341	List result = new ArrayList();
		342	List schemas = ((Database)grandParent).getSchemas();
		343	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		344	Schema schema = (Schema) iterator.next();
		345	List udfs = schema.getUserDefinedTypes();
		346	result.addAll(udfs);
		347	}
		348	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		349	}
		350	else if(grandParent instanceof Catalog)
		351	{
		352	List result = new ArrayList();
		353	List schemas = ((Catalog)grandParent).getSchemas();
		354	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		355	Schema schema = (Schema) iterator.next();
		356	List udfs = schema.getUserDefinedTypes();
		357	result.addAll(udfs);
		358	}
		359	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		360	}
		361	else
		362	{
		363	return EMPTY_ELEMENT_ARRAY;
		364	}
215	}	365	}
216		366
217	/**	367	/**
Lines 258-265 Link Here
258	*/	408	*/
259	protected Object [] displayViewsNodeChildren (Object parent)	409	protected Object [] displayViewsNodeChildren (Object parent)
260	{	410	{
261	Schema schema = (Schema) ((IVirtualNode)parent).getParent();	411	Object grandParent = ((IVirtualNode)parent).getParent();
262	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));	412	if(grandParent instanceof Schema)
		413	{
		414	Schema schema = (Schema) ((IVirtualNode)parent).getParent();
		415	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), schema.getTables()));
		416	}
		417	else if(grandParent instanceof Database)
		418	{
		419	List result = new ArrayList();
		420	List schemas = ((Database)grandParent).getSchemas();
		421	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		422	Schema schema = (Schema) iterator.next();
		423	List udfs = schema.getTables();
		424	result.addAll(udfs);
		425	}
		426	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		427	}
		428	else if(grandParent instanceof Catalog)
		429	{
		430	List result = new ArrayList();
		431	List schemas = ((Catalog)grandParent).getSchemas();
		432	for (Iterator iterator = schemas.iterator(); iterator.hasNext();) {
		433	Schema schema = (Schema) iterator.next();
		434	List udfs = schema.getTables();
		435	result.addAll(udfs);
		436	}
		437	return getArrays (parent, getChildren(((IVirtualNode)parent).getGroupID(), result));
		438	}
		439	else
		440	{
		441	return EMPTY_ELEMENT_ARRAY;
		442	}
263	}	443	}
264		444
265	/**	445	/**