mirror of
https://github.com/sqlalchemy/sqlalchemy.git
synced 2026-05-08 18:00:23 -04:00
Mike Bayer
809c707c73
in 6f710b393a we committed tests using lowercase ``list`` with
indexed access. use only newer Python versions for this test.
Change-Id: Icba0ef1c6b0b8e66e2d2a6c5b7e9fe86ed81deec
23 lines
600 B
Python
23 lines
600 B
Python
# PYTHON_VERSION >= 3.10
|
|
|
|
import sqlalchemy as sa
|
|
|
|
Book = sa.table(
|
|
"book",
|
|
sa.column("id", sa.Integer),
|
|
sa.column("name", sa.String),
|
|
)
|
|
Book.append_column(sa.column("other"))
|
|
Book.corresponding_column(Book.c.id)
|
|
|
|
values = sa.values(
|
|
sa.column("id", sa.Integer), sa.column("name", sa.String), name="my_values"
|
|
)
|
|
value_expr = values.data([(1, "name1"), (2, "name2"), (3, "name3")])
|
|
|
|
data: list[tuple[int, str]] = [(1, "name1"), (2, "name2"), (3, "name3")]
|
|
value_expr2 = values.data(data)
|
|
|
|
sa.select(Book)
|
|
sa.select(sa.literal_column("42"), sa.column("foo")).select_from(sa.table("t"))
|