package main

import (
	"fmt"
	"github.com/eatmoreapple/query"
	_ "github.com/go-sql-driver/mysql"
	"log"
)

func main() {
	db, err := query.Open("mysql", "root:qwe123@tcp(localhost:3306)/mysql")
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()

	fmt.Println(db.Query("SELECT 1").Int64()) // 1 
          

	fmt.Println(db.Query("SELECT 1").Bool()) // true 
          

	fmt.Println(db.Query("SELECT Host from user").StringSlice()) // [localhost localhost localhost] 
          

	var count int64
	fmt.Println(db.Query("SELECT COUNT(*) FROM user").Value(&count), count) // 
          
            3
          

	type User struct {
		Host string
		User string
	}

	var user User
	fmt.Println(db.Query("SELECT * FROM user LIMIT 1").Struct(&user), user) // 
          
            {localhost root}
          

	var user2 = new(User)
	fmt.Println(db.Query("SELECT * FROM user LIMIT 1").Struct(&user2), user2) // 
          
            &{localhost root}
          

	var users []User
	fmt.Println(db.Query("SELECT * FROM user").StructList(&users), users) // 
          
            [{localhost root} {localhost mysql.session} {localhost mysql.sys}]
          

	var users2 []*User
	fmt.Println(db.Query("SELECT * FROM user").StructList(&users2), users2) // 
          
            [0xc00013e040 0xc00013eb60 0xc00013f660]
          
}