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
« 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)
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
26_TSelectParam = TypeVar("_TSelectParam", bound=Any) 1abhcdiefgj
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
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
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
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
95 @deprecated( 1abhcdiefgj
96 """
97 🚨 You probably want to use `session.exec()` instead of `session.execute()`.
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.
102 For example:
104 ```Python
105 heroes = session.execute(select(Hero)).scalars().all()
106 ```
108 instead you could use `exec()`:
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()`.
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.
132 For example:
134 ```Python
135 heroes = session.execute(select(Hero)).scalars().all()
136 ```
138 instead you could use `exec()`:
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 )
153 @deprecated( 1abhcdiefgj
154 """
155 🚨 You probably want to use `session.exec()` instead of `session.query()`.
157 `session.exec()` is SQLModel's own short version with increased type
158 annotations.
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()`.
170 `session.exec()` is SQLModel's own short version with increased type
171 annotations.
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