def login_user(username, password):
session = Session()
users = session.query(User).filter(User.username == username).all()
token = ''
if len(users) != 0:
user = users[0]
if (user.check_password(password)):
token = user.encode_auth_token()
session.close()
return token
def league_data(user_id):
res = {'success': False, 'data': {}}
session = Session()
users = session.query(User).filter(User.id == user_id).all()
if len(users) != 0:
league_data = users[0].leagues
league_ids = [league.id for league in league_data]
league_info = extract_league_info(league_data)
league_games = extract_league_games(league_data)
user_ids = {
member.id
for league in league_data for member in league.members
}
all_relevant_users = session.query(User).filter(
User.id.in_(user_ids)).all()
user_data = extract_user_data(all_relevant_users)
data = {
'myLeagues': league_ids,
'leagueInfo': league_info,
'leagueGames': league_games,
'userData': user_data
}
res['success'] = True
res['data'] = data
session.close()
return res
def register_user(username, password):
if (len(username) < 5):
return False
if (len(password) < 6):
return False
session = Session()
users = session.query(User).filter(User.username == username).all()
unique_name = len(users) == 0
if unique_name:
new_user = User(username, password)
session.add(new_user)
session.commit()
session.close()
return unique_name
def get_auction_listing():
data = request_to_dict(request.values)
if 'listing_id' in data and data['listing_id'] != 0:
row = Session().query(
Auction.listing,
Auction.dirty).filter(Auction.id == data['listing_id']).first()
if row:
return jsonify({
'status': 'ok',
'data': {
'listing': row.listing,
'dirty': row.dirty,
}
})
return jsonify({'status': 'error', 'message': 'invalid/no listing'})
def remove_session(ex=None):
from app.models.base import Session
Session.remove()
# coding=utf-8
# 1 - imports
from datetime import datetime
from app.models.base import Session, engine, Base
from app.models.game import Game
from app.models.league import League
from app.models.user import User
# 2 - generate database schema
Base.metadata.create_all(engine)
# 3 - create a new session
session = Session()
# 4 - create leagues
league1 = League("Catan with the Boys", "Catan")
league2 = League("Bigger Catan Group!", "Catan")
league3 = League("Pokemasters", "Pokemon")
#5 - create games
game1 = Game(datetime(2020, 10, 1, 20, 0))
game2 = Game(datetime(2020, 10, 1, 22, 0))
game3 = Game(datetime(2020, 10, 2, 10, 0))
game4 = Game(datetime(2020, 10, 3, 20, 0))
game5 = Game(datetime(2020, 10, 4, 8, 0))
game6 = Game(datetime(2020, 10, 4, 15, 0))
game7 = Game(datetime(2020, 10, 5, 21, 0))
game8 = Game(datetime(2020, 10, 8, 21, 0))
game9 = Game(datetime(2020, 10, 10, 13, 0))
def teardown_request(exception=None):
try:
Session.remove()
except:
pass
# coding=utf-8 from app.models.base import Session from app.models.game import Game from app.models.user import User from app.models.league import League session = Session() users = session.query(User).delete() leagues = session.query(League).delete() session.commit()
# coding=utf-8
from app.models.base import Session
from app.models.user import User
from app.models.game import Game
from app.models.league import League
session = Session()
# print leagues
leagues = session.query(League).all()
print('\n### All leagues:')
for league in leagues:
print(f'{league.id}, {league.league_name}, {league.game_name}')
for game in league.games:
print(f'\t{game.date}')
for user in league.members:
print(f'\t{user.username}')
print('')
# print games
games = session.query(Game).all()
print('\n### All games:')
for game in games:
print(f'{game.date}, {game.winner}')
print('')
# print users
users = session.query(User).all()
def teardown_request(exception=None):
try:
Session.remove()
except:
pass
def has_listing_prices(auction_id):
return True if Session().query(AuctionItem).filter(
AuctionItem.auction_id == auction_id).count() > 0 else False
def auction(auction_id):
auction_listing = AuctionItem.get_items_by_auction(auction_id)
auction = Session().query(Auction).filter(Auction.id == auction_id).first()
return render_template('admin/auction.html',auction=auction,auction_listing=auction_listing)
def index():
dt = Delorean()
auctions = Session().query(Auction).order_by(Auction.date.desc()).all()
return render_template('admin/index.html', auctions=auctions, now=int(dt.epoch()))
