geonature.core.gn_synthese.models

Attributes

sortable_columns

filterable_columns

cor_observer_synthese

corAreaSynthese

source_subquery

request_nb_obs_synthese

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

Module Contents

geonature.core.gn_synthese.models.sortable_columns = ['meta_last_action_date'][source]
geonature.core.gn_synthese.models.filterable_columns = ['id_synthese', 'last_action', 'meta_last_action_date'][source]
class geonature.core.gn_synthese.models.TSources[source]

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_sources'[source]
__table_args__[source]
id_source[source]
name_source[source]
desc_source[source]
entity_source_pk_field[source]
url_source[source]
meta_create_date[source]
meta_update_date[source]
id_module[source]
module[source]
property module_url[source]
geonature.core.gn_synthese.models.cor_observer_synthese[source]
class geonature.core.gn_synthese.models.CorObserverSynthese[source]

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'[source]
__table_args__[source]
id_synthese[source]
id_role[source]
geonature.core.gn_synthese.models.corAreaSynthese[source]
class geonature.core.gn_synthese.models.SyntheseLogEntryQuery(entities, session=None)[source]

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'][source]
filterable_columns = ['id_synthese', 'last_action', 'meta_last_action_date'][source]
filter_by_params(params)[source]
filter_by_datetime(col, dt: str = None)[source]

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

Parameters

filters_with_operatordict

params filters from url only

Returns

Query

sort(columns: List[str])[source]
class geonature.core.gn_synthese.models.SyntheseQuery(entities, session=None)[source]

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()[source]
lateraljoin_last_validation()[source]
filter_by_scope(scope, user=None)[source]
class geonature.core.gn_synthese.models.CorAreaSynthese[source]

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'[source]
__table_args__[source]
id_synthese[source]
id_area[source]
class geonature.core.gn_synthese.models.Synthese[source]

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'[source]
__table_args__[source]
query_class[source]

Query class used by query. Defaults to SQLAlchemy.Query, which defaults to Query.

nomenclature_fields = ['nomenclature_geo_object_nature', 'nomenclature_grp_typ', 'nomenclature_obs_technique',...[source]
id_synthese[source]
unique_id_sinp[source]
unique_id_sinp_grp[source]
id_source[source]
source[source]
id_module[source]
id_import[source]
module[source]
entity_source_pk_value[source]
id_dataset[source]
dataset[source]
grp_method[source]
id_nomenclature_geo_object_nature[source]
nomenclature_geo_object_nature[source]
id_nomenclature_grp_typ[source]
nomenclature_grp_typ[source]
id_nomenclature_obs_technique[source]
nomenclature_obs_technique[source]
id_nomenclature_bio_status[source]
nomenclature_bio_status[source]
id_nomenclature_bio_condition[source]
nomenclature_bio_condition[source]
id_nomenclature_naturalness[source]
nomenclature_naturalness[source]
id_nomenclature_valid_status[source]
nomenclature_valid_status[source]
id_nomenclature_exist_proof[source]
nomenclature_exist_proof[source]
id_nomenclature_diffusion_level[source]
nomenclature_diffusion_level[source]
id_nomenclature_life_stage[source]
nomenclature_life_stage[source]
id_nomenclature_sex[source]
nomenclature_sex[source]
id_nomenclature_obj_count[source]
nomenclature_obj_count[source]
id_nomenclature_type_count[source]
nomenclature_type_count[source]
id_nomenclature_sensitivity[source]
nomenclature_sensitivity[source]
id_nomenclature_observation_status[source]
nomenclature_observation_status[source]
id_nomenclature_blurring[source]
nomenclature_blurring[source]
id_nomenclature_source_status[source]
nomenclature_source_status[source]
id_nomenclature_info_geo_type[source]
nomenclature_info_geo_type[source]
id_nomenclature_behaviour[source]
nomenclature_behaviour[source]
id_nomenclature_biogeo_status[source]
nomenclature_biogeo_status[source]
id_nomenclature_determination_method[source]
nomenclature_determination_method[source]
reference_biblio[source]
count_min[source]
count_max[source]
cd_nom[source]
taxref[source]
taxref_tree[source]
cd_hab[source]
habitat[source]
nom_cite[source]
meta_v_taxref[source]
sample_number_proof[source]
digital_proof[source]
non_digital_proof[source]
altitude_min[source]
altitude_max[source]
depth_min[source]
depth_max[source]
place_name[source]
the_geom_4326[source]
the_geom_4326_geojson[source]
the_geom_point[source]
the_geom_local[source]
the_geom_authorized[source]
precision[source]
id_area_attachment[source]
date_min[source]
date_max[source]
validator[source]
validation_comment[source]
observers[source]
determiner[source]
id_digitiser[source]
digitiser[source]
comment_context[source]
comment_description[source]
additional_data[source]
meta_validation_date[source]
meta_create_date[source]
meta_update_date[source]
last_action[source]
areas[source]
area_attachment[source]
validations[source]
last_validation[source]
medias[source]
cor_observers[source]
_has_scope_grant(scope) → bool[source]
_has_permissions_grant(permissions) → bool[source]
has_instance_permission(permissions) → bool[source]
classmethod join_nomenclatures(**kwargs)[source]
classmethod lateraljoin_last_validation(**kwargs)[source]
classmethod filter_by_scope(scope, user=None, **kwargs)[source]
class geonature.core.gn_synthese.models.DefaultsNomenclaturesValue[source]

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'[source]
__table_args__[source]
mnemonique_type[source]
id_organism[source]
regne[source]
group2_inpn[source]
id_nomenclature[source]
class geonature.core.gn_synthese.models.BibReportsTypes[source]

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'[source]
__table_args__[source]
id_type[source]
type[source]
class geonature.core.gn_synthese.models.TReport[source]

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'[source]
__table_args__[source]
id_report[source]
id_synthese[source]
id_role[source]
id_type[source]
content[source]
creation_date[source]
deleted[source]
synthese[source]
report_type[source]
user[source]
class geonature.core.gn_synthese.models.VSyntheseForWebApp[source]

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'[source]
__table_args__[source]
id_synthese[source]
unique_id_sinp[source]
unique_id_sinp_grp[source]
id_source[source]
id_import[source]
id_module[source]
entity_source_pk_value[source]
id_dataset[source]
dataset_name[source]
id_acquisition_framework[source]
count_min[source]
count_max[source]
cd_nom[source]
cd_ref[source]
nom_cite[source]
nom_valide[source]
nom_vern[source]
lb_nom[source]
meta_v_taxref[source]
id_statut[source]
id_rang[source]
regne[source]
phylum[source]
classe[source]
ordre[source]
famille[source]
sous_famille[source]
group1_inpn[source]
group2_inpn[source]
group3_inpn[source]
sample_number_proof[source]
digital_proof[source]
non_digital_proof[source]
altitude_min[source]
altitude_max[source]
depth_min[source]
depth_max[source]
place_name[source]
precision[source]
the_geom_4326[source]
date_min[source]
date_max[source]
validator[source]
validation_comment[source]
observers[source]
determiner[source]
id_digitiser[source]
comment_context[source]
comment_description[source]
meta_validation_date[source]
meta_create_date[source]
meta_update_date[source]
last_action[source]
id_nomenclature_geo_object_nature[source]
id_nomenclature_info_geo_type[source]
id_nomenclature_grp_typ[source]
grp_method[source]
id_nomenclature_obs_technique[source]
id_nomenclature_bio_status[source]
id_nomenclature_bio_condition[source]
id_nomenclature_naturalness[source]
id_nomenclature_exist_proof[source]
id_nomenclature_valid_status[source]
id_nomenclature_diffusion_level[source]
id_nomenclature_life_stage[source]
id_nomenclature_sex[source]
id_nomenclature_obj_count[source]
id_nomenclature_type_count[source]
id_nomenclature_sensitivity[source]
id_nomenclature_observation_status[source]
id_nomenclature_blurring[source]
id_nomenclature_source_status[source]
id_nomenclature_determination_method[source]
id_nomenclature_behaviour[source]
id_nomenclature_biogeo_status[source]
reference_biblio[source]
name_source[source]
url_source[source]
st_asgeojson[source]
areas[source]
taxref[source]
taxref_tree[source]
medias[source]
reports[source]
geonature.core.gn_synthese.models.synthese_export_serialization(cls)[source]

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[source]

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'[source]
__table_args__[source]
cd_nom[source]
id_area[source]
nb_obs[source]
last_date[source]
color[source]
class geonature.core.gn_synthese.models.SyntheseLogEntry[source]

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'[source]
__table_args__[source]
query_class[source]

Query class used by query. Defaults to SQLAlchemy.Query, which defaults to Query.

id_synthese[source]
last_action[source]
meta_last_action_date[source]
classmethod filter_by_params(params, **kwargs)[source]
classmethod filter_by_datetime(col, dt: str = None, **kwargs)[source]

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

Parameters

filters_with_operatordict

params filters from url only

Returns

Query

classmethod sort(columns: List[str], *, query)[source]
geonature.core.gn_synthese.models.source_subquery[source]
geonature.core.gn_synthese.models.request_nb_obs_synthese[source]