oracle数据库49161,SQLAlchemy中的位运算符：使用Oracle数据库时出错

在不同的后端创建一个自定义运算符的示例：from sqlalchemy.ext.compiler import compiles

from sqlalchemy.sql.elements import ColumnElement, Visitable, Grouping

from sqlalchemy.sql.operators import custom_op, is_precedent

class BitwiseAnd(ColumnElement):

type = Integer()

operator = custom_op("&", precedence=6)

def __init__(self, left, right):

if not isinstance(left, Visitable):

left = bindparam("bitand", left, unique=True)

if not isinstance(right, Visitable):

right = bindparam("bitand", right, unique=True)

self.left = left

self.right = right

def self_group(self, against=None):

if is_precedent(self.operator, against):

return Grouping(self)

else:

return self

@compiles(BitwiseAnd)

def _compile_bitwise_and(element, compiler, **kwargs):

left = element.left.self_group(against=element.operator)

right = element.right.self_group(against=element.operator)

return compiler.process(element.operator(left, right))

@compiles(BitwiseAnd, "oracle")

def _compile_bitwise_and_oracle(element, compiler, **kwargs):

return compiler.process(func.BITAND(element.left, element.right))

q = select([BitwiseAnd(BitwiseAnd(1, 2), BitwiseAnd(3, 4))])

print(q.compile(dialect=mysql.dialect()))

# SELECT (%s & %s) & (%s & %s) AS anon_1

print(q.compile(dialect=oracle.dialect()))

# SELECT BITAND(BITAND(:bitand_1, :bitand_2), BITAND(:bitand_3, :bitand_4)) AS anon_1 FROM DUAL