def test_parsed_rendered_complex_set(self): # something of a functional test, as we use nvSQL to get parsed. from Shared.DC.ZRDB.DA import nvSQL template = nvSQL(UPDATE_EXAMPLE) mapping = {} mapping['nick_name'] = 'Goofy' mapping['home_town'] = 'Orlando' mapping['sql_quote__'] = _sql_quote rendered = template(None, mapping) self.assertEqual( rendered, 'update actors\n' 'set\nnick_name = "Goofy" , home_town = "Orlando"\n')
def test_parsed_rendered_complex_set(self): # something of a functional test, as we use nvSQL to get parsed. from Shared.DC.ZRDB.DA import nvSQL template = nvSQL(UPDATE_EXAMPLE) mapping = {} mapping['nick_name'] = 'Goofy' mapping['home_town'] = 'Orlando' mapping['sql_quote__'] = _sql_quote rendered = template(None, mapping) self.assertEqual(rendered, 'update actors\n' 'set\nnick_name = "Goofy" , home_town = "Orlando"\n' )
def test_parsed_rendered_complex_where(self): # something of a functional test, as we use nvSQL to get parsed. from Shared.DC.ZRDB.DA import nvSQL template = nvSQL(WHERE_EXAMPLE) mapping = {} mapping['name'] = 'Goofy' mapping['home_town'] = 'Orlando' mapping['sql_quote__'] = _sql_quote rendered = template(None, mapping) self.assertEqual( rendered, 'select * from actors\n' 'where\n' '((nick_name = "Goofy"\n' ' or first_name = "Goofy"\n)\n' ' and home_town = "Orlando"\n)\n')
def test_parsed_rendered_complex_where(self): # something of a functional test, as we use nvSQL to get parsed. from Shared.DC.ZRDB.DA import nvSQL template = nvSQL(WHERE_EXAMPLE) mapping = {} mapping['name'] = 'Goofy' mapping['home_town'] = 'Orlando' mapping['sql_quote__'] = _sql_quote rendered = template(None, mapping) self.assertEqual(rendered, 'select * from actors\n' 'where\n' '((nick_name = "Goofy"\n' ' or first_name = "Goofy"\n)\n' ' and home_town = "Orlando"\n)\n' )