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_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'])
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'])
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'])
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)