task_state.task_id = task.id
task_state.project_id = project_id
task_state.user_id = users[h.username.encode('utf-8')] \
if h.username else None
session_v2.add(task_state)
prev_checkin = h.checkin
if h.comment:
task_comment = TaskComment(h.comment, None)
task_comment.author_id = users[h.username.encode('utf-8')] \
if h.username else None
task_comment.task_id = task.id
task_comment.project_id = project_id
task_comment.date = h.update
session_v2.add(task_comment)
success("Job %s - \"%s\" successfully imported" % (job.id, job.title))
with transaction.manager:
header("Updating projects done stats")
for project in session_v2.query(Project).all():
project.done = project.get_done()
project.validated = project.get_validated()
session_v2.flush()
# FIXME reset the project id sequence
max_project_id = session_v2.query(func.max(Project.id)).scalar()
session_v2.execute('ALTER SEQUENCE project_id_seq RESTART %d' %
(max_project_id + 1))
task_state.project_id = project_id
task_state.user_id = users[h.username.encode('utf-8')] \
if h.username else None
session_v2.add(task_state)
prev_checkin = h.checkin
if h.comment:
task_comment = TaskComment(h.comment, None)
task_comment.author_id = users[h.username.encode('utf-8')] \
if h.username else None
task_comment.task_id = task.id
task_comment.project_id = project_id
task_comment.date = h.update
session_v2.add(task_comment)
success("Job %s - \"%s\" successfully imported" % (job.id, job.title))
with transaction.manager:
header("Updating projects done stats")
for project in session_v2.query(Project).all():
project.done = project.get_done()
project.validated = project.get_validated()
session_v2.flush()
# FIXME reset the project id sequence
max_project_id = session_v2.query(func.max(Project.id)).scalar()
session_v2.execute('ALTER SEQUENCE project_id_seq RESTART %d' %
(max_project_id + 1))
