refactor: use integer primary keys in shared base model

fiqrikm18 · fiqrikm18 · commit 2f0ad827b276 · 2026-08-01T12:54:14.000+07:00
diff --git a/src/shared/database/mixin/tenant.py b/src/shared/database/mixin/tenant.py
@@ -1,13 +1,10 @@
-from uuid import UUID
-
-from sqlalchemy import ForeignKey
-from sqlalchemy.dialects.postgresql import UUID as PG_UUID
+from sqlalchemy import ForeignKey, Integer
 from sqlalchemy.orm import Mapped, mapped_column
 
 
 class TenantMixin:
-    tenant_id: Mapped[UUID] = mapped_column(
-        PG_UUID(as_uuid=True),
+    tenant_id: Mapped[int] = mapped_column(
+        Integer,
         ForeignKey("tenants.id"),
         nullable=False,
         sort_order=-60,
diff --git a/src/shared/database/model.py b/src/shared/database/model.py
@@ -1,15 +1,13 @@
-from uuid import UUID, uuid4
-
-from sqlalchemy.dialects.postgresql import UUID as PG_UUID
+from sqlalchemy import Integer
 from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
 
 from src.shared.database.mixin.tenant import TenantMixin  # noqa: F401
 
 
 class Base(DeclarativeBase):
-    id: Mapped[UUID] = mapped_column(
-        PG_UUID(as_uuid=True),
+    id: Mapped[int] = mapped_column(
+        Integer,
         primary_key=True,
-        default=uuid4,
+        autoincrement=True,
         sort_order=-100,
     )
diff --git a/tests/test_database_relationships.py b/tests/test_database_relationships.py
@@ -1,5 +1,5 @@
 import pytest
-from sqlalchemy import Uuid
+from sqlalchemy import Integer
 from sqlalchemy.orm import configure_mappers
 
 import src.modules.authorization.infrastructure.models.permission_model  # noqa: F401
@@ -51,5 +51,5 @@ def test_relationship_column_declares_expected_foreign_key(table, column, target
 
 
 @pytest.mark.parametrize("table", NORMALIZED_USER_TABLES)
-def test_normalized_user_identifier_uses_uuid(table):
-    assert isinstance(Base.metadata.tables[table].c.user_id.type, Uuid)
+def test_normalized_user_identifier_uses_int(table):
+    assert isinstance(Base.metadata.tables[table].c.user_id.type, Integer)
