def main(): dirdata = "/opt/hosting/run/exploit/current/var/data" reposvn = "%s/uvm" % dirdata CheckInstall(dirdata,reposvn) conn = connect_bdd(echo=False) engine = conn.connect() Session = sessionmaker(bind=engine) session = Session() InsertIntoUvm(session, reposvn) maj_repo(reposvn)
#!/usr/bin/python # -*- coding: utf-8 -*- from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from bdd import connect_bdd #engine = create_engine('sqlite:///uvm.db', echo=True) conn = connect_bdd() engine = conn.connect() Base = declarative_base() class uVM(Base): __tablename__ = 'uVM' id_uvm = Column('uvm_id', Integer, primary_key=True) date_uvm = Column('date_uvm', String(10)) srv_xen = Column('srv_xen', String(255)) vm_name = Column('vm_name', String(255)) pfs_mere = Column('pfs_mere', String(255)) pfs_fille = Column('pfs_fille', String(255)) site = Column('site', String(255)) salle = Column('salle', String(255)) domain = Column('domain', String(255)) memory = Column('memory', Integer) cpu = Column('cpu', Integer) disk = Column('disk', Integer) uvm_memory = Column('uvm_memory', Integer) uvm_cpu = Column('uvm_cpu', Integer) uvm_disk = Column('uvm_disk', Integer)