Pavlos Giannakis
--- a/sammelrepository/routers/internal.py 0 → 100644
+++ b/sammelrepository/routers/internal.py 0 → 100644
+
+from ..config import get_directories, create_engine_from_env
+
+router = APIRouter()
+
+directories = get_directories()
+server_url = os.getenv("SERVER_URL")
+
+templates = Jinja2Templates(directory=directories.templates)
+router.mount(
+    "/static",
+    StaticFiles(directory=directories.static),
+    name="static",
+)
+
+engine = create_engine_from_env()
--- a/sammelrepository/routers/internal.py 0 → 100644
+++ b/sammelrepository/routers/internal.py 0 → 100644
+            f"{server_url}/api/v0/schemas/id/{id}/version/{version}"
+        )
+        response.raise_for_status()
+        schema = response.json()
+
+        return templates.TemplateResponse(
+            "schema_detail.html",
+            {
+                "request": request,
+                "schema": schema,
+            },
+        )
+
+
+#  Fetches the schemas from the API based on the provided parameters
+async def _fetch_schemas(show_all: bool, page: int, size: int):
--- a/sammelrepository/database.py
+++ b/sammelrepository/database.py
 class Database:
    def __init__(self, connection: Connection):
        self.connection = connection
+        engine = self.connection.engine
--- a/sammelrepository/routers/v0.py 0 → 100644
+++ b/sammelrepository/routers/v0.py 0 → 100644
+    return jsonable_encoder(schema_dict)
+
+
+@router.get(
+    "/schemas/status/{status}",
+    response_class=JSONResponse,
+    name="Get one or more schemas based on status",
+    description="Get one or more schemas based on the status. Available status are: "
+    "in Planung, in Bearbeitung,"
+    "Entwurf, methodisch freigegeben, fachlich freigegeben (silber), fachlich "
+    "freigegeben (gold), inaktiv.",
+    responses={
+        200: {"model": SchemaOut},
+    },
+)
+def get_schemas_by_status(
--- a/sammelrepository/migrations/versions/481d38a91b11_more_xdf3_fields_and_removing_not_.py
+++ b/sammelrepository/migrations/versions/481d38a91b11_more_xdf3_fields_and_removing_not_.py

    op.drop_column("schema", "nachricht_id")
    op.drop_column("schema", "erstellungs_zeitpunkt")
+    op.drop_column("schema", "status")


 def downgrade():
    op.add_column("schema", sa.Column("nachricht_id", sa.String(), default=None))
+    op.add_column("schema", sa.Column("status", sa.String(), default=None))
    op.add_column(
        "schema", sa.Column("erstellungs_zeitpunkt", sa.TIMESTAMP(), default=None)
    )

-    op.drop_column("schema", "freigabestatus")
--- a/sammelrepository/migrations/versions/c79962724a25_new_schema_version.py
+++ b/sammelrepository/migrations/versions/c79962724a25_new_schema_version.py
    op.add_column(
        "schema", sa.Column("ableitungsmodifikationen_repraesentation", sa.String)
    )
+    op.add_column("schema", sa.Column("struktur", sa.ARRAY(sa.String)))
--- a/tests/test_schema_queries.py 0 → 100644
+++ b/tests/test_schema_queries.py 0 → 100644
+from conftest import CommandRunner
+from fastapi.testclient import TestClient
+
+
+def test_search_schema_by_id(runner: CommandRunner, client: TestClient):
+    response = client.get("/api/v0/schemas/search/id/S1234")