Removed id column from capability schema and all its dependencies

Capability table no longer has an ID column. Instead, capability_name is used as the primary key and anywhere that capability_id was previously used is now replaced with capability_name.

schema/versions/57c38b5f012e_capabilities_init.py

@@ -5,9 +5,8 @@ Revises: 44d5bbbf2615
 Create Date: 2020-10-07 23:01:25.765027
 
 """
-from alembic import op
 import sqlalchemy as sa
-
+from alembic import op
 
 # revision identifiers, used by Alembic.
 revision = "57c38b5f012e"
@@ -20,8 +19,7 @@ def upgrade():
     print("creating capabilities")
     op.create_table(
         "capabilities",
-        sa.Column("capability_id", sa.Integer, primary_key=True),
-        sa.Column("capability_name", sa.String),
+        sa.Column("capability_name", sa.String, primary_key=True),
         sa.Column("capability_steps", sa.String),
         sa.Column("max_jobs", sa.Integer),
     )
@@ -30,9 +28,7 @@ def upgrade():
         "capability_requests",
         sa.Column("capability_request_id", sa.Integer, primary_key=True),
         sa.Column("state", sa.String),
-        sa.Column(
-            "capability_id", sa.Integer, sa.ForeignKey("capabilities.capability_id")
-        ),
+        sa.Column("capability_name", sa.String, sa.ForeignKey("capabilities.capability_name")),
         sa.Column("parameters", sa.String),
     )
 
@@ -62,7 +58,7 @@ def upgrade():
             sa.ForeignKey("workflow_requests.workflow_request_id"),
         ),
         sa.ForeignKeyConstraint(
-            ["capability_request_id", "capability_version_number"],
+            ("capability_request_id", "capability_version_number"),
             [
                 "capability_versions.capability_request_id",
                 "capability_versions.version_number",