from logilab.common.date import datetime2ticks

from cubicweb.devtools.testlib import CubicWebTC

from cubicweb.web import facet

class BaseFacetTC(CubicWebTC):

    def prepare_rqlst(self):

        req = self.request()

        rset = self.execute('CWUser X')

        rqlst = rset.syntax_tree().copy()

        filtered_variable, baserql = facet.init_facets(rset, rqlst.children[0])

        self.assertEqual(filtered_variable.name, 'X')

        self.assertEqual(baserql, 'Any X WHERE X is CWUser')

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        return req, rset, rqlst, filtered_variable

    def _in_group_facet(self, cls=facet.RelationFacet, no_relation=False):

        req, rset, rqlst, filtered_variable = self.prepare_rqlst()

        cls.no_relation = no_relation

        f = cls(req, rset=rset, select=rqlst.children[0],

                filtered_variable=filtered_variable)

        f.__regid__ = 'in_group'

        f.rtype = 'in_group'

        f.role = 'subject'

        f.target_attr = 'name'

        guests, managers = [eid for eid, in self.execute('CWGroup G ORDERBY GN '

                                                         'WHERE G name GN, G name IN ("guests", "managers")')]

        groups = [eid for eid, in self.execute('CWGroup G ORDERBY GN '

                                               'WHERE G name GN, G name IN ("guests", "managers")')]

        return f, groups

    def test_relation_simple(self):

        f, (guests, managers) = self._in_group_facet()

        self.assertEqual(f.vocabulary(),

                      [(u'guests', guests), (u'managers', managers)])

        # ensure rqlst is left unmodified

        self.assertEqual(f.select.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        #rqlst = rset.syntax_tree()

        self.assertEqual(f.possible_values(),

                          [str(guests), str(managers)])

        # ensure rqlst is left unmodified

        self.assertEqual(f.select.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        f._cw.form[f.__regid__] = str(guests)

        f.add_rql_restrictions()

        # selection is cluttered because rqlst has been prepared for facet (it

        # is not in real life)

        self.assertEqual(f.select.as_string(),

    def test_relation_optional_rel(self):

        req = self.request()

        rset = self.execute('Any X,GROUP_CONCAT(GN) GROUPBY X '

                            'WHERE X in_group G?, G name GN, NOT G name "users"')

        rqlst = rset.syntax_tree().copy()

        select = rqlst.children[0]

        filtered_variable, baserql = facet.init_facets(rset, select)

        f = facet.RelationFacet(req, rset=rset,

                                select=select,

                                filtered_variable=filtered_variable)

        f.rtype = 'in_group'

        f.role = 'subject'

        f.target_attr = 'name'

        guests, managers = [eid for eid, in self.execute('CWGroup G ORDERBY GN '

                                                         'WHERE G name GN, G name IN ("guests", "managers")')]

        self.assertEqual(f.vocabulary(),

                          [(u'guests', guests), (u'managers', managers)])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X in_group G?, G name GN, NOT G name "users"')

        #rqlst = rset.syntax_tree()

        self.assertEqual(sorted(f.possible_values()),

                          [str(guests), str(managers)])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X in_group G?, G name GN, NOT G name "users"')

        req.form[f.__regid__] = str(guests)

        f.add_rql_restrictions()

        # selection is cluttered because rqlst has been prepared for facet (it

        # is not in real life)

        self.assertEqual(f.select.as_string(),

                          'DISTINCT Any  WHERE X in_group G?, G name GN, NOT G name "users", X in_group D, D eid %s' % guests)

    def test_relation_no_relation_1(self):

        f, (guests, managers) = self._in_group_facet(no_relation=True)

        self.assertEqual(f.vocabulary(),

                          [(u'guests', guests), (u'managers', managers)])

        self.assertEqual(f.possible_values(),

                          [str(guests), str(managers)])

        f._cw.create_entity('CWUser', login=u'hop', upassword='toto')

        self.assertEqual(f.vocabulary(),

                          [(u'<no relation>', ''), (u'guests', guests), (u'managers', managers)])

        self.assertEqual(f.possible_values(),

                          [str(guests), str(managers), ''])

        f._cw.form[f.__regid__] = ''

        f.add_rql_restrictions()

        self.assertEqual(f.select.as_string(),

                          'DISTINCT Any  WHERE X is CWUser, NOT X in_group G')

    def test_relation_no_relation_2(self):

        f, (guests, managers) = self._in_group_facet(no_relation=True)

        f._cw.form[f.__regid__] = ['', guests]

        f.select.save_state()

        f.add_rql_restrictions()

        self.assertEqual(f.select.as_string(),

                          'DISTINCT Any  WHERE X is CWUser, (NOT X in_group B) OR (X in_group A, A eid %s)' % guests)

        f.select.recover()

        self.assertEqual(f.select.as_string(),

                          'DISTINCT Any  WHERE X is CWUser')

    def test_relationattribute(self):

        f, (guests, managers) = self._in_group_facet(cls=facet.RelationAttributeFacet)

        self.assertEqual(f.vocabulary(),

                          [(u'guests', u'guests'), (u'managers', u'managers')])

        # ensure rqlst is left unmodified

        self.assertEqual(f.select.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        #rqlst = rset.syntax_tree()

        self.assertEqual(f.possible_values(),

                          ['guests', 'managers'])

        # ensure rqlst is left unmodified

        self.assertEqual(f.select.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        f._cw.form[f.__regid__] = 'guests'

        f.add_rql_restrictions()

        # selection is cluttered because rqlst has been prepared for facet (it

        # is not in real life)

        self.assertEqual(f.select.as_string(),

                          "DISTINCT Any  WHERE X is CWUser, X in_group E, E name 'guests'")

    def test_daterange(self):

        req, rset, rqlst, filtered_variable = self.prepare_rqlst()

        f = facet.DateRangeFacet(req, rset=rset,

                                 select=rqlst.children[0],

                                 filtered_variable=filtered_variable)

        f.rtype = 'creation_date'

        dates = self.execute('Any CD ORDERBY CD WHERE X is CWUser, X creation_date CD')

        self.assertEqual(f.vocabulary(),

                          [(str(dates[0][0]), dates[0][0]),

                           (str(dates[1][0]), dates[1][0])])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        #rqlst = rset.syntax_tree()

        self.assertEqual(f.possible_values(),

                          [str(dates[0][0]), str(dates[1][0])])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        req.form['%s_inf' % f.__regid__] = str(datetime2ticks(dates[0][0]))

        req.form['%s_sup' % f.__regid__] = str(datetime2ticks(dates[0][0]))

        f.add_rql_restrictions()

        # selection is cluttered because rqlst has been prepared for facet (it

        # is not in real life)

        self.assertEqual(f.select.as_string(),

                          'DISTINCT Any  WHERE X is CWUser, X creation_date >= "%s", '

                         'X creation_date <= "%s"'

                         % (dates[0][0].strftime('%Y/%m/%d'),

                            dates[0][0].strftime('%Y/%m/%d')))

    def test_attribute(self):

        req, rset, rqlst, filtered_variable = self.prepare_rqlst()

        f = facet.AttributeFacet(req, rset=rset,

                                 select=rqlst.children[0],

                                 filtered_variable=filtered_variable)

        f.rtype = 'login'

        self.assertEqual(f.vocabulary(),

                          [(u'admin', u'admin'), (u'anon', u'anon')])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        #rqlst = rset.syntax_tree()

        self.assertEqual(f.possible_values(),

                          ['admin', 'anon'])

        # ensure rqlst is left unmodified

        self.assertEqual(rqlst.as_string(), 'DISTINCT Any  WHERE X is CWUser')

        req.form[f.__regid__] = 'admin'

        f.add_rql_restrictions()

        # selection is cluttered because rqlst has been prepared for facet (it

        # is not in real life)

        self.assertEqual(f.select.as_string(),

                          "DISTINCT Any  WHERE X is CWUser, X login 'admin'")

if __name__ == '__main__':

    from logilab.common.testlib import unittest_main

    unittest_main()