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'
)
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'
)
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')