def convert_auth0_id_to_api_id(auth0_user_id):
user = User.query.filter(User.auth0_id == auth0_user_id).first()
if user is None:
new_user = User()
new_user.auth0_id = auth0_user_id
db.session.add(new_user)
db.session.commit()
user_id = new_user.id
else:
user_id = user.id
return user_id
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()
