session-ios/SessionMessagingKit/Database/Migrations/_017_EmojiReacts.swift

// Copyright © 2022 Rangeproof Pty Ltd. All rights reserved.

import Foundation
import GRDB
import SessionUtilitiesKit

/// This migration adds the new types needed for Emoji Reacts
enum _017_EmojiReacts: Migration {
    static let identifier: String = "messagingKit.EmojiReacts"
    static let minExpectedRunDuration: TimeInterval = 0.01
    static let createdTables: [(TableRecord & FetchableRecord).Type] = [Reaction.self]
    
    static func migrate(_ db: ObservingDatabase, using dependencies: Dependencies) throws {
        try db.create(table: "reaction") { t in
            t.column("interactionId", .numeric)
                .notNull()
                .indexed()                                            // Quicker querying
                .references("interaction", onDelete: .cascade)        // Delete if Interaction deleted
            t.column("serverHash", .text)
            t.column("timestampMs", .text)
                .notNull()
            t.column("authorId", .text)
                .notNull()
                .indexed()                                            // Quicker querying
            t.column("emoji", .text)
                .notNull()
                .indexed()                                            // Quicker querying
            t.column("count", .integer)
                .notNull()
                .defaults(to: 0)
            t.column("sortId", .integer)
                .notNull()
                .defaults(to: 0)
            
            /// A specific author should only be able to have a single instance of each emoji on a particular interaction
            t.uniqueKey(["interactionId", "emoji", "authorId"])
        }
        
        MigrationExecution.updateProgress(1)
    }
}