sqlalchemy/sqlalchemy2-stubs issues and pull requests

#265 - Cannot infer the type depending on the `Base` generate method.

Issue - State: closed - Opened by barking-code 5 months ago - 5 comments
Labels: mypy

#264 - Incompatible types in assignment when base declaration is in a separate file

Issue - State: open - Opened by Stacey-Valon 11 months ago - 7 comments
Labels: bug, mypy plugin

#263 - Add ColumnOperators.hash (fixes #262)

Pull Request - State: closed - Opened by mrcljx 11 months ago - 2 comments

#262 - Pyright: Mapped is considered unhashable

Issue - State: closed - Opened by mrcljx 11 months ago
Labels: bug

#261 - TypeError: format_type() missing 1 required positional argument: 'options'

Issue - State: closed - Opened by mgdelmonte 11 months ago - 1 comment
Labels: bug, duplicate

#260 - Restore default for column_valued name parameter

Pull Request - State: closed - Opened by andersk about 1 year ago - 2 comments

#259 - [0.0.2a36 regression] `.column_valued()` without a `name` is no longer accepted

Issue - State: closed - Opened by andersk about 1 year ago
Labels: bug

#258 - Fixes: #257 Add joins_implicitly as arg to column_valued()

Pull Request - State: closed - Opened by joshvoigts about 1 year ago

#257 - Type checking fails when using `joins_implicitly` with `column_valued()`

Issue - State: closed - Opened by joshvoigts about 1 year ago - 1 comment

#256 - ext/mutable/MutableBase: fix coerce type

Pull Request - State: closed - Opened by huwcbjones over 1 year ago - 1 comment

#255 - MutableBase.coerce incorrectly returns None

Issue - State: closed - Opened by huwcbjones over 1 year ago - 1 comment
Labels: bug, help wanted

#254 - Cannot access "sqlalchemy.orm.mapped_column"

Issue - State: closed - Opened by star0202 over 1 year ago - 1 comment

#253 - open up Mapped.set for mypy 1.2

Pull Request - State: closed - Opened by zzzeek over 1 year ago

#252 - get last 1.4 version not v2

Pull Request - State: closed - Opened by CaselIT over 1 year ago

#251 - Fix `RowMapping.getitem` to reflect that it supports `Column`s or strings

Pull Request - State: closed - Opened by rouge8 over 1 year ago - 3 comments

#250 - pre-commit config generates 100s of errors

Issue - State: closed - Opened by zzzeek almost 2 years ago - 1 comment
Labels: bug

#249 - attempt to fix foundational issue in stubs

Pull Request - State: closed - Opened by zzzeek almost 2 years ago - 4 comments

#247 - Cannot access member "add" for type "AsyncSession" (pylance) SQLAlchemy 1.4

Issue - State: open - Opened by jacksbox almost 2 years ago - 2 comments
Labels: bug, PRs welcome

#246 - fix Insert.on_conflict_do_nothing return type

Pull Request - State: closed - Opened by IzeBerg almost 2 years ago - 1 comment

#245 - Allow with_variant to take TypeEngine instance as well as the TypeEngine type directly like Column

Pull Request - State: closed - Opened by tapetersen almost 2 years ago - 2 comments

#244 - TypeEngine.with_variant should accept TypeEngine for type argument instances as well as Type[TypeEngine]

Issue - State: closed - Opened by tapetersen almost 2 years ago - 1 comment
Labels: bug

#243 - Incomplete typing for Engine.dispose's close parameter

Issue - State: open - Opened by satyanash almost 2 years ago - 1 comment
Labels: bug, help wanted

#242 - Invalid base class "Base" when returned by a function

Issue - State: closed - Opened by iskyd almost 2 years ago - 9 comments
Labels: bug, expected behavior

#241 - Error importing plugin "sqlalchemy.ext.mypy.plugin": cannot import name 'Optional' from 'mypy.plugin'

Issue - State: closed - Opened by iskyd almost 2 years ago - 1 comment

#240 - Type error when attempting to use a Literal[True] with sa.and_()

Issue - State: open - Opened by gandhis1 about 2 years ago - 1 comment
Labels: bug

#239 - Using compiles leads to untyped decorator

Issue - State: open - Opened by kasium about 2 years ago - 1 comment
Labels: bug, missing type

#238 - AsyncSession: correct (stream_)scalars arg name

Pull Request - State: closed - Opened by mjpieters about 2 years ago - 2 comments

#237 - Fix memoizedhascache

Pull Request - State: closed - Opened by mehdigmira about 2 years ago - 12 comments

#236 - MemoizedHasCacheKey import path is wrong

Issue - State: closed - Opened by mehdigmira about 2 years ago
Labels: bug

#235 - Make Column and relationship inherit from Mapped

Issue - State: open - Opened by mehdigmira about 2 years ago - 5 comments
Labels: bug, missing type

#234 - TupleType missing from sqlalchemy/types.pyi

Issue - State: closed - Opened by peterschutt about 2 years ago

#233 - Update types.pyi

Pull Request - State: closed - Opened by peterschutt about 2 years ago - 2 comments

#232 - fix declarative_mixin stub

Pull Request - State: closed - Opened by mehdigmira about 2 years ago - 2 comments

#231 - Improve declarative_mixin stub

Issue - State: closed - Opened by mehdigmira about 2 years ago

#230 - Incorrect keyword argument name 'parameters' for AsyncSession.scalars, AsyncEngine.scalars

Issue - State: closed - Opened by mjpieters about 2 years ago - 1 comment
Labels: bug

#229 - Confused on Stubs providing type hints for Table constructor

Issue - State: open - Opened by afreemanio about 2 years ago - 1 comment
Labels: question

#228 - Incompatible type in `values`

Issue - State: open - Opened by mdczaplicki about 2 years ago - 1 comment
Labels: bug

#227 - Conda Forge

Issue - State: closed - Opened by thewchan about 2 years ago - 4 comments
Labels: use case

#226 - improve type of dynamic

Pull Request - State: closed - Opened by CaselIT about 2 years ago

#225 - Re-using sqlalchemy.dialects.postgresql.UUID instance generates mypy violation

Issue - State: open - Opened by mtvx about 2 years ago - 1 comment
Labels: bug, mypy plugin

#224 - "method" of "AppenderQuery" does not return a value

Issue - State: closed - Opened by CrafterSvK about 2 years ago
Labels: bug

#223 - Make the `SQLAlchemy` type hint work better in `Pycharm`.

Pull Request - State: closed - Opened by amisadmin over 2 years ago - 2 comments

#222 - Fix variable name error

Pull Request - State: closed - Opened by amisadmin over 2 years ago - 2 comments

#221 - Fixed typing error in `session.get`.

Pull Request - State: closed - Opened by amisadmin over 2 years ago - 4 comments

#220 - Add keyword arguments for `AsyncSession.connection`

Pull Request - State: closed - Opened by chrisguidry over 2 years ago - 1 comment

#219 - INTERNAL ERROR triggered by broken typing

Issue - State: open - Opened by aberres over 2 years ago - 1 comment
Labels: bug, mypy plugin

#218 - Crash when temporary base class is resolved from mypy cache

Issue - State: open - Opened by aberres over 2 years ago - 2 comments
Labels: bug, mypy plugin

#217 - Add `Select.get_final_froms()`

Pull Request - State: closed - Opened by rouge8 over 2 years ago - 2 comments

#216 - Fix `Connection.connection` to return `_ConnectionFairy` as documented

Pull Request - State: closed - Opened by rouge8 over 2 years ago - 2 comments

#215 - Add missing stubs for `ClauseElement.and` and `ClauseElement.or`

Pull Request - State: closed - Opened by rouge8 over 2 years ago - 4 comments

#214 - Accurate return types for sess.scalar() etc.

Issue - State: closed - Opened by Dreamsorcerer over 2 years ago - 2 comments
Labels: fixed by inline typing

#213 - 212-Add typings

Pull Request - State: closed - Opened by BlackLIonz over 2 years ago

#212 - on_conflict_do_update and on_conflict_do_nothing returns None it typing, but actually returns 'Insert'

Issue - State: closed - Opened by BlackLIonz over 2 years ago - 5 comments
Labels: bug, missing type

#211 - How to type hint a custom type?

Issue - State: closed - Opened by danstewart over 2 years ago - 2 comments

#210 - fix(sql.schema): alias typing.Sequence -> _Sequence to avoid conflict with class Sequence

Pull Request - State: closed - Opened by iyanging over 2 years ago - 2 comments

#209 - from sqlalchemy.sql.schema cannot import Sequence

Issue - State: closed - Opened by iyanging over 2 years ago
Labels: bug

#207 - any, has on column attribute

Issue - State: open - Opened by minyoung90 over 2 years ago - 1 comment
Labels: bug

#205 - fix: add execution_options to session.get

Pull Request - State: closed - Opened by peteris-zealid almost 3 years ago - 2 comments

#204 - missing optional parameter in session.get

Issue - State: closed - Opened by peteris-zealid almost 3 years ago

#203 - Indirection when specifying column type leads to missing init parameter

Issue - State: open - Opened by aberres almost 3 years ago
Labels: bug, mypy plugin

#202 - AsyncResult partitions is any AsyncIterator

Pull Request - State: closed - Opened by iamnoah almost 3 years ago - 1 comment

#201 - can't recognize primary key

Issue - State: closed - Opened by minyoung90 almost 3 years ago - 3 comments
Labels: duplicate

#200 - Regression of #63? `Need type annotation for` <relationship>

Issue - State: open - Opened by posita almost 3 years ago
Labels: requires triage

#199 - Mypy-friendly non-dynamic explicit base documentation is wrong (or at best, confusing)

Issue - State: closed - Opened by posita almost 3 years ago

#198 - Columns with `nullable=False` are typed as optional

Issue - State: open - Opened by peteris-zealid almost 3 years ago - 3 comments
Labels: question, expected behavior

#197 - Proper typing for `run_sync` method is now possible

Issue - State: open - Opened by michaeloliverx almost 3 years ago - 4 comments
Labels: enhancement

#195 - Another file's variable is not defined error

Issue - State: open - Opened by xncbf almost 3 years ago
Labels: requires triage

#194 - update workflow to use python 3.10, add rel_1_4 branch to test

Pull Request - State: closed - Opened by CaselIT almost 3 years ago

#193 - Fix: constructor argument of declarative_base is optional

Pull Request - State: closed - Opened by stefano-maggiolo almost 3 years ago - 1 comment

#192 - declarative_base's constructor arg is optional

Issue - State: closed - Opened by stefano-maggiolo almost 3 years ago - 3 comments
Labels: bug

#191 - Cannot execute DDL construct

Issue - State: closed - Opened by kasium almost 3 years ago - 5 comments

#188 - Add `nesting` flag in CTE functions

Pull Request - State: closed - Opened by Morikko about 3 years ago - 2 comments
Labels: missing type

#187 - stubs use implicit reexports

Issue - State: open - Opened by rectalogic about 3 years ago - 13 comments
Labels: use case

#186 - Add missing get_transaction from async session

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#185 - error: "AsyncSession" has no attribute "get_transaction" [attr-defined]

Issue - State: closed - Opened by ehdgua01 about 3 years ago - 3 comments
Labels: bug, missing type

#184 - Cannot infer type of "Column" when server_default and default kwargs are set on a @declared_attr

Issue - State: open - Opened by Davidonium about 3 years ago - 3 comments
Labels: bug

#183 - replace the master branch of sqlalchemy with main

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#182 - reorder inspect targets

Pull Request - State: closed - Opened by zzzeek about 3 years ago - 2 comments

#181 - type wrongly inferenced when using sqlalchemy.asc

Issue - State: open - Opened by taraskuzyk about 3 years ago - 1 comment
Labels: bug

#180 - don't use typing with ServerDefaultType

Pull Request - State: closed - Opened by zzzeek about 3 years ago - 8 comments

#179 - add api changes from https://github.com/sqlalchemy/sqlalchemy/issues/…

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#178 - add api changes from https://github.com/sqlalchemy/sqlalchemy/issues/…

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#177 - Add api changed from https://github.com/sqlalchemy/sqlalchemy/issues/…

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#176 - Add missing files

Issue - State: open - Opened by CaselIT about 3 years ago
Labels: missing type

#174 - consider a function-layer in the ORM that returns "Any"

Pull Request - State: open - Opened by zzzeek about 3 years ago

#173 - Try to improve hybrid property

Pull Request - State: closed - Opened by CaselIT about 3 years ago - 3 comments

#172 - Add get to the column and relationship to improve usage

Pull Request - State: closed - Opened by CaselIT about 3 years ago - 2 comments

#171 - no implementation for hybrids available

Issue - State: open - Opened by zzzeek about 3 years ago - 2 comments
Labels: bug

#170 - Supporting get and set on Column object

Issue - State: open - Opened by rslinckx about 3 years ago - 108 comments
Labels: enhancement

#169 - Add options to merge

Issue - State: open - Opened by CaselIT about 3 years ago
Labels: good first issue, waiting sa release

#168 - Common execute params

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#167 - Add sync_session_class to the stubs

Pull Request - State: closed - Opened by CaselIT about 3 years ago - 2 comments

#166 - fix with_expression() stub

Pull Request - State: closed - Opened by zzzeek about 3 years ago

#165 - Incomplete typing for AsyncConnection.execute's parameters

Issue - State: closed - Opened by squaresmile about 3 years ago - 2 comments
Labels: bug

#164 - hybrid.pyi: decorators should return the same type

Pull Request - State: closed - Opened by hydrargyrum about 3 years ago - 1 comment

#162 - Improve types of lowecase table, column and values

Pull Request - State: closed - Opened by CaselIT about 3 years ago

#161 - table('name', column(...)) does not work in alembic

Issue - State: closed - Opened by AbdealiLoKo about 3 years ago - 2 comments
Labels: bug

#156 - over order_by doesn't allow multiple clauses

Issue - State: closed - Opened by InsidersByte over 3 years ago - 3 comments
Labels: bug

#155 - Asynchronous sessionmaker initialization type error

Issue - State: closed - Opened by r4rdsn over 3 years ago - 13 comments
Labels: bug

#152 - Allow FunctionElement for Column server_default and server_onupdate

Pull Request - State: closed - Opened by jwilges over 3 years ago - 2 comments

GitHub / sqlalchemy/sqlalchemy2-stubs issues and pull requests