12:17 a.m.
--=_3a2650e5-0f37-4517-8bfb-2025d36037dc
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Hi,
I would like to introduce a change to two tables in oVirt-engine-core.
The VM and VM-template share most of their configuration.
I am looking to unify the two tables into one table.
Currently, if such a change would be made in the DB layer, it would be
abstracted by the DAL so no code beyond that layer should be affected,
and code changes to that layer should be minimal (since we use views and
stored procedures to abstract the DB structure anyway).
The major change would be at the DB layer, which will mostly require
data migration and changing of the STPs.
If anyone has PostgresSQL knowledge and would like to pitch in and help
me push this change it would be great.
I have more technical details if anyone is interested.
Attached is the diff between both tables (vm_static and vm_templates).
Regards,
Mike
--=_3a2650e5-0f37-4517-8bfb-2025d36037dc
Content-Type: text/x-patch; name=vm.template.tables.diff
Content-Disposition: attachment; filename=vm.template.tables.diff
Content-Transfer-Encoding: base64
Miw0YzIsNQo8IGNoaWxkX2NvdW50IGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAo8IENPTlNU
UkFJTlQgcGtfdm1fdGVtcGxhdGVzIFBSSU1BUlkgS0VZICh2bXRfZ3VpZCksCjwgQ09OU1RSQUlO
VCB2ZHNfZ3JvdXBzX3ZtX3RlbXBsYXRlcyBGT1JFSUdOIEtFWSAodmRzX2dyb3VwX2lkKSBSRUZF
UkVOQ0VTIHZkc19ncm91cHMgKHZkc19ncm91cF9pZCkgTUFUQ0ggU0lNUExFIE9OIFVQREFURSBO
TyBBQ1RJT04gT04gREVMRVRFIE5PIEFDVElPTgotLS0KPiBDT05TVFJBSU5UIGZrX3Zkc19zdGF0
aWNfdm1fc3RhdGljIEZPUkVJR04gS0VZIChkZWRpY2F0ZWRfdm1fZm9yX3ZkcykgUkVGRVJFTkNF
UyB2ZHNfc3RhdGljICh2ZHNfaWQpIE1BVENIIFNJTVBMRSBPTiBVUERBVEUgTk8gQUNUSU9OIE9O
IERFTEVURSBOTyBBQ1RJT04sCj4gQ09OU1RSQUlOVCBwa192bV9zdGF0aWMgUFJJTUFSWSBLRVkg
KHZtX2d1aWQpLAo+IENPTlNUUkFJTlQgdmRzX2dyb3Vwc192bV9zdGF0aWMgRk9SRUlHTiBLRVkg
KHZkc19ncm91cF9pZCkgUkVGRVJFTkNFUyB2ZHNfZ3JvdXBzICh2ZHNfZ3JvdXBfaWQpIE1BVENI
IFNJTVBMRSBPTiBVUERBVEUgTk8gQUNUSU9OIE9OIERFTEVURSBOTyBBQ1RJT04sCj4gQ09OU1RS
QUlOVCB2bV90ZW1wbGF0ZXNfdm1fc3RhdGljIEZPUkVJR04gS0VZICh2bXRfZ3VpZCkgUkVGRVJF
TkNFUyB2bV90ZW1wbGF0ZXMgKHZtdF9ndWlkKSBNQVRDSCBTSU1QTEUgT04gVVBEQVRFIE5PIEFD
VElPTiBPTiBERUxFVEUgTk8gQUNUSU9OCjZjNyw5CjwgY3JlYXRpb25fZGF0ZSB0aW1lc3RhbXAg
d2l0aCB0aW1lIHpvbmUgTk9UIE5VTEwsCi0tLQo+IF9jcmVhdGVfZGF0ZSB0aW1lc3RhbXAgd2l0
aCB0aW1lIHpvbmUgREVGQVVMVCAoJ25vdyc6OnRleHQpOjp0aW1lc3RhbXAgd2l0aG91dCB0aW1l
IHpvbmUsCj4gY3JlYXRpb25fZGF0ZSB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUsCj4gZGVkaWNh
dGVkX3ZtX2Zvcl92ZHMgdXVpZCwKMTRhMTgKPiBpc19pbml0aWFsaXplZCBib29sZWFuLAoyMGMy
NCwyNQo8ICJuYW1lIiBjaGFyYWN0ZXIgdmFyeWluZyg0MCkgTk9UIE5VTEwsCi0tLQo+IG1pZ3Jh
dGlvbl9zdXBwb3J0IGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAo+IG1pbl9hbGxvY2F0ZWRf
bWVtIGludGVnZXIgTk9UIE5VTEwgREVGQVVMVCAwLAoyNmEzMgo+IHByZWRlZmluZWRfcHJvcGVy
dGllcyBjaGFyYWN0ZXIgdmFyeWluZyg0MDAwKSwKMjhkMzMKPCBzdGF0dXMgaW50ZWdlciBOT1Qg
TlVMTCwKMzBjMzUKPCBfdXBkYXRlX2RhdGUgdGltZXN0YW1wIHdpdGggdGltZSB6b25lIERFRkFV
TFQgbm93KCksCi0tLQo+IF91cGRhdGVfZGF0ZSB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUsCjMx
YTM3Cj4gdXNlcmRlZmluZWRfcHJvcGVydGllcyBjaGFyYWN0ZXIgdmFyeWluZyg0MDAwKSwKMzJh
MzksNDAKPiB2bV9ndWlkIHV1aWQgTk9UIE5VTEwsCj4gdm1fbmFtZSBjaGFyYWN0ZXIgdmFyeWlu
ZygyNTUpIE5PVCBOVUxMLAo=
--=_3a2650e5-0f37-4517-8bfb-2025d36037dc--