func prepare()

in Sources/XCMetricsBackendLib/Common/Repositories/Postgress/Migrations/AddBuildIdentifierIndexes.swift [27:42]


    func prepare(on database: Database) -> EventLoopFuture<Void> {
        guard let sql = database as? SQLDatabase else {
            preconditionFailure("AddBuildIdentifierIndexToTarget can only run on a SQL database")
        }
        return sql.raw("""
                CREATE INDEX "index_build_identifier_on_targets"
                ON \(raw: Target.schema) using btree(build_identifier);
                """)
                .run()
            .flatMap {
                sql.raw("""
                        DROP INDEX "index_build_identifier_on_targets";
                        """)
                        .run()
            }
    }