github.com/gogf/gf@v1.16.9/.example/database/gdb/sqlite/sqlite.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  
     6  	"github.com/gogf/gf/database/gdb"
     7  	"github.com/gogf/gf/frame/g"
     8  	_ "github.com/mattn/go-sqlite3"
     9  )
    10  
    11  func main() {
    12  	gdb.SetConfig(gdb.Config{
    13  		"default": gdb.ConfigGroup{
    14  			gdb.ConfigNode{
    15  				Name: "/tmp/my.db",
    16  				Type: "sqlite",
    17  			},
    18  		},
    19  	})
    20  	db := g.DB()
    21  	if db == nil {
    22  		panic("db create failed")
    23  	}
    24  
    25  	// 创建表
    26  	sql := `CREATE TABLE user (
    27         uid  INT PRIMARY KEY NOT NULL,
    28         name VARCHAR(30) NOT NULL
    29     );`
    30  	if _, err := db.Exec(sql); err != nil {
    31  		fmt.Println(err)
    32  	}
    33  
    34  	// 写入数据
    35  	result, err := db.Table("user").Data(g.Map{"uid": 1, "name": "john"}).Save()
    36  	if err == nil {
    37  		fmt.Println(result.RowsAffected())
    38  	} else {
    39  		fmt.Println(err)
    40  	}
    41  
    42  	// 删除表
    43  	sql = `DROP TABLE user;`
    44  	if _, err := db.Exec(sql); err != nil {
    45  		fmt.Println(err)
    46  	}
    47  }