# sqlx

**Repository Path**: wlhet/sqlx

## Basic Information

- **Project Name**: sqlx
- **Description**: No description available
- **Primary Language**: Go
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-03-17
- **Last Updated**: 2022-03-17

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## 简介

## 用法示例

```go
package main

import (
	"fmt"
	"sqlx"

	_ "github.com/go-sql-driver/mysql"
)

func main() {
    //初始化配置
    kConf := new(sqlx.KConfig)
    //初始化DB的配置
    dbConfig := new(sqlx.DBConfig)
    dbConfig.Driver = "mysql"
    dbConfig.Dsn = "root:123456@tcp(127.0.0.1:3306)/sqlx?charset=utf8&parseTime=true"
    dbConfig.IsMaster = true
    kConf.DBConfigList = []sqlx.DBConfig{*dbConfig}
    sqlx.RegisterDataBase(*kConf)
    
    //原生SQL查询
    sqlx.Select("select * from user where id = ?", 1).ToArray()
    //返回map[string][string] 
    sqlx.Select("select * from user where id = ?", 1).ToMap()
    //返回struct
    type user struct {
        Id int `db:"id;auto"`
        Name string `db:"name"`
    }
    var result []user
    sqlx.Select("select * from user").ToStruct(&result)
    fmt.Println("result:", result)
    
    //链式操作,返回单条数据
    sqlx.Table("user").Where("id", 1).First().ToArray()
    
    //支持指定库操作
    var u user
    sqlx.WithDB("mysql::master").Table("user").Where("id", 1).First().ToStruct(&u)
    
    //批量插入支持map方式和struct方式
    a1 := new(user)
    a1.Name = "张三"
    
    a2 := new(user)
    a2.Name = "李四"
    
    users := []user{*a1, *a2}
    sqlx.Table("user").MultiInsert(users)
}
```

### 查询数据
```go

//查询单条数据
//返回[]string
arr, err := sqlx.Table("user").Where("id", 1).First().ToArray()

//返回map[string][string
mp, err := sqlx.Table("user").Where("id", 1).First().ToMap()

type user struct {
    Id int `db:"id"`
    Name string `db:"name"`
}

//返回结构体
var result user
err := sqlx.Table("user").Where("id", 1).First().ToStruct(&result)


//查询多条数据
//返回[][]string
arr, err := sqlx.Table("user").Where("id", 1).Get().ToArray()

//返回[]map[string][string
mp, err := sqlx.Table("user").Where("id", 1).Get().ToMap()

type user struct {
    Id int `db:"id"`
    Name string `db:"name"`
}

//返回结构体
var result []user
err := sqlx.Table("user").Where("id", 1).Get().ToStruct(&result)

```

### 插入数据
```go

//通过结构体插入
type user struct {
	Id int `db:"id;auto"`   //tag中包含auto属性的时候，插入时会自动过滤
	Name string `db:"name"`
}

a1 := new(user)
a1.Name = "张三"

//插入单条
sqlx.Table("user").Insert(a1)

//插入多条
a1 := new(user)
a1.Name = "张三"

a2 := new(user)
a2.Name = "李四"
users := []user{*a1, *a2}
sqlx.Table("user").MultiInsert(users)

//通过map方式插入
user := make(map[string]string)
user["name"] = "张三"
sqlx.Table("user").Insert(user)

```


### 更新数据
```go

data := make(map[string]interface{})
data["name"] = "李四"

sqlx.Table("user").Where("id", 1).Update(data)

```

### 删除数据
```go
sqlx.Table("user").Where("id", 1).Delete()
```


### TODO
- [ ] grammar字符串拼接优化

- [ ] 使用对象池来优化new过多的问题

- [ ] 链式操作支持子查询