server/test/unittest_schemaserial.py
changeset 3998 94cc7cad3d2d
parent 3978 2c95e3033f64
child 4191 01638461d4b0
equal deleted inserted replaced
3895:92ead039d3d0 3998:94cc7cad3d2d
    53 
    53 
    54             ('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 name %(se)s,ER name %(rt)s,OE name %(oe)s',
    54             ('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 name %(se)s,ER name %(rt)s,OE name %(oe)s',
    55              {'rt': 'relation_type', 'description': u'', 'composite': u'object', 'oe': 'CWRType',
    55              {'rt': 'relation_type', 'description': u'', 'composite': u'object', 'oe': 'CWRType',
    56               'ordernum': 1, 'cardinality': u'1*', 'se': 'CWRelation'}),
    56               'ordernum': 1, 'cardinality': u'1*', 'se': 'CWRelation'}),
    57             ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT name %(ctname)s, EDEF relation_type ER, EDEF from_entity SE, EDEF to_entity OE, ER name %(rt)s, SE name %(se)s, OE name %(oe)s, EDEF is CWRelation',
    57             ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT name %(ctname)s, EDEF relation_type ER, EDEF from_entity SE, EDEF to_entity OE, ER name %(rt)s, SE name %(se)s, OE name %(oe)s, EDEF is CWRelation',
    58              {'rt': 'relation_type', 'oe': 'CWRType', 'ctname': u'RQLConstraint', 'se': 'CWRelation', 'value': u'O final FALSE'}),
    58              {'rt': 'relation_type', 'oe': 'CWRType', 'ctname': u'RQLConstraint', 'se': 'CWRelation', 'value': u';O;O final FALSE\n'}),
    59 
    59 
    60             ('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 name %(se)s,ER name %(rt)s,OE name %(oe)s',
    60             ('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 name %(se)s,ER name %(rt)s,OE name %(oe)s',
    61              {'rt': 'relation_type', 'description': u'', 'composite': u'object', 'oe': 'CWRType',
    61              {'rt': 'relation_type', 'description': u'', 'composite': u'object', 'oe': 'CWRType',
    62               'ordernum': 1, 'cardinality': u'1*', 'se': 'CWAttribute'}),
    62               'ordernum': 1, 'cardinality': u'1*', 'se': 'CWAttribute'}),
    63             ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT name %(ctname)s, EDEF relation_type ER, EDEF from_entity SE, EDEF to_entity OE, ER name %(rt)s, SE name %(se)s, OE name %(oe)s, EDEF is CWRelation',
    63             ('INSERT CWConstraint X: X value %(value)s, X cstrtype CT, EDEF constrained_by X WHERE CT name %(ctname)s, EDEF relation_type ER, EDEF from_entity SE, EDEF to_entity OE, ER name %(rt)s, SE name %(se)s, OE name %(oe)s, EDEF is CWRelation',
    64              {'rt': 'relation_type', 'oe': 'CWRType', 'ctname': u'RQLConstraint', 'se': 'CWAttribute', 'value': u'O final TRUE'}),
    64              {'rt': 'relation_type', 'oe': 'CWRType', 'ctname': u'RQLConstraint', 'se': 'CWAttribute', 'value': u';O;O final TRUE\n'}),
    65             ])
    65             ])
    66 
    66 
    67     def test_rschema2rql2(self):
    67     def test_rschema2rql2(self):
    68         self.assertListEquals(list(rschema2rql(schema.rschema('add_permission'))),
    68         self.assertListEquals(list(rschema2rql(schema.rschema('add_permission'))),
    69                               [
    69                               [
   141         'owners': 3,
   141         'owners': 3,
   142         }
   142         }
   143 
   143 
   144     def test_eperms2rql1(self):
   144     def test_eperms2rql1(self):
   145         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.eschema('CWEType'), self.GROUP_MAPPING)],
   145         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.eschema('CWEType'), self.GROUP_MAPPING)],
   146                               ['SET X read_permission Y WHERE X is CWEType, X name "CWEType", Y eid 2',
   146                               ['SET X read_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   147                                'SET X read_permission Y WHERE X is CWEType, X name "CWEType", Y eid 0',
   147                                'SET X read_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   148                                'SET X read_permission Y WHERE X is CWEType, X name "CWEType", Y eid 1',
   148                                'SET X read_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   149                                'SET X add_permission Y WHERE X is CWEType, X name "CWEType", Y eid 0',
   149                                'SET X add_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   150                                'SET X update_permission Y WHERE X is CWEType, X name "CWEType", Y eid 0',
   150                                'SET X update_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   151                                'SET X update_permission Y WHERE X is CWEType, X name "CWEType", Y eid 3',
   151                                'SET X update_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   152                                'SET X delete_permission Y WHERE X is CWEType, X name "CWEType", Y eid 0',
   152                                'SET X delete_permission Y WHERE X is CWEType, X name %(name)s, Y eid %(g)s',
   153                                ])
   153                                ])
   154 
   154 
   155     def test_rperms2rql2(self):
   155     def test_rperms2rql2(self):
   156         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.rschema('read_permission'), self.GROUP_MAPPING)],
   156         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.rschema('read_permission'), self.GROUP_MAPPING)],
   157                               ['SET X read_permission Y WHERE X is CWRType, X name "read_permission", Y eid 2',
   157                               ['SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   158                                'SET X read_permission Y WHERE X is CWRType, X name "read_permission", Y eid 0',
   158                                'SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   159                                'SET X read_permission Y WHERE X is CWRType, X name "read_permission", Y eid 1',
   159                                'SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   160                                'SET X add_permission Y WHERE X is CWRType, X name "read_permission", Y eid 0',
   160                                'SET X add_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   161                                'SET X delete_permission Y WHERE X is CWRType, X name "read_permission", Y eid 0',
   161                                'SET X delete_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   162                                ])
   162                                ])
   163 
   163 
   164     def test_rperms2rql3(self):
   164     def test_rperms2rql3(self):
   165         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.rschema('name'), self.GROUP_MAPPING)],
   165         self.assertListEquals([rql for rql, kwargs in erperms2rql(schema.rschema('name'), self.GROUP_MAPPING)],
   166                               ['SET X read_permission Y WHERE X is CWRType, X name "name", Y eid 2',
   166                               ['SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   167                                'SET X read_permission Y WHERE X is CWRType, X name "name", Y eid 0',
   167                                'SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   168                                'SET X read_permission Y WHERE X is CWRType, X name "name", Y eid 1',
   168                                'SET X read_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   169                                'SET X add_permission Y WHERE X is CWRType, X name "name", Y eid 2',
   169                                'SET X add_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   170                                'SET X add_permission Y WHERE X is CWRType, X name "name", Y eid 0',
   170                                'SET X add_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   171                                'SET X add_permission Y WHERE X is CWRType, X name "name", Y eid 1',
   171                                'SET X add_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   172                                'SET X delete_permission Y WHERE X is CWRType, X name "name", Y eid 2',
   172                                'SET X delete_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   173                                'SET X delete_permission Y WHERE X is CWRType, X name "name", Y eid 0',
   173                                'SET X delete_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   174                                'SET X delete_permission Y WHERE X is CWRType, X name "name", Y eid 1',
   174                                'SET X delete_permission Y WHERE X is CWRType, X name %(name)s, Y eid %(g)s',
   175                                ])
   175                                ])
   176 
   176 
   177     #def test_perms2rql(self):
   177     #def test_perms2rql(self):
   178     #    self.assertListEquals(perms2rql(schema, self.GROUP_MAPPING),
   178     #    self.assertListEquals(perms2rql(schema, self.GROUP_MAPPING),
   179     #                         ['INSERT CWEType X: X name 'Societe', X final FALSE'])
   179     #                         ['INSERT CWEType X: X name 'Societe', X final FALSE'])