# sqlite_server

**Repository Path**: nhniu/sqlite_server

## Basic Information

- **Project Name**: sqlite_server
- **Description**: sqlite_server
hatsusakana@gmail.com

一个sqlite的http封装

#添加用户
POST /api/add_user
session=60G8yAtO_a_8shfX&data={"username":"guest"}

#获得用户列表
POST /api/get_users
session=60G8yAtO_a_8shfX

#删除用户
POST /api/del_user
session=60G8yAtO_a_8shfX&data={"uid":2}

#修改密码
POST /api/change_pwd
session=60G8yAtO_a_8shfX&data={"password":"123456"}

#重置session
POST /api/reset_session
session=60G8yAtO_a_8shfX

#开关权限
POST /api/auth_switch
session=60G8yAtO_a_8shfX&data={"uid":1,"type":1,"flag":1}

#获得权限状态
POST /api/get
- **Primary Language**: C
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2021-07-07
- **Last Updated**: 2021-07-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# sqlite_server

#### 介绍
sqlite_server
hatsusakana@gmail.com

一个sqlite的http封装

#添加用户
POST /api/add_user
session=60G8yAtO_a_8shfX&data={"username":"guest"}

#获得用户列表
POST /api/get_users
session=60G8yAtO_a_8shfX

#删除用户
POST /api/del_user
session=60G8yAtO_a_8shfX&data={"uid":2}

#修改密码
POST /api/change_pwd
session=60G8yAtO_a_8shfX&data={"password":"123456"}

#重置session
POST /api/reset_session
session=60G8yAtO_a_8shfX

#开关权限
POST /api/auth_switch
session=60G8yAtO_a_8shfX&data={"uid":1,"type":1,"flag":1}

#获得权限状态
POST /api/get_auth
session=60G8yAtO_a_8shfX&data={"uid":1}

#创建数据库
POST /api/create_db
session=60G8yAtO_a_8shfX&data={"dbname":"testdb"}

#删除数据库
POST /api/drop_db
session=60G8yAtO_a_8shfX&data={"dbname":"testdb"}

#获得数据库列表
POST /api/get_dbs
session=60G8yAtO_a_8shfX

#创建数据表
POST /api/create_table
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1","columns":[
    {"name":"id",    "type":"int primary"},
    {"name":"user",  "type":"text"},
    {"name":"pwd",   "type":"text"},
    {"name":"level", "type":"int"},
    {"name":"money", "type":"double"}
]}

#删除数据表
POST /api/drop_table
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1"}

#获得数据表列表
POST /api/get_tables
session=60G8yAtO_a_8shfX&data={"dbname":"testdb"}

#插入数据
POST /api/insert
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1","data":{
    "user":"user1", "pwd":"123456", "level":1, "money":100.23
}}

session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1","data":[
    {"user":"user1", "pwd":"123456", "level":1, "money":100.23},
    {"user":"user2", "pwd":"123456", "level":2, "money":200.23},
    {"user":"user3", "pwd":"123456", "level":3, "money":300.23}
]}

#批量插入数据
POST /api/insert2
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1","data":[
    {"user":"user1", "pwd":"123456", "level":1, "money":100.23},
    {"user":"user2", "pwd":"123456", "level":2, "money":200.23},
    {"user":"user3", "pwd":"123456", "level":3, "money":300.23}
]}

#更新数据
POST /api/update
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","tablename":"table1",
    "map":{
        "sql":"id=? and user=? and pwd=? and level=?",
        "data":[{"value":null},{"value":1},{"value":23.6},{"value":"1234567890"}]
    },
    "set":{"user":"user1", "pwd":"123456", "level":1, "money":100.23}
}

#删除数据
POST /api/delete
session=60G8yAtO_a_8shfX&data=={"dbname":"testdb","tablename":"table1",
    "map":{
        "sql":"id=? and user=? and pwd=? and level=?",
        "data":[{"value":null},{"value":1},{"value":23.6},{"value":"1234567890"}]
    }
}

#查询数据
POST /api/select
session=60G8yAtO_a_8shfX&data=={"dbname":"testdb","tablename":"table1",
    "map":{
        "sql":"id=? and user=? and pwd=? and level=?",
        "data":[{"value":null},{"value":1},{"value":23.6},{"value":"1234567890"}]
    },
    "columns":"*","group":"*","order":"id asc","limit":"0,1"
}

#查询数据量
POST /api/count
session=60G8yAtO_a_8shfX&data=={"dbname":"testdb","tablename":"table1",
    "map":{
        "sql":"id=? and user=? and pwd=? and level=?",
        "data":[{"value":null},{"value":1},{"value":23.6},{"value":"1234567890"}]
    }
}

#表字段
POST /api/columns
session=60G8yAtO_a_8shfX&data=={"dbname":"testdb","tablename":"table1"}

#sql执行接口
POST /api/query
session=60G8yAtO_a_8shfX&data={"dbname":"testdb","sql":"..."}