Missing index after using tool

[TantumNTatari]

After using this tool to reflect a table in my database, the declarative model that was produced was missing an index. I was just wondering if anyone might know why this is the case:

The actual database, using the '\d+ users' command
Table "public.users"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-------------------+--------------------------+-----------+----------+-----------------------------------+----------+--------------+-------------
id | integer | | not null | nextval('users_id_seq'::regclass) | plain | |
email | text | | not null | | extended | |
password | bytea | | not null | | extended | |
Indexes:
"users_pkey" PRIMARY KEY, btree (id)
"users_email_unique_idx" UNIQUE, btree (lower(email))
"users_username_password_idx" btree (email, password)

However, the tool would only show the following:
Table "public.users"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-------------------+--------------------------+-----------+----------+-----------------------------------+----------+--------------+-------------
id | integer | | not null | nextval('users_id_seq'::regclass) | plain | |
email | text | | not null | | extended | |
password | bytea | | not null | | extended | |
Indexes:
"users_pkey" PRIMARY KEY, btree (id)
"users_username_password_idx" btree (email, password)

Thanks.

[agronholm]

Could you post the generated code? Which version did you use?

[agronholm]

Did you not get this warning at the top?

SAWarning: Skipped unsupported reflection of expression-based index users_email_unique_idx

[TantumNTatari]

I see it now... I deeply apologize for not examining this thoroughly enough. Thank you for your support. I will continue to figure out a solution for my problem.

[agronholm]

You just need to add it to __table_args__ manually. Nothing to it.

[soypedroamaya]

I see it now... I deeply apologize for not examining this thoroughly enough. Thank you for your support. I will continue to figure out a solution for my problem.

Hello, I was wondering how you solved this, I am having the same problem:

sqlacodegen/main.py:47: SAWarning: Skipped unsupported reflection of expression-based index users_instance_id_email_idx
metadata.reflect(engine, args.schema, not args.noviews, tables)

[agronholm]

If SQLAlchemy can't support some form of reflection, there's nothing that sqlacodegen can do. You'll have to add such indexes by hand to the generated code.