def fix_for_employee_feature_group(request, sql_session):
feature_group_1 = FeatureGroup(n=1, name='GROUP_1', parent_n=1)
Session.add(feature_group_1)
feature_group_2 = FeatureGroup(n=2, name='GROUP_2', parent_n=1)
Session.add(feature_group_2)
Session.add(Feature(n=1, name='-'))
Session.add(Feature(n=2, name='FEATURE_1',
feature_group=[feature_group_1, ]))
Session.add(Feature(n=3, name='FEATURE_2',
feature_group=[feature_group_2, ]))
Session.add(Question(n=21, feature_n=1, txt='CONTENT_21'))
Session.add(Question(n=22, feature_n=2, txt='CONTENT_22'))
Session.add(Question(n=31, feature_n=3, txt='CONTENT_31'))
_today = date.today()
Session.add(Result(n=1, question_n=21,
is_correct=True, employee_n=1, ddate=_today))
Session.add(Result(n=2, question_n=22,
is_correct=False, employee_n=1, ddate=_today))
Session.add(Result(n=3, question_n=22,
is_correct=True, employee_n=2, ddate=_today))
Session.add(Result(n=4, question_n=31,
is_correct=False, employee_n=2, ddate=_today))
Session.add(Plan(n=1, employee_n=1, year=date.today().year,
month=date.today().month, qty_work=1, qty_question=1))
Session.add(Plan(n=2, employee_n=2, year=date.today().year,
month=date.today().month, qty_work=1, qty_question=2))
def fix_many_feature_groups(request, sql_session): Session.add(FeatureGroup(n=1, name='group1')) Session.add(FeatureGroup(n=11, name='group11', parent_n=1)) Session.add(FeatureGroup(n=12, name='group12', parent_n=1)) Session.add(FeatureGroup(n=2, name='group2')) Session.add(FeatureGroup(n=21, name='group21', parent_n=2))
def test_add_childs(self):
_group12 = FeatureGroup(n=13, name='NAME_FEATURE_GROUP', parent_n=1)
Session.add(_group12)
Session.flush()
_group = FeatureGroup.get(1)
assert len(_group.children) == 2
assert _group.children[0].n == 13
assert _group.children[1].n == 11
def fix_full_fixteres(request, sql_session):
Session.add(FeatureGroup(n=1, name='group1'))
feature_group = FeatureGroup(n=11, name='group11', parent_n=1)
Session.add(feature_group)
feature = Feature(n=1, name='FEATURE_1',
info='INFO_1', info_profit='INFO_PROFIT_1', feature_group=[feature_group, ])
Session.add(feature)
Session.add(Question(n=1, feature_n=1, txt='QUESTION_1', answer_n=2))
Session.add(Answer(n=1, question_n=1, txt='ANSWER_1'))
Session.add(Answer(n=2, question_n=1, txt='ANSWER_2'))
Session.add(Answer(n=3, question_n=1, txt='ANSWER_3'))
def test_model_sets_n_automatically(self):
_group = FeatureGroup(name='NAME_FEATURE_GROUP')
Session.add(_group)
Session.flush()
assert _group.n is not None
assert _group.parent_n is None
assert _group.name == 'NAME_FEATURE_GROUP'
def fix_results_for_pivot_report(request, sql_session):
feature_group_1 = FeatureGroup(n=1, name='GROUP_1', parent_n=1)
Session.add(feature_group_1)
Session.add(Feature(n=1, name='FEATURE_1',
feature_group=[feature_group_1, ]))
# Session.commit()
# Вопрос 1 к Теме 2
Session.add(Question(n=21, feature_n=1, txt='CONTENT21', answer_n=211))
# Session.commit()
Session.add(Answer(n=211, question_n=21, txt='CONTENT211'))
Session.add(Question(n=31, feature_n=1, txt='CONTENT31', answer_n='311'))
# Session.commit()
Session.add(Answer(n=311, question_n=31, txt='CONTENT311'))
# Session.commit()
_today = date.today()
tomorrow = _today + relativedelta(days=1)
Session.add(Result(n=10, question_n=21, answer_n=211,
is_correct=True, employee_n=1, ddate=_today))
Session.add(Result(n=11, question_n=21, answer_n=211,
is_correct=True, employee_n=1, ddate=_today))
Session.add(Result(n=12, question_n=31, answer_n=221,
is_correct=False, employee_n=1, ddate=_today))
Session.add(Result(n=13, question_n=21, answer_n=211,
is_correct=True, employee_n=1, ddate=tomorrow))
Session.add(Result(n=14, question_n=31, answer_n=221,
is_correct=False, employee_n=1, ddate=tomorrow))
def update_feature_group(feature, feature_group_params):
feature.feature_group = []
for feature_group in feature_group_params:
n = feature_group['n']
feature_group = FeatureGroup.get(n)
feature.feature_group.append(feature_group)
return feature
def test_add_feature(self):
_group11 = FeatureGroup.get(11)
NAME_FEATURE = 'NAME_FEATURE'
_feature = Feature(n=1, name=NAME_FEATURE, feature_group=[_group11])
Session.add(_feature)
assert _feature.n is not None
assert len(_feature.feature_group) == 1
def test_model_sets_n_automatically(self):
feature = Feature(name='name_feature', employee_n=1)
feature_group = FeatureGroup.get(1)
feature.feature_group.append(feature_group)
Session.add(feature)
Session.flush()
assert feature.n is not None
assert feature.name == 'name_feature'
assert feature.employee_n == 1
assert feature.ddate == date.today()
def test_update_feature_group(self):
feature = Feature.get(1)
feature_group = FeatureGroup.get(1)
feature.feature_group.append(feature_group)
Session.flush()
self.assertEqual(len(feature.feature_group), 2)
feature_group_params = [{'n': 11}]
f_updated = FeatureCtrl.update_feature_group(feature,
feature_group_params)
self.assertEqual(len(f_updated.feature_group), 1)
self.assertEqual(f_updated.feature_group[0].n, 11)
def create_feature(params):
feature = Feature()
feature.name = params['name']
feature.info = params['info']
feature.info_profit = params['info_profit']
feature.employee_n = params['employee_n']
for feature_group in params['feature_group']:
g = FeatureGroup.get(feature_group['n'])
feature.feature_group.append(g)
Session.add(feature)
Session.flush()
return feature
def fix_results_for_generate(request, sql_session):
feature_group_1 = FeatureGroup(n=1, name='GROUP_1', parent_n=1)
Session.add(feature_group_1)
feature_group_2 = FeatureGroup(n=2, name='GROUP_2', parent_n=1)
Session.add(feature_group_2)
Session.add(Feature(n=1, name='-'))
Session.add(Feature(n=2, name='FEATURE1', feature_group=[feature_group_1, ]))
Session.add(Feature(n=3, name='FEATURE2', feature_group=[feature_group_2, ]))
# Session.commit()
# Вопрос 1 к Теме 2
Session.add(Question(n=21, feature_n=1, txt='CONTENT21', answer_n=211))
# Session.commit()
Session.add(Answer(n=211, question_n=21, txt='CONTENT211'))
Session.add(Answer(n=212, question_n=21, txt='CONTENT212'))
Session.add(Answer(n=213, question_n=21, txt='CONTENT213'))
# Вопрос 2 к Теме 2
Session.add(Question(n=22, feature_n=2, txt='CONTENT22', answer_n=211))
# Session.commit()
Session.add(Answer(n=221, question_n=22, txt='CONTENT221'))
Session.add(Answer(n=222, question_n=22, txt='CONTENT222'))
Session.add(Answer(n=223, question_n=22, txt='CONTENT223'))
# Session.commit()
# Вопрос 1 к Теме 3
Session.add(Question(n=31, feature_n=3, txt='CONTENT31', answer_n='311'))
# Session.commit()
Session.add(Answer(n=311, question_n=31, txt='CONTENT311'))
Session.add(Answer(n=312, question_n=31, txt='CONTENT312'))
Session.add(Answer(n=313, question_n=31, txt='CONTENT313'))
# Session.commit()
_today = date.today()
Session.add(Result(n=1, question_n=21, answer_n=211,
is_correct=True, employee_n=1, ddate=_today))
def fix_for_pivot_create_feature_report(request, sql_session):
Session.add(EmployeeGroup(n=2, name='SELLERS'))
Session.add(Right(n=2, employee_group_n=1,
section='question', access='edit'))
Session.add(Employee(n=2, name='EMPLOYEE_1',
password='', employee_group_n=2, disabled=False))
Session.add(Employee(n=3, name='EMPLOYEE_2',
password='', employee_group_n=2, disabled=False))
feature_group_1 = FeatureGroup(n=1, name='GROUP_1', parent_n=1)
Session.add(feature_group_1)
Session.add(Feature(n=1, name='FEATURE_11',
feature_group=[feature_group_1, ], employee_n=2, ddate=date.today()))
Session.add(Feature(n=2, name='FEATURE_12',
feature_group=[feature_group_1, ], employee_n=2, ddate=date.today() + timedelta(days=1)))
Session.add(Feature(n=3, name='FEATURE_21',
feature_group=[feature_group_1, ], employee_n=3, ddate=date.today()))
Session.add(Feature(n=4, name='FEATURE_22',
feature_group=[feature_group_1, ], employee_n=3, ddate=date.today() + timedelta(days=1)))
def create(parent_n, name):
if parent_n is not None and parent_n < 0:
parent_n = None
feature_group = FeatureGroup.create({'name': name, 'parent_n': parent_n})
return feature_group
def update(n, name):
feature_group = FeatureGroup.update(n, {'name': name})
return feature_group
def fix_features(request, sql_session): feature_group_1 = FeatureGroup(n=1, name='group1') Session.add(feature_group_1) feature = Feature(n=1, name='-') feature.feature_group.append(feature_group_1) Session.add(feature)
def fix_feature_groups(request, sql_session): Session.add(FeatureGroup(n=1, name='group1')) Session.add(FeatureGroup(n=11, name='group11', parent_n=1))
def test_parent(self):
_group = FeatureGroup.get(11)
assert _group.n == 11
assert _group.parent_n == 1
def test_childs(self):
_group = FeatureGroup.get(1)
assert _group.n == 1
assert _group.parent_n is None
assert len(_group.children) == 1
assert _group.children[0].n == 11
def delete(n): Session.query(FeatureGroup).filter(FeatureGroup.parent_n == n).delete() FeatureGroup.delete(n)
def test_del_childs(self):
_group11 = FeatureGroup.get(11)
Session.delete(_group11)
_group = FeatureGroup.get(1)
assert len(_group.children) == 0
def test_get_child_with_parent(self):
_group = FeatureGroup.get(11)
assert _group.parent_name == 'group1'
_group = FeatureGroup.get(1)
assert _group.parent_name == ''