【Sqlboys的福音】录入你的表结构，让Vanna.AI为你编写业务SQL

import pandas as pd
import mysql.connector
from vanna.rem服务器托管网ote import VannaDefault
vn = VannaDefault(model='yourModel', api_key='xxxx')
conn_details = {
  'host': '127.0.0.1',
  'user': 'admin',
  'password': '123456', 
  'database': 'test'
}

def run_sql(sql: str) -> 服务器托管网pd.DataFrame:
  conn = mysql.connector.connect(**conn_details)
  df = pd.read_sql(sql, conn)
  conn.close()
  return df

vn.run_sql = run_sql
vn.run_sql_is_set = True

from vanna.flask import VannaFlaskApp
app = VannaFlaskApp(vn)
app.run()