# fyzdb

**Repository Path**: zibianqu/fyzdb

## Basic Information

- **Project Name**: fyzdb
- **Description**: go 链式调用
- **Primary Language**: Go
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-11-21
- **Last Updated**: 2025-08-31

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## 自用
### 类似laravel的查询构造器

- 简单示例
查询新增修改可以使用map和sturct
事务的支持，需要在操作的时候添加上sessionId

```

config := dsn.MysqlCfg()
	config.SetDsn("root:root@tcp(127.0.0.1:3306)/fyzdb?charset=utf8mb4&parseTime=true")
	mysqlConn := mysql.Mysql()
	mysqlConn.InitDB(config)
	db := mysqlConn.GetDb()
	defer func() {
		_ = db.Close()
	}()
	/* session := fyzdb.Seesion().BeginTrans()
	sessionId := session.GetSessionId()
	a := fyzdb.Table("sys_user").SetSessionId(sessionId).Where("UserId", 100076893570827317).
		Update(map[string]string{"Nickname": "Lua2"})

	b := fyzdb.Table("sys_user").SetSessionId(sessionId).Where("UserId", 100289599130712766).
		Update(map[string]string{"Nickname": "sona1"})
	session.Commit()
	fmt.Println(a, b) */
	save := make(map[string]any)
	save["PostsId"] = 7222247067349942272
	save["UserId"] = 7221376778797842432
	save["Title"] = "ddfd"
	save["Cover"] = ""
	save["Type"] = 1
	save["Images"] = ""
	save["Content"] = "aaaaaaaaaa"
	a, _ := json.Marshal(map[string]string{"Cover": "", "Video": ""})
	save["Video"] = a
	save["Audio"] = ""
	save["Ctime"] = time.Now().Unix()
	save["Mtime"] = time.Now().Unix()
	rs, _ := fyzdb.Table("user_posts").Insert(save)
	fmt.Println(rs)
    rs1 := fyzdb.Table("user_posts").Where("PostsId", 7222247067349942271).Get()
	fmt.Println(rs1)

	// 也支持结构体进行获取和插入
	type postsData{
		PostsId int64
		Title string
	}
	list:=make([]*postsData, 0)
	fyzdb.Table("user_posts").Where("UserId", 7222247067349942271).Get(&list)
	postsInfo:=new(postsData)
	fyzdb.Table("user_posts").Where("PostsId", 7222247067349942271).first(&postsInfo)



    ```