def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('project_task_type_link',
sa.Column('created_at', sa.DateTime(), nullable=True))
op.add_column(
'project_task_type_link',
sa.Column('id',
sqlalchemy_utils.types.uuid.UUIDType(binary=False),
default=uuid.uuid4,
nullable=True))
op.execute('UPDATE project_task_type_link SET id = \'%s\'' %
fields.gen_uuid())
op.add_column('project_task_type_link',
sa.Column('updated_at', sa.DateTime(), nullable=True))
op.add_column('project_task_type_link',
sa.Column('priority', sa.Integer(), nullable=True))
session = Session(bind=op.get_bind())
for link in session.query(ProjectTaskTypeLink).all():
link.id = fields.gen_uuid()
session.add(link)
session.commit()
op.alter_column('project_task_type_link', 'id', nullable=False)
op.create_unique_constraint('project_tasktype_uc',
'project_task_type_link',
['project_id', 'task_type_id'])
def test_update_entity(self):
entity = self.get_first("data/entities")
data = {"name": "Cosmos Landromat 2"}
self.put("data/entities/%s" % entity["id"], data)
entity_again = self.get("data/entities/%s" % entity["id"])
self.assertEquals(data["name"], entity_again["name"])
self.put_404("data/entities/%s" % fields.gen_uuid(), data)
def test_get_preview_file(self):
preview_file = self.get_first("data/preview-files?relations=true")
preview_file_again = self.get(
"data/preview-files/%s" % preview_file["id"]
)
self.assertEqual(preview_file, preview_file_again)
self.get_404("data/preview-files/%s" % fields.gen_uuid())
def test_get_custom_action(self):
custom_action = self.get_first("data/custom-actions")
custom_action_again = self.get(
"data/custom-actions/%s" % custom_action["id"]
)
self.assertEqual(custom_action, custom_action_again)
self.get_404("data/custom-actions/%s" % fields.gen_uuid())
def test_update_file_status(self):
file_status = self.get_first("data/file-status")
data = {"color": "#FFFFFF"}
self.put("data/file-status/%s" % file_status["id"], data)
file_status_again = self.get("data/file-status/%s" % file_status["id"])
self.assertEquals(data["color"], file_status_again["color"])
self.put_404("data/file-status/%s" % fields.gen_uuid(), data)
def test_update_project(self):
project = self.get_first("data/projects")
data = {"name": "Cosmos Landromat 3"}
self.put("data/projects/%s" % project["id"], data)
project_again = self.get("data/projects/%s" % project["id"])
self.assertEquals(data["name"], project_again["name"])
self.put_404("data/projects/%s" % fields.gen_uuid(), data)
def test_update_entity(self):
entity = self.get_first("data/entities")
data = {
"name": "Cosmos Landromat 2",
"data": {
"extra_work": True
}
}
self.put("data/entities/%s" % entity["id"], data)
entity_again = self.get("data/entities/%s" % entity["id"])
self.assertEquals(entity_again["name"], data["name"])
self.assertEquals(entity_again["data"], data["data"])
data = {
"data": {
"extra_field": True
}
}
self.put("data/entities/%s" % entity["id"], data)
entity_again = self.get("data/entities/%s" % entity["id"])
self.assertEquals(entity_again["data"], {
"extra_work": True,
"extra_field": True
})
self.put_404("data/entities/%s" % fields.gen_uuid(), data)
def test_update_department(self):
department = self.get_first("data/departments")
data = {"color": "#FFFFFF"}
self.put("data/departments/%s" % department["id"], data)
department_again = self.get("data/departments/%s" % department["id"])
self.assertEqual(data["color"], department_again["color"])
self.put_404("data/departments/%s" % fields.gen_uuid(), data)
def test_update_task(self):
task = self.get_first("data/tasks")
data = {"name": "Modeling arbre 2"}
self.put("data/tasks/%s" % task["id"], data)
task_again = self.get("data/tasks/%s" % task["id"])
self.assertEquals(data["name"], task_again["name"])
self.put_404("data/tasks/%s" % fields.gen_uuid(), data)
def test_update_task_type(self):
task_type = self.get_first("data/task-types")
data = {"color": "#FFFFFF"}
self.put("data/task-types/%s" % task_type["id"], data)
task_type_again = self.get("data/task-types/%s" % task_type["id"])
self.assertEqual(data["color"], task_type_again["color"])
self.put_404("data/task-types/%s" % fields.gen_uuid(), data)
def reply_comment(comment_id, text):
person = persons_service.get_current_user()
comment = tasks_service.get_comment_raw(comment_id)
task = tasks_service.get_task(comment.object_id, relations=True)
if comment.replies is None:
comment.replies = []
reply = {
"id": str(fields.gen_uuid()),
"date": date_helpers.get_now(),
"person_id": person["id"],
"text": text
}
replies = list(comment.replies)
replies.append(reply)
comment.update({"replies": replies})
tasks_service.clear_comment_cache(comment_id)
events.emit(
"comment:reply",
{
"task_id": task["id"],
"comment_id": str(comment.id),
"reply_id": reply["id"]
},
project_id=task["project_id"],
)
notifications_service.create_notifications_for_task_and_reply(
task, comment.serialize(), reply)
return reply
def test_update_time_spent(self):
time_spent = self.get_first("data/time-spents")
data = {"duration": 7200}
self.put("data/time-spents/%s" % time_spent["id"], data)
time_spent_again = self.get("data/time-spents/%s" % time_spent["id"])
self.assertEqual(data["duration"], time_spent_again["duration"])
self.put_404("data/time-spents/%s" % fields.gen_uuid(), data)
def test_delete_entity_types(self):
entity_types = self.get("data/entity-types")
self.assertEquals(len(entity_types), 3)
entity_types = entity_types[0]
self.delete("data/entity-types/%s" % entity_types["id"])
entity_types = self.get("data/entity-types")
self.assertEquals(len(entity_types), 2)
self.delete_404("data/entity-types/%s" % fields.gen_uuid())
def test_update_entity_types(self):
entity_types = self.get_first("data/entity_types")
data = {"name": "sequence"}
self.put("data/entity_types/%s" % entity_types["id"], data)
entity_types_again = self.get("data/entity_types/%s" %
entity_types["id"])
self.assertEquals(data["name"], entity_types_again["name"])
self.put_404("data/entity_types/%s" % fields.gen_uuid(), data)
def test_delete_task_type(self):
task_types = self.get("data/task-types")
self.assertEqual(len(task_types), 3)
task_type = task_types[0]
self.delete("data/task-types/%s" % task_type["id"])
task_types = self.get("data/task-types")
self.assertEqual(len(task_types), 2)
self.delete_404("data/task-types/%s" % fields.gen_uuid())
def test_delete_preview_file(self):
preview_files = self.get("data/preview-files")
self.assertEquals(len(preview_files), 3)
preview_file = preview_files[0]
self.delete("data/preview-files/%s" % preview_file["id"])
preview_files = self.get("data/preview-files")
self.assertEquals(len(preview_files), 2)
self.delete_404("data/preview-files/%s" % fields.gen_uuid())
def test_delete_schedule_items(self):
schedule_items = self.get("data/schedule-items")
self.assertEqual(len(schedule_items), 3)
schedule_items = schedule_items[0]
self.delete("data/schedule-items/%s" % schedule_items["id"])
schedule_items = self.get("data/schedule-items")
self.assertEqual(len(schedule_items), 2)
self.delete_404("data/schedule-items/%s" % fields.gen_uuid())
def test_delete_task_status(self):
task_statuss = self.get("data/task-status")
self.assertEquals(len(task_statuss), 3)
task_status = task_statuss[0]
self.delete("data/task-status/%s" % task_status["id"])
task_statuss = self.get("data/task-status")
self.assertEquals(len(task_statuss), 2)
self.delete_404("data/task-status/%s" % fields.gen_uuid())
def test_delete_department(self):
departments = self.get("data/departments")
self.assertEqual(len(departments), 3)
department = departments[0]
self.delete("data/departments/%s" % department["id"])
departments = self.get("data/departments")
self.assertEqual(len(departments), 2)
self.delete_404("data/departments/%s" % fields.gen_uuid())
def test_delete_comment(self):
comments = self.get("data/comments")
self.assertEqual(len(comments), 3)
comment = comments[0]
self.delete("data/comments/%s" % comment["id"])
comments = self.get("data/comments")
self.assertEqual(len(comments), 2)
self.delete_404("data/comments/%s" % fields.gen_uuid())
def test_delete_task(self):
tasks = self.get("data/tasks")
self.assertEquals(len(tasks), 3)
task = tasks[0]
self.delete("data/tasks/%s" % task["id"])
tasks = self.get("data/tasks")
self.assertEquals(len(tasks), 2)
self.delete_404("data/tasks/%s" % fields.gen_uuid())
def test_delete_output_type(self):
output_types = self.get("data/output-types")
self.assertEquals(len(output_types), 3)
output_type = output_types[0]
self.delete("data/output-types/%s" % output_type["id"])
output_types = self.get("data/output-types")
self.assertEquals(len(output_types), 2)
self.delete_404("data/output-types/%s" % fields.gen_uuid())
def test_update_output_type(self):
output_type = self.get_first("data/output-types")
data = {"name": "point cache"}
self.put("data/output-types/%s" % output_type["id"], data)
output_type_again = self.get("data/output-types/%s" %
output_type["id"])
self.assertEquals(data["name"], output_type_again["name"])
self.put_404("data/output-types/%s" % fields.gen_uuid(), data)
def test_update_schedule_items(self):
schedule_items = self.get_first("data/schedule-items")
data = {"man_days": 3}
self.put("data/schedule-items/%s" % schedule_items["id"], data)
schedule_items_again = self.get("data/schedule-items/%s" %
schedule_items["id"])
self.assertEqual(data["man_days"], schedule_items_again["man_days"])
self.put_404("data/schedule-items/%s" % fields.gen_uuid(), data)
def test_delete_software(self):
softwares = self.get("data/softwares")
self.assertEqual(len(softwares), 3)
software = softwares[0]
self.delete("data/softwares/%s" % software["id"])
softwares = self.get("data/softwares")
self.assertEqual(len(softwares), 2)
self.delete_404("data/softwares/%s" % fields.gen_uuid())
def test_delete_project(self):
projects = self.get("data/projects")
self.assertEquals(len(projects), 3)
project = projects[0]
self.delete("data/projects/%s" % project["id"])
projects = self.get("data/projects")
self.assertEquals(len(projects), 2)
self.delete_404("data/projects/%s" % fields.gen_uuid())
def test_update_comment(self):
comment = self.get_first("data/comments")
data = {"text": "Edited comment"}
self.put("data/comments/%s" % comment["id"], data)
comment_again = self.get("data/comments/%s" % comment["id"])
self.assertEqual(data["text"], comment_again["text"])
comment_id = fields.gen_uuid()
self.put_404("data/comments/%s" % comment_id, data)
def test_delete_project_status(self):
project_statuss = self.get("data/project-status")
self.assertEqual(len(project_statuss), 3)
project_status = project_statuss[0]
self.delete("data/project-status/%s" % project_status["id"])
project_statuss = self.get("data/project-status")
self.assertEqual(len(project_statuss), 2)
self.delete_404("data/project-status/%s" % fields.gen_uuid())
def test_get_person(self):
person = self.get_first("data/persons")
person_again = self.get("data/persons/%s" % person["id"])
self.assertEqual(person, person_again)
person_with_relations = self.get("data/persons/%s?relations=true" %
person["id"])
self.assertTrue('skills' in person_with_relations)
self.get_404("data/persons/%s" % fields.gen_uuid())
def test_delete_file_status(self):
file_statuss = self.get("data/file-status")
self.assertEquals(len(file_statuss), 3)
file_status = file_statuss[0]
self.delete("data/file-status/%s" % file_status["id"])
file_statuss = self.get("data/file-status")
self.assertEquals(len(file_statuss), 2)
self.delete_404("data/file-status/%s" % fields.gen_uuid())
