def test4SaveCards(self): for index in range(50): forbidden = "['word1', 'word2', 'word3', 'word4']" card = CardModel("word_" + str(index + 1), forbidden, "Book", "345") self.session.add(card) self.session.flush() self.session.commit() self.assertEqual(CardModel.numberOfRows(self.session), 50)
def start_game_db(Session): session = Session() players = list() players.append( PlayerModel(nickname='nwhite', email='*****@*****.**', role=4)) players.append( PlayerModel(nickname='nwhite2', email='*****@*****.**', role=4)) players.append( PlayerModel(nickname='nwhite3', email='*****@*****.**', role=4)) players.append( PlayerModel(nickname='nwhite4', email='*****@*****.**', role=4)) numberOfTeams = 2 minRequiredPlayers = 2 maxPlayersPerTeam = 2 game = GameModel(name='game1', initiator=players[0], numberOfTeams=numberOfTeams, minRequiredPlayers=minRequiredPlayers, maxPlayersPerTeam=maxPlayersPerTeam) for index in range(50): print("Putting card.") forbidden = "{'word1', 'word2', 'word3', 'word4'}" card = CardModel("word_" + str(index + 1), forbidden, "Book", "345") session.add(card) session.add(game) session.commit() for i in range(numberOfTeams): teamName = 'team' + str(i) team = TeamModel(teamName) if (i == 0): team.addPlayer(players[0]) team.addPlayer(players[1]) else: team.addPlayer(players[2]) team.addPlayer(players[3]) game.addTeam(team) game.gameState = GAME_READY session.commit() session.close()
def testSaveCard(self): delete_db(engine) AppModelBase.metadata.create_all(engine) forbidden = "{'word1', 'word2', 'word3', 'word4'}" card = CardModel(buzzword="unit test", forbidden_words=forbidden, source="Book", source_page="345", skipped_count=0, won_count=0, lost_count=0, is_phrase=IS_PHRASE) self.session.add(card) self.session.commit() card = CardModel.findCardById(self.session, 1) self.assertEqual(card.buzzword, "unit test")
def mutate(root, info, idNumber, name, dob=None, address=None, hometown=None, cardName=None): card = CardModel( idNumber=idNumber, name=name, dob=dob, address=address, hometown=hometown, cardName=cardName, ) ok = True SaveCard(card) return CreateCard(card=card, ok=ok)
def getQuizletCards(login='******', client_id='SN77uEA94G', endpoint='258934949'): # Getting the cards from quizlet. session = globalVars.Session() quizletClient = quizlet.QuizletClient(client_id=client_id, login=login) data = quizletClient.sets.endpoint.get(endpoint) count = 0 for term in data['terms']: count += 1 definitions = term['definition'].split('\n') buzzword = term['term'].strip() buzzword.split() card = CardModel(buzzword=buzzword, forbidden_words=json.dumps(definitions[:-1]), source=definitions[-1], source_page=' '.join(definitions[-1].split()[-2:]), is_phrase=(len(buzzword.split()) > 1), quizletEndpoint=endpoint) session.add(card) session.commit() session.close()
def setUp(self): self.model = CardModel() self.model.open(':memory:') self.view = DummyView() self.view.setModel(self.model)