-
Notifications
You must be signed in to change notification settings - Fork 4
/
typesql.go
71 lines (67 loc) · 1.61 KB
/
typesql.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
package model
import (
"fmt"
"projectforge.dev/projectforge/app/lib/types"
"projectforge.dev/projectforge/app/util"
)
const keyText, keyNVarcharMax = "text", "nvarchar(max)"
func ToSQLType(t types.Type, database string) (string, error) {
switch t.Key() {
case types.KeyAny:
if database == util.DatabaseSQLServer {
return keyText, nil
}
return keyJSONB, nil
case types.KeyBool:
if database == util.DatabaseSQLServer {
return "bit", nil
}
return "boolean", nil
case types.KeyEnum:
if database == util.DatabaseSQLServer {
return "nvarchar(255)", nil
}
e, err := AsEnum(t)
if err != nil {
return "", err
}
return e.Ref, nil
case types.KeyInt:
i := types.TypeAs[*types.Int](t)
if i != nil && i.Bits == 64 {
return "bigint", nil
}
return "int", nil
case types.KeyFloat:
return "double precision", nil
case types.KeyList, types.KeyMap, types.KeyValueMap, types.KeyReference:
if database == util.DatabaseSQLServer {
return keyNVarcharMax, nil
}
return keyJSONB, nil
case types.KeyString:
if database == util.DatabaseSQLServer {
s, ok := types.Wrap(t).T.(*types.String)
if !ok {
return keyNVarcharMax, nil
}
if s.MaxLength > 0 {
return fmt.Sprintf("nvarchar(%d)", s.MaxLength), nil
}
return keyNVarcharMax, nil
}
return keyText, nil
case types.KeyDate, types.KeyTimestamp:
if database == util.DatabaseSQLServer {
return "datetime", nil
}
return "timestamp", nil
case types.KeyUUID:
if database == util.DatabaseSQLServer {
return "uniqueidentifier", nil
}
return "uuid", nil
default:
return "sql-error-invalid-type", nil
}
}