109 lines
3.0 KiB
Go
109 lines
3.0 KiB
Go
package jorm
|
||
|
||
import (
|
||
"fmt"
|
||
"testing"
|
||
)
|
||
|
||
type Contact struct {
|
||
UserId int `json:"user_id"`
|
||
Name string `json:"name" jorm:"real_name" xorm:"real_name"`
|
||
Age int `json:"age"`
|
||
PhoneNumber string `json:"phone_number"`
|
||
HomeAddress string `json:"home_address"`
|
||
CreateTime string `json:"create_time"`
|
||
}
|
||
|
||
func TestCallProcedure(t *testing.T) {
|
||
err := InitMySQL("jerry:Ming521.@tcp(jerry.igoogle.ink:3306)/db_test?charset=utf8")
|
||
//err := InitMySQL("developer:Iloveguiyu2018!@tcp(rm-uf6sl3y5zl5mku48jho.mysql.rds.aliyuncs.com:3306)/lock_test?charset=utf8")
|
||
if err != nil {
|
||
fmt.Println("err:", err)
|
||
}
|
||
//session := MySQL().NewSession()
|
||
//
|
||
//contact := new(Contact)
|
||
//columns := []string{"real_name", "age", "phone_number", "home_address"}
|
||
//
|
||
//_, err = session.Where("real_name = ?", "付明明").Cols(columns...).Get(contact)
|
||
//if err != nil {
|
||
// fmt.Println("err2:", err)
|
||
//} else {
|
||
// fmt.Println("contact:", *contact)
|
||
//}
|
||
//
|
||
//sql, i := session.LastSQL()
|
||
//log.Println("sql:", sql)
|
||
//log.Println("i:", i)
|
||
|
||
//poleLog := new(model.PoleLog)
|
||
//_, err = session.Table("pole_log").Where("plate_number = ?", "沪HZ5690").Desc("id").Get(poleLog)
|
||
//if err != nil {
|
||
// errorLog := new(model.ErrorLog)
|
||
// errorLog.Project = "测试项目"
|
||
// errorLog.Method = "TestCallProcedure"
|
||
// errorLog.Param = "sadfds"
|
||
// sql, value := session.LastSQL()
|
||
// errorLog.ErrorSql = fmt.Sprintf("%v : %v", sql, value)
|
||
// errorLog.ErrotMsg = err.Error()
|
||
// errorLog.CreateTime = time.Now()
|
||
// //写入数据库
|
||
// session.Table("error_log").InsertOne(errorLog)
|
||
//}
|
||
//log.Println("poleLog:", poleLog)
|
||
|
||
//log := new(model.PoleLog)
|
||
////_, err = MySQL().ID(172134).Get(log)
|
||
//_, err = MySQL().ID(14).Get(log)
|
||
//if err != nil {
|
||
// fmt.Println("err:", err)
|
||
//}
|
||
//
|
||
//if log.EndTime.IsZero() {
|
||
// fmt.Println("endtime: null")
|
||
//} else {
|
||
// fmt.Println("endtime:", log.EndTime)
|
||
//}
|
||
|
||
//result, err := CallProcedure("query_contact", 1, 6).InParams("付明明").Query()
|
||
//if err != nil {
|
||
// fmt.Println("err:", err)
|
||
//}
|
||
//for _, v := range result {
|
||
// fmt.Println(v)
|
||
//}
|
||
|
||
contact := new(Contact)
|
||
has, err := CallProcedure("query_contact", 1, 6).InParams("付明明").Get(contact)
|
||
if err != nil {
|
||
fmt.Println("err:", err)
|
||
}
|
||
if has {
|
||
fmt.Println("contact:", *contact)
|
||
} else {
|
||
fmt.Println("没有查到需要的数据")
|
||
}
|
||
|
||
//contactList := make([]Contact, 0)
|
||
//err = CallProcedure("query_contact", 1, 6).InParams("付明明").Find(&contactList)
|
||
//if err != nil {
|
||
// fmt.Println("err:", err)
|
||
//}
|
||
//fmt.Println("contactList:", contactList)
|
||
}
|
||
|
||
//func TestDbSearch(t *testing.T) {
|
||
// err := InitMySQL("root:password@tcp(rm-uf6sl3y5zl5mku48jho.mysql.rds.aliyuncs.com:3306)/lock_test?charset=utf8")
|
||
// if err != nil {
|
||
// fmt.Println("err:", err)
|
||
// }
|
||
//
|
||
// poleLogList := make([]model.PoleLog, 0)
|
||
// err = MySQL().Where("plate_number = ?", "苏E6PS87").And("start_time < ?", "2019-02-14 13:31:44").And("pay_status = 0 or status = 'IN'").Find(&poleLogList)
|
||
// if len(poleLogList) > 0 {
|
||
// for _, v := range poleLogList {
|
||
// log.Println("VVV：", v)
|
||
// }
|
||
// }
|
||
//}
|