Path: csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.018 X-Spam-Evidence: '*H*': 0.96; '*S*': 0.00; 'column': 0.07; 'dynamically': 0.07; 'subject:skip:s 10': 0.07; 'suppose': 0.07; 'string': 0.09; 'better?': 0.16; 'columns': 0.16; 'function?': 0.16; 'sqlalchemy': 0.16; 'sqlalchemy,': 0.16; 'subject:which': 0.16; 'all,': 0.19; 'to:name:python-list@python.org': 0.22; 'logical': 0.24; 'specify': 0.24; 'query': 0.26; 'function': 0.29; 'operators': 0.31; 'question:': 0.31; 'values.': 0.31; 'run': 0.32; 'not.': 0.33; 'yours,': 0.36; 'entry': 0.36; 'subject:?': 0.36; 'two': 0.37; 'filter': 0.38; 'to:addr:python-list': 0.38; 'issue': 0.38; 'delete': 0.39; 'to:addr:python.org': 0.39; 'how': 0.40; 'read': 0.60; "you'll": 0.62; 'such': 0.63; 'field': 0.63; 'dear': 0.65; 'between': 0.67; 'results': 0.69; 'link:': 0.72 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=pahlevanzadeh.org; s=default; h=Content-Transfer-Encoding:Mime-Version:Content-Type:Date:To:From:Subject:Message-ID; bh=MwmRFxVFKD7C6izB77CUL51P9VfKR7DvAdz7jEohiJM=; b=uexH1VCBNWhAoetmyOTpYeiydTK499Kf1UtoveUANH5AkTUJsRE9wWXI5qe5VEyerHvx1iuWFo7cauA7t6RAsTUFaIdrGJtvvx/zD0KFBe91tE7Q9APO1c8qgR7XC+bCNW2F8wqkhhzfSPNGzxWKZZhmR0tdvadR0w0c6D1y3H0=; Subject: which better for me?session.query or session.execute? From: Mohsen Pahlevanzadeh To: "python-list@python.org" Date: Tue, 27 Aug 2013 22:24:35 +0430 Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.4.4-4+b1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - part7.royal-servers.com X-AntiAbuse: Original Domain - python.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - pahlevanzadeh.org X-Get-Message-Sender-Via: part7.royal-servers.com: authenticated_id: mohsen@pahlevanzadeh.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 41 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1377626096 news.xs4all.nl 15944 [2001:888:2000:d::a6]:60248 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:53081 Dear all, Suppose I want to write a function for better using SQLAlchemly dynamically with the following specification: 1. It get field names and values. 2. It get operators such as = , <> , like , between and so on. 3. It get logical operators such as and , or and not. 4. .... 5. .... I need it for update query ,select ,join and delete. I read the following stackoverflow link: SQLAlchemy Flask filter query to combine results from two models SQLAlchemy Query and_/or_ Issue sqlalchemy filter multiple columns How do I specify a relation in SQLAlchemy where one condition requires a column to be null? In sqlalchemy, how can I combine two queries by having a column entry identical? My Question: I neeed to write a string and concatenite above params, which are better? session.query or set of function such as update, delete and so on that run by execute function? You'll make me happy if answer in http://stackoverflow.com : http://stackoverflow.com/questions/18472314/which-better-session-query-or-session-execute-python-sqlalchemy Yours, Mohsen