def login(): if request.method == 'POST': db = model.create_session() if model.check_login(db, **request.form): session['username'] = request.form['username'] return redirect(url_for('show_record')) return redirect(url_for('show_record')) if session.get('username') \ else render_template('login.html')
def main(): session = create_session() date_format = '%Y-%m-%W' results = session.query( func.strftime(date_format, Message.sent), func.sum(Message.polarity), func.count(Message.id), func.strftime('%m-%d-%Y', Message.sent), ).join(Contact).filter( and_( Contact.name == "Me", Message.polarity != 0, Message.subjectivity >= .9, ) ).group_by( func.strftime(date_format, Message.sent), ).order_by( Message.sent.asc() ).all() # width = .35 axis_every = 10 * 1 x_axis_labels = [ x[1][3] for x in enumerate(results) if x[0] % axis_every == 0] x_axis = [x[0] for x in enumerate(results)] y_axis = [x[1]/x[2] for x in results] colors = map(lambda v: {True: 'g', False: 'r'}[v > 0], y_axis) #y_axis = map(abs, y_axis) print "Samples: {}".format(len(x_axis)) plt.rcParams["figure.figsize"][0] = 21.0 plt.rcParams["figure.figsize"][1] = 9.0 plt.rcParams["figure.autolayout"] = True plt.bar(x_axis, y_axis, linewidth=0, color=colors) plt.grid(b=True, which='major', linestyle='-') plt.title('Positive or Negative calculated sentiment of sent text messages per week') plt.ylabel("Calculated percentage of sentiment per message") plt.xlabel("Date") plt.xticks( np.arange(min(x_axis), max(x_axis), axis_every), x_axis_labels, rotation=35, horizontalalignment='center', ) plt.xlim([min(x_axis) - 0.5, max(x_axis) + 0.5]) plt.ylim([min(y_axis) - .1, max(y_axis) + .1]) print plt.rcParams["figure.figsize"] plt.savefig('output.png')
def main(): session = create_session() date_format = '%Y-%m-%W' results = session.query( func.strftime(date_format, Message.sent), func.sum(Message.polarity), func.count(Message.id), func.strftime('%m-%d-%Y', Message.sent), ).join(Contact).filter( and_( Contact.name == "Me", Message.polarity != 0, Message.subjectivity >= .9, )).group_by(func.strftime(date_format, Message.sent), ).order_by( Message.sent.asc()).all() # width = .35 axis_every = 10 * 1 x_axis_labels = [ x[1][3] for x in enumerate(results) if x[0] % axis_every == 0 ] x_axis = [x[0] for x in enumerate(results)] y_axis = [x[1] / x[2] for x in results] colors = map(lambda v: {True: 'g', False: 'r'}[v > 0], y_axis) #y_axis = map(abs, y_axis) print "Samples: {}".format(len(x_axis)) plt.rcParams["figure.figsize"][0] = 21.0 plt.rcParams["figure.figsize"][1] = 9.0 plt.rcParams["figure.autolayout"] = True plt.bar(x_axis, y_axis, linewidth=0, color=colors) plt.grid(b=True, which='major', linestyle='-') plt.title( 'Positive or Negative calculated sentiment of sent text messages per week' ) plt.ylabel("Calculated percentage of sentiment per message") plt.xlabel("Date") plt.xticks( np.arange(min(x_axis), max(x_axis), axis_every), x_axis_labels, rotation=35, horizontalalignment='center', ) plt.xlim([min(x_axis) - 0.5, max(x_axis) + 0.5]) plt.ylim([min(y_axis) - .1, max(y_axis) + .1]) print plt.rcParams["figure.figsize"] plt.savefig('output.png')
backupCount=1) if APP.config['DEBUG'] is not True: handler.setLevel(logging.INFO) else: handler.setLevel(logging.DEBUG) APP.logger.addHandler(handler) # wtforms csrf CsrfProtect(app=APP) # import the modules to be used import model from model import engine, Base import forms SESSION = model.create_session(APP.config['DB_URL'], engine, Base) @APP.route("/", methods=['GET', 'POST']) def index(): ''' Give out the form for preordering ''' form = forms.DiscountForm() out = {'status': False, 'msg': ''} if form.validate_on_submit(): # check if there is a user with the given email user = model.User.get_user_by_email(session=SESSION, emailid=form.data.get('email')) if user is not None: out['msg'] = ("There is already a user registered for " "discount with this email") APP.logger.warn("Another attempt for discount of user: %s",
def add_record(): db = model.create_session() model.add_record(db, username=session['username'], **request.form) return redirect(url_for('show_record'))
def show_record(): if session.get('username'): db = model.create_session() records = model.query_record(db) return render_template('form.html', records=records) return redirect(url_for('login'))
import sys import pylab import numpy import model import random # constants # race ZERG = 'Z' PROTOSS = 'P' TERRAN = 'T' RANDOM = 'R' SAVEDIR = './data' session = model.create_session() pylab.rcParams['font.size'] = 9.0 def plot_single(teamnum): matches = {} wins = {} info = {} total_matches = 0 # query team table to get teamname teamname = session.query(model.Team).filter(model.Team.cslid==teamnum).first().name num_players = session.query(model.Team).filter(model.Team.cslid==teamnum).first().single for player in session.query(model.Player).filter(model.Player.team==teamnum).all(): if player.games > 0:
import numpy as np import pandas as pd import matplotlib.pyplot as plt import seaborn as sns # noqa from sqlalchemy.sql import func from sklearn.cluster import AgglomerativeClustering from model import create_session from model.overview import League from model.personnel import Player from model.stats import PlayerMatchStats Session = create_session() TEMPLATES = { 'Midfielder': ['goals', 'shots_ot', 'dribbles_won', 'big_chances_created', 'acc_through_balls', 'key_passes', 'assists', 'tackles_won_adj', 'interceptions_adj', 'blocks'], } LABELS = { 'goals': 'goals', 'shots_ot': 'shots_ot', 'dribbles_won': 'dribbles', 'big_chances_created': 'big_chances_cr', 'acc_through_balls': 'through_blls', 'key_passes': 'key_p', 'assists': 'assists', 'tackles_won_adj': 'tackles',