Table,\r
MetaData,\r
Column,\r
- # Integer,\r
+ Integer,\r
String,\r
# Date,\r
+ DateTime,\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
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
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
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
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
deploymentmanager = Table(\r
"deploymentmanager",\r
metadata,\r
+ Column("updatetime", DateTime),\r
+ Column("createtime", DateTime),\r
+ Column("hash", String(255)),\r
+\r
Column("deploymentManagerId", String(255), primary_key=True),\r
Column("oCloudId", ForeignKey("ocloud.oCloudId")),\r
Column("name", String(255)),\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