Django Models PrimaryKey not incrimenting I dont understand this framework and the documentation is poorly written.

[G Z]

So I have a database that we are using to collect vm statistics. It is always running and writing to a django database.
I built my models file to resemble the db. However I have run into quite a few issues. I was wondering if anyone else has run into these issues
and found out how to solve them.

First when I try to add a new entry I get an error returned that the value can't be null for the primary key.

ORA-01400: cannot insert NULL into ("DEV"."VM_LICENSES"."VM_LICENSE_ID")

Isn't django supposed to automatically handle this when you set primary_key = True?



Also I want to have a list of available licenses from a table called licenses, and I want to be able to assign
them by foreign key to each vm by its foreign key in an intermediary table called vm_licenses.

Here are the model snippets for that process. However, I can't get manytomany to work right.
Bascially our system admins need to be able to manage the associated licenses for each vm. I'm trying to allow them to 
do this with the admin page. People keep pointing me to the documentation for manytomany but obviously I can't seem to figure out
how django uses already established databases. The django documentation doesn't really explain how things work. Thus,
anything outside the basic blog app is unknown territory you just kinda have to plug away in the dark. I'm tired of plugging away 
trying to figure out how this framework works.

I would greatly appreciate it if someone could help me understand how the django framework interacts with already established databases and how
to do what I want. 

class License(models.Model):
   license_id = models.BigIntegerField(primary_key = True, editable = False, db_column='license_id')
   license_authority_id = models.ForeignKey(License_authoritie,  on_delete = models.PROTECT, db_column='license_authority_id')
   product = models.CharField(max_length = 20)

   class Meta:
      managed = False
      db_table = 'licenses'
      ordering = ['product']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.product
        
class Vm_license(models.Model):
   vm_license_id = models.AutoField(primary_key = True, db_column='vm_license_id')
   license_id = models.ForeignKey(License,  on_delete = models.PROTECT, db_column='license_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')

   class Meta:
      managed = False
      db_table = 'vm_licenses'




Here is my entire models file let me know if you see any problems with it because I don't know why i cant add entries.


from __future__ import unicode_literals
from django.db import models
from django.core.exceptions import ValidationError
from django.contrib.auth.models import User

class Cidr_allocation(models.Model):
   cidr_allocation_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'cidr_allocation_id')
   cidr = models.CharField(max_length = 40)
   allocation_name = models.CharField(max_length = 30)
   allocation_date = models.DateTimeField(auto_now = False,  auto_now_add = True)
   deallocation_date = models.DateTimeField(auto_now=False, auto_now_add=False)
   allocation_source = models.CharField(max_length = 30)
   public_address = models.CharField(max_length = 1)

   class Meta:
      managed = False
      db_table = 'cidr_allocations'
     
   def clean(self):
      if self.public_address != 'Y' and self.public_address != 'N':
         raise ValidationError('Please enter a Y or N')
     
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.allocation_name

class Customer(models.Model):
   customer_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'customer_id')
   customer_name = models.CharField(max_length = 30)
   inactive = models.CharField(max_length = 1)

   class Meta:
      managed = False
      db_table = 'customers'
      ordering = ['customer_name']
     
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.customer_name
  
   def clean(self):
      if self.inactive != 'Y' and self.inactive != 'N':
         raise ValidationError('Please enter a Y or N')

class Vcenter(models.Model):
   vcenter_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vcenter_id')
   vcenter_ip_address = models.BinaryField()
   vcenter_uuid = models.CharField(max_length = 50)
   username = models.CharField(max_length = 20)
   password = models.CharField(max_length = 20)
   name = models.CharField(max_length = 30)

   class Meta:
      managed = False
      db_table = 'vcenters'

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.name

class Datacenter(models.Model):
   datacenter_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'datacenter_id')
   vcenter_id = models.ForeignKey(Vcenter,  on_delete = models.PROTECT, db_column='vcenter_id')
   datacenter_mor = models.CharField(max_length = 20)
   datacenter_name = models.CharField(max_length = 30)

   class Meta:
      managed = False
      db_table = 'datacenters'

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.datacenter_name
  
class Storage_tier(models.Model):
   storage_tier_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'storage_tier_id')
   tier_name = models.CharField(max_length = 20)
   reserved_iops = models.BigIntegerField()
   price_per_gb = models.DecimalField(max_digits = 7, decimal_places = 4)

   class Meta:
      managed = False
      db_table = 'storage_tiers'
      ordering = ['tier_name']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.tier_name

class Datastore(models.Model):
   datastore_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'datastore_id')
   datastore_mor = models.CharField(max_length = 20)
   storage_tier_id = models.ForeignKey(Storage_tier,  on_delete = models.PROTECT, db_column='storage_tier_id')
   datastore_name = models.CharField(max_length = 30)
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')
   type = models.CharField(max_length = 10)
   class Meta:
      managed = False
      db_table = 'datastores'
  
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.datastore_name
  
class Esxi_license(models.Model):
   esxi_license_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'esxi_license_id')
   license_type = models.CharField(max_length = 40)

   class Meta:
      managed = False
      db_table = 'esxi_licenses'
  
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.license_type
  
class Guest_o(models.Model):
   guest_os_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'guest_os_id')
   guest_os = models.CharField(max_length = 60)

   class Meta:
      managed = False
      db_table = 'guest_os'

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.guest_os

class Host(models.Model):
   host_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'host_id')
   host_mor = models.CharField(max_length = 20)
   esxi_license_id = models.ForeignKey(Esxi_license,  on_delete = models.PROTECT, db_column='esxi_license_id')
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')
   host_ip_address = models.BinaryField()
   mfgr = models.CharField(max_length = 40)
   model = models.CharField(max_length = 40)
   cores = models.BigIntegerField()
   core_ghz = models.DecimalField(max_digits = 8, decimal_places = 5)
   processor_type = models.CharField(max_length = 60)
   memory_gb = models.DecimalField(max_digits = 9, decimal_places = 5)
  
   class Meta:
      managed = False
      db_table = 'hosts'
     
   def __str__(self):
      ip = self.host_ip_address.decode("utf-16")
      ip = ip.decode("utf-8")
      return ip

class Ip_addresse(models.Model):
   ip_address_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'ip_address_id')
   ip_address = models.BinaryField()
   cidr_allocation_id = models.ForeignKey(Cidr_allocation, db_column='cidr_allocation_id')

   class Meta:
      managed = False
      db_table = 'ip_addresses'

class Ip_address_usage_historie(models.Model):
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   bytes_sent = models.BigIntegerField()
   bytes_received = models.BigIntegerField()
   ip_address_id = models.ForeignKey(Ip_addresse,  on_delete = models.PROTECT, db_column='ip_address_id')
   load_sequence = models.BigIntegerField()

   class Meta:
      managed = False
      db_table = 'ip_address_usage_histories'

class License_authoritie(models.Model):
   license_authority_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'license_authority_id')
   licensing_authority = models.CharField(max_length = 30)

   class Meta:
      managed = False
      db_table = 'license_authorities'

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.licensing_authority
  

  
class Nas_device(models.Model):
   nas_device_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'nas_device_id')
   device_name = models.CharField(max_length = 20)
   ip_address = models.BinaryField()
   storage_tier_id = models.ForeignKey(Storage_tier,  on_delete = models.PROTECT, db_column='storage_tier_id')
  
   class Meta:
      managed = False
      db_table = 'nas_devices'
      ordering = ['device_name']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.device_name

class Nas_usage(models.Model):
   vm_nas_usage_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_nas_usage_history_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   provisioned_gb = models.DecimalField(max_digits = 13, decimal_places = 5)
   consumed_gb = models.DecimalField(max_digits = 13, decimal_places = 5)
   nas_device_id = models.ForeignKey(Nas_device,  on_delete = models.PROTECT, db_column='nas_device_id')
   customer_id = models.ForeignKey(Customer,  on_delete = models.PROTECT, db_column='customer_id')

   class Meta:
      managed = False
      db_table = 'nas_usage'

class Network_device(models.Model):
   network_device_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'network_device_id')
   name = models.CharField(max_length = 20)
   management_ip_address = models.BinaryField()
   snmp_version = models.DecimalField(max_digits = 1, decimal_places = 0)
   snmp_username = models.CharField(max_length = 20)
   snmp_security = models.CharField(max_length = 12)
   snmp_password = models.CharField(max_length = 20)
   arp_cache_oid = models.CharField(max_length = 40)
   snmp_priv_passphrase = models.CharField(max_length = 20)
   snmp_auth_protocol = models.CharField(max_length = 3)
   snmp_priv_protocol = models.CharField(max_length = 3)
  
   class Meta:
      managed = False
      db_table = 'network_devices'
      ordering = ['name']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.name
     
   def clean(self):
      snmp_security = set(['AuthPriv', 'NoAuthNoPriv', 'AuthNoPriv'])
      auth_protocols = set(['MD5', 'SHA'])
      priv_protocols = set(['AES', 'DES'])
      if self.snmp_version < 1 or self.snmp_version > 3:
         raise ValidationError('Please enter a 1, 2 or 3')
      if self.snmp_security not in snmp_security:
         raise ValidationError('Please enter AuthPriv, NoAuthNoPriv or AuthNoPriv')
      if self.snmp_auth_protocol not in auth_protocols:
         raise ValidationError('Please enter MD5 or SHA')
      if self.snmp_priv_protocol not in priv_protocols:
         raise ValidationError('Please enter AES or DES')
     
class Network_device_ip_addresse(models.Model):
   network_device = models.ForeignKey(Network_device,  on_delete = models.PROTECT)
   ip_address_id = models.ForeignKey(Ip_addresse,  on_delete = models.PROTECT, db_column='ip_address_id')

   class Meta:
      managed = False
      db_table = 'network_device_ip_addresses'

class Network_device_mac_addresse(models.Model):
   network_device = models.ForeignKey(Network_device,  on_delete = models.PROTECT)
   mac_address = models.CharField(max_length = 17)
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')

   class Meta:
      managed = False
      db_table = 'network_device_mac_addresses'
      ordering = ['mac_address']
     
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.mac_address

class Resource_pool(models.Model):
   resource_pool_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'resource_pool')
   resource_pool_mor = models.CharField(max_length = 20)
   resource_pool_name = models.CharField(max_length = 30)
   cpu_ghz_reservation = models.DecimalField(max_digits = 8, decimal_places = 5)
   cpu_ghz_limit = models.DecimalField(max_digits = 8, decimal_places = 5)
   cpu_reservation_expandable = models.CharField(max_length = 1)
   ram_gb_reservation = models.DecimalField(max_digits = 9, decimal_places = 5)
   ram_gb_limit = models.DecimalField(max_digits = 9, decimal_places = 5)
   ram_reservation_expandable = models.CharField(max_length = 1)
   cpu_unlimited = models.CharField(max_length = 1)
   ram_unlimited = models.CharField(max_length = 1)
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')

   class Meta:
      managed = False
      db_table = 'resource_pools'

class Vm_group(models.Model):
   vm_group_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_group_id')
   customer_id = models.ForeignKey(Customer,  on_delete = models.PROTECT, db_column='customer_id')
   vm_group_name = models.CharField(max_length = 30)
  
   class Meta:
      managed = False
      db_table = 'vm_groups'
      ordering = ['vm_group_name']
     
   def __unicode__(self):  # Python 3: def __str__(self):
      return self.vm_group_name

class Vm(models.Model):
   vm_id = models.BigIntegerField(primary_key = True, editable = False, db_column='vm_id')
   vm_mor = models.CharField(max_length = 20)
   vm_name = models.CharField(max_length = 256)
   vm_group_id = models.ForeignKey(Vm_group,  on_delete = models.PROTECT, db_column ='vm_group_id')
   vm_display_name = models.CharField(max_length = 30)
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')
   vcd_managed = models.CharField(max_length = 60)

   class Meta:
      managed = False
      db_table = 'vms'

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.vm_name

class Vm_compute_historie(models.Model):
   vm_compute_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_compute_history')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   power_state = models.DecimalField(max_digits = 1, decimal_places = 0)
   cpu_core_allocation = models.DecimalField(max_digits = 8, decimal_places = 5)
   cpu_ghz_reservation = models.DecimalField(max_digits = 8, decimal_places = 5)
   cpu_ghz_limit = models.DecimalField(max_digits = 8, decimal_places = 5)
   ram_gb_allocation = models.DecimalField(max_digits = 9, decimal_places = 5)
   ram_gb_reservation = models.DecimalField(max_digits = 9, decimal_places = 5)
   ram_gb_limit = models.DecimalField(max_digits = 9, decimal_places = 5)
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   host_id = models.ForeignKey(Host,  on_delete = models.PROTECT, db_column='host_id')
   esxi_license_id = models.ForeignKey(Esxi_license,  on_delete = models.PROTECT, db_column='esxi_license_id')
   resource_pool_id= models.ForeignKey(Resource_pool,  on_delete = models.PROTECT, db_column='resource_pool_id')
   fault_tolerance = models.CharField(max_length = 1)
   guest_os_id= models.ForeignKey(Guest_o,  on_delete = models.PROTECT, db_column='guest_os_id')

   class Meta:
      managed = False
      db_table = 'vm_compute_histories'

class Vm_compute_usage_historie(models.Model):
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   cpu_ghz_hours = models.DecimalField(max_digits = 13, decimal_places = 5)
   ram_gb_hours = models.DecimalField(max_digits = 13, decimal_places = 5)

   class Meta:
      managed = False
      db_table = 'vm_compute_usage_histories'

class Vm_ip_address_historie(models.Model):
   vm_ip_address_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_ip_address_history_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   ip_address= models.ForeignKey(Ip_addresse,  on_delete = models.PROTECT)
   allocation_date = models.DateTimeField(auto_now = False,  auto_now_add = True)
   deallocation_date = models.DateTimeField(auto_now = False,  auto_now_add = False)

   class Meta:
      managed = False
      db_table = 'vm_ip_address_histories'

class Vm_mac_addresse(models.Model):
   vm_mac_address_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_mac_address_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   mac_address = models.CharField(max_length = 20)
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   datacenter_id = models.ForeignKey(Datacenter,  on_delete = models.PROTECT, db_column='datacenter_id')

   class Meta:
      managed = False
      db_table = 'vm_mac_addresses'

class Vm_nas_usage_historie(models.Model):
   vm_nas_usage_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_nas_usage_history_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   provisioned_gb = models.DecimalField(max_digits = 13, decimal_places = 5)
   consumed_gb = models.DecimalField(max_digits = 13, decimal_places = 5)
   nas_device_id = models.ForeignKey(Nas_device,  on_delete = models.PROTECT, db_column='nas_device_id')
   customer_id = models.ForeignKey(Customer,  on_delete = models.PROTECT, db_column='customer_id')

   class Meta:
      managed = False
      db_table = 'vm_nas_usage_histories'

class Vm_storage_historie(models.Model):
   vm_storage_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_storage_history_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   datastore_id= models.ForeignKey(Datastore,  on_delete = models.PROTECT, db_column = 'datastore_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   provisioned_gb = models.DecimalField(max_digits = 13, decimal_places = 5)
   consumed_gb = models.DecimalField(max_digits = 13, decimal_places = 5)

   class Meta:
      managed = False
      db_table = 'vm_storage_histories'

class Vm_storage_perf_historie(models.Model):
   vm_storage_perf_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_storage_perf_history_id')
   datastore_id = models.ForeignKey(Datastore,  on_delete = models.PROTECT, db_column = 'datastore_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   average_reads_per_sec = models.BigIntegerField()
   average_writes_per_sec = models.BigIntegerField()
   max_read_requests = models.BigIntegerField()
   max_write_requests = models.BigIntegerField()
   sum_read_requests = models.BigIntegerField()
   sum_write_requests = models.BigIntegerField()

   class Meta:
      managed = False
      db_table = 'vm_storage_perf_histories'
     

  
class License(models.Model):
   license_id = models.BigIntegerField(primary_key = True, editable = False, db_column='license_id')
   license_authority_id = models.ForeignKey(License_authoritie,  on_delete = models.PROTECT, db_column='license_authority_id')
   product = models.CharField(max_length = 20)

   class Meta:
      managed = False
      db_table = 'licenses'
      ordering = ['product']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.product
        
class Vm_license(models.Model):
   vm_license_id = models.AutoField(primary_key = True, db_column='vm_license_id')
   license_id = models.ForeignKey(License,  on_delete = models.PROTECT, db_column='license_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')

   class Meta:
      managed = False
      db_table = 'vm_licenses'
     
  
  
class Vm_license_historie(models.Model):
   vm_license_history_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_license_history_id')
   license_id = models.ForeignKey(License,  on_delete = models.PROTECT, db_column='license_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')
   assignment_date = models.DateTimeField(auto_now = False,  auto_now_add = False)
   deassignment_date = models.DateTimeField(auto_now = False,  auto_now_add = False)
   class Meta:
      managed = False
      db_table = 'vm_license_histories'     
     
class Vm_backup_storage(models.Model):
   vm_backup_storage_id = models.BigIntegerField(primary_key = True, editable = False, db_column = 'vm_backup_storage_id')
   customer_id = models.ForeignKey(Customer,  on_delete = models.PROTECT, db_column='customer_id')
   datetime = models.DateTimeField(auto_now = False,  auto_now_add = False)
   consumed_gb = models.CharField(max_length = 200)
   class Meta:
      managed = False
      db_table = 'vm_backup_storage' 


class UserProfile(models.Model):
    user = models.OneToOneField(User)
    website = models.URLField(blank=True)
    picture = models.ImageField(upload_to='profile_images', blank=True)
    def __unicode__(self):
        return self.user.username

[G Z]

I can update items just not add them always the same error cannot insert null for the primary key

[Tom Evans]

Auto increment is a feature of AutoField, not of primary keys.

https://docs.djangoproject.com/en/1.6/ref/models/fields/#autofield

BigIntegerField has no auto increment properties.

Marking a field as a primary key simply means that no AutoField named
id is automatically added to your class, and the SQL generated for
that field will mark it as a primary key.

Cheers

Tom

[G Z]

Tom,

It fails with both autofield and bigintergerfield

class License(models.Model):
   license_id = models.AutoField(primary_key = True, editable = False, db_column='license_id')

   license_authority_id = models.ForeignKey(License_authoritie,  on_delete = models.PROTECT, db_column='license_authority_id')
   product = models.CharField(max_length = 20)

   class Meta:
      managed = False
      db_table = 'licenses'
      ordering = ['product']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.product

class Vm_license(models.Model):
   vm_license_id = models.AutoField(primary_key = True, db_column='vm_license_id')
   license_id = models.ForeignKey(License,  on_delete = models.PROTECT, db_column='license_id')
   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')

   class Meta:
      managed = False
      db_table = 'vm_licenses'

I get the same thing:

Request Method:     POST
Request URL:    http://127.0.0.1:8000/admin/portal/vm_license/add/
Django Version:     1.6.5
Exception Type:     IntegrityError
Exception Value:    

ORA-01400: cannot insert NULL into ("DEV"."VM_LICENSES"."VM_LICENSE_ID")

[G Z]

http://www.oracle.com/technetwork/articles/dsl/vasiliev-django-100257.html

the guide I followed from oracle.

<a href="https://docs.djangoproject.com/en/1.6/ref/models/fields/#autofield" target="_blank" onmousedown="this.href='https://www.google.com/url?q\75https%3A%2F%2Fdocs.djangoproject.com%2Fen%2F1.6%2Fref%2Fmodels%2Ffie

...

[Tom Evans]

On Tue, Jul 15, 2014 at 11:16 PM, G Z <zuk...@gmail.com> wrote:
> Tom,
>
> It fails with both autofield and bigintergerfield
>
> class License(models.Model):
> license_id = models.AutoField(primary_key = True, editable = False,
> db_column='license_id')
> license_authority_id = models.ForeignKey(License_authoritie, on_delete =
> models.PROTECT, db_column='license_authority_id')
> product = models.CharField(max_length = 20)
>
> class Meta:
> managed = False

Two things:

Auto increment is a property set at the time you create the table, so
changing the code changes nothing unless you recreate the
table/migrations.

Secondly, you have told django you are managing that table yourself.
If you want that field auto increment, make it so.

Cheers

Tom

[G Z]

so I added a db trigger in oracle and it still said the same thing when ever I tried to save the new addition. Also whenever I try to go to an existing vm the manytomany field throws an exception that table or view doesn't exist but when I goto add new it doesnt and the correct field is displayed, but then when i save it says can't be null.


What changes from what you can see could I make to curb these problems?

class License(models.Model):
   license_id = models.AutoField(primary_key = True, editable = False, db_column='license_id')

   license_authority_id = models.ForeignKey(License_authoritie,  on_delete = models.PROTECT, db_column='license_authority_id')
   product = models.CharField(max_length = 20)

   class Meta:
      managed = False

      db_table = 'licenses'
      ordering = ['product']

   def __unicode__(self):  # Python 3: def __str__(self):
      return self.product
        
class Vm_license(models.Model):
   vm_license_id = models.AutoField(primary_key = True, db_column='vm_license_id')

   vm_id = models.ForeignKey(Vm,  on_delete = models.PROTECT, db_column='vm_id')

   license = models.ManyToManyField(

License)

   class Meta:
      managed = False

      db_table = 'vm_licenses'

class vm_license_admin(admin.ModelAdmin):
    #list_display = ('vm_id', 'license_id')
    list_display = ('vm_id',)
    search_fields = ('vm_id__vm_name',)
    ordering = ('vm_id',)
    filter_horizontal = ('license',)
   
admin.site.register(Vm_license, vm_license_admin)

[Frank Bieniek]

Hi there,
you are telling django, you know what you are doing via

managed = False -> no batteries included, please read the details here
https://docs.djangoproject.com/en/dev/ref/models/options/

There are great books out there explaining django from
other perspectives than the online documentation

Two Scoops of Django
http://www.amazon.com/Two-Scoops-Django-Best-Practices/dp/098146730X/

Test driven development in python
http://www.amazon.com/Test-Driven-Development-Python-Harry-Percival/dp/1449364829/

Hope this helps
Frank



Am 16.07.14 19:08, schrieb G Z:

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To post to this group, send email to django...@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/9ecf5d7f-c303-4742-9ad7-a1a56bddb716%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[G Z]

Thanks, I eventually solved it by using django to generate the models i believe it was because i was defining the db_column in the primary key and django said whatever, so when inspectdb built the models file it took that out and it started to work.