[Python] sql alchemy generates integer instead of int for sql lite

Python Sql Alchemy generates table with VARCHAR for sql lite instead of INTEGER so select for sql lite ordered by with alphabet number

Given City Table in Sql lite generated from sql alchemy:

class City(Base):
__tablename__ = "city"
id: Mapped[int] = mapped_column(Integer, primary_key=True, index=True)
city_name: Mapped[str] = mapped_column(String, index=True)


It generates:

Data:

15470 Paris
100567 Paris


Query:

select(City).where(City.city_name == city_name.upper()).order_by(City.id).limit(1)

SELECT city.id, city.city_name
FROM city
WHERE city.city_name = :city_name_1 ORDER BY city.id
LIMIT aram_1


returns city id with 100567 instead of 15470.

Do I need to provide example with sql insert as well?

Continue reading...