"""unit tests for schema rql (de)serialization

:license: GNU Lesser General Public License, v2.1 - http://www.gnu.org/licenses

"""

import sys

from cStringIO import StringIO

from logilab.common.testlib import TestCase, unittest_main

from cubicweb.schema import CubicWebSchemaLoader

from cubicweb.devtools import TestServerConfiguration

loader = CubicWebSchemaLoader()

config = TestServerConfiguration('data')

config.bootstrap_cubes()

schema = loader.load(config)

from cubicweb.server.schemaserial import *

from cubicweb.server.schemaserial import _erperms2rql as erperms2rql

cstrtypemap = {'RQLConstraint': 'RQLConstraint_eid',

               'SizeConstraint': 'SizeConstraint_eid',

               'StaticVocabularyConstraint': 'StaticVocabularyConstraint_eid',

               'FormatConstraint': 'FormatConstraint_eid',

               }

class Schema2RQLTC(TestCase):

    def test_eschema2rql1(self):

        self.assertListEquals(list(eschema2rql(schema.eschema('CWAttribute'))),

                              [

            ('INSERT CWEType X: X description %(description)s,X final %(final)s,X name %(name)s',

             {'description': u'define a final relation: link a final relation type from a non final entity to a final entity type. used to build the instance schema',

              'name': u'CWAttribute', 'final': False})

            ])

    def test_eschema2rql2(self):

        self.assertListEquals(list(eschema2rql(schema.eschema('String'))), [

                ('INSERT CWEType X: X description %(description)s,X final %(final)s,X name %(name)s',

                 {'description': u'', 'final': True, 'name': u'String'})])

    def test_eschema2rql_specialization(self):

        # x: None since eschema.eid are None

        self.assertListEquals(sorted(specialize2rql(schema)),

                              [('SET X specializes ET WHERE X eid %(x)s, ET eid %(et)s',

                                {'et': None, 'x': None}),

                               ('SET X specializes ET WHERE X eid %(x)s, ET eid %(et)s',

                                {'et': None, 'x': None}),

                               ('SET X specializes ET WHERE X eid %(x)s, ET eid %(et)s',

                                {'et': None, 'x': None}),

                               # ('SET X specializes ET WHERE X eid %(x)s, ET eid %(et)s',

                               #  {'et': 'File', 'x': 'Image'}),

                               ('SET X specializes ET WHERE X eid %(x)s, ET eid %(et)s',

                                {'et': None, 'x': None})])

    def test_rschema2rql1(self):

        self.assertListEquals(list(rschema2rql(schema.rschema('relation_type'), cstrtypemap)),

                             [

            ('INSERT CWRType X: X description %(description)s,X final %(final)s,X fulltext_container %(fulltext_container)s,X inlined %(inlined)s,X name %(name)s,X symmetric %(symmetric)s',

             {'description': u'link a relation definition to its relation type', 'symmetric': False, 'name': u'relation_type', 'final' : False, 'fulltext_container': None, 'inlined': True}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'', 'composite': u'object', 'cardinality': u'1*',

              'ordernum': 1}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'RQLConstraint_eid', 'value': u';O;O final TRUE\n'}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'', 'composite': u'object', 

              'ordernum': 1, 'cardinality': u'1*'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'RQLConstraint_eid', 'value': u';O;O final FALSE\n'}),

            ])

    def test_rschema2rql2(self):

        self.assertListEquals(list(rschema2rql(schema.rschema('add_permission'), cstrtypemap)),

                              [

            ('INSERT CWRType X: X description %(description)s,X final %(final)s,X fulltext_container %(fulltext_container)s,X inlined %(inlined)s,X name %(name)s,X symmetric %(symmetric)s', {'description': u'', 'symmetric': False, 'name': u'add_permission', 'final': False, 'fulltext_container': None, 'inlined': False}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'groups allowed to add entities/relations of this type', 'composite': None, 'ordernum': 9999, 'cardinality': u'**'}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'rql expression allowing to add entities/relations of this type', 'composite': 'subject', 'ordernum': 9999, 'cardinality': u'*?'}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'groups allowed to add entities/relations of this type', 'composite': None, 'ordernum': 9999, 'cardinality': u'**'}),

            ('INSERT CWRelation X: X cardinality %(cardinality)s,X composite %(composite)s,X description %(description)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'rql expression allowing to add entities/relations of this type', 'composite': 'subject', 'ordernum': 9999, 'cardinality': u'*?'}),

            ])

    def test_rschema2rql3(self):

        self.assertListEquals(list(rschema2rql(schema.rschema('cardinality'), cstrtypemap)),

                             [

            ('INSERT CWRType X: X description %(description)s,X final %(final)s,X fulltext_container %(fulltext_container)s,X inlined %(inlined)s,X name %(name)s,X symmetric %(symmetric)s',

             {'description': u'', 'symmetric': False, 'name': u'cardinality', 'final': True, 'fulltext_container': None, 'inlined': False}),

            ('INSERT CWAttribute X: X cardinality %(cardinality)s,X defaultval %(defaultval)s,X description %(description)s,X fulltextindexed %(fulltextindexed)s,X indexed %(indexed)s,X internationalizable %(internationalizable)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'subject/object cardinality', 'internationalizable': True, 'fulltextindexed': False, 'ordernum': 5, 'defaultval': None, 'indexed': False, 'cardinality': u'?1'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'SizeConstraint_eid', 'value': u'max=2'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'StaticVocabularyConstraint_eid', 'value': u"u'?1', u'11'"}),

            ('INSERT CWAttribute X: X cardinality %(cardinality)s,X defaultval %(defaultval)s,X description %(description)s,X fulltextindexed %(fulltextindexed)s,X indexed %(indexed)s,X internationalizable %(internationalizable)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'subject/object cardinality', 'internationalizable': True, 'fulltextindexed': False, 'ordernum': 5, 'defaultval': None, 'indexed': False, 'cardinality': u'?1'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'SizeConstraint_eid', 'value': u'max=2'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'ct': u'StaticVocabularyConstraint_eid', 'value': u"u'?*', u'1*', u'+*', u'**', u'?+', u'1+', u'++', u'*+', u'?1', u'11', u'+1', u'*1', u'??', u'1?', u'+?', u'*?'"}),

            ])

    def test_rdef2rql(self):

        self.assertListEquals(list(rdef2rql(schema['description_format'].rdefs[('CWRType', 'String')], cstrtypemap)),

                              [

            ('INSERT CWAttribute X: X cardinality %(cardinality)s,X defaultval %(defaultval)s,X description %(description)s,X fulltextindexed %(fulltextindexed)s,X indexed %(indexed)s,X internationalizable %(internationalizable)s,X ordernum %(ordernum)s,X relation_type ER,X from_entity SE,X to_entity OE WHERE SE eid %(se)s,ER eid %(rt)s,OE eid %(oe)s',

             {'se': None, 'rt': None, 'oe': None,

              'description': u'', 'internationalizable': True, 'fulltextindexed': False, 'ordernum': 7, 'defaultval': u'text/plain', 'indexed': False, 'cardinality': u'?1'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'value': u'None', 'ct': 'FormatConstraint_eid'}),

            ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT eid %(ct)s, EDEF eid %(x)s',

             {'x': None, 'value': u'max=50', 'ct': 'SizeConstraint_eid'})])

    def test_updateeschema2rql1(self):

        self.assertListEquals(list(updateeschema2rql(schema.eschema('CWAttribute'), 1)),

                              [('SET X description %(description)s,X final %(final)s,X name %(name)s WHERE X eid %(x)s',

                                {'description': u'define a final relation: link a final relation type from a non final entity to a final entity type. used to build the instance schema', 'x': 1, 'final': False, 'name': u'CWAttribute'}),

                               ])

    def test_updateeschema2rql2(self):

        self.assertListEquals(list(updateeschema2rql(schema.eschema('String'), 1)),

                              [('SET X description %(description)s,X final %(final)s,X name %(name)s WHERE X eid %(x)s',

                                {'description': u'', 'x': 1, 'final': True, 'name': u'String'})

                               ])

    def test_updaterschema2rql1(self):

        self.assertListEquals(list(updaterschema2rql(schema.rschema('relation_type'), 1)),

                             [

            ('SET X description %(description)s,X final %(final)s,X fulltext_container %(fulltext_container)s,X inlined %(inlined)s,X name %(name)s,X symmetric %(symmetric)s WHERE X eid %(x)s',

             {'x': 1, 'symmetric': False,

              'description': u'link a relation definition to its relation type',

              'final': False, 'fulltext_container': None, 'inlined': True, 'name': u'relation_type'})

            ])

    def test_updaterschema2rql2(self):

        expected = [

            ('SET X description %(description)s,X final %(final)s,X fulltext_container %(fulltext_container)s,X inlined %(inlined)s,X name %(name)s,X symmetric %(symmetric)s WHERE X eid %(x)s',

             {'x': 1, 'symmetric': False,

              'description': u'', 'final': False, 'fulltext_container': None,

              'inlined': False, 'name': u'add_permission'})

            ]

        for i, (rql, args) in enumerate(updaterschema2rql(schema.rschema('add_permission'), 1)):

            yield self.assertEquals, (rql, args), expected[i]

class Perms2RQLTC(TestCase):

    GROUP_MAPPING = {

        'managers': 0,

        'users':  1,

        'guests': 2,

        'owners': 3,

        }

    def test_eperms2rql1(self):

        self.assertListEquals([(rql, kwargs) for rql, kwargs in erperms2rql(schema.eschema('CWEType'), self.GROUP_MAPPING)],

                              [('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 1}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 2}),

                               ('SET X add_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X update_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X delete_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ])

    def test_rperms2rql2(self):

        self.assertListEquals([(rql, kwargs) for rql, kwargs in erperms2rql(schema.rschema('read_permission').rdef('CWEType', 'CWGroup'), self.GROUP_MAPPING)],

                              [('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 1}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 2}),

                               ('SET X add_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X delete_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ])

    def test_rperms2rql3(self):

        self.assertListEquals([(rql, kwargs) for rql, kwargs in erperms2rql(schema.rschema('name').rdef('CWEType', 'String'), self.GROUP_MAPPING)],

                              [('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 1}),

                               ('SET X read_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 2}),

                               ('SET X update_permission Y WHERE Y eid %(g)s, X eid %(x)s', {'g': 0}),

                               ])

    #def test_perms2rql(self):

    #    self.assertListEquals(perms2rql(schema, self.GROUP_MAPPING),

    #                         ['INSERT CWEType X: X name 'Societe', X final FALSE'])

if __name__ == '__main__':

    unittest_main()