Beispiel #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'
     )
Beispiel #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'
     )
 def test_render_explain_with_analyze(
     self,
     session,
     assert_startswith,
     Article
 ):
     assert_startswith(
         explain(session.query(Article), analyze=True),
         'EXPLAIN (ANALYZE true) SELECT'
     )
Beispiel #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'
     )
 def test_verbose(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), verbose=True),
         'EXPLAIN (VERBOSE true) SELECT')
 def test_format(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), format='json'),
         'EXPLAIN (FORMAT json) SELECT')
 def test_with_string_as_stmt_param(self, assert_startswith):
     assert_startswith(explain(sa.text('SELECT 1 FROM article')),
                       'EXPLAIN SELECT')
 def test_buffers(self):
     self.assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, buffers=True),
         'EXPLAIN (ANALYZE true, BUFFERS true) SELECT')
 def test_timing(self):
     self.assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, timing=False),
         'EXPLAIN (ANALYZE true, TIMING false) SELECT')
 def test_with_string_as_stmt_param(self):
     self.assert_startswith(explain('SELECT 1 FROM article'),
                            'EXPLAIN SELECT')
 def test_timing(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, timing=False),
         'EXPLAIN (ANALYZE true, TIMING false) SELECT'
     )
 def test_format(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', format='json'),
         'EXPLAIN (FORMAT json) SELECT'
     )
 def test_with_string_as_stmt_param(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article'),
         'EXPLAIN SELECT'
     )
 def test_render_explain(self, session, assert_startswith, Article):
     assert_startswith(
         explain(session.query(Article)),
         'EXPLAIN SELECT'
     )
 def test_render_explain(self):
     self.assert_startswith(
         explain(self.session.query(self.Article)),
         'EXPLAIN SELECT'
     )
 def test_costs(self, assert_startswith):
     assert_startswith(
         explain(sa.text('SELECT 1 FROM article'), costs=False),
         'EXPLAIN (COSTS false) SELECT')
 def test_render_explain(self):
     self.assert_startswith(explain(self.session.query(self.Article)),
                            'EXPLAIN SELECT')
 def test_verbose(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', verbose=True),
         'EXPLAIN (VERBOSE true) SELECT'
     )
 def test_format(self):
     self.assert_startswith(explain('SELECT 1 FROM article', format='json'),
                            'EXPLAIN (FORMAT json) SELECT')
 def test_buffers(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', analyze=True, buffers=True),
         'EXPLAIN (ANALYZE true, BUFFERS true) SELECT'
     )
 def test_verbose(self):
     self.assert_startswith(explain('SELECT 1 FROM article', verbose=True),
                            'EXPLAIN (VERBOSE true) SELECT')
 def test_costs(self, assert_startswith):
     assert_startswith(
         explain('SELECT 1 FROM article', costs=False),
         'EXPLAIN (COSTS false) SELECT'
     )
 def test_costs(self):
     self.assert_startswith(explain('SELECT 1 FROM article', costs=False),
                            'EXPLAIN (COSTS false) SELECT')
 def test_render_explain(self, session, assert_startswith, Article):
     assert_startswith(explain(session.query(Article)), 'EXPLAIN SELECT')