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 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)