Example #1
0
class IpObjetReseau(db.Model):
    ior_id = db.Column(db.Integer, primary_key=True)
    ior_ip = db.Column(db.String(140), index=True)
    ior_groupe = db.Column(db.Integer,
                           db.ForeignKey('objet_reseau.objrezo_id'))

    objet = db.relationship("ObjetReseau", foreign_keys=[ior_groupe])
Example #2
0
class User(UserMixin, db.Model):
    user_id = db.Column(db.Integer, primary_key=True)
    user_login = db.Column(db.String(64), index=True, unique=True)
    user_nom = db.Column(db.String(64), index=True, unique=True)
    user_prenom = db.Column(db.String(64), index=True, unique=True)
    user_email = db.Column(db.String(120), index=True, unique=True)
    profil_id = db.Column(db.Integer, db.ForeignKey('profil.profil_id'))
    user_password_hash = db.Column(db.String(128))

    profil = db.relationship("Profil", foreign_keys=[profil_id])

    def __repr__(self):
        return '<User {}>'.format(self.user_login)

    def set_password(self, pwd):
        m = hashlib.md5()
        m.update(pwd.encode('utf-8'))
        self.user_password_hash = m.hexdigest()

    def check_password(self, pwd):
        m = hashlib.md5()
        m.update(pwd.encode('utf-8'))
        if self.user_password_hash == m.hexdigest():
            return True
        return False

    def get_id(self):
        return self.user_id
Example #3
0
class Historique(db.Model):
    histo_id = db.Column(db.Integer, primary_key=True)
    histo_projet = db.Column(db.Integer, db.ForeignKey('projet.projet_id'))
    histo_date = db.Column(db.DateTime, index=True, default=datetime.utcnow)
    histo_fct = db.Column(db.String(140))
    histo_data = db.Column(db.String(140))
    history_user = db.Column(db.String(140))
Example #4
0
class Projet(db.Model):
    projet_id = db.Column(db.Integer, primary_key=True)
    projet_name = db.Column(db.String(140))
    projet_client = db.Column(db.Integer, db.ForeignKey('client.client_id'))
    projet_date_creation = db.Column(db.DateTime,
                                     index=True,
                                     default=datetime.utcnow)
    projet_date_mep = db.Column(db.DateTime,
                                index=True,
                                default=datetime.utcnow)
    projet_cpi = db.Column(db.Integer, db.ForeignKey('user.user_id'))
    projet_dp = db.Column(db.Integer, db.ForeignKey('user.user_id'))
    projet_status = db.Column(db.Integer)
    projet_ged = db.Column(db.String(240))

    cpi = db.relationship("User", foreign_keys=[projet_cpi])
    dp = db.relationship("User", foreign_keys=[projet_dp])
    client = db.relationship("Client", foreign_keys=[projet_client])
Example #5
0
class Roadmap(db.Model):
    rmp_id = db.Column(db.Integer, primary_key=True)
    rmp_sol = db.Column(db.Integer, db.ForeignKey('solution.sol_id'))
    rmp_date = db.Column(db.DateTime, index=True, default=datetime.utcnow)
    rmp_semaine = db.Column(db.String(5), index=True)
    rmp_fct = db.Column(db.String(50), index=True)
    rmp_desc = db.Column(db.Text(200))
    solution = db.relationship("Solution", foreign_keys=[rmp_sol])
Example #6
0
class Serveur(db.Model):
    __table_args__ = (db.UniqueConstraint('srv_hostname'), )
    srv_id = db.Column(db.Integer, primary_key=True)
    srv_hostname = db.Column(db.String(140))
    srv_cpu = db.Column(db.Float)
    srv_ram = db.Column(db.Integer)
    srv_pci = db.Column(db.Boolean)
    srv_os = db.Column(db.Integer, db.ForeignKey('OS.os_id'))
    os = db.relationship("OS", foreign_keys=[srv_os])
Example #7
0
class Rglfw(db.Model):
    __table_args__ = (db.UniqueConstraint('rglfw_source', 'rglfw_destination',
                                          'rglfw_port', 'rglfw_projet'), )
    rglfw_id = db.Column(db.Integer, primary_key=True)
    rglfw_source = db.Column(db.Integer,
                             db.ForeignKey('objet_reseau.objrezo_id'))
    rglfw_destination = db.Column(db.Integer,
                                  db.ForeignKey('objet_reseau.objrezo_id'))
    rglfw_port = db.Column(db.Integer)
    # 0=non soumis / 1=soumis / 2=traité
    rglfw_etat = db.Column(db.Integer)
    # date de soumission
    rglfw_date = db.Column(db.DateTime, index=True, default=datetime.utcnow)
    rglfw_projet = db.Column(db.Integer, db.ForeignKey('projet.projet_id'))
    rglfw_description = db.Column(db.String(140), index=True)
    #
    source = db.relationship("ObjetReseau", foreign_keys=[rglfw_source])
    destination = db.relationship("ObjetReseau",
                                  foreign_keys=[rglfw_destination])
Example #8
0
class ProjetServeur(db.Model):
    #__table_args__ = (db.UniqueConstraint('p_id','s_id'),)
    ps_id = db.Column(db.Integer, primary_key=True)
    p_id = db.Column(db.Integer, db.ForeignKey('projet.projet_id'))
    s_id = db.Column(db.Integer, db.ForeignKey('serveur.srv_id'))
    srv = db.relationship("Serveur", foreign_keys=[s_id])
Example #9
0
class Profil(db.Model):
    profil_id = db.Column(db.Integer, primary_key=True)
    profil_name = db.Column(db.String(140))
    profil_mask = db.Column(db.Integer)
Example #10
0
class Solution(db.Model):
    sol_id = db.Column(db.Integer, primary_key=True)
    sol_nom = db.Column(db.String(140), index=True)
Example #11
0
class ObjetReseau(db.Model):
    objrezo_id = db.Column(db.Integer, primary_key=True)
    objrezo_nom = db.Column(db.String(140))
Example #12
0
class IpServeur(db.Model):
    __table_args__ = (db.UniqueConstraint('ips_serveur', 'ips_ip'), )
    ips_id = db.Column(db.Integer, primary_key=True)
    ips_serveur = db.Column(db.Integer, db.ForeignKey('serveur.srv_id'))
    ips_ip = db.Column(db.String(140))
Example #13
0
class Client(db.Model):
    client_id = db.Column(db.Integer, primary_key=True)
    client_name = db.Column(db.String(140))
Example #14
0
class OS(db.Model):
    os_id = db.Column(db.Integer, primary_key=True)
    os_name = db.Column(db.String(140))
Example #15
0
class FileSystem(db.Model):
    __table_args__ = (db.UniqueConstraint('fs_serveur', 'fs_montage'), )
    fs_id = db.Column(db.Integer, primary_key=True)
    fs_serveur = db.Column(db.Integer, db.ForeignKey('serveur.srv_id'))
    fs_montage = db.Column(db.String(140))
    fs_volume = db.Column(db.Integer)
Example #16
0
class Ksu(db.Model):
    ksu_id = db.Column(db.Integer, primary_key=True)
    ksu_compte = db.Column(db.Integer, db.ForeignKey('compte_serveur.cps_id'))
    ksu_serveur = db.Column(db.Integer, db.ForeignKey('serveur.srv_id'))
    ksu_user = db.Column(db.String(140))
Example #17
0
class CompteServeur(db.Model):
    __table_args__ = (db.UniqueConstraint('cps_serveur', 'cps_compte'), )
    cps_id = db.Column(db.Integer, primary_key=True)
    cps_serveur = db.Column(db.Integer, db.ForeignKey('serveur.srv_id'))
    cps_groupe = db.Column(db.String(140))
    cps_compte = db.Column(db.String(140))