Python param Examples

Example #1

def test_build_set_prepared():
    gen = build_set(
        OrderedDict([
            ('custom_param', param('myparam')),
            ('auto_param', autoparam),
        ]))
    eq_(gen, '"custom_param"=%(myparam)s, "auto_param"=%(auto_param)s')

Example #2

File: test_query.py Project: galacticsurfer/mosql

def test_select_param():
    gen = select('table', OrderedDict([
        ('custom_param', param('my_param')), ('auto_param', autoparam),
        ('using_alias', ___),
    ]))
    exp = (
        'SELECT * FROM "table" WHERE "custom_param" = %(my_param)s '
        'AND "auto_param" = %(auto_param)s AND "using_alias" = %(using_alias)s'
    )
    eq_(gen, exp)

Example #3

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)

Example #4

File: test_sqlite.py Project: victorneo/mosql

    def test_param_query(self):

        with self.db as cur:
            cur.execute(
                select(
                    'person',
                    {'person_id': param('person_id')}
                ),
                {'person_id': 'mosky'}
            )
            self.db._conn.rollback()

Example #5

def test_select_param():
    gen = select(
        'table',
        OrderedDict([
            ('custom_param', param('my_param')),
            ('auto_param', autoparam),
            ('using_alias', ___),
        ]))
    exp = (
        'SELECT * FROM "table" WHERE "custom_param" = %(my_param)s '
        'AND "auto_param" = %(auto_param)s AND "using_alias" = %(using_alias)s'
    )
    eq_(gen, exp)

Example #6

File: test_sqlite.py Project: taipeipy/mosql

    def test_param_query(self):

        with self.db as cur:
            cur.execute(select("person", {"person_id": param("person_id")}), {"person_id": "mosky"})
            self.db._conn.rollback()

Example #7

File: test_encoding.py Project: galacticsurfer/mosql

 def test_param_repr():
     eq_(repr(param('Mosky')), "param('Mosky')")

Example #8

File: test_util.py Project: taipeipy/mosql

def test_build_set_prepared():
    gen = build_set(OrderedDict([("custom_param", param("myparam")), ("auto_param", autoparam)]))
    eq_(gen, '"custom_param"=%(myparam)s, "auto_param"=%(auto_param)s')

Example #9

File: test_util.py Project: 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)

Example #10

    def test_param_query(self):

        with self.db as cur:
            cur.execute(select('person', {'person_id': param('person_id')}),
                        {'person_id': 'mosky'})
            self.db._conn.rollback()

Example #11

 def test_param_repr():
     eq_(repr(param('Mosky')), "param('Mosky')")