geonature.core.gn_synthese.models

Module Contents

Classes

TSources	The base class of the SQLAlchemy.Model declarative model class.
CorObserverSynthese	The base class of the SQLAlchemy.Model declarative model class.
SyntheseLogEntryQuery	SQLAlchemy Query subclass with some extra methods
SyntheseQuery	SQLAlchemy Query subclass with some extra methods
CorAreaSynthese	The base class of the SQLAlchemy.Model declarative model class.
Synthese	The base class of the SQLAlchemy.Model declarative model class.
DefaultsNomenclaturesValue	The base class of the SQLAlchemy.Model declarative model class.
BibReportsTypes	The base class of the SQLAlchemy.Model declarative model class.
TReport	The base class of the SQLAlchemy.Model declarative model class.
VSyntheseForWebApp	The base class of the SQLAlchemy.Model declarative model class.
VColorAreaTaxon	The base class of the SQLAlchemy.Model declarative model class.
SyntheseLogEntry	Log synthese table, populated with Delete Triggers on gn_synthes.synthese

Functions

synthese_export_serialization(cls)

Décorateur qui definit une serialisation particuliere pour la vue v_synthese_for_export

Attributes

sortable_columns
filterable_columns
cor_observer_synthese
corAreaSynthese
source_subquery

geonature.core.gn_synthese.models.sortable_columns = ['meta_last_action_date']

geonature.core.gn_synthese.models.filterable_columns = ['id_synthese', 'last_action', 'meta_last_action_date']

class geonature.core.gn_synthese.models.TSources

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

property module_url

__tablename__ = 't_sources'

__table_args__

id_source

name_source

desc_source

entity_source_pk_field

url_source

meta_create_date

meta_update_date

id_module

module

geonature.core.gn_synthese.models.cor_observer_synthese

class geonature.core.gn_synthese.models.CorObserverSynthese

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'cor_observer_synthese'

__table_args__

id_synthese

id_role

geonature.core.gn_synthese.models.corAreaSynthese

class geonature.core.gn_synthese.models.SyntheseLogEntryQuery(entities, session=None)

Bases: flask_sqlalchemy.query.Query

SQLAlchemy Query subclass with some extra methods useful for querying in a web application.

This is the default query class for Model.query.

Modifié dans la version 3.0: Renamed to Query from BaseQuery.

sortable_columns = ['meta_last_action_date']

filterable_columns = ['id_synthese', 'last_action', 'meta_last_action_date']

filter_by_params(params)

filter_by_datetime(col, dt: str = None)

Filter on date only with operator among « <,>,=<,>= »

Parameters

filters_with_operatordict

params filters from url only

Returns

Query

sort(columns: List[str])

class geonature.core.gn_synthese.models.SyntheseQuery(entities, session=None)

Bases: utils_flask_sqla_geo.mixins.GeoFeatureCollectionMixin, flask_sqlalchemy.query.Query

SQLAlchemy Query subclass with some extra methods useful for querying in a web application.

This is the default query class for Model.query.

Modifié dans la version 3.0: Renamed to Query from BaseQuery.

join_nomenclatures()

lateraljoin_last_validation()

filter_by_scope(scope, user=None)

class geonature.core.gn_synthese.models.CorAreaSynthese

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'cor_area_synthese'

__table_args__

id_synthese

id_area

class geonature.core.gn_synthese.models.Synthese

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'synthese'

__table_args__

query_class

nomenclature_fields = ['nomenclature_geo_object_nature', 'nomenclature_grp_typ', 'nomenclature_obs_technique',...

id_synthese

unique_id_sinp

unique_id_sinp_grp

id_source

source

id_module

module

entity_source_pk_value

id_dataset

dataset

grp_method

id_nomenclature_geo_object_nature

nomenclature_geo_object_nature

id_nomenclature_grp_typ

nomenclature_grp_typ

id_nomenclature_obs_technique

nomenclature_obs_technique

id_nomenclature_bio_status

nomenclature_bio_status

id_nomenclature_bio_condition

nomenclature_bio_condition

id_nomenclature_naturalness

nomenclature_naturalness

id_nomenclature_valid_status

nomenclature_valid_status

id_nomenclature_exist_proof

nomenclature_exist_proof

id_nomenclature_diffusion_level

nomenclature_diffusion_level

id_nomenclature_life_stage

nomenclature_life_stage

id_nomenclature_sex

nomenclature_sex

id_nomenclature_obj_count

nomenclature_obj_count

id_nomenclature_type_count

nomenclature_type_count

id_nomenclature_sensitivity

nomenclature_sensitivity

id_nomenclature_observation_status

nomenclature_observation_status

id_nomenclature_blurring

nomenclature_blurring

id_nomenclature_source_status

nomenclature_source_status

id_nomenclature_info_geo_type

nomenclature_info_geo_type

id_nomenclature_behaviour

nomenclature_behaviour

id_nomenclature_biogeo_status

nomenclature_biogeo_status

id_nomenclature_determination_method

nomenclature_determination_method

reference_biblio

count_min

count_max

cd_nom

taxref

cd_hab

habitat

nom_cite

meta_v_taxref

sample_number_proof

digital_proof

non_digital_proof

altitude_min

altitude_max

depth_min

depth_max

place_name

the_geom_4326

the_geom_4326_geojson

the_geom_point

the_geom_local

the_geom_authorized

precision

id_area_attachment

date_min

date_max

validator

validation_comment

observers

determiner

id_digitiser

digitiser

comment_context

comment_description

additional_data

meta_validation_date

meta_create_date

meta_update_date

last_action

areas

area_attachment

validations

last_validation

medias

cor_observers

_has_scope_grant(scope)

_has_permissions_grant(permissions)

has_instance_permission(permissions)

classmethod join_nomenclatures(**kwargs)

classmethod lateraljoin_last_validation(**kwargs)

classmethod filter_by_scope(scope, user=None, **kwargs)

class geonature.core.gn_synthese.models.DefaultsNomenclaturesValue

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'defaults_nomenclatures_value'

__table_args__

mnemonique_type

id_organism

regne

group2_inpn

id_nomenclature

class geonature.core.gn_synthese.models.BibReportsTypes

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'bib_reports_types'

__table_args__

id_type

type

class geonature.core.gn_synthese.models.TReport

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 't_reports'

__table_args__

id_report

id_synthese

id_role

id_type

content

creation_date

deleted

synthese

report_type

user

class geonature.core.gn_synthese.models.VSyntheseForWebApp

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'v_synthese_for_web_app'

__table_args__

id_synthese

unique_id_sinp

unique_id_sinp_grp

id_source

id_module

entity_source_pk_value

id_dataset

dataset_name

id_acquisition_framework

count_min

count_max

cd_nom

cd_ref

nom_cite

nom_valide

nom_vern

lb_nom

meta_v_taxref

group1_inpn

group2_inpn

group3_inpn

sample_number_proof

digital_proof

non_digital_proof

altitude_min

altitude_max

depth_min

depth_max

place_name

precision

the_geom_4326

date_min

date_max

validator

validation_comment

observers

determiner

id_digitiser

comment_context

comment_description

meta_validation_date

meta_create_date

meta_update_date

last_action

id_nomenclature_geo_object_nature

id_nomenclature_info_geo_type

id_nomenclature_grp_typ

grp_method

id_nomenclature_obs_technique

id_nomenclature_bio_status

id_nomenclature_bio_condition

id_nomenclature_naturalness

id_nomenclature_exist_proof

id_nomenclature_valid_status

id_nomenclature_diffusion_level

id_nomenclature_life_stage

id_nomenclature_sex

id_nomenclature_obj_count

id_nomenclature_type_count

id_nomenclature_sensitivity

id_nomenclature_observation_status

id_nomenclature_blurring

id_nomenclature_source_status

id_nomenclature_determination_method

id_nomenclature_behaviour

reference_biblio

name_source

url_source

st_asgeojson

medias

reports

geonature.core.gn_synthese.models.synthese_export_serialization(cls)

Décorateur qui definit une serialisation particuliere pour la vue v_synthese_for_export Il rajoute la fonction as_dict_ordered qui conserve l’ordre des attributs tel que definit dans le model (fonctions utilisees pour les exports) et qui redefinit le nom des colonnes tel qu’ils sont nommes en configuration

class geonature.core.gn_synthese.models.VColorAreaTaxon

Bases: geonature.utils.env.DB.Model

The base class of the SQLAlchemy.Model declarative model class.

To define models, subclass db.Model, not this. To customize db.Model, subclass this and pass it as model_class to SQLAlchemy. To customize db.Model at the metaclass level, pass an already created declarative model class as model_class.

__tablename__ = 'v_color_taxon_area'

__table_args__

cd_nom

id_area

nb_obs

last_date

color

class geonature.core.gn_synthese.models.SyntheseLogEntry

Bases: geonature.utils.env.DB.Model

Log synthese table, populated with Delete Triggers on gn_synthes.synthese Parameters ———- DB:

Flask SQLAlchemy controller

__tablename__ = 't_log_synthese'

__table_args__

query_class

id_synthese

last_action

meta_last_action_date

classmethod filter_by_params(params, **kwargs)

classmethod filter_by_datetime(col, dt: str = None, **kwargs)

Filter on date only with operator among « <,>,=<,>= »

Parameters

filters_with_operatordict

params filters from url only

Returns

Query

classmethod sort(columns: List[str], *, query)

geonature.core.gn_synthese.models.source_subquery