[openstack-dev] [magnum] Should pod/rc/service 'bay_uuid' be foreign key for Bay 'uuid' ?

Vilobh Meshram vilobhmeshram.openstack at gmail.com
Tue Sep 8 23:25:00 UTC 2015


Hi All,


K8s resources Pod/RC/Service share same 'bay_uuid' which it gets from the
Bay 'uuid' (which happens to be the primary key for Bay). Shouldn't it be a
good idea to make pod/rc/service 'bay_uuid' be foreign key for Bay 'uuid'.
Are there any cons in doing so ? Why was it done in this specific way
initially ?

Listing down some pros in doing so :-

1. It helps to give a clear indication whether a Bay exist or not; if the
Pod/RC/Service 'bay_uuid' is a foreign key for Bay 'uuid'.
2. No additional lookup is necessary for the Bay table to check the
existence of Bay.



Nova already does so by [1]. Even other projects do follow the same pattern.


- Vilobh

[1]
https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/models.py#L352
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150908/ed6a1d7a/attachment.html>


More information about the OpenStack-dev mailing list