Sync DB models and migrations in keystone.assignment.backends.sql

This patch syncs models with migrations for:

-Domain
-GroupDomainGrant
-GroupProjectGrant
-Role
-UserDomainGrant
-UserProjectGrant

No actual schema change is taking place, this patch just corrects errors
in the model definitions.

partially implements bp db-sync-models-with-migrations

Change-Id: Ib3f22f56a9d00c725f21036ab4bfe4df5fad6876

2 files changed, 14 insertions, 10 deletions

diff --git a/keystone/assignment/backends/sql.py b/keystone/assignment/backends/sql.py
index 5ec435ff..a52a720c 100644
--- a/keystone/assignment/backends/sql.py
+++ b/keystone/assignment/backends/sql.py
@@ -657,9 +657,10 @@ class Domain(sql.ModelBase, sql.DictBase):
     __tablename__ = 'domain'
     attributes = ['id', 'name', 'enabled']
     id = sql.Column(sql.String(64), primary_key=True)
-    name = sql.Column(sql.String(64), unique=True, nullable=False)
-    enabled = sql.Column(sql.Boolean, default=True)
+    name = sql.Column(sql.String(64), nullable=False)
+    enabled = sql.Column(sql.Boolean, default=True, nullable=False)
     extra = sql.Column(sql.JsonBlob())
+    __table_args__ = (sql.UniqueConstraint('name'), {})
 
 
 class Project(sql.ModelBase, sql.DictBase):
@@ -681,8 +682,9 @@ class Role(sql.ModelBase, sql.DictBase):
     __tablename__ = 'role'
     attributes = ['id', 'name']
     id = sql.Column(sql.String(64), primary_key=True)
-    name = sql.Column(sql.String(64), unique=True, nullable=False)
+    name = sql.Column(sql.String(255), nullable=False)
     extra = sql.Column(sql.JsonBlob())
+    __table_args__ = (sql.UniqueConstraint('name'), {})
 
 
 class BaseGrant(sql.DictBase):
@@ -720,9 +722,8 @@ class BaseGrant(sql.DictBase):
 
 class UserProjectGrant(sql.ModelBase, BaseGrant):
     __tablename__ = 'user_project_metadata'
-    user_id = sql.Column(sql.String(64),
-                         primary_key=True)
-    project_id = sql.Column(sql.String(64),
+    user_id = sql.Column(sql.String(64), primary_key=True)
+    project_id = sql.Column(sql.String(64), sql.ForeignKey('project.id'),
                             primary_key=True)
     data = sql.Column(sql.JsonBlob())
 
@@ -730,19 +731,22 @@ class UserProjectGrant(sql.ModelBase, BaseGrant):
 class UserDomainGrant(sql.ModelBase, BaseGrant):
     __tablename__ = 'user_domain_metadata'
     user_id = sql.Column(sql.String(64), primary_key=True)
-    domain_id = sql.Column(sql.String(64), primary_key=True)
+    domain_id = sql.Column(sql.String(64), sql.ForeignKey('domain.id'),
+                           primary_key=True)
     data = sql.Column(sql.JsonBlob())
 
 
 class GroupProjectGrant(sql.ModelBase, BaseGrant):
     __tablename__ = 'group_project_metadata'
     group_id = sql.Column(sql.String(64), primary_key=True)
-    project_id = sql.Column(sql.String(64), primary_key=True)
+    project_id = sql.Column(sql.String(64), sql.ForeignKey('project.id'),
+                            primary_key=True)
     data = sql.Column(sql.JsonBlob())
 
 
 class GroupDomainGrant(sql.ModelBase, BaseGrant):
     __tablename__ = 'group_domain_metadata'
     group_id = sql.Column(sql.String(64), primary_key=True)
-    domain_id = sql.Column(sql.String(64), primary_key=True)
+    domain_id = sql.Column(sql.String(64), sql.ForeignKey('domain.id'),
+                           primary_key=True)
     data = sql.Column(sql.JsonBlob())
diff --git a/tests/test_backend_sql.py b/tests/test_backend_sql.py
index 38eddaa4..89276e86 100644
--- a/tests/test_backend_sql.py
+++ b/tests/test_backend_sql.py
@@ -114,7 +114,7 @@ class SqlModels(SqlTests):
 
     def test_role_model(self):
         cols = (('id', sql.String, 64),
-                ('name', sql.String, 64))
+                ('name', sql.String, 255))
         self.assertExpectedSchema('role', cols)
 
     def test_user_project_metadata_model(self):