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