PageRenderTime 43ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/historical/sqlfilters_test.py

https://bitbucket.org/lindenlab/apiary/
Python | 54 lines | 25 code | 5 blank | 24 comment | 1 complexity | 4db61a9fc9c54ec9ace78226ef2e3f9f MD5 | raw file
  1. #
  2. # $LicenseInfo:firstyear=2010&license=mit$
  3. #
  4. # Copyright (c) 2010, Linden Research, Inc.
  5. #
  6. # Permission is hereby granted, free of charge, to any person obtaining a copy
  7. # of this software and associated documentation files (the "Software"), to deal
  8. # in the Software without restriction, including without limitation the rights
  9. # to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
  10. # copies of the Software, and to permit persons to whom the Software is
  11. # furnished to do so, subject to the following conditions:
  12. #
  13. # The above copyright notice and this permission notice shall be included in
  14. # all copies or substantial portions of the Software.
  15. #
  16. # THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
  17. # IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
  18. # FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
  19. # AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
  20. # LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
  21. # OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
  22. # THE SOFTWARE.
  23. # $/LicenseInfo$
  24. #
  25. import re
  26. import unittest
  27. class TestREBuilding(unittest.TestCase):
  28. def testBasicPlan(self):
  29. q = re.compile(r'[^`.\w]`?(?:foo|bar|baz)`?(?:[^`.\w]|$)')
  30. self.assert_(q.search('FROM foo,'))
  31. self.assert_(q.search('FROM bar,'))
  32. self.assert_(q.search('FROM baz,'))
  33. self.assert_(not q.search('FROM moo,'))
  34. self.assert_(not q.search('FROM ffoo,'))
  35. self.assert_(not q.search('FROM bazz,'))
  36. self.assert_(q.search('FROM `foo`,'))
  37. self.assert_(q.search('FROM `bar`,'))
  38. self.assert_(q.search('FROM `baz`,'))
  39. self.assert_(not q.search('FROM `moo`,'))
  40. self.assert_(not q.search('FROM `ffoo`,'))
  41. self.assert_(not q.search('FROM `bazz`,'))
  42. self.assert_(q.search('FROM foo'))
  43. self.assert_(q.search('(foo as f'))
  44. self.assert_(not q.search('FROM schema.foo'))
  45. self.assert_(not q.search('FROM `schema`.`foo`'))
  46. self.assert_(not q.search('SELECT foo.col'))
  47. self.assert_(not q.search('SELECT `foo`.`col`'))
  48. if __name__ == '__main__':
  49. unittest.main()