blob: 596f47795c41b7330a09c3f2819cb2e776990f74 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
from __future__ import annotations
from typing import Any
from typing import Dict
from sqlalchemy import Column
from sqlalchemy import insert
from sqlalchemy import select
from sqlalchemy.orm import DeclarativeBase
from sqlalchemy.orm import Mapped
from sqlalchemy.orm import mapped_column
class Base(DeclarativeBase):
pass
class User(Base):
__tablename__ = "user"
id: Mapped[int] = mapped_column(primary_key=True)
name: Mapped[str]
data: Mapped[str]
# test #9376
d1: dict[str, Any] = {}
stmt1 = insert(User).values(d1)
d2: Dict[str, Any] = {}
stmt2 = insert(User).values(d2)
d3: Dict[Column[str], Any] = {}
stmt3 = insert(User).values(d3)
stmt4 = insert(User).from_select(
[User.id, "name", User.__table__.c.data],
select(User.id, User.name, User.data),
)
|