Coverage for sqlmodel/orm/session.py: 100%

27 statements  

« prev     ^ index     » next       coverage.py v7.11.0, created at 2025-10-27 00:03 +0000

1from typing import ( 1abhcdiefgj

2 Any, 

3 Dict, 

4 Mapping, 

5 Optional, 

6 Sequence, 

7 TypeVar, 

8 Union, 

9 overload, 

10) 

11 

12from sqlalchemy import util 1abhcdiefgj

13from sqlalchemy.engine.cursor import CursorResult 1abhcdiefgj

14from sqlalchemy.engine.interfaces import _CoreAnyExecuteParams 1abhcdiefgj

15from sqlalchemy.engine.result import Result, ScalarResult, TupleResult 1abhcdiefgj

16from sqlalchemy.orm import Query as _Query 1abhcdiefgj

17from sqlalchemy.orm import Session as _Session 1abhcdiefgj

18from sqlalchemy.orm._typing import OrmExecuteOptionsParameter 1abhcdiefgj

19from sqlalchemy.sql._typing import _ColumnsClauseArgument 1abhcdiefgj

20from sqlalchemy.sql.base import Executable as _Executable 1abhcdiefgj

21from sqlalchemy.sql.dml import UpdateBase 1abhcdiefgj

22from sqlmodel.sql.base import Executable 1abhcdiefgj

23from sqlmodel.sql.expression import Select, SelectOfScalar 1abhcdiefgj

24from typing_extensions import deprecated 1abhcdiefgj

25 

26_TSelectParam = TypeVar("_TSelectParam", bound=Any) 1abhcdiefgj

27 

28 

29class Session(_Session): 1abhcdiefgj

30 @overload 1abhcdiefgj

31 def exec( 1abhcdiefgj

32 self, 

33 statement: Select[_TSelectParam], 1abcdefg

34 *, 

35 params: Optional[Union[Mapping[str, Any], Sequence[Mapping[str, Any]]]] = None, 1abhcdiefgj

36 execution_options: Mapping[str, Any] = util.EMPTY_DICT, 1abhcdiefgj

37 bind_arguments: Optional[Dict[str, Any]] = None, 1abhcdiefgj

38 _parent_execute_state: Optional[Any] = None, 1abhcdiefgj

39 _add_event: Optional[Any] = None, 1abhcdiefgj

40 ) -> TupleResult[_TSelectParam]: ... 1abcdefg

41 

42 @overload 1abhcdiefgj

43 def exec( 1abhcdiefgj

44 self, 

45 statement: SelectOfScalar[_TSelectParam], 1abcdefg

46 *, 

47 params: Optional[Union[Mapping[str, Any], Sequence[Mapping[str, Any]]]] = None, 1abhcdiefgj

48 execution_options: Mapping[str, Any] = util.EMPTY_DICT, 1abhcdiefgj

49 bind_arguments: Optional[Dict[str, Any]] = None, 1abhcdiefgj

50 _parent_execute_state: Optional[Any] = None, 1abhcdiefgj

51 _add_event: Optional[Any] = None, 1abhcdiefgj

52 ) -> ScalarResult[_TSelectParam]: ... 1abcdefg

53 

54 @overload 1abhcdiefgj

55 def exec( 1abhcdiefgj

56 self, 

57 statement: UpdateBase, 1abcdefg

58 *, 

59 params: Optional[Union[Mapping[str, Any], Sequence[Mapping[str, Any]]]] = None, 1abhcdiefgj

60 execution_options: Mapping[str, Any] = util.EMPTY_DICT, 1abhcdiefgj

61 bind_arguments: Optional[Dict[str, Any]] = None, 1abhcdiefgj

62 _parent_execute_state: Optional[Any] = None, 1abhcdiefgj

63 _add_event: Optional[Any] = None, 1abhcdiefgj

64 ) -> CursorResult[Any]: ... 1abcdefg

65 

66 def exec( 1abhcdiefgj

67 self, 

68 statement: Union[ 

69 Select[_TSelectParam], 

70 SelectOfScalar[_TSelectParam], 

71 Executable[_TSelectParam], 

72 UpdateBase, 

73 ], 

74 *, 

75 params: Optional[Union[Mapping[str, Any], Sequence[Mapping[str, Any]]]] = None, 

76 execution_options: Mapping[str, Any] = util.EMPTY_DICT, 

77 bind_arguments: Optional[Dict[str, Any]] = None, 

78 _parent_execute_state: Optional[Any] = None, 

79 _add_event: Optional[Any] = None, 

80 ) -> Union[ 

81 TupleResult[_TSelectParam], ScalarResult[_TSelectParam], CursorResult[Any] 

82 ]: 

83 results = super().execute( 2ekfkgkhkikk l jkm n kko p q r s t u v w x y z A B C D 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 ! lkmknkokpkqkrksktkukvkwkxkykzkAkBkCk# $ % ' ( ) DkEkFkGkHkIk* + , - JkKkLkMk. / : ; = ? @ [ ] ^ _ ` { | } ~ abbbcbdbebfbgbhbibjbkbNkOkPkQkRkSkTkUklbmbnbobpbqbrbsbVkWkXkYkZk0k1k2k3k4k5k6k7k8k9k!k#k$k%k'k(k)k*k+k,k-k.ktbub/kvbwb:kxbybzbAbBbCbDbEbFbGbHbIbJbKbLbMbNbObPbQbRbSbTbUbVbWbXbYbZb0b1b2b3b4b5b6b7b8b9b!b#b$b%b'b(b)b*b+b,b;k=k?k@k[k]k^k_k`k{k|k}k~kalblcldlel-b.b/b:b;b=bflglhliljlkl?b@b[b]bllmlnlol^b_b`b{b|b}b~bacbcccdcecfcgchcicjckclcmcncocpcqcrcsctcplqlrlsltlulvlwlucvcwcxcyczcAcBcxlylzlAlBlClDlElFlGlHlIlJlKlLlMlNlOlPlQlRlSlTlUlVlWlXlCcDcYlZlEcFc0lGcHcIcJcKcLcMcNcOcPcQcRcScTcUcVcWcXcYcZc0c1c2c3c4c5c6c7c8c9c!c#c$c%c'c(c)c*c+c,c-c.c/c:c;c=c?c@c[c1l2l3l4l5l6l7l8l9l!l#l$l%l'l(l)l*l+l]c^c_c`c{c|c,l-l.l/l:l;l}c~cadbd=l?l@l[lcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzdAdBdCd]l^l_l`l{l|l}l~lDdEdFdGdHdIdJdKdambmcmdmemfmgmhmimjmkmlmmmnmompmqmrmsmtmumvmwmxmymLdzmAmMdNdBmOdPdQdRdSdTdUdVdWdXdYdZd0d1d2d3d4d5d6d7d8d9d!d#d$d%d'd(d)d*dCmDmEmFmGmHmImJmKm+d,d-d.dLmMmNm/d:dOmPm;d=d?d@d[d]d^d_d`d{d|d}d~daebecedeeeQmRmSmTmfegeheieUmVmWmXmYmZm0m1m2m3m4m5m6m7m8m9mjeke!mleme#mneoepeqereseteuevewexeyezeAeBeCeDeEeFeGeHeIeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe0e1e2e3e4e5e6e7e8e9e$m%m'm(m)m*m+m,m-m.m/m:m;m=m?m@m[m]m!e#e$e%e'e(e^m_m`m{m|m}m)e*e+e,e~manbncn-e.e/e:e;e=e?e@e[e]e^e_e`e{e|e}e~eafbfcfdfefffgfhfifjfdnenfngnhninjnknkflfmfnfofpfqfrflnmnnnonpnqnrnsntnunvnwnxnynznAnBnCnDnEnFnGnHnInJnKnLnsftfMnNnufvfOnwfxfyfzfAfBfCfDfEfFfGfHfIfJfKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf0f1f2f3f4f5f6f7f8f9f!f#f$f%f'f(f)f*f+fPnQnRnSnTnUnVnWnXnYnZn0n1n2n3n4n5n6n,f-f.f/f:f;f7n8n9n!n#n$n=f?f@f[f%n'n(n)n]f^f_f`f{f|f}f~fagbgcgdgegfggghgigjgkglgmgngogpgqgrgsg*n+n,n-n.n/n:n;ntgugvgwgxgygzgAg=n?n@n[n]n^n_n`n{n|n}n~naobocodoeofogohoiojokoloBgmoCgDgnoEgFgGgHgIgJgKgLgMgNgOgPgQgRgSgTgUgVgWgoopoqorosotouovowoXgYgxoyozoZg0gAoBo1g2g3g4g5g6g7g8g9gCoDoEoFo!g#g$g%gGoHoIoJoKoLoMoNoOoPoQoRoSoToUoVo'g(gWoXo)g*gYo+g,g-g.g/g:g;g=g?g@g[g]g^g_g`g{g|g}g~gahbhchdhehfhghhhihjhkhlhmhnhohphqhrhshthuhvhwhxhyhzhAhBhChDhZo0o1o2o3o4o5o6o7o8o9o!o#o$o%o'o(o)oEhFhGhHhIhJh*o+o,o-o.o/oKhLhMhNh:o;o=o?oOhPhQhRhShThUhVhWhXhYhZh0h1h2h3h4h5h6h7h8h9h!h#h$h%h'h@o[o]o^o_o`o{o|o(h)h*h+h,h-h.h/h}o~oapbpcpdpepfpgphpipjpkplpmpnpopppqprpsptpupvpwpxpyp:h;hzpAp=h?hBp@h[h]h^h_h`h{h|h}h~haibicidieifigihiiijikiliminioipiqirisitiuiviwixiyiziAiBiCiDiEiFiGiHiIiJiKiLiMiCpDpEpFpGpHpIpJpKpLpMpNpOpPpQpRpSpTpNiOiPiQiRiSiUpVpWpXpYpZpTiUiViWi0p1p2p3pXiYiZi0i1i2i3i4i5i6i7i8i9i!i#i$i%i'i(i)i*i+i,i-i.i/i:i4p5p6p7p8p9p!p#p;i=i?i@i[i]i^i_i$p%p'p(p)p*p+p,p-p.p/p:p;p=p?p@p[p]p^p_p`p{p|p}p~paqbq`i{icqdq|i}ieq~iajbjcjdjejfjgjhjijjjkjljmjnjojpjqjrjsjtjujvjwjxjyjzjAjBjCjDjEjFjGjHjIjJjKjLjMjNjOjPjQjRjSjTjUjVjfqgqhqiqjqkqlqmqnqoqpqqqrqsqtquqvqwqWjXjYjZj0j1jxqyqzqAqBqCq2j3j4j5jDqEqFqGq6j7j8j9j!j#j$j%j'j(j)j*j+j,j-j.j/j:j;j=j?j@j[j]j^j_j`jHqIqJqKqLqMqNqOq{j|j}j~jakbkckdkPqQqRqSqTqUqVqWqXqYqZq0q1q2q3q4q5q6q7q8q9q!q

84 statement, 

85 params=params, 

86 execution_options=execution_options, 

87 bind_arguments=bind_arguments, 

88 _parent_execute_state=_parent_execute_state, 

89 _add_event=_add_event, 

90 ) 

91 if isinstance(statement, SelectOfScalar): 2ekfkgkhkikk l jkm n kko p q r s t u v w x y z A B C D 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 ! lkmknkokpkqkrksktkukvkwkxkykzkAkBkCk# $ % ' ( ) DkEkFkGkHkIk* + , - JkKkLkMk. / : ; = ? @ [ ] ^ _ ` { | } ~ abbbcbdbebfbgbhbibjbkbNkOkPkQkRkSkTkUklbmbnbobpbqbrbsbVkWkXkYkZk0k1k2k3k4k5k6k7k8k9k!k#k$k%k'k(k)k*k+k,k-k.ktbub/kvbwb:kxbybzbAbBbCbDbEbFbGbHbIbJbKbLbMbNbObPbQbRbSbTbUbVbWbXbYbZb0b1b2b3b4b5b6b7b8b9b!b#b$b%b'b(b)b*b+b,b;k=k?k@k[k]k^k_k`k{k|k}k~kalblcldlel-b.b/b:b;b=bflglhliljlkl?b@b[b]bllmlnlol^b_b`b{b|b}b~bacbcccdcecfcgchcicjckclcmcncocpcqcrcsctcplqlrlsltlulvlwlucvcwcxcyczcAcBcxlylzlAlBlClDlElFlGlHlIlJlKlLlMlNlOlPlQlRlSlTlUlVlWlXlCcDcYlZlEcFc0lGcHcIcJcKcLcMcNcOcPcQcRcScTcUcVcWcXcYcZc0c1c2c3c4c5c6c7c8c9c!c#c$c%c'c(c)c*c+c,c-c.c/c:c;c=c?c@c[c1l2l3l4l5l6l7l8l9l!l#l$l%l'l(l)l*l+l]c^c_c`c{c|c,l-l.l/l:l;l}c~cadbd=l?l@l[lcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzdAdBdCd]l^l_l`l{l|l}l~lDdEdFdGdHdIdJdKdambmcmdmemfmgmhmimjmkmlmmmnmompmqmrmsmtmumvmwmxmymLdzmAmMdNdBmOdPdQdRdSdTdUdVdWdXdYdZd0d1d2d3d4d5d6d7d8d9d!d#d$d%d'd(d)d*dCmDmEmFmGmHmImJmKm+d,d-d.dLmMmNm/d:dOmPm;d=d?d@d[d]d^d_d`d{d|d}d~daebecedeeeQmRmSmTmfegeheieUmVmWmXmYmZm0m1m2m3m4m5m6m7m8m9mjeke!mleme#mneoepeqereseteuevewexeyezeAeBeCeDeEeFeGeHeIeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe0e1e2e3e4e5e6e7e8e9e$m%m'm(m)m*m+m,m-m.m/m:m;m=m?m@m[m]m!e#e$e%e'e(e^m_m`m{m|m}m)e*e+e,e~manbncn-e.e/e:e;e=e?e@e[e]e^e_e`e{e|e}e~eafbfcfdfefffgfhfifjfdnenfngnhninjnknkflfmfnfofpfqfrflnmnnnonpnqnrnsntnunvnwnxnynznAnBnCnDnEnFnGnHnInJnKnLnsftfMnNnufvfOnwfxfyfzfAfBfCfDfEfFfGfHfIfJfKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf0f1f2f3f4f5f6f7f8f9f!f#f$f%f'f(f)f*f+fPnQnRnSnTnUnVnWnXnYnZn0n1n2n3n4n5n6n,f-f.f/f:f;f7n8n9n!n#n$n=f?f@f[f%n'n(n)n]f^f_f`f{f|f}f~fagbgcgdgegfggghgigjgkglgmgngogpgqgrgsg*n+n,n-n.n/n:n;ntgugvgwgxgygzgAg=n?n@n[n]n^n_n`n{n|n}n~naobocodoeofogohoiojokoloBgmoCgDgnoEgFgGgHgIgJgKgLgMgNgOgPgQgRgSgTgUgVgWgoopoqorosotouovowoXgYgxoyozoZg0gAoBo1g2g3g4g5g6g7g8g9gCoDoEoFo!g#g$g%gGoHoIoJoKoLoMoNoOoPoQoRoSoToUoVo'g(gWoXo)g*gYo+g,g-g.g/g:g;g=g?g@g[g]g^g_g`g{g|g}g~gahbhchdhehfhghhhihjhkhlhmhnhohphqhrhshthuhvhwhxhyhzhAhBhChDhZo0o1o2o3o4o5o6o7o8o9o!o#o$o%o'o(o)oEhFhGhHhIhJh*o+o,o-o.o/oKhLhMhNh:o;o=o?oOhPhQhRhShThUhVhWhXhYhZh0h1h2h3h4h5h6h7h8h9h!h#h$h%h'h@o[o]o^o_o`o{o|o(h)h*h+h,h-h.h/h}o~oapbpcpdpepfpgphpipjpkplpmpnpopppqprpsptpupvpwpxpyp:h;hzpAp=h?hBp@h[h]h^h_h`h{h|h}h~haibicidieifigihiiijikiliminioipiqirisitiuiviwixiyiziAiBiCiDiEiFiGiHiIiJiKiLiMiCpDpEpFpGpHpIpJpKpLpMpNpOpPpQpRpSpTpNiOiPiQiRiSiUpVpWpXpYpZpTiUiViWi0p1p2p3pXiYiZi0i1i2i3i4i5i6i7i8i9i!i#i$i%i'i(i)i*i+i,i-i.i/i:i4p5p6p7p8p9p!p#p;i=i?i@i[i]i^i_i$p%p'p(p)p*p+p,p-p.p/p:p;p=p?p@p[p]p^p_p`p{p|p}p~paqbq`i{icqdq|i}ieq~iajbjcjdjejfjgjhjijjjkjljmjnjojpjqjrjsjtjujvjwjxjyjzjAjBjCjDjEjFjGjHjIjJjKjLjMjNjOjPjQjRjSjTjUjVjfqgqhqiqjqkqlqmqnqoqpqqqrqsqtquqvqwqWjXjYjZj0j1jxqyqzqAqBqCq2j3j4j5jDqEqFqGq6j7j8j9j!j#j$j%j'j(j)j*j+j,j-j.j/j:j;j=j?j@j[j]j^j_j`jHqIqJqKqLqMqNqOq{j|j}j~jakbkckdkPqQqRqSqTqUqVqWqXqYqZq0q1q2q3q4q5q6q7q8q9q!q

92 return results.scalars() 2ekfkgkhkikk l jkm n u v y z A B C D 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 ! lkmknkokpkqkrksktkukvkwkxkykzkAkBkCk# $ % ' ( ) DkEkFkGkHkIk* + , - JkKkLkMk. / : ; = ? @ [ ] ^ _ ` { | } ~ abbbcbdbebfbgbhbibjbkbNkOkPkQkRkSkTkUklbmbnbobpbqbrbsbVkWkXkYkZk0k1k2k3k4k5k6k7k8k9k!k#k$k%k'k(k)k*k+k,k-k.ktbub/kvbwbDbEbHbIbJbKbLbMbNbObPbQbRbSbTbUbVbWbXbYbZb0b1b2b3b4b5b6b7b8b9b!b#b$b%b'b(b)b*b+b,b;k=k?k@k[k]k^k_k`k{k|k}k~kalblcldlel-b.b/b:b;b=bflglhliljlkl?b@b[b]bllmlnlol^b_b`b{b|b}b~bacbcccdcecfcgchcicjckclcmcncocpcqcrcsctcplqlrlsltlulvlwlucvcwcxcyczcAcBcxlylzlAlBlClDlElFlGlHlIlJlKlLlMlNlOlPlQlRlSlTlUlVlWlXlCcDcYlZlEcFcMcNcQcRcScTcUcVcWcXcYcZc0c1c2c3c4c5c6c7c8c9c!c#c$c%c'c(c)c*c+c,c-c.c/c:c;c=c?c@c[c1l2l3l4l5l6l7l8l9l!l#l$l%l'l(l)l*l+l]c^c_c`c{c|c,l-l.l/l:l;l}c~cadbd=l?l@l[lcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzdAdBdCd]l^l_l`l{l|l}l~lDdEdFdGdHdIdJdKdambmcmdmemfmgmhmimjmkmlmmmnmompmqmrmsmtmumvmwmxmymLdzmAmMdNdRdTdUdVdWdXdYdZd0d1d2d3d4d5d6d7d8d9d!d#d$d%d'd(d)d*dCmDmEmFmGmHmImJmKm+d,d-d.dLmMmNm/d:dOmPm;d=d?d@d[d]d^d_d`d{d|d}d~daebecedeeeQmRmSmTmfegeheieUmVmWmXmYmZm0m1m2m3m4m5m6m7m8m9mjeke!mlemeteuexeyezeAeBeCeDeEeFeGeHeIeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe0e1e2e3e4e5e6e7e8e9e$m%m'm(m)m*m+m,m-m.m/m:m;m=m?m@m[m]m!e#e$e%e'e(e^m_m`m{m|m}m)e*e+e,e~manbncn-e.e/e:e;e=e?e@e[e]e^e_e`e{e|e}e~eafbfcfdfefffgfhfifjfdnenfngnhninjnknkflfmfnfofpfqfrflnmnnnonpnqnrnsntnunvnwnxnynznAnBnCnDnEnFnGnHnInJnKnLnsftfMnNnufvfCfDfGfHfIfJfKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf0f1f2f3f4f5f6f7f8f9f!f#f$f%f'f(f)f*f+fPnQnRnSnTnUnVnWnXnYnZn0n1n2n3n4n5n6n,f-f.f/f:f;f7n8n9n!n#n$n=f?f@f[f%n'n(n)n]f^f_f`f{f|f}f~fagbgcgdgegfggghgigjgkglgmgngogpgqgrgsg*n+n,n-n.n/n:n;ntgugvgwgxgygzgAg=n?n@n[n]n^n_n`n{n|n}n~naobocodoeofogohoiojokoloBgmoCgDgHgJgKgLgMgNgOgPgQgRgSgTgUgVgWgoopoqorosotouovowoXgYgxoyozoZg0gAoBo1g2g3g4g5g6g7g8g9gCoDoEoFo!g#g$g%gGoHoIoJoKoLoMoNoOoPoQoRoSoToUoVo'g(gWoXo)g*g;g=g[g]g^g_g`g{g|g}g~gahbhchdhehfhghhhihjhkhlhmhnhohphqhrhshthuhvhwhxhyhzhAhBhChDhZo0o1o2o3o4o5o6o7o8o9o!o#o$o%o'o(o)oEhFhGhHhIhJh*o+o,o-o.o/oKhLhMhNh:o;o=o?oOhPhQhRhShThUhVhWhXhYhZh0h1h2h3h4h5h6h7h8h9h!h#h$h%h'h@o[o]o^o_o`o{o|o(h)h*h+h,h-h.h/h}o~oapbpcpdpepfpgphpipjpkplpmpnpopppqprpsptpupvpwpxpyp:h;hzpAp=h?h{h|haibicidieifigihiiijikiliminioipiqirisitiuiviwixiyiziAiBiCiDiEiFiGiHiIiJiKiLiMiCpDpEpFpGpHpIpJpKpLpMpNpOpPpQpRpSpTpNiOiPiQiRiSiUpVpWpXpYpZpTiUiViWi0p1p2p3pXiYiZi0i1i2i3i4i5i6i7i8i9i!i#i$i%i'i(i)i*i+i,i-i.i/i:i4p5p6p7p8p9p!p#p;i=i?i@i[i]i^i_i$p%p'p(p)p*p+p,p-p.p/p:p;p=p?p@p[p]p^p_p`p{p|p}p~paqbq`i{icqdq|i}ifjgjjjkjljmjnjojpjqjrjsjtjujvjwjxjyjzjAjBjCjDjEjFjGjHjIjJjKjLjMjNjOjPjQjRjSjTjUjVjfqgqhqiqjqkqlqmqnqoqpqqqrqsqtquqvqwqWjXjYjZj0j1jxqyqzqAqBqCq2j3j4j5jDqEqFqGq6j7j8j9j!j#j$j%j'j(j)j*j+j,j-j.j/j:j;j=j?j@j[j]j^j_j`jHqIqJqKqLqMqNqOq{j|j}j~jakbkckdkPqQqRqSqTqUqVqWqXqYqZq0q1q2q3q4q5q6q7q8q9q!q

93 return results # type: ignore 2kko p q r s t w x * + , - :kxbybzbAbBbCbFbGb?b@b[b]b0lGcHcIcJcKcLcOcPc}c~cadbdBmOdPdQdSd/d:d#mneoepeqeresevewe)e*e+e,eOnwfxfyfzfAfBfEfFf=f?f@f[fnoEgFgGgIgZg0gYo+g,g-g.g/g:g?g@gKhLhMhNhBp@h[h]h^h_h`h}h~hTiUiViWieq~iajbjcjdjejhjij2j3j4j5j

94 

95 @deprecated( 1abhcdiefgj

96 """ 

97 🚨 You probably want to use `session.exec()` instead of `session.execute()`. 

98 

99 This is the original SQLAlchemy `session.execute()` method that returns objects 

100 of type `Row`, and that you have to call `scalars()` to get the model objects. 

101 

102 For example: 

103 

104 ```Python 

105 heroes = session.execute(select(Hero)).scalars().all() 

106 ``` 

107 

108 instead you could use `exec()`: 

109 

110 ```Python 

111 heroes = session.exec(select(Hero)).all() 

112 ``` 

113 """, 

114 category=None, 

115 ) 

116 def execute( 1abhcdiefgj

117 self, 

118 statement: _Executable, 

119 params: Optional[_CoreAnyExecuteParams] = None, 

120 *, 

121 execution_options: OrmExecuteOptionsParameter = util.EMPTY_DICT, 

122 bind_arguments: Optional[Dict[str, Any]] = None, 

123 _parent_execute_state: Optional[Any] = None, 

124 _add_event: Optional[Any] = None, 

125 ) -> Result[Any]: 

126 """ 

127 🚨 You probably want to use `session.exec()` instead of `session.execute()`. 

128 

129 This is the original SQLAlchemy `session.execute()` method that returns objects 

130 of type `Row`, and that you have to call `scalars()` to get the model objects. 

131 

132 For example: 

133 

134 ```Python 

135 heroes = session.execute(select(Hero)).scalars().all() 

136 ``` 

137 

138 instead you could use `exec()`: 

139 

140 ```Python 

141 heroes = session.exec(select(Hero)).all() 

142 ``` 

143 """ 

144 return super().execute( 2.q/q:q;q=q?q@q[q]q^q_q`q{q|q}q~qarbrcrdrerfrgrhrirjrkrlrmrnrorprqrrrsrtrurvrwrk l xryrzrm n Ar#qBrCrDrErFrGrHrIrJro p q r s t u v w x KrLry z A B MrNrOrPrQrRrC D 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 ! SrTrUr# $ % ' ( ) VrWrXrYr. / : ; = ? Zr0r1r2r3r4r@ [ ] ^ _ ` { | } ~ abbbcbdbebfbgbhbibjbkblbmbnbobpbqbrbsb5r6r7r8r9r!r#r$r%r'r(r)r*r+r,r-r.r/r:r;r=r?r@r[r]r^r_r`r{r|r}r~rasbscsdsesfsgstbubhsisjsvbwbks$qlsmsnsospsqsrssstsxbybzbAbBbCbDbEbFbGbusvsHbIbJbKbwsxsyszsAsBsLbMbNbObPbQbRbSbTbUbVbWbXbYbZb0b1b2b3b4b5b6b7b8b9b!b#b$b%b'b(b)b*b+b,bCsDsEs-b.b/b:b;b=bFsGsHsIs^b_b`b{b|b}bJsKsLsMsNsOs~bacbcccdcecfcgchcicjckclcmcncocpcqcrcsctcucvcwcxcyczcAcBcPsQsRsSsTsUsVsWsXsYsZs0s1s2s3s4s5s6s7s8s9s!s#s$s%s's(s)s*s+s,s-s.s/s:s;s=s?s@sCcDc[s]s^sEcFc_s%q`s{s|s}s~satbtctdtGcHcIcJcKcLcMcNcOcPcetftQcRcScTcgthtitjtktltUcVcWcXcYcZc0c1c2c3c4c5c6c7c8c9c!c#c$c%c'c(c)c*c+c,c-c.c/c:c;c=c?c@c[cmtntot]c^c_c`c{c|cptqtrtstcdddedfdgdhdttutvtwtxtytidjdkdldmdndodpdqdrdsdtdudvdwdxdydzdAdBdCdDdEdFdGdHdIdJdKdztAtBtCtDtEtFtGtHtItJtKtLtMtNtOtPtQtRtStTtUtVtWtXtYtLdZt0tMdNd1t'q2t3t4t5t6t7tOdPdQdRdSd8tTdUd9t!t#t$t%t'tVdWdXdYdZd0d1d2d3d4d5d6d7d8d9d!d#d$d%d'd(d)d*d(t)t+d,d-d.d*t+t;d=d?d@d,t-t.t/t[d]d^d_d`d{d|d}d~daebecedeeefegeheie:t;t=t?t@t[t]t^t_t`t{t|t}t~taubucudueufuguhuiujukulumunuoupuqurusutuuuvuwuxuyujekezuAuBulemeCu(qDuEuFuGuHuIuJuKuLuneoepeqereseteueveweMuNuxeyezeAeOuPuQuRuSuTuBeCeDeEeFeGeHeIeJeKeLeMeNeOePeQeReSeTeUeVeWeXeYeZe0e1e2e3e4e5e6e7e8e9eUuVuWu!e#e$e%e'e(eXuYuZu0u-e.e/e:e;e=e1u2u3u4u5u6u?e@e[e]e^e_e`e{e|e}e~eafbfcfdfefffgfhfifjfkflfmfnfofpfqfrf7u8u9u!u#u$u%u'u(u)u*u+u,u-u.u/u:u;u=u?u@u[u]u^u_u`u{u|u}u~uavbvcvdvevfvgvhvivsftfjvkvlvufvfmv)qnvovpvqvrvsvtvuvvvwfxfyfzfAfBfCfDfEfFfwvxvGfHfIfJfyvzvAvBvCvDvKfLfMfNfOfPfQfRfSfTfUfVfWfXfYfZf0f1f2f3f4f5f6f7f8f9f!f#f$f%f'f(f)f*f+fEvFvGv,f-f.f/f:f;fHvIvJvKv]f^f_f`f{f|fLvMvNvOvPvQv}f~fagbgcgdgegfggghgigjgkglgmgngogpgqgrgsgtgugvgwgxgygzgAgRvSvTvUvVvWvXvYvZv0v1v2v3vBg4v5vCgDg6v*q7v8v9v!v#vEgFgGgHgIg$vJgKg%v'v(v)v*v+vLgMgNgOgPgQgRgSgTgUgVgWg,vXgYg-v.v1g2g/v:v3g4g5g6g7g8g9g!g#g$g%g;v=v?v@v[v]v^v_v`v{v|v}v~vawbwcwdwewfwgwhwiwjwkwlwmwnwowpwqwrwswtwuwvwwwxwywzw'g(gAwBwCw)g*gDw+qEwFwGwHwIwJwKwLwMw+g,g-g.g/g:g;g=g?g@gNwOw[g]g^g_gPwQwRwSwTwUw`g{g|g}g~gahbhchdhehfhghhhihjhkhlhmhnhohphqhrhshthuhvhwhxhyhzhAhBhChDhVwWwXwEhFhGhHhIhJhYwZw0w1wOhPhQhRhShTh2w3w4w5w6w7wUhVhWhXhYhZh0h1h2h3h4h5h6h7h8h9h!h#h$h%h'h(h)h*h+h,h-h.h/h8w9w!w#w$w%w'w(w)w*w+w,w-w.w/w:w;w=w?w@w[w]w^w_w`w{w|w}w~waxbxcxdxexfxgxhxixjx:h;hkxlxmx=h?hnx,qoxpxqxrxsxtxuxvxwx@h[h]h^h_h`h{h|h}h~hxxyxaibicidizxAxBxCxDxExeifigihiiijikiliminioipiqirisitiuiviwixiyiziAiBiCiDiEiFiGiHiIiJiKiLiMiFxGxHxNiOiPiQiRiSiIxJxKxLxXiYiZi0i1i2iMxNxOxPxQxRx3i4i5i6i7i8i9i!i#i$i%i'i(i)i*i+i,i-i.i/i:i;i=i?i@i[i]i^i_iSxTxUxVxWxXxYxZx0x1x2x3x4x5x6x7x8x9x!x#x$x%x'x(x)x*x+x,x-x.x/x:x;x=x?x@x[x]x^x`i{i_x`x{x|i}i|x-q}x~xaybycydyeyfygy~iajbjcjdjejfjgjhjijhyiyjjkjljmjjykylymynyoynjojpjqjrjsjtjujvjwjxjyjzjAjBjCjDjEjFjGjHjIjJjKjLjMjNjOjPjQjRjSjTjUjVjpyqyryWjXjYjZj0j1jsytyuyvy6j7j8j9j!j#jwyxyyyzyAyBy$j%j'j(j)j*j+j,j-j.j/j:j;j=j?j@j[j]j^j_j`j{j|j}j~jakbkckdk

145 statement, 

146 params=params, 

147 execution_options=execution_options, 

148 bind_arguments=bind_arguments, 

149 _parent_execute_state=_parent_execute_state, 

150 _add_event=_add_event, 

151 ) 

152 

153 @deprecated( 1abhcdiefgj

154 """ 

155 🚨 You probably want to use `session.exec()` instead of `session.query()`. 

156 

157 `session.exec()` is SQLModel's own short version with increased type 

158 annotations. 

159 

160 Or otherwise you might want to use `session.execute()` instead of 

161 `session.query()`. 

162 """ 

163 ) 

164 def query( # type: ignore 1abhcdiefgj

165 self, *entities: _ColumnsClauseArgument[Any], **kwargs: Any 

166 ) -> _Query[Any]: 

167 """ 

168 🚨 You probably want to use `session.exec()` instead of `session.query()`. 

169 

170 `session.exec()` is SQLModel's own short version with increased type 

171 annotations. 

172 

173 Or otherwise you might want to use `session.execute()` instead of 

174 `session.query()`. 

175 """ 

176 return super().query(*entities, **kwargs) 2#q$q%q'q(q)q*q+q,q-q