def select(id):
party = None
sql = "SELECT * FROM parties WHERE id = %s"
values = [id]
result = run_sql(sql, values)[0]
if result is not None:
party = Party(result['name'], result['next_game'], result['id'])
return party
def parties(id):
player_parties = []
sql = "SELECT parties.* FROM parties INNER JOIN characters ON characters.party_id = parties.id WHERE characters.player_id = %s"
values = [id]
results = run_sql(sql, values)
for result in results:
party = Party(result["name"], result["next_game"], result["id"])
player_parties.append(party)
return player_parties
def select_all():
parties = []
sql = "SELECT * FROM parties"
results = run_sql(sql)
for result in results:
party = Party(result['name'], result['next_game'], result['id'])
parties.append(party)
return parties
def createParty(self, name):
if name and not name.isspace():
party = Party(0)
session.add(party)
session.commit()
session.close()
return party
def post(self):
logging.info("Running scrape handler")
scraper = Scraper()
scrape_result = scraper.scrape_all()
seats = []
parties = []
prices = []
winners = {}
for s in scrape_result:
if s.name not in seats:
seats.append(Seat(name=s.name, state=s.state, id=s.name))
seats[-1].put()
lowest_price = 1000
winner = ''
for c in s.candidates:
if c.name not in parties:
parties.append(Party(name=c.name, id=c.name))
party_key = ndb.Key(Party, c.name)
seat_key = ndb.Key(Seat, s.name)
price = Price(party=party_key, seat=seat_key, price=c.price)
price.put()
if c.price < lowest_price:
lowest_price = c.price
winner = c.name
if winner in winners:
winners[winner] += 1
else:
winners[winner] = 1
for party in parties:
if party.name in winners:
party.num_seats = winners[party.name]
else:
party.num_seats = 0
party.put()
self.response.out.write(winners)
def update_party(id):
name = request.form["name"]
next_game = request.form["next_game"]
party = Party(name, next_game, id)
party_repository.update(party)
return show_parties(party.id)
def create_party():
name = request.form["name"]
next_game = request.form["next_game"]
new_party = Party(name, next_game)
party_repository.save(new_party)
return redirect("/parties")
def insert_party(session, r):
name = r['party']
if name and not has_party(session, name):
party = Party(name=name)
session.add(party)
session.flush()
def get(self):
parties = Party.query(Party.num_seats > 0).order(-Party.num_seats).fetch(150)
template = jinja_environment.get_template('templates/summary.html')
self.response.out.write(template.render({'parties':parties}))
def get(self):
parties = Party.query(
Party.num_seats > 0).order(-Party.num_seats).fetch(150)
template = jinja_environment.get_template('templates/summary.html')
self.response.out.write(template.render({'parties': parties}))
def setUp(self):
self.party_1 = Party("Barovian Basterds", "2020.10.04")
def test_party_can_have_id(self):
self.party_2 = Party("Argyle & Associates", "Friday", 2)
self.assertEqual(2, self.party_2.id)
import pdb
from models.character import Character
from models.party import Party
from models.player import Player
import repos.character_repository as character_repository
import repos.party_repository as party_repository
import repos.player_repository as player_repository
character_repository.delete_all()
party_repository.delete_all()
player_repository.delete_all()
party_1 = Party("Barovian Basterds", "2020.10.04")
party_repository.save(party_1)
party_2 = Party("Argyle & Associates", "Friday")
party_repository.save(party_2)
player_1 = Player("Dafyd", "Dungynmaestrr", "*****@*****.**")
player_repository.save(player_1)
player_2 = Player("Vin", "Diesel", "*****@*****.**")
player_repository.save(player_2)
player_3 = Player("Wil", "Wheaton", "*****@*****.**")
player_repository.save(player_3)
player_4 = Player("Joe", "Manganiello", "*****@*****.**")
player_repository.save(player_4)
def setUp(self):
self.player_1 = Player("Dafyd", "Dungynmaestrr", "*****@*****.**", 2)
self.party_1 = Party("Barovian Basterds", "2020.10.04", 4)
self.character_1 = Character("Duirric 'Dusty' Glenfoot", "Halfling", "Rogue", 11, 18, True, 80, 20, 12, "Brave: advantage against frightened", "Normal", "Thieves Cant", None, "The law", 0, self.player_1, self.party_1)