Re: Advanced SQL Question

I suppose you can always switch to the raw SQL queries instead of using Django's ORM. You have to type more, but it will be more efficient if you know how to code SQL for your DB. On Thursday, 19 June 2014 23:49:52 UTC+2, G Z wrote: > > I have a multi-level database that uses concatenated fore

Re: Advanced SQL Question

On Thu, Jun 19, 2014 at 4:49 PM, G Z wrote: > how do I deal with concatenated foreign keys to form a primary key how do i > even register that in the models.py? i guess you mean composite keys. if so, then no; the Django ORM doesn't support composite primary keys. -- Javier -- You received

Advanced SQL Question

I have a multi-level database that uses concatenated foreign keys as primary keys for tables. For example we have three tables VMS VM_LICENSE LICENSES VMS has name license_id <- foreign key vm_id <-primary key vm_licenses has two concatenated fkeys to for a primary key of: licenses_id fkey