File size: 489 Bytes
117b368
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
from docutils.frontend import read_config_file
from fastapi import Depends
from mysql.connector import connect
import json

def get_db_connection():
    config = read_config_file('config.json')
    db_config = config['database']
    connection = connect(
        host=db_config['host'],
        user=db_config['user'],
        password=db_config['password'],
        database=db_config['database']
    )
    # 开启自动提交模式
    connection.autocommit = True
    return connection