test/unittest_compare.py
author Philippe Pepiot <philippe.pepiot@logilab.fr>
Wed, 06 Nov 2019 11:27:36 +0100
changeset 868 3ee87bec4482
parent 861 d5e1e2b627fc
permissions -rw-r--r--
Stop building python2 wheels and workaround broken py38 wheel This script is used to publish wheel binary packages to pypi. Since we're going to remove python2 support, stop generating wheels for python2. Also py38 is out and our wheel doesn't compile with py38 due to a bug of logilab-common. Waiting a fix, don't build wheel for py38. % docker run --rm -it quay.io/pypa/manylinux1_x86_64 ls -1A /opt/python cp27-cp27m cp27-cp27mu cp34-cp34m cp35-cp35m cp36-cp36m cp37-cp37m cp38-cp38

# copyright 2004-2010 LOGILAB S.A. (Paris, FRANCE), all rights reserved.
# contact http://www.logilab.fr/ -- mailto:contact@logilab.fr
#
# This file is part of rql.
#
# rql is free software: you can redistribute it and/or modify it under the
# terms of the GNU Lesser General Public License as published by the Free
# Software Foundation, either version 2.1 of the License, or (at your option)
# any later version.
#
# rql is distributed in the hope that it will be useful, but WITHOUT ANY
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
# A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more
# details.
#
# You should have received a copy of the GNU Lesser General Public License along
# with rql. If not, see <http://www.gnu.org/licenses/>.
from logilab.common.testlib import TestCase, SkipTest, unittest_main

from rql import RQLHelper
from unittest_analyze import RelationSchema, EntitySchema, DummySchema as BaseSchema


class DummySchema(BaseSchema):

    def __init__(self):
        super(DummySchema, self).__init__()
        for etype in ['Note', ]:
            self._types[etype] = EntitySchema(etype)
        relations = [('a_faire_par', (('Note', ('Person',)),)),
                     ('creation_date', (('Note', ('Date',)),)),
                     ]
        for rel_name, rel_ent in relations:
            self._relations[rel_name] = RelationSchema(rel_ent)
        self._relations['nom'] = self._relations['name']
        self._relations['prenom'] = self._relations['firstname']


class RQLCompareClassTest(TestCase):
    """ Compare RQL strings """
    @classmethod
    def setUpClass(cls):
        raise SkipTest('broken')

    def setUp(self):
        self.h = RQLHelper(DummySchema(), None)

    def _compareEquivalent(self, r1, r2):
        """fails if the RQL strings r1 and r2 are equivalent"""
        self.skipTest('broken')
        self.failUnless(self.h.compare(r1, r2),
                        'r1: %s\nr2: %s' % (r1, r2))

    def _compareNotEquivalent(self, r1, r2):
        """fails if the RQL strings r1 and r2 are not equivalent"""
        self.failIf(self.h.compare(r1, r2),
                    'r1: %s\nr2: %s' % (r1, r2))

    # equivalent queries ##################################################

    def test_same_request_simple(self):
        r = "Any X WHERE X is Note ;"
        self._compareEquivalent(r, r)

    def test_same_request_diff_names(self):
        r1 = "Any X ;"
        r2 = "Any Y ;"
        self._compareEquivalent(r1, r2)

    def test_same_request_diff_names_simple(self):
        r1 = "Any X WHERE X is Note ;"
        r2 = "Any Y WHERE Y is Note ;"
        self._compareEquivalent(r1, r2)

    def test_same_request_any(self):
        r1 = "Any X WHERE X is Note ;"
        r2 = "Note X ;"
        self._compareEquivalent(r1, r2)

    def test_same_request_any_diff_names(self):
        r1 = "Any X WHERE X is Note ;"
        r2 = "Note Y ;"
        self._compareEquivalent(r1, r2)

    def test_same_request_complex(self):
        r = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
             "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        self._compareEquivalent(r, r)

    def test_same_request_comma_and(self):
        r1 = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
              "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        r2 = ("Any N, N2 WHERE N is Note AND N2 is Note AND N a_faire_par P1 "
              "AND P1 nom 'jphc' AND N2 a_faire_par P2 AND P2 nom 'ocy' ;")
        self._compareEquivalent(r1, r2)

    def test_same_request_diff_names_complex(self):
        r1 = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
              "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        r2 = ("Any Y, X  WHERE X is Note, Y is Note,  X a_faire_par A1, "
              "A1 nom 'ocy',  Y a_faire_par A2,  A2 nom 'jphc' ;")
        self._compareEquivalent(r1, r2)

    def test_same_request_diff_order(self):
        r1 = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
              "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        r2 = ("Any N, N2 WHERE N2 is Note, N is Note, N a_faire_par P1, "
              "N2 a_faire_par P2, P2 nom 'ocy', P1 nom 'jphc' ;")
        self._compareEquivalent(r1, r2)

    def test_same_request_diff_order_diff_names(self):
        r1 = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
              "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        r2 = ("Any Y, X  WHERE X is Note, X a_faire_par P1, P1 nom 'ocy', "
              "Y is Note, Y a_faire_par P2, P2 nom 'jphc' ;")
        self._compareEquivalent(r1, r2)

    def test_same_request_with_comparison(self):
        r1 = "Note N WHERE N a_faire_par P, P nom 'jphc', K creation_date > today-10;"
        r2 = "Note K WHERE K a_faire_par Y, K creation_date > today-10, Y nom 'jphc';"
        self._compareEquivalent(r1, r2)

    def test_same_request_in_or(self):
        r1 = ("Note N WHERE N creation_date > today-10, N a_faire_par P, "
              "P nom 'jphc' or P  nom 'ludal';")
        r2 = "Note K WHERE K a_faire_par Y, K creation_date > today-10, Y nom in ('jphc', 'ludal');"
        self._compareEquivalent(r1, r2)

    def test_same_request_reverse_or(self):
        r1 = (
                "Note N WHERE N creation_date > today-10, N a_faire_par P, "
                "P nom 'jphc' or P nom 'ludal';"
             )
        r2 = (
                "Note N WHERE N creation_date > today-10, N a_faire_par P, "
                "P nom 'ludal' or P nom 'jphc';"
             )
        self._compareEquivalent(r1, r2)

    def test_same_request_reverse_or2(self):
        r1 = (
                "Note N WHERE N creation_date > today-10, N a_faire_par P, "
                "P prenom 'jphc' or P nom 'ludal';"
             )
        r2 = (
                "Note N WHERE N creation_date > today-10, N a_faire_par P, "
                "P nom 'ludal' or P prenom 'jphc';"
             )
        self._compareEquivalent(r1, r2)

    def test_same_request_duplicate_expr(self):
        r1 = "Note N WHERE N creation_date D, N creation_date D;"
        r2 = "Note N WHERE N creation_date D;"
        self._compareEquivalent(r1, r2)

    def test_same_request_not_in_or(self):
        r1 = (
                "Note K WHERE K a_faire_par Y, K creation_date > today-10, "
                "not Y nom in ('jphc', 'ludal');"
             )
        r2 = (
                "Note K WHERE K a_faire_par Y, K creation_date > today-10, "
                "not Y nom 'jphc' and not Y nom 'ludal';"
             )
        self._compareEquivalent(r1, r2)

    # non equivalent queries ##################################################

    def test_diff_request(self):
        r1 = ("Any N, N2 WHERE N is Note, N2 is Note, N a_faire_par P1, "
              "P1 nom 'jphc', N2 a_faire_par P2, P2 nom 'ocy' ;")
        r2 = "Any X WHERE X is Note ;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_and_or(self):
        r1 = ("Note N WHERE N creation_date > today-10, N a_faire_par P, "
              "P nom 'jphc' or P nom 'ludal';")
        r2 = ("Note N WHERE N creation_date > today-10, N a_faire_par P, "
              "P nom 'jphc', P nom 'ludal';")

        self._compareNotEquivalent(r1, r2)

    def test_diff_request_and_or2(self):
        r1 = ("Note N WHERE N creation_date > today-10, N a_faire_par P, "
              "P nom 'jphc' or P prenom 'ludal';")
        r2 = ("Note N WHERE N creation_date > today-10, N a_faire_par P, "
              "P nom 'jphc', P prenom 'ludal';")
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_non_selected_var(self):
        r1 = "Any X, D WHERE X is Note, X creation_date D ;"
        r2 = "Any X WHERE X is Note, X creation_date D ;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_aggregat(self):
        r1 = "Any X, D WHERE X is Note, X creation_date D ;"
        r2 = "Any X, MAX(D) WHERE X is Note, X creation_date D ;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_group(self):
        r1 = "Any X GROUPBY X WHERE X is Note;"
        r2 = "Any X WHERE X is Note;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_sort(self):
        r1 = "Any X ORDERBY X WHERE X is Note;"
        r2 = "Any X WHERE X is Note;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_not(self):
        r1 = "Any X WHERE NOT X is Note ;"
        r2 = "Any X WHERE X is Note;"
        self._compareNotEquivalent(r1, r2)

    def test_diff_request_not_in_or(self):
        r1 = ("Note K WHERE K a_faire_par Y, K creation_date > today-10, "
              "not Y nom in ('jphc', 'ludal');")
        r2 = ("Note K WHERE K a_faire_par Y, K creation_date > today-10, "
              "not Y nom 'jphc' or not Y nom 'ludal';")
        self._compareNotEquivalent(r1, r2)


if __name__ == '__main__':
    unittest_main()