Problem with typing arrays.

[JoaquimEsteves]

Hello everyone,

Just found this wonderful library, however I'm facing an issue that I couldn't find an answer for in the docs.

I have a table that uses postgresql ARRAYs, sqlacodegen is perfectly capable of creating the right side of the model, but the types are wrong (partially unknown to be precise).

Anyone know a solution for this? I decided to open a discussion first instead of an issue since others might have already faces this.

CREATE TABLE FOO (
 id SERIAL PRIMARY KEY,
 some_ints INT[],
 some_floats FLOAT[]
);

class Foo(Base)
 #...etc
 # right side is perfect! The type however is partially known
 some_ints: Mapped[Optional[list]] = mapped_column(ARRAY(Integer()))

Saw that this codebase is looking for maintainers, so if PRs are welcome I could take a crack at it.

[sheinbergon]

@JoaquimEsteves
Are you getting the optional value generated with a lower case o?
Are you using latest version 3.0.0?
Please share the CLI comamnd you're running

[JoaquimEsteves]

@sheinbergon

Pip list shows that I'm using version 3.0.0. I generate the models with:

sqlacodegen postgresql://blablabla/my_db > tables.py

You're quite right that I had a typo on optional. The code correctly emits the Optional from the typing library. Wrote the whole thing on my phone since $WORK doesn't allow me to log into GitHub from the old corporate laptop.

[sheinbergon]

Ok, so this can be summed up with a generic type inference issue. I'm converting this to an issue

[sheinbergon]

@JoaquimEsteves I'm closing this discusson. I've opened #383

PRs are more than welcomed