github.com/insionng/yougam@v0.0.0-20170714101924-2bc18d833463/libraries/go-xorm/xorm/examples/find.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  	"os"
     6  	"time"
     7  
     8  	"github.com/insionng/yougam/libraries/xorm"
     9  )
    10  
    11  type User struct {
    12  	Id      int64
    13  	Name    string
    14  	Created time.Time `xorm:"created"`
    15  	Updated time.Time `xorm:"updated"`
    16  }
    17  
    18  func main() {
    19  	f := "conversion.db"
    20  	os.Remove(f)
    21  
    22  	Orm, err := xorm.NewEngine("sqlite3", f)
    23  	if err != nil {
    24  		fmt.Println(err)
    25  		return
    26  	}
    27  	Orm.ShowSQL(true)
    28  
    29  	err = Orm.CreateTables(&User{})
    30  	if err != nil {
    31  		fmt.Println(err)
    32  		return
    33  	}
    34  
    35  	_, err = Orm.Insert(&User{Id: 1, Name: "xlw"})
    36  	if err != nil {
    37  		fmt.Println(err)
    38  		return
    39  	}
    40  
    41  	users := make([]User, 0)
    42  	err = Orm.Find(&users)
    43  	if err != nil {
    44  		fmt.Println(err)
    45  		return
    46  	}
    47  
    48  	fmt.Println(users)
    49  }