X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2ims%2Fadapter%2Fclients%2Form_stx.py;h=b8c1523606e3d4c2cd0fd5b8743440c2af9bb4be;hb=refs%2Fchanges%2F05%2F7005%2F7;hp=02f9becbfb64a391f26355607e420b6504c84e59;hpb=81e3575a77366f30c2049f98c48a3087db0ea992;p=pti%2Fo2.git

diff --git a/o2ims/adapter/clients/orm_stx.py b/o2ims/adapter/clients/orm_stx.py
index 02f9bec..b8c1523 100644
--- a/o2ims/adapter/clients/orm_stx.py
+++ b/o2ims/adapter/clients/orm_stx.py
@@ -23,14 +23,21 @@ from sqlalchemy import (
     String,
     # Date,
     DateTime,
+    # engine,
     # ForeignKey,
     # event,
+    Enum
 )
 
 from sqlalchemy.orm import mapper
+# from sqlalchemy.sql.sqltypes import Integer
 # from sqlalchemy.sql.expression import true
 
 from o2ims.domain import stx_object as ocloudModel
+# from o2ims.adapter.orm import metadata
+from o2ims.service.unit_of_work import AbstractUnitOfWork
+from o2ims.adapter.unit_of_work import SqlAlchemyUnitOfWork
+from o2ims.domain.resource_type import ResourceTypeEnum
 
 logger = logging.getLogger(__name__)
 
@@ -40,12 +47,20 @@ stxobject = Table(
     "stxcache",
     metadata,
     Column("id", String(255), primary_key=True),
+    Column("type", Enum(ResourceTypeEnum)),
     Column("name", String(255)),
-    Column("lastupdate", DateTime),
-    Column("content", String(255))
+    Column("updatetime", DateTime),
+    Column("createtime", DateTime),
+    Column("hash", String(255)),
+    Column("content", String)
 )
 
 
-def start_o2ims_stx_mappers():
+def start_o2ims_stx_mappers(uow: AbstractUnitOfWork = SqlAlchemyUnitOfWork()):
     logger.info("Starting O2 IMS Stx mappers")
     mapper(ocloudModel.StxGenericModel, stxobject)
+
+    with uow:
+        engine1 = uow.session.get_bind()
+        metadata.create_all(engine1)
+        uow.commit()