SQLAlchemy （三）---使用操作连接符

建立Python文件alchemy10.py，代码如下：

#!/usr/bin/ python#encoding:utf8from sqlalchemy import *from sqlalchemy.orm import *#alchemy5实现创建数据库表格功能from alchemy5 import *#功能：测试操作连接#这里的连接指条件查询的时候，逻辑运算符的连接，即 and or 和 notprint '#'*15union = and_(user.c.name.like('%j'),             user.c.id == address.c.user_id,        or_(address.c.email == '[e-mail]',            address.c.email == '[e-mail]'),        not_(user.c.id>5)        )print unionprint '#'*15#######################完整例子#########################3se_sql = [(user.c.fullname +", " + address.c.email).label('title')]wh_sql = and_(              user.c.id == address.c.user_id,              user.c.name.between('m', 'z'),              or_(                  address.c.email.like('[e-mail]'),                  address.c.email.like('[e-mail]')              )         )#print wh_sqls = select(se_sql).where(wh_sql) #第一步 select()#print sr = conn.execute(s) #第二步 execute()result = r.fetchall()   #第三步 fetchall()取结果print resultprint '#'*15