ea2ddl-ddl/src/main/java/jp/sourceforge/ea2ddl/ddl/model/ColumnModel.java

   1 /**\r
   2  * \r
   3  */\r
   4 package jp.sourceforge.ea2ddl.ddl.model;\r
   5 \r
   6 import java.io.Serializable;\r
   7 \r
   8 /**\r
   9  * @author takiguchi\r
  10  * \r
  11  */\r
  12 public class ColumnModel implements Serializable {\r
  13         private static final long serialVersionUID = 1L;\r
  14 \r
  15         private String _name;\r
  16         private String _alias;\r
  17         private String _note;\r
  18         private String _type;\r
  19         private Integer _length;\r
  20         private Integer _precision;\r
  21         private Integer _scale;\r
  22         private boolean nullable;\r
  23 \r
  24         public boolean isNullable() {\r
  25                 return nullable;\r
  26         }\r
  27 \r
  28         public void setNullable(boolean nullable) {\r
  29                 this.nullable = nullable;\r
  30         }\r
  31 \r
  32         private String defaultValue;\r
  33 \r
  34         public String getName() {\r
  35                 return _name;\r
  36         }\r
  37 \r
  38         public void setName(String name) {\r
  39                 _name = name;\r
  40         }\r
  41 \r
  42         public String getAlias() {\r
  43                 return _alias;\r
  44         }\r
  45 \r
  46         public void setAlias(String alias) {\r
  47                 _alias = alias;\r
  48         }\r
  49 \r
  50         public String getNote() {\r
  51                 return _note;\r
  52         }\r
  53 \r
  54         public void setNote(String note) {\r
  55                 _note = note;\r
  56         }\r
  57 \r
  58         public String getType() {\r
  59                 return _type;\r
  60         }\r
  61 \r
  62         public void setType(String type) {\r
  63                 _type = type;\r
  64         }\r
  65 \r
  66         public Integer getLength() {\r
  67                 return _length;\r
  68         }\r
  69 \r
  70         public void setLength(Integer length) {\r
  71                 _length = length;\r
  72         }\r
  73 \r
  74         public Integer getPrecision() {\r
  75                 return _precision;\r
  76         }\r
  77 \r
  78         public void setPrecision(Integer precision) {\r
  79                 _precision = precision;\r
  80         }\r
  81 \r
  82         public Integer getScale() {\r
  83                 return _scale;\r
  84         }\r
  85 \r
  86         public void setScale(Integer scale) {\r
  87                 _scale = scale;\r
  88         }\r
  89 \r
  90         public String getDefaultValue() {\r
  91                 return defaultValue;\r
  92         }\r
  93 \r
  94         public void setDefaultValue(String defaultValue) {\r
  95                 this.defaultValue = defaultValue;\r
  96         }\r
  97 \r
  98         public String getDefinition() {\r
  99                 StringBuffer b = new StringBuffer();\r
 100                 b.append(getType());\r
 101                 if ("CHAR".equals(getType()) || "VARCHAR".equals(getType())\r
 102                                 || "VARCHAR2".equals(getType()) || "INTEGER".equals(getType())\r
 103                                 || "LONG".equals(getType()) || "FLOAT".equals(getType())\r
 104                                 || "NCHAR".equals(getType()) || "NVARCHAR".equals(getType())\r
 105                                 || "NVARCHAR2".equals(getType()) || "RAW".equals(getType())) {\r
 106                         b.append("(").append(getLength()).append(")");\r
 107                 } else if ("NUMBER".equals(getType())) {\r
 108                         b.append("(").append(getPrecision());\r
 109                         if (getScale() != null && 0 != getScale()) {\r
 110                                 b.append(",").append(getScale());\r
 111                         }\r
 112                         b.append(")");\r
 113                 }\r
 114                 if (!isNullable()) {\r
 115                         b.append(" NOT NULL");\r
 116                 }\r
 117                 return b.toString();\r
 118         }\r
 119 \r
 120         public String getComment() {\r
 121                 StringBuffer b = new StringBuffer();\r
 122                 if (getAlias() != null) {\r
 123                         b.append(getAlias()).append(".").append("\r\n");\r
 124                 }\r
 125                 if (getNote() != null) {\r
 126                         b.append(getNote());\r
 127                 }\r
 128                 if (b.length() == 0) {\r
 129                         return null;\r
 130                 }\r
 131                 return b.toString();\r
 132         }\r
 133 }\r