X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2dms%2Fadapter%2Form.py;h=6bf5e55fd9aa28639666267cf385ef055f1db2a3;hb=82ae293db69b560751856f925ccf0a7f58a184d9;hp=7527515cef1dea57d99903f0141c864d40247eac;hpb=5e02e76308e1677fb106572b885a366eb6c0fbec;p=pti%2Fo2.git

diff --git a/o2dms/adapter/orm.py b/o2dms/adapter/orm.py
index 7527515..6bf5e55 100644
--- a/o2dms/adapter/orm.py
+++ b/o2dms/adapter/orm.py
@@ -18,6 +18,7 @@ from sqlalchemy import (
     Column,
     Integer,
     String,
+    Text,
     # Date,
     DateTime,
     # ForeignKey,
@@ -45,17 +46,56 @@ nfDeploymentDesc = Table(
     Column("deploymentManagerId", String(255)),
     Column("name", String(255)),
     Column("description", String(255)),
-    Column("supportedLocations", String(255)),
-    Column("capabilities", String(255)),
-    Column("capacity", String(255)),
+    Column("inputParams", Text()),
+    Column("outputParams", String(255)),
+    Column("artifactRepoUrl", String(255)),
+    Column("artifactName", String(255)),
     # Column("extensions", String(1024))
 )
 
+nfDeployment = Table(
+    "nfDeployment",
+    metadata,
+    Column("updatetime", DateTime),
+    Column("createtime", DateTime),
+    Column("hash", String(255)),
+    Column("version_number", Integer),
+
+    Column("id", String(255), primary_key=True),
+    Column("deploymentManagerId", String(255)),
+    Column("name", String(255)),
+    Column("description", String(255)),
+    Column("descriptorId", String(255)),
+    Column("parentDeploymentId", String(255)),
+    Column("status", Integer)
+)
+
+nfOCloudVResource = Table(
+    "nfOcloudVRes",
+    metadata,
+    Column("updatetime", DateTime),
+    Column("createtime", DateTime),
+    Column("hash", String(255)),
+    Column("version_number", Integer),
+
+    Column("id", String(255), primary_key=True),
+    Column("deploymentManagerId", String(255)),
+    Column("name", String(255)),
+    Column("description", String(255)),
+    Column("descriptorId", String(255)),
+    Column("vresourceType", String(255)),
+    Column("status", Integer),
+    Column("metadata", String(2048)),
+    Column("nfDeploymentId", String(255))
+)
+
 
 def start_o2dms_mappers(engine=None):
     logger.info("Starting O2 DMS mappers")
 
     mapper(dmsModel.NfDeploymentDesc, nfDeploymentDesc)
+    mapper(dmsModel.NfDeployment, nfDeployment)
+    mapper(dmsModel.NfOCloudVResource, nfOCloudVResource)
 
     if engine is not None:
         metadata.create_all(engine)