/
sql.go
36 lines (32 loc) · 1.09 KB
/
sql.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
package sqlutils
import (
"database/sql"
"fmt"
)
func ExecuteStatement(connection *sql.DB, queries ...string) error {
for _, query := range queries {
if _, err := connection.Exec(query); err != nil {
return fmt.Errorf("ERROR Executing the following query:\n%s\n | Error: %s", query, err.Error())
}
}
return nil
}
// GetRedshiftTranslator is delegated to create a translator for csvutils.GetCSVDataType in order to create table
func GetRedshiftTranslator() map[string]string {
var replacer = make(map[string]string)
replacer["string"] = "TEXT"
replacer["int"] = "INTEGER"
replacer["float"] = "FLOAT"
replacer["bool"] = "BOOLEAN"
replacer["time"] = "TIMESTAMPTZ"
return replacer
}
// GetOracleTranslator is delegated to create a translator for csvutils.GetCSVDataType in order to create table
func GetOracleTranslator(charLength int) map[string]string {
var replacer = make(map[string]string)
replacer["string"] = fmt.Sprintf("VARCHAR2(%d)", charLength)
replacer["int"] = "INTEGER"
replacer["float"] = "FLOAT"
replacer["bool"] = "VARCHAR(5)" // TRUE,FALSE -> 5 Character
return replacer
}