def create_new_user(name): verify_user_does_not_exist(name) new_user = User() new_user.name = name new_user.questions_total = 0 new_user.questions_won = 0 save(new_user) return get_response({'name': name})
def add_user_to_database(self, users): with self.app.app_context(): self.db = SQLAlchemy() self.db.init_app(self.app) for i in range(len(users)): user = User() user.name = users[i]['name'] user.questions_won = users[i]['wins'] user.questions_total = users[i]['answers'] self.db.session.add(user) self.db.session.commit()
def add_data_to_database(self, data): with self.app.app_context(): self.db = SQLAlchemy() self.db.init_app(self.app) for datapoint in data: test = Test() test.name = "Test" + str(datapoint['test']) self.db.session.add(test) user = User() user.auth0_id = "User" + str(datapoint['user']) user.name = "User" + str(datapoint['user']) user.email = "User" + str(datapoint['user']) self.db.session.add(user) self.db.session.commit() for j in range(datapoint['data']): result = TestResult() result.test_id = test.id result.user_id = user.id result.value = j result.time = datetime.datetime.utcnow() self.db.session.add(result) self.db.session.commit()