Code
Docs
https://prefecthq.github.io/prefect-sqlalchemy/
Example
Create table named customers and insert values.
from prefect import flow
from prefect_sqlalchemy import DatabaseCredentials, AsyncDriver
from prefect_sqlalchemy.database import sqlalchemy_execute
@flow
def sqlalchemy_execute_flow():
sqlalchemy_credentials = DatabaseCredentials(
driver=AsyncDriver.POSTGRESQL_ASYNCPG,
username="prefect",
password="prefect_password",
database="postgres",
)
sqlalchemy_execute(
"CREATE TABLE IF NOT EXISTS customers (name varchar, address varchar);",
sqlalchemy_credentials,
)
sqlalchemy_execute(
"INSERT INTO customers (name, address) VALUES (:name, :address);",
sqlalchemy_credentials,
params={"name": "Marvin", "address": "Highway 42"}
)
sqlalchemy_execute_flow()