How to properly use UUID for making quries with SQLAlchemy

Question

How to properly use UUID for making quries with SQLAlchemy

to not get error from postgres like "cannot cast type record to uuid"

I have Cards Repository, that has delete method, which uses squence of uuid, if uuid in that sequnce they must be deleted from db.

method:
`def delete(self, cardsids: Sequence[UUID5]) -> Sequence[UUID5]:
stmt = (
delete(Card)
.where(Card.id.in_([cardsids]))
.returning(Card.id)
)

with self.ss.begin():
return self.ss.execute(stmt) # type:ignore`

Then I am trying to delete values:
`Cards.delete(
cardsids=(
UUID("ffbbd142-c9bf-4c66-8b9d-6ebc4806a8cc"),
UUID("5cce0583-f506-4d0b-8fa9-f5604dfddde6"),
)
)`

but unfortunately get error from postgres:
`sqlalchemy.exc.ProgrammingError: (psycopg2.errors.CannotCoerce) cannot cast type record to uuid
LINE 1: ...6ebc4806a8cc', '5cce0583f5064d0b8fa9f5604dfddde6')::UUID) RE...
^

[SQL: DELETE FROM cards WHERE cards.id IN (%(id_1_1)s::UUID) RETURNING cards.id]
[parameters: {'id_1_1': ('ffbbd142c9bf4c668b9d6ebc4806a8cc', '5cce0583f5064d0b8fa9f5604dfddde6')}]`

As you can see SQLAlchemy have made syntax erros for casting simlpe string to uuid.
So instead of:
LINE 1: ...6ebc4806a8cc', '5cce0583f5064d0b8fa9f5604dfddde6')::UUID) RE...
As I think must be::
`LINE 1: ...6ebc4806a8cc':UUID, '5cce0583f5064d0b8fa9f5604dfddde6':UUID)) RE...

Model and his types:
`class Card(BaseModel):
tablename = "cards"

id: Mapped[pkuuid4]
user_id: Mapped[pkuuid4]
origin: Mapped[str64]
interpretation: Mapped[str512]
example: Mapped[str512]
curtt: Mapped[timestamp]
nextt: Mapped[timestamp]
last_rotate: Mapped[numeric]

str64 = Annotated[str, mapped_column(String(64))]
str512 = Annotated[str, mapped_column(String(512))]

pkuuid4 = Annotated[UUID, mapped_column(Uuid(as_uuid=True), primary_key=True)]

numeric = Annotated[
float, mapped_column(Numeric(precision=4, scale=2, asdecimal=False))
]

timestamp = Annotated[datetime, mapped_column(DateTime(timezone=True))]`

**So I assume that i'm passing incorrectly UUID to SQlAlchemy statment in body part of delete method in Cards repository. Perhaps somone knows how correctky use python UUID to make queries?

P.S. I tried to pass uuids as string as it was, instead of pasing them to uuid.UUID() but with just strings i have the same error**

0

20.11.2023

5 ответов

87 просмотров

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽 Автор вопроса

https://github.com/sqlalchemy/sqlalchemy/discussions/10666

0

12 месяцев назад

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽 Автор вопроса

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽
https://github.com/sqlalchemy/sqlalchemy/discussio...

Какой я нахуй слепой даун

0

12 месяцев назад

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽 Автор вопроса

kai 3341
Ох, такая мелочь, а сколько часов дебага стоила? К...

2 часа.

0

12 месяцев назад

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽 Автор вопроса

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽
2 часа.

Просто оставил зайвые [], и сижу с мудрым лицом, думаю как же решить эту проблему, "это же не моя, это же проблема в сукулеалхимии, я же не могу быть слепым"

0

12 месяцев назад

kai 3341 · Accepted Answer

kai 3341

⛧🇮🇱 Shennaz Martinez 🇺🇸🗽
Какой я нахуй слепой даун

Ох, такая мелочь, а сколько часов дебага стоила? Кстати, а почему mypy не ругнулся? Хотя формально он получил Sequence[Any] и на том его полномочия по идее всё

0

12 месяцев назад

Похожие чаты

How to properly use UUID for making quries with SQLAlchemy

5 ответов

Похожие вопросы