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))