示例1：使用URL进行配置

您可以使用Streamlit的Secrets management来配置您的SQL连接。以下示例指定了一个SQL连接URL。

.streamlit/secrets.toml:

[connections.sql]
url = "xxx+xxx://xxx:xxx@xxx:xxx/xxx"

您的应用程序代码：

import streamlit as st

conn = st.connection("sql")
df = conn.query("SELECT * FROM pet_owners")
st.dataframe(df)

示例2：使用方言、主机和用户名的配置

如果不指定url，则必须至少指定dialect、host和username。以下示例还包括password。

.streamlit/secrets.toml:

[connections.sql]
dialect = "xxx"
host = "xxx"
username = "xxx"
password = "xxx"

您的应用程序代码：

import streamlit as st

conn = st.connection("sql")
df = conn.query("SELECT * FROM pet_owners")
st.dataframe(df)

示例 3：使用关键字参数进行配置

您可以使用关键字参数（带或不带secrets.toml）配置您的SQL连接。例如，如果您将Microsoft Entra ID与Microsoft Azure SQL服务器一起使用，您可以使用交互式身份验证快速设置本地连接以进行开发。

此示例需要Microsoft ODBC Driver for SQL Server以及Python的sqlalchemy和pyodbc包。

import streamlit as st

conn = st.connection(
    "sql",
    dialect="mssql",
    driver="pyodbc",
    host="xxx.database.windows.net",
    database="xxx",
    username="xxx",
    query={
        "driver": "ODBC Driver 18 for SQL Server",
        "authentication": "ActiveDirectoryInteractive",
        "encrypt": "yes",
    },
)

df = conn.query("SELECT * FROM pet_owners")
st.dataframe(df)

import streamlit as st

conn = st.connection("sql")
df = conn.query(
    "SELECT * FROM pet_owners WHERE owner = :owner",
    ttl=3600,
    params={"owner": "barbara"},
)
st.dataframe(df)

import streamlit as st

conn = st.connection("my_conn")

# Reset the connection before using it if it isn't healthy
# Note: is_healthy() isn't a real method and is just shown for example here.
if not conn.is_healthy():
    conn.reset()

# Do stuff with conn...

import streamlit as st
conn = st.connection("sql")
n = st.slider("Pick a number")
if st.button("Add the number!"):
    with conn.session as session:
        session.execute("INSERT INTO numbers (val) VALUES (:n);", {"n": n})
        session.commit()