func clearDb(dbName string, swarm *swarm.Swarm) error {
cmd := []string{}
cmd = append(cmd, "mysql")
cmd = append(cmd, "-u"+"cup_dba")
cmd = append(cmd, "-p"+"111111")
cmd = append(cmd, "-S"+"/DBAASDAT/upsql.sock")
cmd = append(cmd, "-e drop database qjrtest1")
res, err := swarm.Exec(cmd, dbName)
if err != nil {
log.WithFields(log.Fields{
"DbName": dbName,
"err": err.Error(),
}).Error("drop qjrtest1 fail")
return err
}
res.Close()
cmd = []string{}
cmd = append(cmd, "mysql")
cmd = append(cmd, "-u"+"cup_dba")
cmd = append(cmd, "-p"+"111111")
cmd = append(cmd, "-S"+"/DBAASDAT/upsql.sock")
cmd = append(cmd, "-e drop database qjrtest2")
res1, err := swarm.Exec(cmd, dbName)
if err != nil {
log.WithFields(log.Fields{
"DbName": dbName,
"err": err.Error(),
}).Error("drop qjrtest2 fail")
return err
}
res1.Close()
return nil
}
func createDb(dbName, dbString string, swarm *swarm.Swarm) error {
cmd := []string{}
cmd = append(cmd, "mysql")
cmd = append(cmd, "-u"+"cup_dba")
cmd = append(cmd, "-p"+"111111")
cmd = append(cmd, "-S"+"/DBAASDAT/upsql.sock")
cmd = append(cmd, "-e create database "+dbString)
res, err := swarm.Exec(cmd, dbName)
if err != nil {
log.WithFields(log.Fields{
"DbName": dbName,
"err": err.Error(),
"Database": dbString,
}).Error("create test database fail")
return err
}
res.Close()
return nil
}