X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=o2dms%2Fadapter%2Form.py;h=6bf5e55fd9aa28639666267cf385ef055f1db2a3;hb=ac3d5fc0fba9caed9a65c3200362e68826e3e272;hp=05821dc24689e3db6c53edd9b125044f15807974;hpb=c3ab2dcb442a0e66b7a621c59c6c7a679c26cee9;p=pti%2Fo2.git

diff --git a/o2dms/adapter/orm.py b/o2dms/adapter/orm.py
index 05821dc..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,16 +46,56 @@ nfDeploymentDesc = Table(
     Column("deploymentManagerId", String(255)),
     Column("name", String(255)),
     Column("description", String(255)),
-    Column("inputParams", 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)