Code Review
/
pti
/
o2.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Add o2dms api endpoint
[pti/o2.git]
/
o2ims
/
adapter
/
orm.py
diff --git
a/o2ims/adapter/orm.py
b/o2ims/adapter/orm.py
index
9cbf41a
..
7aafde5
100644
(file)
--- a/
o2ims/adapter/orm.py
+++ b/
o2ims/adapter/orm.py
@@
-16,15
+16,17
@@
from sqlalchemy import (
Table,
\r
MetaData,
\r
Column,
\r
Table,
\r
MetaData,
\r
Column,
\r
-
#
Integer,
\r
+ Integer,
\r
String,
\r
# Date,
\r
String,
\r
# Date,
\r
+ DateTime,
\r
ForeignKey,
\r
# engine,
\r
# event,
\r
)
\r
\r
from sqlalchemy.orm import mapper, relationship
\r
ForeignKey,
\r
# engine,
\r
# event,
\r
)
\r
\r
from sqlalchemy.orm import mapper, relationship
\r
+# from sqlalchemy.sql.sqltypes import Integer
\r
\r
from o2ims.domain import ocloud as ocloudModel
\r
\r
\r
from o2ims.domain import ocloud as ocloudModel
\r
\r
@@
-36,6
+38,11
@@
metadata = MetaData()
ocloud = Table(
\r
"ocloud",
\r
metadata,
\r
ocloud = Table(
\r
"ocloud",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+ Column("version_number", Integer),
\r
+
\r
Column("oCloudId", String(255), primary_key=True),
\r
Column("globalcloudId", String(255)),
\r
Column("name", String(255)),
\r
Column("oCloudId", String(255), primary_key=True),
\r
Column("globalcloudId", String(255)),
\r
Column("name", String(255)),
\r
@@
-47,6
+54,10
@@
ocloud = Table(
resourcetype = Table(
\r
"resourcetype",
\r
metadata,
\r
resourcetype = Table(
\r
"resourcetype",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+
\r
Column("resourceTypeId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("name", String(255)),
\r
Column("resourceTypeId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("name", String(255)),
\r
@@
-60,6
+71,11
@@
resourcetype = Table(
resourcepool = Table(
\r
"resourcepool",
\r
metadata,
\r
resourcepool = Table(
\r
"resourcepool",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+ Column("version_number", Integer),
\r
+
\r
Column("resourcePoolId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("globalLocationId", String(255)),
\r
Column("resourcePoolId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("globalLocationId", String(255)),
\r
@@
-73,9
+89,15
@@
resourcepool = Table(
resource = Table(
\r
"resource",
\r
metadata,
\r
resource = Table(
\r
"resource",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+ Column("version_number", Integer),
\r
+
\r
Column("resourceId", String(255), primary_key=True),
\r
Column("resourceTypeId", ForeignKey("resourcetype.resourceTypeId")),
\r
Column("resourcePoolId", ForeignKey("resourcepool.resourcePoolId")),
\r
Column("resourceId", String(255), primary_key=True),
\r
Column("resourceTypeId", ForeignKey("resourcetype.resourceTypeId")),
\r
Column("resourcePoolId", ForeignKey("resourcepool.resourcePoolId")),
\r
+ # Column("globalAssetId", String(255)),
\r
# Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("parentId", String(255)),
\r
Column("description", String(255)),
\r
# Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("parentId", String(255)),
\r
Column("description", String(255)),
\r
@@
-86,6
+108,11
@@
resource = Table(
deploymentmanager = Table(
\r
"deploymentmanager",
\r
metadata,
\r
deploymentmanager = Table(
\r
"deploymentmanager",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+ Column("version_number", Integer),
\r
+
\r
Column("deploymentManagerId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("name", String(255)),
\r
Column("deploymentManagerId", String(255), primary_key=True),
\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),
\r
Column("name", String(255)),
\r
@@
-100,6
+127,11
@@
deploymentmanager = Table(
subscription = Table(
\r
"subscription",
\r
metadata,
\r
subscription = Table(
\r
"subscription",
\r
metadata,
\r
+ Column("updatetime", DateTime),
\r
+ Column("createtime", DateTime),
\r
+ Column("hash", String(255)),
\r
+ Column("version_number", Integer),
\r
+
\r
Column("subscriptionId", String(255), primary_key=True),
\r
Column("callback", String(255)),
\r
Column("consumerSubscriptionId", String(255)),
\r
Column("subscriptionId", String(255), primary_key=True),
\r
Column("callback", String(255)),
\r
Column("consumerSubscriptionId", String(255)),
\r