@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(