# sql-builder

**Repository Path**: cppteam/sql-builder

## Basic Information

- **Project Name**: sql-builder
- **Description**: 可以更加轻松的写 sql,减少出错率。
- **Primary Language**: C++
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 3
- **Forks**: 0
- **Created**: 2017-08-17
- **Last Updated**: 2023-01-17

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 帮助简单的写 sql 语句。
        #demo 在 test 目录下。单元测试依赖 gtest

# 安装[Linux/Mac]
1.mkdir build
2.cd build
3.cmake ..
4.make
5.make install
#安装 [windows/Visual Studio]
1、CMake GUI配置VS 工程文件
2、VS打开右键生成 Debug、Release不同版本的静态库


# 使用

## 增
```
 InsertModel i;
    i.insert("score", 100)
            ("name", std::string("yu"))
            ("age", 28)
            ("address", nullptr)
            ("create_time", "2016-03-25 10:15:59")
    into("user");
 std::cout << i.str() << std::endl;
```

## 删
```
  DeleteModel d;
    d._delete()
            .from("user")
            .where(Column("id") == 1);
  std::cout << d << std::endl;
```

## 改
```
 updateModel.update("user")
            .set("name", "yu")
                    ("age", 18)
                    ("score", 50)
                    ("address", nullptr)
            .where(Column("id").in(a));
 std::cout << updateModel << std::endl;
```

## 查
```
 sql.select("id", "age", "name", "address")
            .from("user")
            .where(Column("score") > 60 and (Column("age") >= 20 or Column("address").is_not_null()))
            .group_by("age")
            .having(Column("age") > 10)
            .order_by("age desc")
            .limit(10)
            .offset(1);

    std::cout << sql << std::endl;
```