Coverage for sqlmodel/sql/_expression_select_cls.py: 100%
15 statements
« prev ^ index » next coverage.py v7.17.2, created at 2026-11-16 00:02 +0000
« prev ^ index » next coverage.py v7.17.2, created at 2026-11-16 00:02 +0000
1from typing import ( 1abcdefghijklm
2 Self,
3 TypeVar,
4 TypeVarTuple,
5)
7from sqlalchemy.sql._typing import ( 1abcdefghijklm
8 _ColumnExpressionArgument,
9)
10from sqlalchemy.sql.expression import Select as _Select 1abcdefghijklm
12_T = TypeVar("_T") 1abcdefghijklm
13_Ts = TypeVarTuple("_Ts") 1abcdefghijklm
16# Separate this class in SelectBase, Select, and SelectOfScalar so that they can share
17# where and having without having type overlap incompatibility in session.exec().
18class SelectBase(_Select[*_Ts]): 1abcdefghijklm
19 inherit_cache = True 1abcdefghijklm
21 def where(self, *whereclause: _ColumnExpressionArgument[bool] | bool) -> Self: 1abcdefghijklm
22 """Return a new `Select` construct with the given expression added to
23 its `WHERE` clause, joined to the existing clause via `AND`, if any.
24 """
25 return super().where(*whereclause) # ty: ignore[invalid-argument-type] 2A B C D n E F G H I J K L M N O P Q R S T U V W X Y Z 0 1 2 3 4 5 6 7 8 9 ! # $ % ' ( ) * + , - . / o : ; = ? @ [ ] ^ _ ` { | } ~ abbbcbdbebfbgbhbibjbkblbmbnbobpbqbrbsbtbubvbwbxbybzbAbBbCbDbEbp FbGbHbIbJbKbLbMbNbObPbQbRbSbTbUbVbWbXbYbZb0b1b2b3b4b5b6b7b8b9b!b#b$b%b'b(b)b*b+b,b-b.b/b:bq ;b=b?b@b[b]b^b_b`b{b|b}b~bacbcccdcecfcgchcicjckclcmcncocpcqcrcsctcucvcwcxcyczcAcBcCcDcEcFcr GcHcIcJcKcLcMcNcOcPcQcRcScTcUcVcWcXcYcZc0c1c2c3c4c5c6c7c8c9c!c#c$c%c'c(c)c*c+c,c-c.c/c:c;cs =c?c@c[c]c^c_c`c{c|c}c~cadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzdAdBdCdDdEdFdGdt HdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd0d1d2d3d4d5d6d7d8d9d!d#d$d%d'd(d)d*d+d,d-d.d/d:d;d=du ?d@d[d]d^d_d`d{d|d}d~daebecedeeefegeheiejekelemeneoepeqereseteuevewexeyezeAeBeCeDeEeFeGeHev IeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe0e1e2e3e4e5e6e7e8e9e!e#e$e%e'e(e)e*e+e,e-e.e/e:e;e=e?ew @e[e]e^e_e`e{e|e}e~eafbfcfdfefffgfhfifjfkflfmfnfofpfqfrfsftfufvfwfxfyfzfAfBfCfDfEfFfGfHfIfx JfKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf0f1f2f3f4f5f6f7f8f9f!f#f$f%f'f(f)f*f+f,f-f.f/f:f;f=f?f@fy [f]f^f_f`f{f|f}f~fagbgcgdgegfggghgigjgkglgmgngogpgqgrgsgtgugvgwgxgygzgAgBgCgDgEgFgGgHgIgJgz KgLgMgNgOgPgQgRgSgTgUgVgWgXgYgZg0g1g2g3g4g5g6g7g8g9g!g#g$g%g'g(g)g*g+g,g-g.g/g:g;g
27 def having(self, *having: _ColumnExpressionArgument[bool] | bool) -> Self: 1abcdefghijklm
28 """Return a new `Select` construct with the given expression added to
29 its `HAVING` clause, joined to the existing clause via `AND`, if any.
30 """
31 return super().having(*having) # ty: ignore[invalid-argument-type] 1nopqrstuvwxyz
34class Select(SelectBase[*_Ts]): 1abcdefghijklm
35 inherit_cache = True 1abcdefghijklm
38# This is not comparable to sqlalchemy.sql.selectable.ScalarSelect, that has a different
39# purpose. This is the same as a normal SQLAlchemy Select class where there's only one
40# entity, so the result will be converted to a scalar by default. This way writing
41# for loops on the results will feel natural.
42class SelectOfScalar(SelectBase[_T]): 1abcdefghijklm
43 inherit_cache = True 1abcdefghijklm