cc_test/log.go

package main

import "fmt"

// logType: 0提交URL，1URL成功，2URL失败，3提交实验账号
func f_log_db(uid int, logType int, adminMsg string) bool {
	tx, err := db.Begin()
	if err != nil {
		fmt.Printf("logdb_error begin: %s\n", err)
		return false
	}
	result, err := tx.Exec("call add_log(?,?,?)", uid, logType, adminMsg)
	if err != nil {
		fmt.Printf("logdb_error exec: %s\n", err)
		return false
	}
	err = tx.Commit()
	if err != nil {
		fmt.Printf("logdb_error commit: %s\n", err)
		err = tx.Rollback()
		if err != nil {
			fmt.Printf("logdb_error rollback: %s\n", err)
		}
		return false
	}
	row, err := result.RowsAffected()
	if err != nil {
		fmt.Println("logdb_error getrows: %s\n", err)
		return false
	}
	if row == 0 {
		// 没有插入数据
		fmt.Println("logdb_error row0: %s\n", err)
		return false
	}
	return true
}