class C4Projet(db.Model): __bind_key__ = 'gescli' __tablename__ = 'PROJET{0}'.format(datetime.now().strftime('%Y')) code_projet = db.Column(db.String(8), primary_key=True) code_personne = db.Column(db.Integer, db.ForeignKey('PERSONNE.code_personne')) intitule_projet = db.Column(db.String(50))
class C4Qualite(db.Model): __bind_key__ = 'gescli' __tablename__ = 'QUALITE' code_qualite = db.Column(db.String(8), primary_key=True) libelle_qualite = db.Column(db.String(50)) personnes = db.relationship('C4Personne', backref='qualite', lazy='dynamic')
class C4Comite(db.Model): __bind_key__ = 'gescli' __tablename__ = 'COMITE' code_comite = db.Column(db.Integer, primary_key=True) ct = db.Column(db.String(8)) intitule_comite = db.Column(db.String(80)) ressources = db.relationship('C4Ressource', backref='comite', lazy='dynamic')
class Shell(db.Model): __bind_key__ = 'lac' __tablename__ = 'shell' id = db.Column(db.Integer, primary_key=True) path = db.Column(db.String(50), unique=True) label = db.Column(db.String(50)) def __init__(self, label, path): self.path = path self.label = label
class Filesystem(db.Model): __bind_key__ = 'lac' __tablename__ = 'filesystem' id = db.Column(db.Integer, primary_key=True) label = db.Column(db.String(50), unique=True) description = db.Column(db.String(50)) def __init__(self, label, description): self.description = description self.label = label
class Field(db.Model): __bind_key__ = 'lac' __tablename__ = 'field' id = db.Column(db.Integer, primary_key=True) label = db.Column(db.String(50)) description = db.Column(db.String(80)) display = db.Column(db.Boolean()) edit = db.Column(db.Boolean()) multivalue = db.Column(db.Boolean()) mandatory = db.Column(db.Boolean()) restrict = db.Column(db.Boolean()) display_mode = db.Column(db.String(50), unique=True) priority = db.Column(db.Integer) block = db.Column(db.String(1)) page_id = Column( Integer, ForeignKey('page.id', onupdate="CASCADE", ondelete="CASCADE")) ldapattribute_id = Column( Integer, ForeignKey('ldapattribute.id', onupdate="CASCADE", ondelete="CASCADE")) fieldtype_id = Column( Integer, ForeignKey('fieldtype.id', onupdate="CASCADE", ondelete="CASCADE")) def __init__(self, label, page, ldapattribute, fieldtype=None, description=None, display=False, edit=False, mandatory=False, multivalue=False, restrict=False, priority=False, block=False): self.label = label self.description = description self.display = display self.edit = edit self.restrict = restrict self.page = page self.ldapattribute = ldapattribute self.fieldtype = fieldtype self.mandatory = mandatory self.multivalue = multivalue self.priority = priority self.block = block def __repr__(self): return '<Field %r>' % self.label
class C4Ressource(db.Model): __bind_key__ = 'gescli' __tablename__ = 'RESSOURCE{0}'.format(datetime.now().strftime('%Y')) code_dossier_ressource = db.Column(db.String(15), primary_key=True) code_comite = db.Column(db.Integer, db.ForeignKey('COMITE.code_comite')) code_projet = db.Column( db.String(8), db.ForeignKey('PROJET{0}.code_projet'.format( datetime.now().strftime('%Y')))) demande_uc_ibm = db.Column(db.Integer) demande_uc_occigen = db.Column(db.Integer) accorde_uc_ibm = db.Column(db.Integer) accorde_uc_occigen = db.Column(db.Integer)
class LDAPObjectType(db.Model): __bind_key__ = 'lac' __tablename__ = 'ldapobjecttype' id = db.Column(db.Integer, primary_key=True) label = db.Column(db.String(50), unique=True) description = db.Column(db.String(50)) ranges = db.Column(db.String(200)) apply_to = db.Column(db.String(20)) last_used_id = db.Column(db.Integer) ppolicy = db.Column(db.String(50)) ldapobjecttypeobjectclasses = db.relationship("LDAPObjectTypeObjectClass", backref="ldapobjecttype", lazy='dynamic')
class User(db.Model): __bind_key__ = 'lac' __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True) uid = db.Column(db.String(200)) uid_number = db.Column(db.Integer, unique=True) firstname = db.Column(db.String(200)) lastname = db.Column(db.String(200)) email = db.Column(db.String(200)) phone_number = db.Column(db.String(20)) deletion_timestamp = db.Column(db.Date()) binds = db.relationship('UserBind', backref="user", lazy='dynamic', order_by='desc(UserBind.time)')
class FieldType(db.Model): __bind_key__ = 'lac' __tablename__ = 'fieldtype' id = db.Column(db.Integer, primary_key=True) type = db.Column(db.String(80)) fields = db.relationship('Field', backref='fieldtype', lazy='dynamic')
class OTRSUser(db.Model): __bind_key__ = 'otrs' __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) valid_id = db.Column(db.Integer) login = db.Column(db.String(200), unique=True) change_time = db.Column(db.DateTime)
class Page(db.Model): __bind_key__ = 'lac' __tablename__ = 'page' id = db.Column(db.Integer, primary_key=True) label = db.Column(db.String(50), unique=True) description = db.Column(db.String(80)) fields = db.relationship("Field", backref="page", lazy='dynamic') pageobjectclasses = db.relationship("PageObjectClass", backref="page", lazy='dynamic') def __init__(self, label, description): self.label = label self.description = description def __repr__(self): return '<Page %r>' % self.label
class C4Adresse(db.Model): __bind_key__ = 'gescli' __tablename__ = 'ADRESSE' code_adresse = db.Column(db.Integer, primary_key=True) laboratoire_adresse = db.Column(db.String(50)) organisme_adresse = db.Column(db.String(50)) adresse1_adresse = db.Column(db.String(50)) adresse2_adresse = db.Column(db.String(50)) cdpostal_adresse = db.Column(db.String(10)) ville_adresse = db.Column(db.String(50)) pays_adresse = db.Column(db.String(20)) personnes = db.relationship('C4Personne', backref='adresse', lazy='dynamic')
class C4Personne(db.Model): __bind_key__ = 'gescli' __tablename__ = 'PERSONNE' code_personne = db.Column(db.Integer, primary_key=True) nom_personne = db.Column(db.String(30)) prenom_personne = db.Column(db.String(30)) code_adresse = db.Column(db.Integer, db.ForeignKey('ADRESSE.code_adresse')) code_qualite = db.Column(db.String(8), db.ForeignKey('QUALITE.code_qualite')) code_profil = db.Column(db.String(15), db.ForeignKey('PROFIL.code_profil')) telephone_personne = db.Column(db.String(20)) fax_personne = db.Column(db.String(20)) bal_personne = db.Column(db.String(50)) projets = db.relationship('C4Projet', backref='personne', lazy='dynamic')
class LDAPAttribute(db.Model): __bind_key__ = 'lac' __tablename__ = 'ldapattribute' id = db.Column(db.Integer, primary_key=True) label = db.Column(db.String(50), unique=True) ldapobjectclassattributes = db.relationship("LDAPObjectClassAttribute", backref="ldapattribute", lazy='dynamic') fields = db.relationship('Field', backref='ldapattribute', lazy='dynamic') def __init__(self, label): self.label = label def __repr__(self): return '<LDAPAttribute %r>' % self.label
class OTRSCustomerUser(db.Model): __bind_key__ = 'otrs' __tablename__ = 'customer_user' id = db.Column(db.Integer, primary_key=True) login = db.Column(db.String(200), unique=True) email = db.Column(db.String(150)) customer_id = db.Column(db.String(150)) # pw = db.Column(db.String(64)) # title = db.Column(db.String(50)) first_name = db.Column(db.String(100)) last_name = db.Column(db.String(100)) phone = db.Column(db.String(150)) # fax = db.Column(db.String(150)) # mobile = db.Column(db.String(150)) # street = db.Column(db.String(150)) # zip = db.Column(db.String(200)) # city = db.Column(db.String(200)) # country = db.Column(db.String(200)) comments = db.Column(db.String(250)) valid_id = db.Column(db.Integer) create_time = db.Column(db.DateTime)
class C4IBM(db.Model): __bind_key__ = 'gescpt' __tablename__ = 'IBM{0}'.format(datetime.now().strftime('%Y')) grpunix = db.Column(db.String(255), primary_key=True) walltime = db.Column(db.Float()) nbcoeurs = db.Column(db.Integer)
class C4OCCIGEN(db.Model): __bind_key__ = 'gescpt' __tablename__ = 'OCCIGEN' grpunix = db.Column(db.String(255), primary_key=True) walltime = db.Column(db.Float()) nbcoeurs = db.Column(db.Integer)
class C4Profil(db.Model): __bind_key__ = 'gescli' __tablename__ = 'PROFIL' code_profil = db.Column(db.String(15), primary_key=True) libelle_profil = db.Column(db.String(50)) personnes = db.relationship('C4Personne', backref='profil', lazy='dynamic')
class OTRSTicket(db.Model): __bind_key__ = 'otrs' __tablename__ = 'ticket' id = db.Column(db.Integer, primary_key=True) customer_user_id = db.Column(db.String(250))