pypnusershub.db

Submodules

• pypnusershub.db.models
• pypnusershub.db.models_register
• pypnusershub.db.tools

Package 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

get_current_app_id()
check_and_encrypt_password(password, password_confirmation)
fn_check_password(self, pwd)

Attributes

cor_roles
profils_for_app
cor_role_liste

exception pypnusershub.db.NoPasswordError

Bases: Exception

Common base class for all non-exit exceptions.

exception pypnusershub.db.DifferentPasswordError

Bases: Exception

Common base class for all non-exit exceptions.

pypnusershub.db.get_current_app_id()

pypnusershub.db.check_and_encrypt_password(password, password_confirmation, md5=False)

pypnusershub.db.fn_check_password(self, pwd)

pypnusershub.db.cor_roles

class pypnusershub.db.UserQuery(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.

filter_by_app(code_app=None)

class pypnusershub.db.User

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

property password

property is_public

__tablename__ = 't_roles'

__table_args__

query_class

groupe

id_role

identifiant

nom_role

prenom_role

desc_role

_password

_password_plus

email

id_organisme

remarques

champs_addi

date_insert

date_update

active

groups

check_password

nom_complet()

nom_complet()

get_id()

__repr__()

Return repr(self).

__str__()

Return str(self).

classmethod filter_by_app(code_app=None, **kwargs)

class pypnusershub.db.Organisme

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'

__table_args__

id_organisme

uuid_organisme

nom_organisme

adresse_organisme

cp_organisme

ville_organisme

tel_organisme

fax_organisme

email_organisme

url_organisme

url_logo

id_parent

additional_data

members

__str__()

Return str(self).

pypnusershub.db.profils_for_app

class pypnusershub.db.Profils

Bases: pypnusershub.env.db.Model

Model de la classe t_profils

__tablename__ = 't_profils'

__table_args__

id_profil

code_profil

nom_profil

desc_profil

applications

class pypnusershub.db.Application

Bases: pypnusershub.env.db.Model

Représente une application ou un module

__tablename__ = 't_applications'

__table_args__

id_application

code_application

nom_application

desc_application

id_parent

profils

__repr__()

Return repr(self).

__str__()

Return str(self).

static get_application(nom_application)

class pypnusershub.db.ApplicationRight

Bases: pypnusershub.env.db.Model

Droit d’acces a une application

__tablename__ = 'bib_droits'

__table_args__

id_droit

nom_droit

desc_droit

__repr__()

Return repr(self).

__str__()

Return str(self).

class pypnusershub.db.UserApplicationRight

Bases: pypnusershub.env.db.Model

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

__tablename__ = 'cor_role_app_profil'

__table_args__

id_role

id_profil

id_application

role

profil

application

__repr__()

Return repr(self).

class pypnusershub.db.AppUser

Bases: pypnusershub.env.db.Model

Relations entre applications et utilisateurs

property password

__tablename__ = 'v_userslist_forall_applications'

__table_args__

id_role

role

nom_role

prenom_role

id_application

id_organisme

application

identifiant

_password

_password_plus

id_droit_max

check_password

__repr__()

Return repr(self).

class pypnusershub.db.AppRole

Bases: pypnusershub.env.db.Model

Relations entre applications et role

__tablename__ = 'v_roleslist_forall_applications'

__table_args__

id_role

groupe

nom_role

prenom_role

id_application

id_organisme

identifiant

application

as_dict()

pypnusershub.db.cor_role_liste

class pypnusershub.db.UserList

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'

__table_args__

id_liste

code_liste

nom_liste

desc_liste

users