Beispiel #1
0
    def test_convert_named_params_none_required(self):
        query = "SELECT * FROM people"

        (new_query, param_index,
         args_found) = convert_named_query_params(query)
        self.assertEquals(query, new_query)
        self.assertEquals(0, len(param_index.keys()))
    def test_convert_named_query_params(self):
        query = "INSERT INTO people(id, name, phone) VALUES(:id, :name, :phone)"
        expected_query = \
            "INSERT INTO people(id, name, phone) VALUES(%(id)s, %(name)s, %(phone)s)"

        new_query = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
    def test_convert_named_params_multiple_uses(self):
        query = "INSERT INTO people(a, b, c, d) VALUES(:a, :b, :a, :b)"
        expected_query = \
                "INSERT INTO people(a, b, c, d) VALUES(%(a)s, %(b)s, %(a)s, %(b)s)"

        new_query = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
    def test_convert_named_query_params(self):
        query = "INSERT INTO people(id, name, phone) VALUES(:id, :name, :phone)"
        expected_query = \
                "INSERT INTO people(id, name, phone) VALUES(%(id)s, %(name)s, %(phone)s)"

        new_query = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
    def test_convert_named_params_multiple_uses(self):
        query = "INSERT INTO people(a, b, c, d) VALUES(:a, :b, :a, :b)"
        expected_query = \
            "INSERT INTO people(a, b, c, d) VALUES(%(a)s, %(b)s, %(a)s, %(b)s)"

        new_query = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
Beispiel #6
0
 def test_date_format_conversion_issue(self):
     query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=:id, name=:name"
     expected_query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=$1, name=$2"
     (new_query, param_index, args_found) = convert_named_query_params(query)
     self.assertEquals(expected_query, new_query)
     self.assertEquals(2, args_found)
     self.assertEquals(2, len(param_index.keys()))
     self.assertEquals([1], param_index['id'])
     self.assertEquals([2], param_index['name'])
Beispiel #7
0
 def test_date_format_conversion_issue(self):
     query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=:id, name=:name"
     expected_query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=$1, name=$2"
     (new_query, param_index,
      args_found) = convert_named_query_params(query)
     self.assertEquals(expected_query, new_query)
     self.assertEquals(2, args_found)
     self.assertEquals(2, len(param_index.keys()))
     self.assertEquals([1], param_index['id'])
     self.assertEquals([2], param_index['name'])
Beispiel #8
0
    def test_convert_named_params_multiple_uses(self):
        query = "INSERT INTO people(a, b, c, d) VALUES(:a, :b, :a, :b)"
        expected_query = \
                "INSERT INTO people(a, b, c, d) VALUES($1, $2, $3, $4)"

        (new_query, param_index, args_found) = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
        self.assertEquals(4, args_found)
        self.assertEquals(2, len(param_index.keys()))
        self.assertEquals([1, 3], param_index['a'])
        self.assertEquals([2, 4], param_index['b'])
Beispiel #9
0
    def test_convert_named_params_multiple_uses(self):
        query = "INSERT INTO people(a, b, c, d) VALUES(:a, :b, :a, :b)"
        expected_query = \
                "INSERT INTO people(a, b, c, d) VALUES($1, $2, $3, $4)"

        (new_query, param_index,
         args_found) = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
        self.assertEquals(4, args_found)
        self.assertEquals(2, len(param_index.keys()))
        self.assertEquals([1, 3], param_index['a'])
        self.assertEquals([2, 4], param_index['b'])
Beispiel #10
0
    def test_convert_named_query_params(self):
        query = "INSERT INTO people(id, name, phone) VALUES(:id, :name, :phone)"
        expected_query = \
                "INSERT INTO people(id, name, phone) VALUES($1, $2, $3)"

        (new_query, param_index, args_found) = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
        self.assertEquals(3, len(param_index.keys()))
        self.assertEquals(3, args_found)
        self.assertEquals([1], param_index['id'])
        self.assertEquals([2], param_index['name'])
        self.assertEquals([3], param_index['phone'])
Beispiel #11
0
    def test_convert_named_query_params(self):
        query = "INSERT INTO people(id, name, phone) VALUES(:id, :name, :phone)"
        expected_query = \
                "INSERT INTO people(id, name, phone) VALUES($1, $2, $3)"

        (new_query, param_index,
         args_found) = convert_named_query_params(query)
        self.assertEquals(expected_query, new_query)
        self.assertEquals(3, len(param_index.keys()))
        self.assertEquals(3, args_found)
        self.assertEquals([1], param_index['id'])
        self.assertEquals([2], param_index['name'])
        self.assertEquals([3], param_index['phone'])
Beispiel #12
0
 def test_date_format_conversion_issue(self):
     query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=:id, name=:name"
     expected_query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=%(id)s, name=%(name)s"
     new_query = convert_named_query_params(query)
     self.assertEquals(expected_query, new_query)
Beispiel #13
0
    def test_convert_named_params_none_required(self):
        query = "SELECT * FROM people"

        new_query = convert_named_query_params(query)
        self.assertEquals(query, new_query)
 def test_date_format_conversion_issue(self):
     query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=:id, name=:name"
     expected_query = "SELECT TO_CHAR(issued, 'YYYY-MM-DD HH24:MI:SS') issued FROM rhnSatelliteCert WHERE id=%(id)s, name=%(name)s"
     new_query = convert_named_query_params(query)
     self.assertEquals(expected_query, new_query)
    def test_convert_named_params_none_required(self):
        query = "SELECT * FROM people"

        new_query = convert_named_query_params(query)
        self.assertEquals(query, new_query)
Beispiel #16
0
    def test_convert_named_params_none_required(self):
        query = "SELECT * FROM people"

        (new_query, param_index, args_found) = convert_named_query_params(query)
        self.assertEquals(query, new_query)
        self.assertEquals(0, len(param_index.keys()))