From deec15a9a613558b35024637d02d348a8a95deb1 Mon Sep 17 00:00:00 2001 From: Adam Johnson Date: Fri, 17 Dec 2021 07:50:27 +0000 Subject: Refs #33355 -- Made trunc functions raise ValueError on invalid lookups on SQLite. Co-Authored-By: Nick Pope --- tests/backends/sqlite/test_functions.py | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 tests/backends/sqlite/test_functions.py (limited to 'tests/backends/sqlite') diff --git a/tests/backends/sqlite/test_functions.py b/tests/backends/sqlite/test_functions.py new file mode 100644 index 0000000000..0659717799 --- /dev/null +++ b/tests/backends/sqlite/test_functions.py @@ -0,0 +1,21 @@ +from django.db.backends.sqlite3._functions import ( + _sqlite_date_trunc, _sqlite_datetime_trunc, _sqlite_time_trunc, +) +from django.test import SimpleTestCase + + +class FunctionTests(SimpleTestCase): + def test_sqlite_date_trunc(self): + msg = "Unsupported lookup type: 'unknown-lookup'" + with self.assertRaisesMessage(ValueError, msg): + _sqlite_date_trunc('unknown-lookup', '2005-08-11', None, None) + + def test_sqlite_datetime_trunc(self): + msg = "Unsupported lookup type: 'unknown-lookup'" + with self.assertRaisesMessage(ValueError, msg): + _sqlite_datetime_trunc('unknown-lookup', '2005-08-11 1:00:00', None, None) + + def test_sqlite_time_trunc(self): + msg = "Unsupported lookup type: 'unknown-lookup'" + with self.assertRaisesMessage(ValueError, msg): + _sqlite_time_trunc('unknown-lookup', '2005-08-11 1:00:00', None, None) -- cgit v1.3