def testReport(): ret = main(sys.argv[1:]) if ret: #connect to the database engine = model.connectDB() print "Create database session..." DBSession = sessionmaker(bind=engine) session = DBSession() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." flag = check(ret, session) if flag != -1: getresult(flag, session) else: print "Please input the right parameter!" session.close() engine.dispose() else: print "Error input parameter!" usage() sys.exit(2)
def logDB(param): engine = model.connectDB() print "Create database session..." DBSession = sessionmaker(bind=engine) session = DBSession() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." checksysos(param['sysosid'], session) rootdir= "/home/information/log/" + param['logdir'] allFiles(rootdir, session) session.close() engine.dispose()
def logDB(param): engine = model.connectDB() print "Create database session..." DBSession = sessionmaker(bind=engine) session = DBSession() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." checksysos(param['sysosid'], session) rootdir = "/home/information/log/" + param['logdir'] allFiles(rootdir, session) session.close() engine.dispose()
def driverDB(param): global osname, osversion engine = model.connectDB() print "Create database session..." DBSession = sessionmaker(bind=engine) session = DBSession() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." sPos = model.findSubstring(param, '/', 1) osname = param[:sPos] osversion = param[sPos+1:] rootdir= "/home/information/drivers/" + param allFiles(rootdir, session) session.close() engine.dispose()
def initDB(rootdir): engine = model.connectDB() print "Create database session..." DBSession = sessionmaker(bind=engine) session = DBSession() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." print "Searching file change...." ret = allFiles(rootdir) if ret == 0: print "Updating system and os table" updatedb(session) print "Done." session.close() engine.dispose() return logparam
# -*- coding: utf-8 -*- ''' Created on Mar 5, 2018 webapp.py: website provider @author: Neo ''' import sys, os, md5 sys.path.append("/root/Project/autotest") from flask import Flask, redirect, render_template, request, session, json from sqlalchemy import * from sqlalchemy.orm import sessionmaker from sqlserver import SQLClass from common import model #database connection engine = model.connectDB() print "Create database session..." Session = sessionmaker(bind=engine) db_session = Session() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." #app initialization app = Flask(__name__) #webpage initialization @app.route('/')
# -*- coding: utf-8 -*- ''' Created on Mar 5, 2018 webapp.py: website provider @author: Neo ''' import sys, os, md5 sys.path.append("/root/Project/autotest") from flask import Flask, redirect, render_template, request, session, json from sqlalchemy import * from sqlalchemy.orm import sessionmaker from sqlserver import SQLClass from common import model #database connection engine = model.connectDB() print "Create database session..." Session = sessionmaker(bind=engine) db_session = Session() print "Done." print "Create metadata object..." meta = MetaData(bind=engine) meta.reflect(bind=engine) model.Base.metadata.create_all(engine, checkfirst=True) print "Done." #app initialization app = Flask(__name__) #webpage initialization