changeset 5b990ac7f2d1 in modules/currency:default
details: https://hg.tryton.org/modules/currency?cmd=changeset&node=5b990ac7f2d1
description:
        Support window functions with SQLite backend

        issue7703
        review364231002
diffstat:

 tests/test_currency.py |  5 +++++
 1 files changed, 5 insertions(+), 0 deletions(-)

diffs (29 lines):

diff -r 63fe6663141d -r 5b990ac7f2d1 tests/test_currency.py
--- a/tests/test_currency.py    Mon Nov 01 17:02:13 2021 +0100
+++ b/tests/test_currency.py    Mon Nov 08 19:30:15 2021 +0100
@@ -5,6 +5,7 @@
 import unittest
 from decimal import Decimal
 import trytond.tests.test_tryton
+from trytond import backend
 from trytond.transaction import Transaction
 from trytond.tests.test_tryton import ModuleTestCase, with_transaction
 from trytond.tests.test_tryton import doctest_teardown
@@ -338,6 +339,7 @@
         "Test currency rate SQL"
         pool = Pool()
         Currency = pool.get('currency.currency')
+        Rate = pool.get('currency.currency.rate')
         transaction = Transaction()
         cursor = transaction.connection.cursor()
         date = datetime.date
@@ -355,6 +357,9 @@
             add_currency_rate(cu2, rate, date_)
 
         query = Currency.currency_rate_sql()
+        if backend.name == 'sqlite':
+            query.columns[-1].output_name += (
+                ' [%s]' % Rate.date.sql_type().base)
         cursor.execute(*query)
         data = set(cursor)
         result = {

Reply via email to