def study_init(row):
study = Study()
num = Study.query.filter_by(name=row['Nom']).count()
if num > 0:
Study.query.delete()
study.name = row['Nom']
study.description = row['Description']
return study
def add():
form = StudyForm()
if form.validate_on_submit():
study = Study(name=form.name.data, description=form.description.data)
db.session.add(study)
db.session.commit()
flash(_('Nouvelle etude ajouté avec succèss!'))
return redirect(url_for('study.detail', id=study.id))
return render_template('study/form.html', form=form)
def study():
form = StudyForm()
if form.validate_on_submit():
study = Study(id_study=form.id_study.data, date_study=form.date_study.data, result_study=form.result_study.data)
#save the model to the database
db.session.add(study)
db.session.commit()
flash('Congratulations, you are now a registered study!')
return redirect(url_for('index'))
return render_template('study.html', title='validate', form=form)
def create_study(
client,
name="Test Study",
description="",
image="",
data_values=0,
number_of_columns=4,
number_of_rows=4,
start_date=date.today(),
end_date=date.today() + timedelta(days=3),
mail_sent=False,
creator=None,
user_group=None,
card_set_x=None,
card_set_y=None,
data_value_labels=None,
):
with client.application.test_request_context():
if not creator:
creator = create_admin(client)
if not user_group:
user_group = create_user_group(client, creator=creator)
if not card_set_x:
card_set_x = create_card_set(client, creator=creator)
if not card_set_y:
card_set_y = create_card_set(client, creator=creator)
if not data_value_labels:
data_value_labels = [
create_data_value_label(client, creator=creator, label="You get the benefit (e.g. Personalised Service)"),
create_data_value_label(client, creator=creator, label="Data Consumer gets the benefit (e.g. Supply Chain gets the benefit)")
]
study = Study(
name=name,
description=description,
image=image,
data_values=data_values,
number_of_columns=number_of_columns,
number_of_rows=number_of_rows,
start_date=start_date,
end_date=end_date,
mail_sent=mail_sent,
creator=creator,
user_group=user_group,
card_set_x=card_set_x,
card_set_y=card_set_y,
data_value_labels=data_value_labels,
)
db.session.add(study)
db.session.commit()
return study
def add_fake_data(number_users):
"""
Adds fake data to the database.
"""
study = Study()
study.name = 'test_study'
study.patients = 10
study.variables = 10
db.session.add(study)
db.session.commit()
variables = [Variable() for i in range(10)]
for i, v in enumerate(variables):
v.code = 'variable' + str(i)
v.path = '\\\\folder1\\folder2\\variable' + str(i)
v.type = 'NUMERIC'
v.study_id = study.id
db.session.add(v)
db.session.commit()
