alembic_utils_postgresql_view_definition_for_autogenerate.py

1from alembic_utils.pg_view import PGView
2from sqlalchemy import Column, Integer, String, MetaData, Table
3
4metadata = MetaData()
5
6# Define a table
7users = Table(
8    "users",
9    metadata,
10    Column("id", Integer, primary_key=True),
11    Column("name", String),
12)
13
14# Define a View using alembic-utils
15# This view will be automatically detected by 'alembic revision --autogenerate'
16# if registered in your env.py
17user_view = PGView(
18    schema="public",
19    signature="user_names",
20    definition="SELECT name FROM users"
21)
22
23# To use this in an Alembic environment, you would typically 
24# include 'user_view' in the target_metadata or a list of entities 
25# passed to the alembic-utils functions in your env.py.