in hsqldb/hsqldb.go [37:110]
func (a Adapter) GetColumnTypeDefinition(col *message.ColumnMetaData) *internal.Column {
column := &internal.Column{
Name: col.ColumnName,
TypeName: col.Type.Name,
Nullable: col.Nullable != 0,
}
// Handle precision and length
switch col.Type.Name {
case "DECIMAL", "NUMERIC":
precision := int64(col.Precision)
if precision == 0 {
precision = math.MaxInt64
}
scale := int64(col.Scale)
if scale == 0 {
scale = math.MaxInt64
}
column.PrecisionScale = &internal.PrecisionScale{
Precision: precision,
Scale: scale,
}
case "VARCHAR", "CHAR", "CHARACTER", "BINARY", "VARBINARY", "BIT", "BITVARYING":
column.Length = int64(col.Precision)
}
// Handle scan types
switch col.Type.Name {
case "INTEGER", "BIGINT", "TINYINT", "SMALLINT":
column.ScanType = reflect.TypeOf(int64(0))
case "FLOAT", "DOUBLE":
column.ScanType = reflect.TypeOf(float64(0))
case "DECIMAL", "NUMERIC", "VARCHAR", "CHAR", "CHARACTER":
column.ScanType = reflect.TypeOf("")
case "BOOLEAN":
column.ScanType = reflect.TypeOf(false)
case "TIME", "DATE", "TIMESTAMP":
column.ScanType = reflect.TypeOf(time.Time{})
case "BINARY", "VARBINARY":
column.ScanType = reflect.TypeOf([]byte{})
default:
column.ScanType = reflect.TypeOf(new(interface{})).Elem()
}
// Handle rep type special cases for decimals, floats, date, time and timestamp
switch col.Type.Name {
case "DECIMAL", "NUMERIC":
column.Rep = message.Rep_BIG_DECIMAL
case "FLOAT":
column.Rep = message.Rep_FLOAT
case "TIME":
column.Rep = message.Rep_JAVA_SQL_TIME
case "DATE":
column.Rep = message.Rep_JAVA_SQL_DATE
case "TIMESTAMP":
column.Rep = message.Rep_JAVA_SQL_TIMESTAMP
default:
column.Rep = col.Type.Rep
}
return column
}