你能给予我一些解释和一些代码例子,它将如何完成(例如:创建表和插入数据)?你会建议我使用哪个库?谢谢你,谢谢
du7egjpx1#
import ( "database/sql" "fmt" _ "github.com/lib/pq")func MakeRedshfitConnection(username, password, host, port, dbName string) (*sql.DB, error) { url := fmt.Sprintf("sslmode=require user=%v password=%v host=%v port=%v dbname=%v", username, password, host, port, dbName) var err error var db *sql.DB if db, err = sql.Open("postgres", url); err != nil { return nil, fmt.Errorf("redshift conn error : (%v)", err) } if err = db.Ping(); err != nil { return nil, fmt.Errorf("redshift ping error : (%v)", err) } return db, nil}
import (
"database/sql"
"fmt"
_ "github.com/lib/pq"
)
func MakeRedshfitConnection(username, password, host, port, dbName string) (*sql.DB, error) {
url := fmt.Sprintf("sslmode=require user=%v password=%v host=%v port=%v dbname=%v",
username,
password,
host,
port,
dbName)
var err error
var db *sql.DB
if db, err = sql.Open("postgres", url); err != nil {
return nil, fmt.Errorf("redshift conn error : (%v)", err)
}
if err = db.Ping(); err != nil {
return nil, fmt.Errorf("redshift ping error : (%v)", err)
return db, nil
字符串
1条答案
按热度按时间du7egjpx1#
字符串