PDP script to fix screening numbers

Script to fix screening numbers given a CSV file with columns 'Last Name', 'First Name', 'Screening'

Not an actual merge request since I don't know if you want to keep this script for the future but if you want to merge it and keep the script it's fine. But I want you to see it just in case. I only do changes if the query retrieves a single result, otherwise I print a log error.

smash/db_scripts/create_dummy_data.py

+# coding=utf-8
+import os, sys
+sys.path.append(sys.path.append(os.path.join(os.path.dirname(__file__), '..'))) #run script as it was on parent folder
 from django.conf import settings
 from django.core.files import File  # you need this somewhere
 import urllib
@@ -5,7 +8,6 @@ from django.core.files.uploadedfile import SimpleUploadedFile
 import django
 import datetime
 from django.utils import timezone
-import os
 os.environ.setdefault("DJANGO_SETTINGS_MODULE", "smash.settings")
 django.setup()
 from django.contrib.auth.models import User
@@ -18,13 +20,12 @@ from web.models.constants import REDCAP_TOKEN_CONFIGURATION_TYPE, REDCAP_BASE_UR
 from web.models.constants import MAIL_TEMPLATE_CONTEXT_APPOINTMENT, MAIL_TEMPLATE_CONTEXT_VISIT, \
     MAIL_TEMPLATE_CONTEXT_SUBJECT, MAIL_TEMPLATE_CONTEXT_VOUCHER
 from web.models.worker_study_role import ROLE_CHOICES_PROJECT_MANAGER, ROLE_CHOICES_SECRETARY, ROLE_CHOICES_DOCTOR, WORKER_VOUCHER_PARTNER, ROLE_CHOICES_TECHNICIAN, ROLE_CHOICES_PSYCHOLOGIST, ROLE_CHOICES_NURSE
-from web.tests.functions import get_resource_path
 
 from collections import defaultdict
 import logging
 logger = logging.getLogger(__name__)
 
-from web.views.notifications import get_today_midnight_date
+from web.utils import get_today_midnight_date
 from faker.providers import BaseProvider, color
 from numpy.random import choice
 from faker import Faker
@@ -100,7 +101,7 @@ class smashProvider(BaseProvider):
     # screening number
     screening_number_ctrs = defaultdict(int)
     # template file
-    template_file = get_resource_path('upcoming_appointment_FR.docx')
+    template_file = os.path.join(os.path.dirname(__file__), '../web/tests/data', 'upcoming_appointment_FR.docx')
     template_context = [MAIL_TEMPLATE_CONTEXT_APPOINTMENT, MAIL_TEMPLATE_CONTEXT_VOUCHER,
                         MAIL_TEMPLATE_CONTEXT_VISIT, MAIL_TEMPLATE_CONTEXT_SUBJECT]
     # subjects
@@ -717,5 +718,5 @@ if __name__ == "__main__":
     fake.createSmashStudySubjects()
     fake.createSmashAppointments()
     fake.createSmashWorker(first_name=u'System', last_name=u'Admin',
-                           email=u'carlos.vega@uni.lu', name=ROLE_CHOICES_TECHNICIAN, password='smashtest007',
+                           email=u'carlos.vega@uni.lu', role=ROLE_CHOICES_TECHNICIAN, password='smashtest007',
                            locations=fake.getAllCreatedLocations(), languages=fake.getAllCreatedLanguages(), is_super=True)