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',
