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()
}
}