/*
    * Copyright 2004-2006 the Seasar Foundation and the Others.
    *
    * Licensed under the Apache License, Version 2.0 (the "License");
    * you may not use this file except in compliance with the License.
    * You may obtain a copy of the License at
    *
    *     http://www.apache.org/licenses/LICENSE-2.0
    *
   * Unless required by applicable law or agreed to in writing, software
   * distributed under the License is distributed on an "AS IS" BASIS,
   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, 
   * either express or implied. See the License for the specific language
   * governing permissions and limitations under the License.
   */
  package org.seasar.tuigwaa.model.common;
  
  import java.beans.PropertyDescriptor;
  import java.lang.reflect.InvocationTargetException;
  import java.security.Principal;
  import java.sql.Timestamp;
  import java.util.ArrayList;
  import java.util.Calendar;
  import java.util.Collection;
  import java.util.Collections;
  import java.util.Date;
  import java.util.HashMap;
  import java.util.HashSet;
  import java.util.Iterator;
  import java.util.List;
  import java.util.Map;
  import java.util.Set;
  
  import org.apache.commons.beanutils.ConvertUtils;
  import org.apache.commons.beanutils.DynaBean;
  import org.apache.commons.beanutils.PropertyUtils;
  import org.seasar.tuigwaa.model.core.TgwAttribute;
  import org.seasar.tuigwaa.model.core.TgwEntity;
  import org.seasar.tuigwaa.model.core.impl.BooleanAttribute;
  import org.seasar.tuigwaa.model.core.impl.ByteArrayAttribute;
  import org.seasar.tuigwaa.model.core.impl.DateAttribute;
  import org.seasar.tuigwaa.model.core.impl.FileAttribute;
  import org.seasar.tuigwaa.model.core.impl.FkAttribute;
  import org.seasar.tuigwaa.model.core.impl.FloatAttribute;
  import org.seasar.tuigwaa.model.core.impl.IntegerAttribute;
  import org.seasar.tuigwaa.model.core.impl.SecurityAttribute;
  import org.seasar.tuigwaa.model.core.impl.SelfAttribute;
  import org.seasar.tuigwaa.model.core.impl.SetAttribute;
  import org.seasar.tuigwaa.model.core.impl.StringAttribute;
  import org.seasar.tuigwaa.model.core.impl.TimestampAttribute;
  import org.seasar.tuigwaa.system.Constants;
  import org.seasar.tuigwaa.util.TgwContext;
  import org.seasar.tuigwaa.util.TgwNameUtils;
  import org.seasar.tuigwaa.util.TgwResource;
  
  public class EntityUtils {
  
  	public static final String ESCAPED_ID = "__id__";
  
  	public static final String ENTITY_BUILTIN_RESOURCE_PREFIX = "entity.builtin.";
  
  	/* Convert : Tuigwaa Type -> Tuigwaa Attribute */
  	private static final Map TGWTYPE2TGWATTR_MAP;
  
  	/* Convert : Java Type -> Tuigwaa Attribute */
  	private static final Map JAVA2TGWATTR_MAP;
  
  	/* Convert : Tuigwaa Type -> Java Type */
  	private static final Map TGWTYPE2JAVA_MAP;
  
  	static {
  		Map map = new HashMap();
  		map.put(TgwAttribute.TYPE_STRING, StringAttribute.class);
  		map.put(TgwAttribute.TYPE_INTEGER, IntegerAttribute.class);
  		map.put(TgwAttribute.TYPE_FLOAT, FloatAttribute.class);
  		map.put(TgwAttribute.TYPE_BOOLEAN, BooleanAttribute.class);
  		map.put(TgwAttribute.TYPE_DATE, DateAttribute.class);
  		map.put(TgwAttribute.TYPE_FILE, FileAttribute.class);
  		map.put(TgwAttribute.TYPE_FK, FkAttribute.class);
  		map.put(TgwAttribute.TYPE_SET, SetAttribute.class);
  		map.put(TgwAttribute.TYPE_SELF, SelfAttribute.class);
  		TGWTYPE2TGWATTR_MAP = Collections.unmodifiableMap(map);
  
  		Map map2 = new HashMap();
  		map2.put(int.class.getName(), IntegerAttribute.class);
  		map2.put(long.class.getName(), IntegerAttribute.class);
  		map2.put(float.class.getName(), FloatAttribute.class);
  		map2.put(double.class.getName(), FloatAttribute.class);
  		map2.put(boolean.class.getName(), BooleanAttribute.class);
  		map2.put(String.class.getName(), StringAttribute.class);
  		map2.put(Integer.class.getName(), IntegerAttribute.class);
  		map2.put(Long.class.getName(), IntegerAttribute.class);
  		map2.put(Float.class.getName(), FloatAttribute.class);
  		map2.put(Double.class.getName(), FloatAttribute.class);
  		map2.put(Boolean.class.getName(), BooleanAttribute.class);
  		map2.put(Date.class.getName(), DateAttribute.class);
  		map2.put(java.sql.Date.class.getName(), DateAttribute.class);
  		map2.put(Timestamp.class.getName(), TimestampAttribute.class);
  		map2.put(byte[].class.getName(), ByteArrayAttribute.class);
 		JAVA2TGWATTR_MAP = Collections.unmodifiableMap(map2);
 
 		Map tmp = new HashMap();
 		tmp.put(TgwAttribute.TYPE_STRING, String.class);
 		tmp.put(TgwAttribute.TYPE_INTEGER, Integer.class);
 		tmp.put(TgwAttribute.TYPE_LONG, Long.class);
 		tmp.put(TgwAttribute.TYPE_FLOAT, Float.class);
 		tmp.put(TgwAttribute.TYPE_BOOLEAN, Boolean.class);
 		tmp.put(TgwAttribute.TYPE_DATE, Date.class);
 		tmp.put(TgwAttribute.TYPE_STRINGARRAY, Integer.class);
 		tmp.put(TgwAttribute.TYPE_TIMESTAMP, Date.class);
 		tmp.put(TgwAttribute.TYPE_SET, Set.class);
 		tmp.put(TgwAttribute.TYPE_FILE, "byte[]");
 		tmp.put(TgwAttribute.TYPE_SECURITY, String.class);
 		tmp.put(TgwAttribute.TYPE_BYTEARRAY, "byte[]");
 		TGWTYPE2JAVA_MAP = Collections.unmodifiableMap(tmp);
 	}
 
 	// [Start] ---- converter ------
 
 	public static Class toJavaClass(TgwAttribute attribute) {
 		return (Class) TGWTYPE2JAVA_MAP.get(attribute.getType());
 	}
 
 	public static TgwAttribute toTgwAttribute(Class clazz) {
 		return toTgwAttribute(clazz.getName());
 	}
 
 	public static TgwAttribute toTgwAttribute(String className) {
 		Class attrClass = (Class) JAVA2TGWATTR_MAP.get(className);
 		if (attrClass != null) {
 			try {
 				TgwAttribute attr = (TgwAttribute) attrClass.newInstance();
 				return attr;
 			} catch (InstantiationException e) {
 				// do nothing
 			} catch (IllegalAccessException e) {
 				// do nothing
 			}
 		}
 		return null;
 	}
 
 	public static String toEntityName(Class clazz) {
 		String[] array = clazz.getName().split("//.");
 		return array[array.length - 1].toLowerCase();
 	}
 
 	public static String toJavaType(TgwAttribute attribute) {
 		if (attribute instanceof FkAttribute) {
 			return ((FkAttribute) attribute).getRefClassName();
 		} else if (attribute instanceof SelfAttribute) {
 			return attribute.getEntity().getJavaClassName();
 		} else if (attribute instanceof FileAttribute) {
 			return "byte[]";
 		}
 		return toJavaClass(attribute).getName();
 	}
 
 	// [End] ---- converter ------
 
 	public static boolean isBuiltinAttribute(TgwAttribute attr) {
 		if (attr instanceof TimestampAttribute
 				|| attr instanceof SecurityAttribute) {
 			return true;
 		}
 		return false;
 	}
 
 	public static boolean isM2MAttribute(TgwAttribute attr) {
 		if ((attr instanceof SetAttribute)
 				&& SetAttribute.OPTION_M2M.equals(attr.getOption())) {
 			return true;
 		}
 		return false;
 	}
 
 	public static TgwAttribute createAttribute(String type) {
 		TgwAttribute attr = null;
 		Class clazz = (Class) TGWTYPE2TGWATTR_MAP.get(type);
 		try {
 			attr = (TgwAttribute) clazz.newInstance();
 		} catch (InstantiationException e) {
 			// do nothing
 		} catch (IllegalAccessException e) {
 			// do nothing
 		}
 		return attr;
 	}
 
 	public static void setUser(Object obj) {
 		Principal principal = TgwContext.getPrincipal();
 		if (principal == null) {
 			return;
 		}
 
 		// Creation Date Inser t
 		if (PropertyUtils.isWriteable(obj,
 				Constants.ENTITY_BUILTIN_CREATIONUSER)) {
 			if (!hasId(obj)) {
 				setProperty(obj, Constants.ENTITY_BUILTIN_CREATIONUSER,
 						principal.getName());
 			}
 		}
 
 		// Modification Date Insert
 		if (PropertyUtils.isWriteable(obj,
 				Constants.ENTITY_BUILTIN_MODIFICATIONUSER)) {
 			setProperty(obj, Constants.ENTITY_BUILTIN_MODIFICATIONUSER,
 					principal.getName());
 		}
 	}
 
 	public static void setTimestamp(Object obj) {
 		// Creation Date Insert
 		if (PropertyUtils.isWriteable(obj,
 				Constants.ENTITY_BUILTIN_CREATIONDATE)) {
 			if (!hasId(obj)) {
 				setTimestamp(obj, Constants.ENTITY_BUILTIN_CREATIONDATE);
 			}
 		}
 
 		// Modification Date Insert
 		if (PropertyUtils.isWriteable(obj,
 				Constants.ENTITY_BUILTIN_MODIFICATIONDATE)) {
 			setTimestamp(obj, Constants.ENTITY_BUILTIN_MODIFICATIONDATE);
 		}
 	}
 
 	private static void setTimestamp(Object obj, String property) {
 		try {
 			Date now = new Date();
 			Class propType = PropertyUtils.getPropertyType(obj, property);
 			if (propType.equals(Date.class)) {
 				setProperty(obj, property, now);
 			} else if (propType.equals(Timestamp.class)) {
 				setProperty(obj, property, new Timestamp(now.getTime()));
 			}
 		} catch (IllegalAccessException e) {
 			// do nothing
 		} catch (InvocationTargetException e) {
 			// do nothing
 		} catch (NoSuchMethodException e) {
 			// do nothing
 		}
 	}
 
 	public static void addCreationUserAttribute(TgwEntity entity,
 			boolean userUniqueFlag, String attrName) {
 		SecurityAttribute attr = new SecurityAttribute();
 		attr.setName(Constants.ENTITY_BUILTIN_CREATIONUSER);
 		attr.setDisplayName(attrName);
 		attr.setUnique(userUniqueFlag);
 		entity.addField(attr);
 	}
 
 	public static void addCreationUserAttribute(TgwEntity entity,
 			boolean userUniqueFlag) {
 		addCreationUserAttribute(entity, userUniqueFlag, TgwResource
 				.getMessage(ENTITY_BUILTIN_RESOURCE_PREFIX
 						+ Constants.ENTITY_BUILTIN_CREATIONUSER));
 	}
 
 	public static void addModificationUserAttribute(TgwEntity entity) {
 		addModificationUserAttribute(entity, TgwResource
 				.getMessage(ENTITY_BUILTIN_RESOURCE_PREFIX
 						+ Constants.ENTITY_BUILTIN_MODIFICATIONUSER));
 	}
 
 	public static void addModificationUserAttribute(TgwEntity entity,
 			String attrDisplayName) {
 		SecurityAttribute attr = new SecurityAttribute();
 		attr.setName(Constants.ENTITY_BUILTIN_MODIFICATIONUSER);
 		attr.setDisplayName(attrDisplayName);
 		entity.addField(attr);
 	}
 
 	public static void addCreationDateAttribute(TgwEntity entity) {
 		addCreationDateAttribute(entity, TgwResource
 				.getMessage(ENTITY_BUILTIN_RESOURCE_PREFIX
 						+ Constants.ENTITY_BUILTIN_CREATIONDATE));
 	}
 
 	public static void addCreationDateAttribute(TgwEntity entity,
 			String displayName) {
 		TimestampAttribute tfield = new TimestampAttribute();
 		tfield.setName(Constants.ENTITY_BUILTIN_CREATIONDATE);
 		tfield.setDisplayName(displayName);
 		entity.addField(tfield);
 	}
 
 	public static void addModificationDateAttribute(TgwEntity entity) {
 		addModificationDateAttribute(entity, TgwResource
 				.getMessage(ENTITY_BUILTIN_RESOURCE_PREFIX
 						+ Constants.ENTITY_BUILTIN_MODIFICATIONDATE));
 	}
 
 	public static void addModificationDateAttribute(TgwEntity entity,
 			String displayName) {
 		TimestampAttribute tfield = new TimestampAttribute();
 		tfield.setName(Constants.ENTITY_BUILTIN_MODIFICATIONDATE);
 		tfield.setDisplayName(displayName);
 		entity.addField(tfield);
 	}
 
 	public static boolean hasId(Object bean) {
 		Long id = getId(bean);
 		return (id != null && ((Long) id).longValue() != 0l);
 	}
 
 	public static Long getEscapedId(Object bean) {
 		return (Long) getProperty(bean, ESCAPED_ID);
 	}
 
 	public static Long getId(Object bean) {
 		return getId(bean, false);
 	}
 
 	public static Long getId(Object bean, boolean isDynaProperty) {
 		String idProp = Constants.ENTITY_BUILTIN_ID;
 		if (isDynaProperty) {
 			idProp = TgwNameUtils.toDynaPropertyName(idProp);
 		}
 		return (Long) getProperty(bean, idProp);
 	}
 
 	public static void setId(Object bean, Long id) {
 		setId(bean, id, false);
 	}
 
 	public static void setId(Object bean, Long id, boolean isDynaProperty) {
 		String idProp = Constants.ENTITY_BUILTIN_ID;
 		if (isDynaProperty) {
 			idProp = TgwNameUtils.toDynaPropertyName(idProp);
 		}
 		setProperty(bean, idProp, id);
 	}
 
 	public static Object newInstanceById(TgwEntity entity, Long id) {
 		return newInstanceById(entity.getJavaClass(), id);
 	}
 
 	public static Object newInstanceById(Class clazz, Long id) {
 		if (clazz == null) {
 			return null;
 		}
 		try {
 			Object obj = clazz.newInstance();
 			setId(obj, id);
 			return obj;
 		} catch (InstantiationException e) {
 			// do nothig
 		} catch (IllegalAccessException e) {
 			// do nothig
 		}
 		return null;
 	}
 
 	public static Object getProperty(Object valueObj, TgwAttribute field) {
 		return getProperty(valueObj, field.getName());
 	}
 
 	public static void copyPropertyCollectionEscape(Object src, Object target,
 			String propertyName) {
 		Object value = getProperty(src, propertyName);
 		if (value != null && value instanceof Collection) {
 			Collection collection = (Collection) getProperty(target,
 					propertyName);
 			collection.clear();
 			collection.addAll((Collection) value);
 		} else {
 			setProperty(target, propertyName, value);
 		}
 	}
 
 	public static Object copyPropertiesCollectionEscape(Object src,
 			Object target, TgwEntity entity) {
 		Iterator itr = entity.getFieldList().iterator();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (attr instanceof SetAttribute && !manyToManyFlag(attr)) {
 				continue;
 			}
 			copyPropertyCollectionEscape(src, target, attr.getName());
 		}
 		return target;
 	}
 
 	public static String getKeys(TgwEntity entity) {
 		return entity.getDomainName() + "." + entity.getName();
 	}
 
 	public static Object exchange(TgwEntity entity, DynaBean src) {
 		return exchange(entity.newInstance(), src, entity);
 	}
 
 	public static Object exchange(Object dest, DynaBean src, TgwEntity entity) {
 
 		// id
 		if (PropertyUtils.isWriteable(dest, Constants.ENTITY_BUILTIN_ID)) {
 			Object value = getProperty(src, ESCAPED_ID);
 			setProperty(dest, Constants.ENTITY_BUILTIN_ID, value);
 		}
 
 		for (Iterator i = entity.getFieldIterator(); i.hasNext();) {
 			TgwAttribute attr = (TgwAttribute) i.next();
 			String propertyName = attr.getName();
 			if (!isBuiltinAttribute(attr)
 					&& PropertyUtils.isWriteable(dest, propertyName)) {
 
 				String dynaPropertyName = TgwNameUtils
 						.toDynaPropertyName(propertyName);
 
 				if (!PropertyUtils.isReadable(src, dynaPropertyName)) {
 					continue;
 				}
 				Object value = getProperty(src, dynaPropertyName);
 				String attrType = attr.getType();
 
 				// for null-value handling
 				if (TgwAttribute.TYPE_STRING.equals(attrType)) {
 					String str = (String) value;
 					if (str == null || "".equals(str)) {
 						continue;
 					}
 				}
 
 				setProperty(dest, propertyName, value);
 
 				if (TgwAttribute.TYPE_DATE.equals(attrType)) {
 					exchangeDate(propertyName, (Date) value, dest);
 				}
 			}
 		}
 		return dest;
 	}
 
 	private static void exchangeDate(String name, Date date, Object dest) {
 		if (date == null) {
 			return;
 		}
 		Calendar cal = Calendar.getInstance();
 		cal.setTime(date);
 		String[] dateParts = TgwNameUtils.toDateParts(name);
 		setProperty(dest, dateParts[0], new Integer(cal.get(Calendar.YEAR)));
 		setProperty(dest, dateParts[1],
 				new Integer(cal.get(Calendar.MONTH) + 1));
 		setProperty(dest, dateParts[2], new Integer(cal.get(Calendar.DATE)));
 	}
 
 	public static Object getProperty(Object valueObj, String fieldName) {
 		if (valueObj != null) {
 			try {
 				return PropertyUtils.getProperty(valueObj, fieldName);
 			} catch (IllegalAccessException e) {
 				e.printStackTrace();
 				throw new RuntimeException(e);
 			} catch (InvocationTargetException e) {
 				e.printStackTrace();
 				throw new RuntimeException(e);
 			} catch (NoSuchMethodException e) {
 				e.printStackTrace();
 				throw new RuntimeException(e);
 			}
 		}
 		return null;
 	}
 
 	public static void setProperty(Object bean, TgwAttribute attr, Object value) {
 		setProperty(bean, attr.getName(), value);
 	}
 
 	public static void convertAndSetProperty(Object bean, TgwAttribute attr,
 			String value) {
 		Class clazz = toJavaClass(attr);
 		if (value != null && !java.lang.String.class.equals(clazz)) {
 			Object obj = ConvertUtils.convert(value, clazz);
 			setProperty(bean, attr, obj);
 		} else {
 			// TODO XSS WebServiceImpl
 			setProperty(bean, attr, value);
 		}
 	}
 
 	public static void setProperty(Object bean, String propertyName,
 			Object value) {
 		try {
 			PropertyDescriptor desc = PropertyUtils.getPropertyDescriptor(bean,
 					propertyName);
 			if (desc != null
 					&& (desc.getPropertyType().isPrimitive() && value == null)) {
 				return;
 			}
 			PropertyUtils.setProperty(bean, propertyName, value);
 		} catch (IllegalAccessException e) {
 			// do nothing
 		} catch (InvocationTargetException e) {
 			// do nothing
 		} catch (NoSuchMethodException e) {
 			// do nothing
 		}
 	}
 
 	public static boolean needConverter(TgwAttribute attr) {
 		if (attr instanceof DateAttribute || attr instanceof FkAttribute
 				|| attr instanceof SelfAttribute
 				|| attr instanceof FileAttribute
 				|| attr instanceof SetAttribute
 				|| attr instanceof TimestampAttribute) {
 			return true;
 		}
 		return false;
 	}
 
 	public static boolean isExistFileField(TgwEntity entity) {
 		Iterator itr = entity.getFieldList().iterator();
 		while (itr.hasNext()) {
 			TgwAttribute field = (TgwAttribute) itr.next();
 			if (field instanceof FileAttribute) {
 				return true;
 			}
 		}
 		return false;
 	}
 	
 	public static boolean hasAttribute(TgwEntity entity, String attrType){		
 		for(Iterator itr = entity.getFieldList().iterator();itr.hasNext();){
 			TgwAttribute field = (TgwAttribute) itr.next();
 			if (field.getType().equals(attrType)) {
 				return true;
 			}			
 		}
 		return false;
 	}	
 
 	public static boolean hasSelfAttribute(TgwEntity entity) {
 		Iterator itr = entity.getFieldList().iterator();		
 		while (itr.hasNext()) {
 			TgwAttribute field = (TgwAttribute) itr.next();
 			if (field instanceof SelfAttribute) {
 				return true;
 			}
 		}
 		return false;
 	}
 
 	public static TgwAttribute getEmailAttribute(TgwEntity entity) {
 		Iterator itr = entity.getFieldIterator();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (isEmail(attr)) {
 				return attr;
 			}
 		}
 		return null;
 	}
 
 	public static boolean isEmail(TgwAttribute field) {
 		if (field instanceof StringAttribute
 				&& ((StringAttribute) field).getMask().equals(
 						StringAttribute.MASK_EMAIL)) {
 			return true;
 		}
 		return false;
 	}
 
 	public static boolean manyToMnayFlag(TgwEntity entity) {
 		Iterator itr = entity.getFieldList().iterator();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (manyToManyFlag(attr)) {
 				return true;
 			}
 		}
 		return false;
 	}
 
 	public static boolean manyToManyFlag(TgwAttribute attr) {
 		if (!(attr instanceof SetAttribute)) {
 			return false;
 		}
 		return manyToManyFlag((SetAttribute) attr);
 	}
 
 	public static boolean oneToManyFlag(TgwAttribute attr) {
 		if (!(attr instanceof SetAttribute)) {
 			return false;
 		}
 		return !manyToManyFlag((SetAttribute) attr);
 	}
 
 	public static boolean manyToManyFlag(SetAttribute attr) {
 		if (attr == null) {
 			return false;
 		}
 
 		TgwEntity ref = attr.getRefEntity();
 		Collection list = ref.getFieldList();
 		if (list.size() != 2) {
 			return false;
 		}
 		TgwAttribute target = getTheOtherAttribute(attr);
 		if (target instanceof FkAttribute) {
 			return true;
 		} else if (target instanceof StringAttribute
 				&& "restriction".equals(target.getOption())) {
 			return true;
 		}
 		return false;
 	}
 
 	public static TgwAttribute getTheOtherAttribute(SetAttribute attr) {
 		TgwEntity ref = attr.getRefEntity();
 		if (ref == null) {
 			return null;
 		}
 		Collection list = ref.getFieldList();
 		if (list.size() != 2) {
 			return null;
 		}
 		for (Iterator i = list.iterator(); i.hasNext();) {
 			TgwAttribute anAttr = (TgwAttribute) i.next();
 			if (!anAttr.equals(attr.getInverseField())) {
 				return anAttr;
 			}
 		}
 		return null;
 	}
 
 	public static boolean contains(Set set, TgwAttribute theOtherAttr,
 			Object value) {
 		if (set == null) {
 			return false;
 		}
 
 		for (Iterator i = set.iterator(); i.hasNext();) {
 			Object obj = getProperty(i.next(), theOtherAttr);
 			if (theOtherAttr instanceof FkAttribute) {
 				String id = String.valueOf(getId(obj));
 				if (id.equals(value)) {
 					return true;
 				}
 			} else if (theOtherAttr instanceof StringAttribute) {
 				if (obj.equals(value)) {
 					return true;
 				}
 			}
 		}
 		return false;
 	}
 
 	public static void bindSelfObject(Object obj, TgwEntity entity) {
 		if (entity == null) {
 			return;
 		}
 		Iterator itr = entity.getFieldIterator();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (attr instanceof SetAttribute) {
 				SetAttribute setAttr = (SetAttribute) attr;
 				FkAttribute fk = setAttr.getInverseField();
 				Set set = (Set) EntityUtils.getProperty(obj, setAttr);
 				if (set == null) {
 					continue;
 				}
 				for (Iterator i = set.iterator(); i.hasNext();) {
 					Object bean = i.next();
 					EntityUtils.setProperty(bean, fk, obj);
 				}
 			}
 		}
 	}
 
 	public static void removeSelfObjectTree(Object selfObj, TgwEntity entity,
 			Collection visitedEntities) {
 		if (entity == null) {
 			return;
 		}
 		if (visitedEntities == null) {
 			visitedEntities = new HashSet();
 		}
 		visitedEntities.add(entity);
 		Iterator itr = entity.getFieldIterator();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (attr instanceof FkAttribute) {
 				FkAttribute fkAttr = (FkAttribute) attr;
 				TgwEntity refEntity = fkAttr.getRefEntity();
 				if (!visitedEntities.contains(refEntity)) {
 					SetAttribute setAttr = fkAttr.getInverseField();
 					if (setAttr != null) {
 						removeSelfObject(selfObj, fkAttr, setAttr);
 					}
 				}
 			} else if (attr instanceof SetAttribute) {
 				SetAttribute setAttr = (SetAttribute) attr;
 				TgwEntity refEntity = setAttr.getRefEntity();
 				if (!visitedEntities.contains(refEntity)) {
 					Set childrenObj = (Set) getProperty(selfObj, setAttr);
 					if (childrenObj != null) {
 						for (Iterator i = childrenObj.iterator(); i.hasNext();) {
 							Object childObj = i.next();
 							removeSelfObjectTree(childObj, refEntity,
 									visitedEntities);
 						}
 					}
 				}
 			}
 		}
 	}
 
 	private static void removeSelfObject(Object selfObj, FkAttribute fkAttr,
 			SetAttribute setAttr) {
 		Object parentObj = getProperty(selfObj, fkAttr);
 		Set set = (Set) getProperty(parentObj, setAttr);
 		if(set != null){
 			set.remove(selfObj);	
 		}
 		
 	}
 
 	public static List getCrossRefList(TgwEntity entity) {
 		Iterator itr = entity.getFieldList().iterator();
 		List list = new ArrayList();
 		while (itr.hasNext()) {
 			TgwAttribute attr = (TgwAttribute) itr.next();
 			if (attr instanceof FkAttribute) {
 				FkAttribute fk = (FkAttribute) attr;
 				if (fk.getInverseField() != null) {
 					list.add(fk.getInverseField());
 				}
 			}
 		}
 		return list;
 	}
 
 	/***
 	 * 引数に指定したエンティティ（テーブル）のカラム名一覧を返す
 	 */
 	public static String[] getColumns(TgwEntity entity) {
 
 		Collection fieldList = entity.getFieldList();
 		int fieldnum = fieldList.size();
 		String[] columns = new String[fieldnum + 1];
 		columns[0] = entity.getPrimaryKeyColumnName();
 		int idx = 1;
 		for (Iterator i = fieldList.iterator(); i.hasNext();) {
 			TgwAttribute attr = (TgwAttribute) i.next();
 			columns[idx++] = attr.getName();
 		}
 		return columns;
 	}
 
 	public static String[] getColumnTypes(TgwEntity entity) {
 
 		Collection fieldList = entity.getFieldList();
 		int fieldnum = fieldList.size();
 		String[] types = new String[fieldnum + 1];
 		types[0] = "java.lang.Long";
 		int idx = 1;
 		for (Iterator i = fieldList.iterator(); i.hasNext();) {
 			TgwAttribute attr = (TgwAttribute) i.next();
 			types[idx++] = toJavaClass(attr).getName();
 		}
 		return types;
 	}
 
 	public static boolean alreadyUserDataInserted(TgwEntity entity) {
 		SecurityAttribute attr = (SecurityAttribute) entity
 				.getField(Constants.ENTITY_BUILTIN_CREATIONUSER);
 		if (attr == null) {
 			return false;
 		}
 		if (!attr.isUnique()) {
 			return false;
 		}
 		Object obj = DataServiceUtils.loadByValue(entity,
 				Constants.ENTITY_BUILTIN_CREATIONUSER, TgwContext
 						.getPrincipal().getName());
 		return obj != null;
 	}
 }