migrate-example.yaml

#yaml-migration-config
---
authentification:
  old-database:
    host: <DB_HOST>
    name: <DB-NAME>
    user: <DB-USER>
    password: <DB-PASSWORD>
  new-database:
    host: <DB_HOST>
    name: <DB-NAME>
    user: <DB-USER>
    password: <DB-PASSWORD>

steps:
- action: RUN_COMMAND
  enabled: true
  command: DELETE FROM fl_tags WHERE id=1
- action: COPY
  enabled: true
  old-table: categories
  new-table: fl_tags
  columns:
    id: id
    name: name
    color: color
    position: position
    parent_category_id: parent_id
    slug: slug
    description: description
- action: RUN_COMMAND
  enable: true
  command: UPDATE fl_tags SET parent_id = NULL WHERE parent_id = 0

- action: COPY
  enabled: true
  old-table: posts
  new-table: fl_posts
  columns:
    id: id
    user_id: user_id
    topic_id: discussion_id
    raw*: content
    created_at: time
    updated_at: edit_time
- action: RUN_COMMAND
  enabled: true
  command: UPDATE fl_posts SET type='comment'
- action: RUN_COMMAND
  enabled: true
  # -1 is the system account
  command: DELETE FROM fl_posts WHERE user_id='-1'

- action: COPY
  enabled: true
  old-table: topics
  new-table: fl_discussions
  columns:
    id: id
    title: title
    posts_count++: comments_count
    participant_count: participants_count
    created_at: start_time
    user_id: start_user_id
    updated_at: last_time
    last_post_user_id: last_user_id
    slug: slug
    archetype?private_message: is_private
- action: RUN_COMMAND
  enabled: true
  command: DELETE FROM fl_discussions WHERE title='Backup completed successfully'
- action: FIRST_AND_LAST
  enabled: true
  table: fl_discussions
  from-table: fl_posts
  start_post_id: last_post_id

- action: COPY
  enabled: true
  old-table: topics
  new-table: fl_discussions_tags
  columns:
    id: discussion_id
    category_id: tag_id

- action: RUN_COMMAND
  enabled: true
  # make all discussions private that are in category Staff
  command: UPDATE fl_discussions d SET is_private=1 WHERE EXISTS (SELECT * FROM fl_discussions_tags dt, fl_tags t where dt.discussion_id = d.id and dt.tag_id = t.id and t.name='Staff')
- action: RUN_COMMAND
  enabled: true
  # make all posts private that are in a private discussion
  command: UPDATE fl_posts p SET is_private=1 WHERE EXISTS (SELECT * FROM fl_discussions d where d.id = p.discussion_id and d.is_private=1)
- action: RUN_COMMAND
  enabled: true
  # make all posts private that are from user 0 (system user in discourse) or lower
  command: UPDATE fl_posts p SET is_private=1 WHERE p.user_id<=0
- action: RUN_COMMAND
  enabled: true
  # make all discussions private that only have private posts
  command: UPDATE fl_discussions d SET is_private=1 WHERE NOT EXISTS (SELECT * from fl_posts p WHERE p.discussion_id = d.id and p.is_private=0)
- action: RUN_COMMAND
  enabled: true
  # update discussions count of tags
  command: UPDATE fl_tags t SET t.discussions_count = (SELECT COUNT(*) FROM fl_discussions_tags dt, fl_discussions d WHERE dt.discussion_id = d.id AND dt.tag_id = t.id AND d.is_private=0)
- action: RUN_COMMAND
  enabled: true
  # make all tags invisible that have no public discussions
  command: UPDATE fl_tags t SET is_hidden=1, is_restricted=1 WHERE t.discussions_count = 0

- action: RUN_COMMAND
  enabled: true
  # delete the flarum admin user. the first user from discourse will be the admin
  command: DELETE FROM fl_users WHERE id=1

- action: COPY
  enabled: true
  old-table: users
  new-table: fl_users
  where: id > 0
  orderby: id
  columns:
    id: id
    username: username
    email: email
    password_hash: password
    created_at: join_time
    last_posted_at: last_seen_time
- action: RUN_COMMAND
  enabled: true
  command: UPDATE fl_users u SET discussions_count=(SELECT count(*) FROM fl_discussions d WHERE d.is_private=0 AND d.start_user_id=u.id)
- action: RUN_COMMAND
  enabled: true
  command: UPDATE fl_users u SET comments_count=(SELECT count(*) FROM fl_posts p WHERE p.is_private=0 AND p.user_id=u.id)
- action: RUN_COMMAND
  enabled: true
  command: DELETE FROM fl_users WHERE password='NULL'
- action: SET_PARENT_TAGS
  enabled: true
  from: fl_tags
  into: fl_discussion_tags