Python connectDB Examples

Example #1

File: report.py Project: NeoCui/Codebackup

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)

Example #2

File: log.py Project: NeoCui/Codebackup

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()

Example #3

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()

Example #4

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()

Example #5

File: initHandle.py Project: NeoCui/Codebackup

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

Example #6

File: initHandle.py Project: NeoCui/Codebackup

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

Example #7

File: webapp.py Project: NeoCui/Codebackup

# -*- 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('/')

Example #8

File: webapp.py Project: NeoCui/Codebackup

# -*- 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