# sqlm

**Repository Path**: wlhet/sqlm

## Basic Information

- **Project Name**: sqlm
- **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-02-11
- **Last Updated**: 2023-02-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### 使用示例

```
package main

import (
	"gitee.com/wlhet/sqlm"
)

type User struct {
	UId   int64  `sqlm:"id"`
	Names string `sqlm:"name"`
	Email string `sqlm:"email"`
	Phone string `sqlm:"phone"`
}

func main() {
	orcl := sqlm.NewOracle()
	orcl.Open("oracle://test:test@127.0.0.1:1521/test")

	//更新信息
    //sql  UPDATE   USERS  SET NAME = "test", EMAIL = "xxxxx@qq.com"  WHERE ID > 10086 
	orcl.Update("users", sqlm.Params{"name": "test", "email": "xxxxx@qq.com"}, sqlm.WhereCase{"id__eq": 10086})

	//删除信息
    //sql  DELETE FROM USERS WHERE ID > 10086 
	orcl.Delete("users",sqlm.WhereCase{"id__gt": 10086})

	//查询结果映射到结构体
	var v User
	orcl.GetOne("users", sqlm.WhereCase{"id__eq": 893}, &v)

	//查询多条数据映射到切片
	var vs []User
	orcl.GetMany("users", nil, &vs)
}

```