Example #1
0
func mustMysqlGetTableFieldTypeList(TableName string) (out []MysqlField) {
	fieldRowList := MustQuery(`SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?`, GetDefaultDbConfig().DbName, TableName)
	for _, row := range fieldRowList {
		field := MysqlFieldType{}
		field.DataType = MysqlDataType(row["DATA_TYPE"])
		field.Default = row["COLUMN_DEFAULT"]
		switch field.DataType {
		case MysqlDataTypeVarchar:
			field.CharacterSetName = row["CHARACTER_SET_NAME"]
			field.CollationName = row["COLLATION_NAME"]
			field.StringLength = kmgStrconv.AtoIDefault0(row["CHARACTER_MAXIMUM_LENGTH"])
		case MysqlDataTypeLongText:
			field.CharacterSetName = row["CHARACTER_SET_NAME"]
			field.CollationName = row["COLLATION_NAME"]
		case MysqlDataTypeInt32, MysqlDataTypeInt8:
			field.IsUnsigned = strings.Contains(row["COLUMN_TYPE"], "unsigned")
			field.IsAutoIncrement = strings.Contains(row["EXTRA"], "auto_increment")
		case MysqlDataTypeDateTime, MysqlDataTypeFloat, MysqlDataTypeLongBlob:
		default:
			panic(fmt.Errorf("TODO implement MysqlDataType %s", field.DataType))
		}
		out = append(out, MysqlField{
			Name: row["COLUMN_NAME"],
			Type: field,
		})
	}
	return out
}
Example #2
0
func GetFirstIntFromRowList(rowList []map[string]string) int {
	if len(rowList) == 0 {
		return 0
	}
	for _, val := range rowList[0] {
		return kmgStrconv.AtoIDefault0(val)
	}
	return 0
}
Example #3
0
func cpu(output string) (used float64, numOfCore int) {
	o := strings.Split(output, "\n")
	o0 := strings.TrimSuffix(o[0], " CPU)")
	ol0 := strings.Split(o0, "(")
	numOfCore = kmgStrconv.AtoIDefault0(ol0[len(ol0)-1])
	o1 := strings.Split(o[3], " ")
	_used := kmgStrconv.ParseFloat64Default0(o1[len(o1)-1])
	used = (float64(100) - _used) / float64(100)
	used = kmgMath.Float64RoundToRelativePrec(used, 4)
	return
}
Example #4
0
func memory(output string) (used float64, total int) {
	o := strings.Split(output, "\n")
	o0 := strings.TrimPrefix(o[2], "-/+ buffers/cache:")
	o1 := strings.Split(o0, " ")
	usedByte := 0
	free := 0
	for _, s := range o1 {
		if s == "" {
			continue
		}
		if usedByte == 0 {
			usedByte = kmgStrconv.AtoIDefault0(s)
			continue
		}
		free = kmgStrconv.AtoIDefault0(s)
		break
	}
	total = usedByte + free
	used = float64(usedByte) / float64(total)
	used = kmgMath.Float64RoundToRelativePrec(used, 4)
	return
}
Example #5
0
func networkRXTX(output string) (rx int, tx int) {
	al := strings.Split(output, "\n")
	sl := ""
	for _, v := range al {
		v = strings.TrimSpace(v)
		v = strings.TrimPrefix(v, "\t")
		if strings.HasPrefix(v, "RX bytes") {
			sl = v
			break
		}
	}
	l := strings.Split(sl, "  ")
	_l := []string{}
	for _, s := range l {
		if s == "" || s == "\t" {
			continue
		}
		_l = append(_l, s)
	}
	rx = kmgStrconv.AtoIDefault0(strings.TrimPrefix(strings.TrimSuffix(strings.Split(_l[0], "(")[0], " "), "RX bytes:"))
	tx = kmgStrconv.AtoIDefault0(strings.TrimPrefix(strings.TrimSuffix(strings.Split(_l[1], "(")[0], " "), "TX bytes:"))
	return
}
Example #6
0
//psOutput 样例
// 1234 /bin/hi -l :1024
//12345 /bin/world -n test
func Extract(psOutput string) []*Process {
	lines := strings.Split(psOutput, "\n")
	out := []*Process{}
	for _, l := range lines {
		ls := strings.Fields(l)
		if len(ls) == 0 {
			continue
		}
		p := &Process{
			Id:      kmgStrconv.AtoIDefault0(ls[0]),
			Command: strings.Join(ls[1:], " "),
		}
		p.StartCmd = "setsid " + p.Command
		out = append(out, p)
	}
	return out
}
Example #7
0
func ikeUserCount(output string) int {
	lines := strings.Split(output, "\n")
	c := ""
	if !strings.Contains(output, "IKE_SAs") {
		return 0
	}
	for _, line := range lines {
		if strings.HasPrefix(line, "IKE_SAs") {
			_line := strings.Split(line, "total")
			c = _line[0]
			c = strings.Trim(c, "IKE_SAs:")
			c = strings.TrimSpace(c)
			break
		}
	}
	return kmgStrconv.AtoIDefault0(c)
}
Example #8
0
func (t1 MysqlFieldType) String() string {
	out := string(t1.DataType)
	if t1.StringLength != 0 {
		out += "(" + strconv.Itoa(t1.StringLength) + ")"
	}
	if t1.IsUnsigned {
		out += " unsigned"
	}
	if t1.IsAutoIncrement {
		out += " auto_increment"
	}
	if t1.CollationName != "" {
		out += " COLLATE " + t1.CollationName
	}
	switch t1.DataType {
	case MysqlDataTypeInt32, MysqlDataTypeInt8, MysqlDataTypeFloat:
		out += " DEFAULT " + strconv.Itoa(kmgStrconv.AtoIDefault0(t1.Default))
	case MysqlDataTypeVarchar, MysqlDataTypeDateTime:
		out += " DEFAULT " + fmt.Sprintf("%#v", t1.Default) //TODO 正确的序列化方式
	}
	return out
}
Example #9
0
func disk(output string) (used float64, total int) {
	o := strings.Split(output, "\n")
	o0 := strings.Split(o[1], " ")
	after := 0
	for i, s := range o0 {
		if i == 0 {
			continue
		}
		if s == "" {
			continue
		}
		if total == 0 {
			total = kmgStrconv.AtoIDefault0(s)
			continue
		}
		after++
		if after == 3 {
			p := kmgStrconv.ParseFloat64Default0(strings.TrimSuffix(s, "%"))
			used = kmgMath.Float64RoundToRelativePrec(p/float64(100), 4)
			break
		}
	}
	return
}
Example #10
0
func networkConnection(output string) (connectionCount int) {
	output = strings.TrimSpace(output)
	return kmgStrconv.AtoIDefault0(output)
}