示例#1
0
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
}
示例#2
0
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
}