# cpc审核存储过程移植（python）

**Repository Path**: qwd1505/CPC-Audit-Migration

## Basic Information

- **Project Name**: cpc审核存储过程移植（python）
- **Description**: cpc审核Oracle存储过程移植到python，兼容Oracle、Doris。
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-09-18
- **Last Updated**: 2025-09-29

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# CPC审核Oracle存储过程移植到python，兼容Oracle、Doris

### 环境安装切换到项目目录

#### 本地

```bash
pip install fastapi pydantic oracledb pymysql uvicorn
# pip install --no-index --find-links=./wheels -r requirements.txt
```

### 修改配置

- 查看py/config.py文件，修改数据库配置

### 运行 （nohup ... &）

```bash
uvicorn py.api:app --reload --host 0.0.0.0 --port 8123
```

#### docker

```bash
docker run --privileged -it -v ${PWD}/config.py:/app/py/config.py -p 8123:8123   fastapi-cpc
docker run --privileged -it  -v /app1/docker_temp/fastapi/config.py:/app/py/config.py -p 8123:8123 fastapi-cpc
```

### 接口测试是否启动（Linux）

```bash
curl -X POST "http://10.2.12.209:8123/auto_check"  -H "Content-Type: application/json"  -d '{"exchange_id":"1WHDMT202311100446111536961708","id":"20250926-1092100","model_flag":"12C","user_name":"彭青龙","user_staff":"PENGQL"}'
curl -X POST "http://10.2.12.209:8123/auto_check"  -H "Content-Type: application/json"  -d '{"exchange_id":"1WHDMT202311100446111536961708","id":"20250928-1091092","model_flag":"12C","user_name":"彭青龙","user_staff":"PENGQL"}'
curl -X POST "http://10.2.12.209:8123/auto_check"  -H "Content-Type: application/json"  -d '{"exchange_id":"1WHDMT202311100446111536961708","id":"20250926-1092099","model_flag":"12C","user_name":"彭青龙","user_staff":"PENGQL"}'
```