DEV Community: Manish

Answer: VSCode "go to definition" not working

Manish — Thu, 08 Feb 2024 07:00:46 +0000

Apr 23 '22

106

I had a the same issue: F12 and Ctrl + Click and Right Click "Go To Definition" wasn't working The fix for me was:

Go to Extensions
Click "Disable All Installed Extensions"
Close and Reopen VS Code
Back to Extensions and "Enable All Extensions"

Essentially enable/disable all extensions fixed the…

Open Full Answer

Answer: Limit the number of records via join if their id matches in SQLAlchemy 2.x

Manish — Sat, 13 Jan 2024 08:33:42 +0000

Aug 14 '23

looks like I did it (Probably not optimally). Here's my solution:

async def get_topics(session: AsyncSession, limit: int, continue_after: int)
    subquery = (
        select(
            QuizTopic.id,
            Quiz.id.label("quiz_id"),
            func.row_number().over(partition_by=QuizTopic.id, order_by=Quiz.id).label("row_num")
        )
        .join(Quiz, Quiz.topic_id == QuizTopic.id)
        .subquery()
    )

    smt = (
        select(QuizTopic)
        .join(QuizTopic.quizzes_info)
        .join(subquery, subquery.c.quiz_id == Quiz.id)
        .where(subquery.c.row_num <= 3)
        .order_by(QuizTopic.id)
        .offset(continue_after).limit(limit)
        .options(
            load_only(QuizTopic.id,

…

Open Full Answer

Answer: How to use an existing sqlalchemy Enum in an Alembic migration (Postgres)

Manish — Sat, 30 Dec 2023 10:23:36 +0000

Feb 11 '21

There are two parts to make this happen with Postgres.

Specify create_type=False
Use sqlalchemy.dialects.postgresql.ENUM (not sqlalchemy.Enum)

Eg:

from sqlalchemy.dialects import postgresql

sa.Column('my_column', postgresql.ENUM(name='my_enum', create_type=False))

Open Full Answer