예제 #1
0
 def test_buffers(self, assert_startswith):
     assert_startswith(
         explain(
             sa.text('SELECT 1 FROM article'),
             analyze=True,
             buffers=True
         ),
         'EXPLAIN (ANALYZE true, BUFFERS true) SELECT'
     )
예제 #2
0
 def test_timing(self, assert_startswith):
     assert_startswith(
         explain(
             sa.text('SELECT 1 FROM article'),
             analyze=True,
             timing=False
         ),
         'EXPLAIN (ANALYZE true, TIMING false) SELECT'
     )
예제 #3
0
 def test_render_explain_with_analyze(
     self,
     session,
     assert_startswith,
     Article
 ):
     assert_startswith(
         explain(session.query(Article), analyze=True),
         'EXPLAIN (ANALYZE true) SELECT'
     )
예제 #4
0
 def test_render_explain_with_analyze(
     self,
     session,
     assert_startswith,
     Article
 ):
     assert_startswith(
         explain(session.query(Article), analyze=True),
         'EXPLAIN (ANALYZE true) SELECT'
     )
예제 #5
0
 def test_verbose(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), verbose=True),
         'EXPLAIN (VERBOSE true) SELECT')
예제 #6
0
 def test_format(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), format='json'),
         'EXPLAIN (FORMAT json) SELECT')
예제 #7
0
 def test_with_string_as_stmt_param(self, assert_startswith):
     assert_startswith(explain(sa.text('SELECT 1 FROM article')),
                       'EXPLAIN SELECT')
예제 #8
0
 def test_buffers(self):
     self.assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, buffers=True),
         'EXPLAIN (ANALYZE true, BUFFERS true) SELECT')
예제 #9
0
 def test_timing(self):
     self.assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, timing=False),
         'EXPLAIN (ANALYZE true, TIMING false) SELECT')
예제 #10
0
 def test_with_string_as_stmt_param(self):
     self.assert_startswith(explain('SELECT 1 FROM article'),
                            'EXPLAIN SELECT')
예제 #11
0
 def test_timing(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, timing=False),
         'EXPLAIN (ANALYZE true, TIMING false) SELECT'
     )
예제 #12
0
 def test_format(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', format='json'),
         'EXPLAIN (FORMAT json) SELECT'
     )
예제 #13
0
 def test_with_string_as_stmt_param(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article'),
         'EXPLAIN SELECT'
     )
예제 #14
0
 def test_render_explain(self, session, assert_startswith, Article):
     assert_startswith(
         explain(session.query(Article)),
         'EXPLAIN SELECT'
     )
예제 #15
0
 def test_render_explain(self):
     self.assert_startswith(
         explain(self.session.query(self.Article)),
         'EXPLAIN SELECT'
     )
예제 #16
0
 def test_costs(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), costs=False),
         'EXPLAIN (COSTS false) SELECT')
예제 #17
0
 def test_render_explain(self):
     self.assert_startswith(explain(self.session.query(self.Article)),
                            'EXPLAIN SELECT')
예제 #18
0
 def test_verbose(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', verbose=True),
         'EXPLAIN (VERBOSE true) SELECT'
     )
예제 #19
0
 def test_format(self):
     self.assert_startswith(explain('SELECT 1 FROM article', format='json'),
                            'EXPLAIN (FORMAT json) SELECT')
예제 #20
0
 def test_buffers(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, buffers=True),
         'EXPLAIN (ANALYZE true, BUFFERS true) SELECT'
     )
예제 #21
0
 def test_verbose(self):
     self.assert_startswith(explain('SELECT 1 FROM article', verbose=True),
                            'EXPLAIN (VERBOSE true) SELECT')
예제 #22
0
 def test_costs(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', costs=False),
         'EXPLAIN (COSTS false) SELECT'
     )
예제 #23
0
 def test_costs(self):
     self.assert_startswith(explain('SELECT 1 FROM article', costs=False),
                            'EXPLAIN (COSTS false) SELECT')
예제 #24
0
 def test_render_explain(self, session, assert_startswith, Article):
     assert_startswith(explain(session.query(Article)), 'EXPLAIN SELECT')