# chaos-python

**Repository Path**: hyperchaos/chaos-python

## Basic Information

- **Project Name**: chaos-python
- **Description**: No description available
- **Primary Language**: Python
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-11-25
- **Last Updated**: 2023-12-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

- mysql的使用
```
引入flask-SQLAlchemy和pymysql依赖
pip install flask_sqlalchemy
pip install pymysql
```
- flask_sqlalchemy查询使用
```
1、使用实体
result = SysUser.query.all()
for item in result:
    item.name
    
2、使用语句
sql = db.text('select * from chaos_sys_user')
result = db.session.execute(sql)
for item in  result:
    item.name
da.session.close()
```
- sqlalchemy事务
```
try:
    user = SysUser('', '')
    db.session.add(user)
    db.session.commit()
except Exception:
    db.session.rollback()
```