main.go

/*
 *
 *
 *  * Copyright 2019 koalaone@163.com
 *  *
 *  * Licensed under the Apache License, Version 2.0 (the "License");
 *  * you may not use this file except in compliance with the License.
 *  * You may obtain a copy of the License at
 *  *
 *  *       http://www.apache.org/licenses/LICENSE-2.0
 *  *
 *  * Unless required by applicable law or agreed to in writing, software
 *  * distributed under the License is distributed on an "AS IS" BASIS,
 *  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  * See the License for the specific language governing permissions and
 *  * limitations under the License.
 *
 */

package main

import (
	"log"

	_ "github.com/go-sql-driver/mysql"
	"github.com/koalaone/model_auto/mysql"
	"github.com/koalaone/model_auto_example/model"
)

func main() {
	dbType := "mysql"
	dbConn := "root:password@tcp(127.0.0.1:3306)/test?charset=utf8mb4&parseTime=True"
	err := mysql.InitConnDB(dbType, dbConn)
	if err != nil {
		log.Println("InitConnDB error:" + err.Error())
		return
	}

	wheres := make(map[string]interface{})
	wheres["uid"] = "u_1234"
	locUser, err := model.GetUserByWheres(wheres)
	if err != nil {
		log.Println("GetUserByWheres error:" + err.Error())
		return
	}

	if locUser == nil {
		newUser := model.User{
			Uid:   "u_1234",
			Uname: "koalaone",
			Age:   22,
		}
		err = model.CreateUser(&newUser)
		if err != nil {
			log.Println("CreateUser error:" + err.Error())
			return
		}
	} else {
		updates := make(map[string]interface{})
		updates["uname"] = "koala"
		err = model.UpdateUser(wheres, updates)
		if err != nil {
			log.Println("UpdateUser error:" + err.Error())
			return
		}
	}

	wheres = make(map[string]interface{})
	wheres["uid"] = "u_1234"
	locUser, err = model.GetUserByWheres(wheres)
	if err != nil {
		log.Println("GetUserByWheres error:" + err.Error())
		return
	}

	log.Printf("user info:%#v", locUser)
}