def display_rt_graph(conn): while True: try: db = dbHandler('sqlite3') conn = db.connect() #read all the invoice data from the sqlite database df = pd.read_sql_query( "select InvoiceId,CustomerId,InvoiceDate,Total from invoice;", conn, parse_dates=['InvoiceDate'], index_col='InvoiceDate') fig, axes = plt.subplots( ncols=2) #display two graphs to see the differences clearly sales = df.resample("M").sum() #sum of sales for one graph sales['Total'].plot(ax=axes[0]) #unique customers for the other graph unique_customers = df['CustomerId'].resample('M').apply( lambda x: x.nunique()) unique_customers.plot(ax=axes[1]) fig.tight_layout() plt.pause(1) clear_output(wait=True) except Exception as e: pass
def __getPlot(req, plot, filename, title, xSize, ySize): filenameWithPath = "/tmp/%s-%sx%s.%s" % (filename.split('.')[0], xSize, ySize, filename.split('.')[1]) db = dbHandler.dbHandler() g = tempPlot.tempPlot() if plot == 'day': houres = 24 if plot == 'week': houres = 24 * 7 if plot == 'month': houres = 24 * 7 * 30 if plot == 'year': houres = 24 * 365 # Check for new Data if db.hasNewData(filenameWithPath): data = db.getData(houres) g.plotToFile(data, filenameWithPath, title, int(xSize), int(ySize)) db.writeRequest(filenameWithPath) # Check if file exits: if not os.path.exists(filenameWithPath): return apache.HTTP_NOT_FOUND req.content_type = 'image/png' req.sendfile(filenameWithPath)
def getTestPlanId(self, name): """ 通过测试计划名获取测试计划id :param name: :return: tpid """ db = dbHandler() # sql = 'select * from nodes_hierarchy WHERE name="%s"'% name datas = db.getTestPlanId(name) db.closeConnection() return datas[0][0]
def main(): """ """ cfg = parseCmdArgs(sys.argv) db = dbHandler.dbHandler() db.connectDb(cfg['user'], cfg['password'], cfg['db_host'], "openbmp") asnList = getASNList(db) walkWhois(db,asnList) db.close()
def getPlanTV(self, tpid): """ 获取testversion id :param tpid: 测试计划Id,可调用getTestPlanId来获取 :return: 返回测试计划中包含的用例tvid list """ db = dbHandler() datas = db.getTVidByTP(tpid) db.closeConnection() tcversionids = [] for i in xrange(len(datas)): tcversionids.append(datas[i][2]) return tcversionids
def main(): cfg = parseCmdArgs(sys.argv) db = dbHandler.dbHandler() db.connectDb(cfg['user'], cfg['password'], cfg['db_host'], cfg['db_name']) print('connected to db') server = cfg['server'] load_export(db, server); print "Loaded rpki roas" # Purge old entries that didn't get updated db.queryNoResults("DELETE FROM rpki_validator WHERE timestamp < now() - interval '1 hour'") print("purged old roas") print("Done")
def getCaseId(self, tvids): """ 获取数据库中的caseId :param tvid: :return: """ if not tvids: return False db = dbHandler() caseids = [] for i in xrange(len(tvids)): datas = db.getCaseid(tvids[i]) for j in xrange(len(datas)): caseids.append(datas[j][0]) db.closeConnection() return caseids
def getExternalId(self, tvids): """ 获取测试用例的id :param tvids: 传入list[testversion_id, ] :return: 返回列表 """ if not tvids: return False db = dbHandler() externalids = [] for i in xrange(len(tvids)): datas = db.getTCidByTV(tvids[i]) for j in xrange(len(datas)): externalids.append(datas[j][1]) db.closeConnection() return externalids
def main(): """ """ cfg = parseCmdArgs(sys.argv) # Download the RR data files download_data_file() db = dbHandler.dbHandler() db.connectDb(cfg['user'], cfg['password'], cfg['db_host'], cfg['db_name']) for source in RR_DB_FTP: import_rr_db_file(db, source, "%s/%s" % (TMP_DIR, RR_DB_FTP[source]['filename'])) rmtree(TMP_DIR) db.close()
conn, parse_dates=['InvoiceDate'], index_col='InvoiceDate') fig, axes = plt.subplots( ncols=2) #display two graphs to see the differences clearly sales = df.resample("M").sum() #sum of sales for one graph sales['Total'].plot(ax=axes[0]) #unique customers for the other graph unique_customers = df['CustomerId'].resample('M').apply( lambda x: x.nunique()) unique_customers.plot(ax=axes[1]) fig.tight_layout() plt.pause(1) clear_output(wait=True) except Exception as e: pass if __name__ == '__main__': try: db = dbHandler('sqlite3') conn = db.connect() display_rt_graph(conn) except KeyboardInterrupt: print('Interrupted') try: sys.exit(0) except SystemExit: os._exit(0)
from flask import Flask, render_template, request, jsonify from planner import Planner import json from dbHandler import dbHandler app = Flask(__name__) dbCaller = dbHandler() planner = Planner() # Should comment out this call to prevent initialization of radar db at ever # server restart. #dbCaller.initializeDatabase() @app.route("/") def index(): planner.definePlanningProblem() a = planner.getActionNames() g = ['Extinguish Fire At Byeng'] if a == []: o = {'1': 'INVALID INITIAL STATE ;Initial State is Invalid'} else: o = planner.getOrderedObservations() return render_template('index.html', plan=o, actions=a, goals=g) def getPresentPlan(request): """ Example 'plan' : [ {"name":"address_media firechief","x":0,"y":0,"width":12,"height":1},
Copyright: (c) 2012 by Anusha Ranganathan. """ from __future__ import absolute_import import pyinotify from celery import Celery import os, stat, time from dbHandler import dbHandler from diskMonitorConfig import SCAN_LOCATIONS, DATABASE, TABLE import celeryconfig celery = Celery() celery.config_from_object(celeryconfig) db = dbHandler(database=DATABASE, table=TABLE) class EventHandler(pyinotify.ProcessEvent): def bytes_to_english(self, no_of_bytes): # Helper function to convert number of bytes receives from os.stat into human radabale form # 1024 per 'level' suffixes = ["bytes", "kb", "Mb", "Gb", "Tb", "Pb", "Eb", "Yb"] f_no = float(no_of_bytes) level = 0 while f_no > 1024.0: f_no = f_no / 1024.0 level = level + 1 if level == 0: return "%s %s" % (no_of_bytes, suffixes[level]) return "%5.1f %s" % (f_no, suffixes[level])
def __init__(self): self.dbCaller = dbHandler()
def __init__(self, user_id): self.db = dbHandler.dbHandler() self.userPreferences = self.db.GetUserPreferences(user_id) self.ingredientsGroups = self.db.ingredients
def get_db(): "Opens a new database connection if there is none yet for the current application context." top = _app_ctx_stack.top if not hasattr(top, 'sqlite_db'): top.sqlite_db = dbHandler(database=DATABASE, table=TABLE) return top.sqlite_db
def __init__(self): self.db_handler = dbHandler() self.new_db = self.db_handler.new_db
from flask import Flask, jsonify, request import subprocess import sys import rateCalculation import dbHandler app = Flask(__name__) db = dbHandler.dbHandler() @app.route('/') def home(): pass #post /user data: {name :} @app.route('/user', methods=['POST']) def create_user(): request_data = request.get_json() return db.SaveNewUserPreferences(user_data=request_data) #get /restaurant/<name> data: {name :} @app.route('/restaurant/<string:data>') def get_recommended_dishes(data): datar = rateCalculation.main(data) return jsonify(datar) #get /users