1 # copyright 2014 LOGILAB S.A. (Paris, FRANCE), all rights reserved.

     2 # contact http://www.logilab.fr/ -- mailto:contact@logilab.fr

     3 #

     4 # This file is part of CubicWeb.

     5 #

     6 # CubicWeb is free software: you can redistribute it and/or modify it under the

     7 # terms of the GNU Lesser General Public License as published by the Free

     8 # Software Foundation, either version 2.1 of the License, or (at your option)

     9 # any later version.

    10 #

    11 # CubicWeb is distributed in the hope that it will be useful, but WITHOUT

    12 # ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS

    13 # FOR A PARTICULAR PURPOSE.  See the GNU Lesser General Public License for more

    14 # details.

    15 #

    16 # You should have received a copy of the GNU Lesser General Public License along

    17 # with CubicWeb.  If not, see <http://www.gnu.org/licenses/>.

    18 from yams.buildobjs import EntityType, String, Int, SubjectRelation, RelationDefinition

    19 

    20 THISYEAR = 2014

    21 

    22 class Person(EntityType):

    23     name = String()

    24     salaire = Int()

    25     birth_year = Int(required=True)

    26     travaille = SubjectRelation('Societe')

    27     age = Int(formula='Any %d - D WHERE X birth_year D' % THISYEAR)

    28 

    29 class Societe(EntityType):

    30     nom = String()

    31     salaire_total = Int(formula='Any SUM(SA) GROUPBY X WHERE P travaille X, P salaire SA')

    32 

    33 

    34 class Agent(EntityType):

    35     asalae_id = String(formula='Any E WHERE M mirror_of X, M extid E')

    36 

    37 class MirrorEntity(EntityType):

    38     extid = String(required=True, unique=True,

    39                    description=_('external identifier of the object'))

    40 

    41 

    42 class mirror_of(RelationDefinition):

    43     subject  = 'MirrorEntity'

    44     object = ('Agent', 'Societe')

    45     cardinality = '?*'

    46     inlined = True