def test_get_run_count(self):
q = SimpleQueryFactory()
assert q.get_run_count() == 0
expected = 4
for _ in range(0, expected):
q.log()
assert q.get_run_count() == expected
def test_query_logs_final_sql(self):
q = SimpleQueryFactory(sql="select '$$foo$$';")
q.params = {'foo': 'bar'}
q.log(None)
assert QueryLog.objects.count() == 1
log = QueryLog.objects.first()
assert log.sql == "select 'bar';"
def test_avg_duration(self):
q = SimpleQueryFactory()
assert q.avg_duration() is None
expected = 2.5
ql = q.log()
ql.duration = 2
ql.save()
ql = q.log()
ql.duration = 3
ql.save()
assert q.avg_duration() == expected
def test_query_log(self):
assert QueryLog.objects.count() == 0
q = SimpleQueryFactory(connection='Alt')
q.log(None)
assert QueryLog.objects.count() == 1
log = QueryLog.objects.first()
assert log.run_by_user is None
assert log.query == q
assert log.is_playground is False
assert log.connection == q.connection
def test_run_count(self, user, client):
q = SimpleQueryFactory(title='foo - bar1', created_by_user=user)
for _ in range(0, 4):
q.log()
resp = client.get(reverse("explorer:list_queries"))
assert '4' in resp.content.decode(resp.charset)