hooks.py

# Copyright 2017 - 2018 Modoolar <info@modoolar.com>
# License LGPLv3.0 or later (https://www.gnu.org/licenses/lgpl-3.0.en.html).


def post_init_hook(cr, registry):
    import os
    from odoo import api, SUPERUSER_ID
    from odoo.tools import misc

    env = api.Environment(cr, SUPERUSER_ID, {})

    # Load project workflow
    workflow_pathname = os.path.join(
        "project_agile", "import", "project_workflow.xml"
    )
    with misc.file_open(workflow_pathname) as stream:
        importer = env["project.workflow.importer"]
        reader = env["project.workflow.xml.reader"]
        workflow = importer.run(reader, stream)
        workflow.write({"state": "live"})  # Publish imported workflow

        # Assign simple workflow to all project types
        env["project.type"].search([]).write({"workflow_id": workflow.id})

    # We need to assign initial agile order.
    # It would be nicer if latest tasks were in the top of the backlog.
    cr.execute("SELECT COUNT(*) FROM project_task")
    count = cr.fetchone()[0]
    cr.execute(
        """
      UPDATE project_task
      SET agile_order = %s - id
      WHERE agile_order IS NULL
      """,
        (int(count),),
    )

    # Epics allow sub epics
    task_type_epic = env.ref("project_agile.project_task_type_epic")
    type_ids = task_type_epic.type_ids.ids
    type_ids.append(task_type_epic.id)
    task_type_epic.write({"type_ids": [(6, 0, type_ids)]})

    # Set default project task type to the existing projects
    env["project.project"].sudo().with_context(
        no_workflow=True
    )._set_default_project_type_id()

    # and set ``type_id`` field to not null
    cr.execute(
        "ALTER TABLE project_project ALTER COLUMN type_id SET NOT NULL;"
    )

    # Set default project task type to the existing tasks
    env["project.task"].sudo()._set_default_task_type_id()
    task_type_task = env.ref("project_agile.project_task_type_task")
    cr.execute(
        "UPDATE project_task SET type_id=%s WHERE type_id IS NULL;",
        (task_type_task.id,),
    )

    # and set ``type_id`` field to not null
    cr.execute("ALTER TABLE project_task ALTER COLUMN type_id SET NOT NULL;")

    # Set default task priority to the existing tasks
    env["project.task"].sudo()._set_default_task_priority_id()
    priority_minor = env.ref("project_agile.project_task_priority_minor")
    cr.execute(
        "UPDATE project_task SET priority_id=%s WHERE priority_id IS NULL;",
        (priority_minor.id,),
    )

    # and set ``priority_id`` field to not null
    cr.execute(
        "ALTER TABLE project_task ALTER COLUMN priority_id SET NOT NULL;"
    )