__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): __tablename__ = "v_synthese_decode_nomenclatures" __table_args__ = {"schema": "gn_synthese"} id_synthese = DB.Column(DB.Integer, primary_key=True) nat_obj_geo = DB.Column(DB.Unicode) grp_typ = DB.Column(DB.Unicode)
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 class CorCountingOccurrence(DB.Model): __tablename__ = "cor_counting_occtax"
- 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 class CorCountingOccurrence(DB.Model): __tablename__ = 'cor_counting_occtax' __table_args__ = {'schema': 'pr_occtax'} id_counting_occtax = DB.Column(DB.Integer, primary_key=True) id_occurrence_occtax = DB.Column( DB.Integer,
__table_args__ = {"schema": "gn_permissions"} id_action = DB.Column(DB.Integer, primary_key=True) code_action = DB.Column(DB.Unicode) description_action = DB.Column(DB.Unicode) cor_object_module = DB.Table( "cor_object_module", DB.Column( "id_cor_object_module", DB.Integer, primary_key=True, ), DB.Column( "id_object", DB.Integer, ForeignKey("gn_permissions.t_objects.id_object"), ), DB.Column( "id_module", DB.Integer, ForeignKey("gn_commons.t_modules.id_module"), ), schema="gn_permissions", ) @serializable class TObjects(DB.Model): __tablename__ = "t_objects" __table_args__ = {"schema": "gn_permissions"}
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), DB.Column('id_module', DB.Integer, ForeignKey('gn_commons.t_modules.id_module'), primary_key=True))
# -*- encoding: utf-8 -*- from geoalchemy2 import Geometry from geonature.core.users.models import BibOrganismes from geonature.core.ref_geo.models import LiMunicipalities, LAreas from geonature.utils.utilssqlalchemy import serializable, geoserializable from geonature.utils.env import DB SCHEMA = 'pr_psdrf' dispositifs_municipalities_assoc = DB.Table('cor_dispositif_municipality', DB.metadata, DB.Column('id_dispositif', DB.Integer, DB.ForeignKey(SCHEMA + '.t_dispositifs.id_dispositif')), DB.Column('id_municipality', DB.String, DB.ForeignKey('ref_geo.li_municipalities.id_municipality')), schema=SCHEMA ) dispositifs_area_assoc = DB.Table('cor_dispositif_area', DB.metadata, DB.Column('id_dispositif', DB.Integer, DB.ForeignKey(SCHEMA + '.t_dispositifs.id_dispositif')), DB.Column('id_area', DB.Integer, DB.ForeignKey('ref_geo.l_areas.id_area')), schema=SCHEMA ) # @serializable class TDispositifs (DB.Model): __tablename__ = "t_dispositifs" __table_args__ = {'schema': SCHEMA} id_dispositif = DB.Column('id_dispositif', DB.Integer, primary_key = True)
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 ??? @serializable # @geoserializable class CorVisitGrid(DB.Model): '''
id_table_location = DB.Column(DB.Integer, primary_key=True) table_desc = DB.Column(DB.Unicode) schema_name = DB.Column(DB.Unicode) table_name = DB.Column(DB.Unicode) pk_field = DB.Column(DB.Unicode) uuid_field_name = DB.Column(DB.Unicode) cor_module_dataset = DB.Table( "cor_module_dataset", DB.Column( "id_module", DB.Integer, ForeignKey("gn_commons.t_modules.id_module"), primary_key=True, ), DB.Column( "id_dataset", DB.Integer, ForeignKey("gn_meta.t_datasets.id_dataset"), primary_key=True, ), schema="gn_commons", ) @serializable class TModules(DB.Model): __tablename__ = "t_modules" __table_args__ = {"schema": "gn_commons"} id_module = DB.Column(DB.Integer, primary_key=True) module_code = DB.Column(DB.Unicode)
@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 ) ) @serializable class VSyntheseDecodeNomenclatures(DB.Model): __tablename__ = 'v_synthese_decode_nomenclatures' __table_args__ = {'schema': 'gn_synthese'} id_synthese = DB.Column(DB.Integer, primary_key=True) nat_obj_geo = DB.Column(DB.Unicode)
class BibTablesLocation(DB.Model): __tablename__ = "bib_tables_location" __table_args__ = {"schema": "gn_commons"} id_table_location = DB.Column(DB.Integer, primary_key=True) table_desc = DB.Column(DB.Unicode) schema_name = DB.Column(DB.Unicode) table_name = DB.Column(DB.Unicode) pk_field = DB.Column(DB.Unicode) uuid_field_name = DB.Column(DB.Unicode) cor_module_dataset = DB.Table( "cor_module_dataset", DB.Column( "id_module", DB.Integer, ForeignKey("gn_commons.t_modules.id_module"), primary_key=True, ), DB.Column( "id_dataset", DB.Integer, ForeignKey("gn_meta.t_datasets.id_dataset"), primary_key=True, ), schema="gn_commons", ) @serializable class CorModuleDataset(DB.Model): __tablename__ = "cor_module_dataset" __table_args__ = {"schema": "gn_commons", 'extend_existing': True} id_module = DB.Column( DB.Integer, ForeignKey("gn_commons.t_modules.id_module"), primary_key=True, )
from utils_flask_sqla.serializers import serializable from utils_flask_sqla_geo.serializers import geoserializable from geonature.core.gn_commons.models import TModules from geonature.core.gn_meta.models import TDatasets from geonature.utils.env import DB corVisitObserver = DB.Table( "cor_visit_observer", DB.Column( "id_base_visit", DB.Integer, ForeignKey("gn_monitoring.t_base_visits.id_base_visit"), primary_key=True, ), DB.Column( "id_role", DB.Integer, ForeignKey("utilisateurs.t_roles.id_role"), primary_key=True, ), schema="gn_monitoring" ) corSiteModule = DB.Table( "cor_site_module", DB.Column( "id_base_site", DB.Integer, ForeignKey("gn_monitoring.t_base_sites.id_base_site"),
__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.Column("id_synthese", DB.Integer, ForeignKey("gn_synthese.synthese.id_synthese"), primary_key=True), DB.Column("id_area", DB.Integer, ForeignKey("ref_geo.l_areas.id_area"), primary_key=True), schema='gn_synthese', ) @serializable class VSyntheseDecodeNomenclatures(DB.Model): __tablename__ = "v_synthese_decode_nomenclatures" __table_args__ = {"schema": "gn_synthese"} id_synthese = DB.Column(DB.Integer, primary_key=True) nat_obj_geo = DB.Column(DB.Unicode) grp_typ = DB.Column(DB.Unicode) obs_technique = DB.Column(DB.Unicode)