Latest posts on sqlalchemy и stored procedure. topichttps://python.su/forum/topic/21785/2015-02-22T19:20:57+02:00Общий :: Базы данных :: sqlalchemy и stored procedure.
2015-02-22T19:20:57+02:00warpson141179Истина где-то рядом :<br/> filter(User.id == <br/>не согласуется с 'select id from passwd <br/>
Общий :: Базы данных :: sqlalchemy и stored procedure.
2013-07-19T06:29:33+03:00plusplus112300Всё просто оказалось:<br/><div class="code"><pre><span class="kn">from</span> <span class="nn">sqlalchemy</span> <span class="kn">import</span> <span class="n">func</span>
<span class="n">db</span><span class="o">.</span><span class="n">session</span><span class="o">.</span><span class="n">query</span><span class="p">(</span><span class="n">User</span><span class="p">)</span><span class="o">.</span><span class="n">filter</span><span class="p">(</span><span class="n">User</span><span class="o">.</span><span class="n">id</span> <span class="o">==</span> <span class="n">func</span><span class="o">.</span><span class="n">check_pass</span><span class="p">(</span><span class="n">login</span><span class="p">,</span> <span class="n">password</span><span class="p">))</span><span class="o">.</span><span class="n">first</span><span class="p">()</span>
</pre></div>
Общий :: Базы данных :: sqlalchemy и stored procedure.
2013-07-18T18:51:50+03:00movie46112296Да, интересно знать
Общий :: Базы данных :: sqlalchemy и stored procedure.
2013-07-02T06:48:52+03:00plusplus111610<div class="code"><pre><span class="n">result</span> <span class="o">=</span> <span class="n">db</span><span class="o">.</span><span class="n">session</span><span class="o">.</span><span class="n">execute</span><span class="p">(</span><span class="s">'''select id from passwd </span>
<span class="s"> where id = check_pass(:login,:password)'''</span><span class="p">,</span>
<span class="p">{</span><span class="s">'login'</span><span class="p">:</span> <span class="n">login</span><span class="p">,</span> <span class="s">'password'</span><span class="p">:</span> <span class="n">password</span><span class="p">})</span><span class="o">.</span><span class="n">first</span><span class="p">()</span>
</pre></div><br/>Как-нибудь можно переделать этот запрос через модели, а не через raw-sql?