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

1from typing import ( 1abcdefghijklm

2 Self, 

3 TypeVar, 

4 TypeVarTuple, 

5) 

6 

7from sqlalchemy.sql._typing import ( 1abcdefghijklm

8 _ColumnExpressionArgument, 

9) 

10from sqlalchemy.sql.expression import Select as _Select 1abcdefghijklm

11 

12_T = TypeVar("_T") 1abcdefghijklm

13_Ts = TypeVarTuple("_Ts") 1abcdefghijklm

14 

15 

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

20 

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

26 

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

32 

33 

34class Select(SelectBase[*_Ts]): 1abcdefghijklm

35 inherit_cache = True 1abcdefghijklm

36 

37 

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