Python build_where示例

示例#1

def test_build_where_operator():
    gen = build_where(
        OrderedDict([
            ('detail_id', 1),
            (('age', '>='), 20),
            ('created', date(2013, 4, 16)),
        ]))
    eq_(gen, '"detail_id" = 1 AND "age" >= 20 AND "created" = \'2013-04-16\'')

示例#2

def test_build_where_prepared():
    gen = build_where(
        OrderedDict([
            ('custom_param', param('my_param')),
            ('auto_param', autoparam),
            ('using_alias', ___),
        ]))
    exp = ('"custom_param" = %(my_param)s AND "auto_param" = %(auto_param)s '
           'AND "using_alias" = %(using_alias)s')
    eq_(gen, exp)

示例#3

文件： test_util.py 项目： taipeipy/mosql

def test_build_where_prepared():
    gen = build_where(
        OrderedDict([("custom_param", param("my_param")), ("auto_param", autoparam), ("using_alias", ___)])
    )
    exp = '"custom_param" = %(my_param)s AND "auto_param" = %(auto_param)s ' 'AND "using_alias" = %(using_alias)s'
    eq_(gen, exp)

示例#4

文件： test_util.py 项目： taipeipy/mosql

def test_build_where_operator():
    gen = build_where(OrderedDict([("detail_id", 1), (("age", ">="), 20), ("created", date(2013, 4, 16))]))
    eq_(gen, '"detail_id" = 1 AND "age" >= 20 AND "created" = \'2013-04-16\'')