def test_duplicate_reviewer(self):
test_reviewer = Reviewer('tester', 'reviewer', 'toScore_dir',
'scored_dir').save_to_db(
testing=True, postgresql=self.postgresql)
dup_reviewer = test_reviewer.save_to_db(testing=True,
postgresql=self.postgresql)
self.assertFalse(dup_reviewer.reviewer_id is None)
def test_delete_reviewer(self):
reviewer_to_delete = Reviewer.from_db(scored_dir=self.seed_tup[-1],
testing=True,
postgresql=self.postgresql)
reviewer_to_delete.delete_from_db(testing=True,
postgresql=self.postgresql)
reload_reviewer = Reviewer.from_db(scored_dir=self.seed_tup[-1],
testing=True,
postgresql=self.postgresql)
self.assertIsNone(reload_reviewer)
def handler_seed_blind_trials(postgresql):
all_trials = [
'trial_1.txt', 'trial_2.txt', 'trial_3.txt', 'trial_4.txt',
'trial_5.txt'
]
with TestingCursor(postgresql) as cursor:
handler_seed_blind_folders_table_only(cursor)
all_blind_names = models.blind_folders.list_all_blind_names(cursor)
for blind_name in all_blind_names:
blind_folder = BlindFolder.from_db(blind_name=blind_name,
testing=True,
postgresql=postgresql)
reviewer = Reviewer.from_db(reviewer_id=blind_folder.reviewer_id,
testing=True,
postgresql=postgresql)
folder = Folder.from_db(folder_id=blind_folder.folder_id,
testing=True,
postgresql=postgresql)
for trial_file in all_trials:
trial = Trial.from_db(trial_dir='/'.join(
[folder.folder_dir, trial_file]),
testing=True,
postgresql=postgresql)
full_path = '/'.join(
[reviewer.toScore_dir, blind_name, blind_name + trial_file])
with TestingCursor(postgresql) as cursor:
database.seed_tables.seed_tables.seed_blind_trials_table(
cursor, trial.trial_id, trial.folder_id, full_path)
def test_from_db(self):
load_reviewer = Reviewer.from_db(scored_dir=self.seed_tup[-1],
testing=True,
postgresql=self.postgresql)
self.assertEqual(self.seed_tup[0], load_reviewer.first_name)
self.assertEqual(self.seed_tup[1], load_reviewer.last_name)
self.assertEqual(self.seed_tup[2], load_reviewer.toScore_dir)
self.assertEqual(self.seed_tup[3], load_reviewer.scored_dir)
self.assertFalse(load_reviewer.reviewer_id is None)
def test_add_new_reviewer(self):
test_reviewer = Reviewer('tester', 'reviewer', 'toScore_dir',
'scored_dir').save_to_db(
testing=True, postgresql=self.postgresql)
self.assertEqual('tester', test_reviewer.first_name)
self.assertEqual('reviewer', test_reviewer.last_name)
self.assertEqual('toScore_dir', test_reviewer.toScore_dir)
self.assertEqual('scored_dir', test_reviewer.scored_dir)
self.assertFalse(test_reviewer.reviewer_id is None)
def setUp(self):
self.postgresql = Postgresql()
database.handlers.handlers.handler_seed_trials_table(self.postgresql)
database.handlers.handlers.handler_seed_reviewers_table(self.postgresql)
with TestingCursor(self.postgresql) as cursor:
database.handlers.handlers.handler_seed_blind_folders_table_only(cursor)
blind_name = models.blind_folders.list_all_blind_names(cursor).pop()
trial = 'trial_1.txt'
self.blind_folder = BlindFolder.from_db(blind_name=blind_name, testing=True, postgresql=self.postgresql)
self.folder = Folder.from_db(folder_id=self.blind_folder.folder_id, testing=True, postgresql=self.postgresql)
self.reviewer = Reviewer.from_db(reviewer_id=self.blind_folder.reviewer_id,
testing=True, postgresql=self.postgresql)
self.trial = Trial.from_db(trial_dir='/'.join([self.folder.folder_dir, trial]),
testing=True, postgresql=self.postgresql)
self.full_path = '/'.join([self.reviewer.toScore_dir, self.blind_folder.blind_name,
self.blind_folder.blind_name + '_1.txt'])
from models.reviewers import Reviewer
from database.database import Database
from data.constants import dbDetails, dbUser_Krista
Database.initialize(**dbDetails, **dbUser_Krista)
Reviewer(
'Krista', 'K', '/Users/Krista/Desktop/blindScoring/Krista_K/toScore_KK',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Krista_K/Scored_KK'
).save_to_db()
Reviewer(
'Jen', 'M',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Jen_M/toScore_JM',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Jen_M/Scored_JM'
).save_to_db()
Reviewer(
'Dan', 'L',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Dan_L/toScore_DL',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Dan_L/Scored_DL'
).save_to_db()
Reviewer(
'Alli', 'B',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Alli_B/toScore_AB',
'/Volumes/SharedX/Neuro-Leventhal/data/mouseSkilledReaching/blindedScoring/Alli_B/Scored_AB'
).save_to_db()
Reviewer(
all_not_blind_folders = list()
for folder in all_folders:
for blind_folder in all_blind_folders:
if folder.folder_id == blind_folder.folder_id:
break
if folder.folder_id == blind_folder.folder_id:
continue
all_not_blind_folders.append(folder)
folders_to_mask = list()
for ii in range(num_folders_to_mask):
folders_to_mask.append(all_not_blind_folders.pop())
do_break = False
reviewer = Reviewer.from_db(reviewer_fullname=reviewer_name)
for index, folder in enumerate(folders_to_mask):
all_blind_names = BlindFolder.list_all_blind_names()
blind_name = utils.random_string_generator(10)
while blind_name in all_blind_names:
blind_name = utils.random_string_generator(10)
BlindFolder(folder.folder_id, reviewer.reviewer_id,
blind_name).save_to_db()
blind_folder_dir = Path(reviewer.toScore_dir).joinpath(blind_name)
os.mkdir(blind_folder_dir)
all_trials = Trial.list_trials_for_folder(folder.folder_id)
print(f'{index}: {blind_name} - {len(all_trials)}')
count = 0
for trial in all_trials:
count += 1
if len(str(count)) < 2: