runbot/runbot_merge/migrations/13.0.1.1/pre-migration.py

18 lines
651 B
Python
Raw Permalink Normal View History

def migrate(cr, version):
""" Moved the required_statuses field from the project to the repository so
different repos can have different CI requirements within a project
"""
# create column on repo
cr.execute("ALTER TABLE runbot_merge_repository ADD COLUMN required_statuses varchar")
# copy data from project
cr.execute("""
UPDATE runbot_merge_repository r
SET required_statuses = (
SELECT required_statuses
FROM runbot_merge_project
WHERE id = r.project_id
)
""")
# drop old column on project
cr.execute("ALTER TABLE runbot_merge_project DROP COLUMN required_statuses")