__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)
