@serializable
class CorObserverSynthese(DB.Model):
__tablename__ = "cor_observer_synthese"
__table_args__ = {"schema": "gn_synthese"}
id_synthese = DB.Column(DB.Integer,
ForeignKey("gn_synthese.synthese.id_synthese"),
primary_key=True)
id_role = DB.Column(DB.Integer,
ForeignKey("utilisateurs.t_roles.id_role"),
primary_key=True)
corAreaSynthese = DB.Table(
"cor_area_synthese",
DB.MetaData(schema="gn_synthese"),
DB.Column(
"id_synthese",
DB.Integer,
ForeignKey("gn_synthese.cor_area_synthese.id_synthese"),
primary_key=True,
),
DB.Column("id_area",
DB.Integer,
ForeignKey("ref_geo.t_areas.id_area"),
primary_key=True),
)
@serializable
class VSyntheseDecodeNomenclatures(DB.Model):
"""
Return the user's cruved for a Releve instance.
Use in the map-list interface to allow or not an action
params:
- user : a TRole object
- user_cruved: object return by cruved_for_user_in_app(user)
"""
return {
action: self.user_is_allowed_to(user, level)
for action, level in user_cruved.items()
}
corRoleRelevesOccurrence = DB.Table(
"cor_role_releves_occtax",
DB.MetaData(schema="pr_occtax"),
DB.Column(
"unique_id_cor_role_releve",
UUID(as_uuid=True),
default=select([func.uuid_generate_v4()]),
primary_key=True,
),
DB.Column(
"id_releve_occtax",
DB.Integer,
ForeignKey("pr_occtax.t_releves_occtax.id_releve_occtax"),
primary_key=False,
),
DB.Column(
"id_role",
DB.Integer,
def get_releve_cruved(self, user, user_cruved):
"""
Return the user's cruved for a Releve instance.
Use in the map-list interface to allow or not an action
params:
- user : a TRole object
- user_cruved: object return by cruved_for_user_in_app(user)
"""
return {
action: self.user_is_allowed_to(user, level)
for action, level in user_cruved.items()
}
corRoleRelevesOccurrence = DB.Table(
'cor_role_releves_occtax', DB.MetaData(schema='pr_occtax'),
DB.Column('unique_id_cor_role_releve',
UUID(as_uuid=True),
default=select([func.uuid_generate_v4()]),
primary_key=True),
DB.Column('id_releve_occtax',
DB.Integer,
ForeignKey('pr_occtax.t_releves_occtax.id_releve_occtax'),
primary_key=False),
DB.Column('id_role',
DB.Integer,
ForeignKey('utilisateurs.t_roles.id_role'),
primary_key=False))
@serializable
'''
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.sql import select, func
from geoalchemy2 import Geometry
from geonature.utils.utilssqlalchemy import (serializable, geoserializable)
from geonature.utils.env import DB
from geonature.core.users.models import TApplications
from pypnusershub.db.models import User
corVisitObserver = DB.Table(
'cor_visit_observer', DB.MetaData(schema='gn_monitoring'),
DB.Column('id_base_visit',
DB.Integer,
ForeignKey('gn_monitoring.cor_visit_observer.id_base_visit'),
primary_key=True),
DB.Column('id_role',
DB.Integer,
ForeignKey('utilisateurs.t_roles.id_role'),
primary_key=True))
corSiteModule = DB.Table(
'cor_site_module', DB.MetaData(schema='gn_monitoring'),
DB.Column('id_base_site',
DB.Integer,
ForeignKey('gn_monitoring.cor_site_application.id_base_site'),
primary_key=True),
# fk gn_monitoring.base_site
id_base_site = DB.Column(DB.Integer, ForeignKey(TBaseSites.id_base_site))
base_site = DB.relationship(TBaseSites)
geom = association_proxy('base_site', 'geom')
cd_nom = DB.Column(DB.Integer)
def get_geofeature(self, recursif=True):
return self.as_geofeature('geom', 'id_infos_site', recursif)
'''
Corespondance entre une maille et une visite
'''
corVisitPerturbation = DB.Table(
'cor_visit_perturbation',
DB.MetaData(schema='pr_monitoring_flora_territory'),
DB.Column(
'id_base_visit',
DB.Integer,
ForeignKey(TBaseVisits.id_base_visit),
primary_key=True,
),
DB.Column('id_nomenclature_perturbation',
DB.Integer,
ForeignKey(TNomenclatures.id_nomenclature),
primary_key=True))
# au début, on écrit cette table sous "format de classe" (comme la partie commentaire)
# Cependant, on doit écrire sous "format" table pour que ça marche.
# Parce que ???
url_source = DB.Column(DB.Unicode)
meta_create_date = DB.Column(DB.DateTime)
meta_update_date = DB.Column(DB.DateTime)
@serializable
class CorRoleSynthese(DB.Model):
__tablename__ = 'cor_role_synthese'
__table_args__ = {'schema': 'gn_synthese'}
id_synthese = DB.Column(DB.Integer, ForeignKey('gn_synthese.synthese.id_synthese'), primary_key=True)
id_role = DB.Column(DB.Integer, ForeignKey('utilisateurs.t_roles.id_role'), primary_key=True)
corAreaSynthese = DB.Table(
'cor_area_synthese',
DB.MetaData(schema='gn_synthese'),
DB.Column(
'id_synthese',
DB.Integer,
ForeignKey('gn_synthese.cor_area_synthese.id_synthese'),
primary_key=True
),
DB.Column(
'id_area',
DB.Integer,
ForeignKey('ref_geo.t_areas.id_area'),
primary_key=True
)
)
from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.sql import select, func
from geoalchemy2 import Geometry
from geonature.utils.utilssqlalchemy import serializable, geoserializable
from geonature.utils.env import DB
from geonature.core.gn_commons.models import TModules
from pypnusershub.db.models import User
corVisitObserver = DB.Table(
"cor_visit_observer",
DB.MetaData(schema="gn_monitoring"),
DB.Column(
"id_base_visit",
DB.Integer,
ForeignKey("gn_monitoring.cor_visit_observer.id_base_visit"),
primary_key=True,
),
DB.Column(
"id_role",
DB.Integer,
# ForeignKey("utilisateurs.t_roles.id_role"),
primary_key=True,
),
)
corSiteModule = DB.Table(
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.postgresql import UUID
from sqlalchemy.sql import select, func
from geoalchemy2 import Geometry
from geonature.utils.utilssqlalchemy import (
serializable, geoserializable
)
from geonature.utils.env import DB
from geonature.core.users.models import TRoles, TApplications
corVisitObserver = DB.Table(
'cor_visit_observer',
DB.MetaData(schema='gn_monitoring'),
DB.Column(
'id_base_visit',
DB.Integer,
ForeignKey('gn_monitoring.cor_visit_observer.id_base_visit'),
primary_key=True
),
DB.Column(
'id_role',
DB.Integer,
ForeignKey('utilisateurs.t_roles.id_role'),
primary_key=True
)
)
corSiteApplication = DB.Table(
