pypnusershub.db.models

Module Contents

Classes

UserQuery

SQLAlchemy Query subclass with some extra methods

User

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

Organisme

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

Profils

Model de la classe t_profils

Application

Représente une application ou un module

ApplicationRight

Droit d'acces a une application

UserApplicationRight

Droit d'acces d'un user particulier a une application particuliere

AppUser

Relations entre applications et utilisateurs

AppRole

Relations entre applications et role

UserList

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

Functions

check_and_encrypt_password(password, password_confirmation)

fn_check_password(self, pwd)

Attributes

cor_roles

profils_for_app

cor_role_liste

pypnusershub.db.models.check_and_encrypt_password(password, password_confirmation, md5=False)[source]
pypnusershub.db.models.fn_check_password(self, pwd)[source]
pypnusershub.db.models.cor_roles[source]
class pypnusershub.db.models.UserQuery(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.

filter_by_app(code_app=None)[source]
class pypnusershub.db.models.User[source]

Bases: pypnusershub.env.db.Model, flask_login.UserMixin

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 max_level_profil[source]
property password[source]
property is_public[source]
__tablename__ = 't_roles'[source]
__table_args__[source]
query_class[source]
groupe[source]
id_role[source]
identifiant[source]
nom_role[source]
prenom_role[source]
desc_role[source]
_password[source]
_password_plus[source]
email[source]
id_organisme[source]
remarques[source]
champs_addi[source]
date_insert[source]
date_update[source]
active[source]
groups[source]
check_password[source]
nom_complet()[source]
nom_complet()[source]
get_id()[source]
__repr__()[source]

Return repr(self).

__str__()[source]

Return str(self).

classmethod filter_by_app(code_app=None, **kwargs)[source]
class pypnusershub.db.models.Organisme[source]

Bases: pypnusershub.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_organismes'[source]
__table_args__[source]
id_organisme[source]
uuid_organisme[source]
nom_organisme[source]
adresse_organisme[source]
cp_organisme[source]
ville_organisme[source]
tel_organisme[source]
fax_organisme[source]
email_organisme[source]
url_organisme[source]
id_parent[source]
additional_data[source]
members[source]
__str__()[source]

Return str(self).

pypnusershub.db.models.profils_for_app[source]
class pypnusershub.db.models.Profils[source]

Bases: pypnusershub.env.db.Model

Model de la classe t_profils

__tablename__ = 't_profils'[source]
__table_args__[source]
id_profil[source]
code_profil[source]
nom_profil[source]
desc_profil[source]
applications[source]
class pypnusershub.db.models.Application[source]

Bases: pypnusershub.env.db.Model

Représente une application ou un module

__tablename__ = 't_applications'[source]
__table_args__[source]
id_application[source]
code_application[source]
nom_application[source]
desc_application[source]
id_parent[source]
profils[source]
__repr__()[source]

Return repr(self).

__str__()[source]

Return str(self).

static get_application(nom_application)[source]
class pypnusershub.db.models.ApplicationRight[source]

Bases: pypnusershub.env.db.Model

Droit d’acces a une application

__tablename__ = 'bib_droits'[source]
__table_args__[source]
id_droit[source]
nom_droit[source]
desc_droit[source]
__repr__()[source]

Return repr(self).

__str__()[source]

Return str(self).

class pypnusershub.db.models.UserApplicationRight[source]

Bases: pypnusershub.env.db.Model

Droit d’acces d’un user particulier a une application particuliere

__tablename__ = 'cor_role_app_profil'[source]
__table_args__[source]
id_role[source]
id_profil[source]
id_application[source]
role[source]
profil[source]
application[source]
__repr__()[source]

Return repr(self).

class pypnusershub.db.models.AppUser[source]

Bases: pypnusershub.env.db.Model

Relations entre applications et utilisateurs

property password[source]
__tablename__ = 'v_userslist_forall_applications'[source]
__table_args__[source]
id_role[source]
role[source]
nom_role[source]
prenom_role[source]
id_application[source]
id_organisme[source]
application[source]
identifiant[source]
_password[source]
_password_plus[source]
id_droit_max[source]
check_password[source]
__repr__()[source]

Return repr(self).

class pypnusershub.db.models.AppRole[source]

Bases: pypnusershub.env.db.Model

Relations entre applications et role

__tablename__ = 'v_roleslist_forall_applications'[source]
__table_args__[source]
id_role[source]
groupe[source]
nom_role[source]
prenom_role[source]
id_application[source]
id_organisme[source]
identifiant[source]
application[source]
as_dict()[source]
pypnusershub.db.models.cor_role_liste[source]
class pypnusershub.db.models.UserList[source]

Bases: pypnusershub.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_listes'[source]
__table_args__[source]
id_liste[source]
code_liste[source]
nom_liste[source]
desc_liste[source]
users[source]