jstrachan 2002/10/28 08:15:30
Modified: sql/src/java/org/apache/commons/sql/builder SqlBuilder.java
Log:
applied J. Russell Smyth 's patches
modified to work with these changes
modified getSqlType to do its own sql creation, allowing it
to be overridden in db specific builders.
Revision Changes Path
1.10 +14 -2
jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/builder/SqlBuilder.java
Index: SqlBuilder.java
===================================================================
RCS file:
/home/cvs/jakarta-commons-sandbox/sql/src/java/org/apache/commons/sql/builder/SqlBuilder.java,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- SqlBuilder.java 23 Sep 2002 16:56:06 -0000 1.9
+++ SqlBuilder.java 28 Oct 2002 16:15:29 -0000 1.10
@@ -76,6 +76,7 @@
import org.apache.commons.sql.model.ForeignKey;
import org.apache.commons.sql.model.Reference;
import org.apache.commons.sql.model.Table;
+import org.apache.commons.sql.model.TypeMap;
/**
* This class is a collection of Strategy methods for creating the DDL required to
create and drop
@@ -392,9 +393,20 @@
* @return the full SQL type string including the size
*/
protected String getSqlType(Column column) {
- return column.getTypeString();
+ StringBuffer sqlType = new StringBuffer(column.getType());
+ if ( column.getSize() > 0 ) {
+ sqlType.append(" (");
+ sqlType.append(column.getSize());
+ sqlType.append(")");
+ }
+ if ( TypeMap.isDecimalType(column.getType()) ){
+ sqlType.append(",");
+ sqlType.append(column.getScale());
+ sqlType.append(")");
+ }
+ return sqlType.toString();
}
-
+
/**
* Writes the column types for a table
*/
--
To unsubscribe, e-mail: <mailto:commons-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:commons-dev-help@;jakarta.apache.org>
