func CreateUser() error {
var (
uid int = 1
username string = "HJin"
createTS int64 = time.Now().Unix()
)
pwd := ""
privilege := 0xFFFF
db, err := da.Connect()
if err != nil {
return err
}
insertStmt, err := db.Prepare(insertSQL)
if err != nil {
log.Println("insert")
return err
}
defer insertStmt.Close()
db.Exec("delete from " + targetTableName)
_, err = insertStmt.Exec(uid, username, user.Hash(pwd), privilege, createTS)
if err != nil {
return err
}
return nil
}
func importUsers() error {
db, err := da.Connect()
if err != nil {
return err
}
readStmt, err := db.Prepare(readSQL)
if err != nil {
log.Println("read")
return err
}
defer readStmt.Close()
insertStmt, err := db.Prepare(insertSQL)
if err != nil {
log.Println("insert")
return err
}
defer insertStmt.Close()
db.Exec("delete from " + targetTableName)
rows, err := readStmt.Query()
if err != nil {
return err
}
for rows.Next() {
var (
uid int
username string
createTS int64
)
err := rows.Scan(&uid, &username, &createTS)
if err != nil {
return err
}
pwd := ""
privilege := 0xFFFF
_, err = insertStmt.Exec(uid, username, user.Hash(pwd), privilege, createTS)
if err != nil {
return err
}
}
return nil
}