package org.beanfuse.db.dialect; import java.util.Map; import java.util.HashMap; import java.util.TreeMap; import java.util.Iterator; import org.apache.commons.lang.StringUtils; /** * This class maps a type to names. Associations may be marked with a capacity. * Calling the get() method with a type and actual size n will return the * associated name with smallest capacity >= n, if available and an unmarked * default type otherwise. Eg, setting * * <pre> * names.put(type, "TEXT"); * names.put(type, 255, "VARCHAR($l)"); * names.put(type, 65534, "LONGVARCHAR($l)"); * </pre> * * will give you back the following: * * <pre> * names.get(type) // --> "TEXT" (default) * names.get(type, 100) // --> "VARCHAR(100)" (100 is in [0:255]) * names.get(type, 1000) // --> "LONGVARCHAR(1000)" (1000 is in [256:65534]) * names.get(type, 100000) // --> "TEXT" (default) * </pre> * * On the other hand, simply putting * * <pre> * names.put(type, "VARCHAR($l)"); * </pre> * * would result in * * <pre> * names.get(type) // --> "VARCHAR($l)" (will cause trouble) * names.get(type, 100) // --> "VARCHAR(100)" * names.get(type, 10000) // --> "VARCHAR(10000)" * </pre> * * @author Christoph Beck */ public class TypeNames { private HashMap weighted = new HashMap(); private HashMap defaults = new HashMap(); /** * get default type name for specified type * * @param typecode * the type key * @return the default type name associated with specified key */ public String get(int typecode) { String result = (String) defaults.get(new Integer(typecode)); if (result == null) throw new RuntimeException("No Dialect mapping for JDBC type: " + typecode); return result; } /** * get type name for specified type and size * * @param typecode * the type key * @param size * the SQL length * @param scale * the SQL scale * @param precision * the SQL precision * @return the associated name with smallest capacity >= size, if available * and the default type name otherwise */ public String get(int typecode, int size, int precision, int scale) { Map map = (Map) weighted.get(new Integer(typecode)); if (map != null && map.size() > 0) { // iterate entries ordered by capacity to find first fit Iterator entries = map.entrySet().iterator(); while (entries.hasNext()) { Map.Entry entry = (Map.Entry) entries.next(); if (size <= ((Integer) entry.getKey()).intValue()) { return replace((String) entry.getValue(), size, precision, scale); } } } return replace(get(typecode), size, precision, scale); } private static String replace(String type, int size, int precision, int scale) { type = StringUtils.replace(type, "$s", Integer.toString(scale)); type = StringUtils.replace(type, "$l", Integer.toString(size)); return StringUtils.replace(type, "$p", Integer.toString(precision)); } /** * set a type name for specified type key and capacity * * @param typecode * the type key */ public void put(int typecode, int capacity, String value) { TreeMap map = (TreeMap) weighted.get(new Integer(typecode)); if (map == null) {// add new ordered map map = new TreeMap(); weighted.put(new Integer(typecode), map); } map.put(new Integer(capacity), value); } /** * set a default type name for specified type key * * @param typecode * the type key */ public void put(int typecode, String value) { defaults.put(new Integer(typecode), value); } }