Python extract_cached_query_ids示例

示例#1

 def test_finds_queries_with_whitespace_characters(self):
     query = "SELECT * FROM    cached_query_123 a JOIN\tcached_query_4566 b ON a.id=b.parent_id JOIN\r\ncached_query_78 c ON b.id=c.parent_id"
     self.assertEqual([123, 4566, 78], extract_cached_query_ids(query))

示例#2

 def test_finds_queries_to_load(self):
     query = "SELECT * FROM cached_query_123"
     self.assertEqual([123], extract_cached_query_ids(query))

示例#3

 def test_finds_queries_in_joins(self):
     query = "SELECT * FROM cached_query_123 JOIN cached_query_4566"
     self.assertEqual([123, 4566], extract_cached_query_ids(query))

示例#4

 def test_works_with_simple_query(self):
     query = "SELECT 1"
     self.assertEqual([], extract_cached_query_ids(query))

示例#5

文件： test_query_results.py 项目： jonyboy2000/redash

 def test_finds_queries_with_whitespace_characters(self):
     query = "SELECT * FROM    cached_query_123 a JOIN\tcached_query_4566 b ON a.id=b.parent_id JOIN\r\ncached_query_78 c ON b.id=c.parent_id"
     self.assertEquals([123, 4566, 78], extract_cached_query_ids(query))

示例#6

文件： test_query_results.py 项目： jonyboy2000/redash

 def test_finds_queries_in_joins(self):
     query = "SELECT * FROM cached_query_123 JOIN cached_query_4566"
     self.assertEquals([123, 4566], extract_cached_query_ids(query))

示例#7

文件： test_query_results.py 项目： jonyboy2000/redash

 def test_finds_queries_to_load(self):
     query = "SELECT * FROM cached_query_123"
     self.assertEquals([123], extract_cached_query_ids(query))

示例#8

文件： test_query_results.py 项目： jonyboy2000/redash

 def test_works_with_simple_query(self):
     query = "SELECT 1"
     self.assertEquals([], extract_cached_query_ids(query))