Create RecommendedWorkerVersionRetrieve endpoint

closes #1888 (closed)

arkindex/process/migrations/0047_alter_workerversion_tag.py

+# Generated by Django 5.0.8 on 2025-01-21 10:59
+
+from django.contrib.postgres.operations import CreateCollation
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ("process", "0046_workerrun_ttl"),
+    ]
+
+    operations = [
+        # This collation allows us to sort the "tag" field as semantic version tags. The sorting is done using US English
+        # rules, treating numeric values as single numbers and not split by digit (so that 10.2.1 is not the same as 1.0.21).
+        # The ordering is non-deterministic because two strings can have the same value (1.2 == 01.2).
+        CreateCollation(
+            "english_numeric",
+            provider="icu",
+            locale="en-US-u-kn-true-u-ks-level2",
+            deterministic=False
+        ),
+        migrations.AlterField(
+            model_name="workerversion",
+            name="tag",
+            field=models.CharField(blank=True, db_collation="english_numeric", default=None, max_length=512, null=True),
+        ),
+    ]