G Z
2014-07-16 21:14:35 UTC
So I'm still running in to issues using a prexisting database, ive worked
out almost all of the issues except one.
You can now update, and add new records through the admin panel, but after
that you can't delete them.
The Models file was generated by djangos inspect Db. I'm not sure why but I
can't delete.
MODELS.PY
# This is an auto-generated Django model module.
error:*
Exception Type:DatabaseErrorException Value:
ORA-00942: table or view does not exist
Environment:
Request Method: GET
Request URL: http://127.0.0.1:8000/admin/portal/customers/121/delete/
Django Version: 1.6.5
Python Version: 2.7.5
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'portal')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware')
Traceback:
File "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py"
in get_response
112. response = wrapped_callback(request,
*callback_args, **callback_kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
wrapper
432. return self.admin_site.admin_view(view)(*args,
**kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/views/decorators/cache.py"
in _wrapped_view_func
52. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/sites.py"
in inner
198. return view(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapper
29. return bound_func(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
bound_func
25. return func(self, *args2, **kwargs2)
File "/usr/local/lib/python2.7/dist-packages/django/db/transaction.py" in
inner
371. return func(*args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
delete_view
1457. [obj], opts, request.user, self.admin_site, using)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in get_deleted_objects
109. collector.collect(objs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in collect
160. return super(NestedObjects, self).collect(objs,
source_attr=source_attr, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/deletion.py"
in collect
196. elif sub_objs:
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
__nonzero__
100. self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
_fetch_all
857. self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
iterator
220. for row in compiler.results_iter():
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in results_iter
713. for rows in self.execute_sql(MULTI):
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in execute_sql
786. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
69. return super(CursorDebugWrapper, self).execute(sql,
params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py" in __exit__
99. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/oracle/base.py"
in execute
816. return self.cursor.execute(query,
self._param_generator(params))
Exception Type: DatabaseError at /admin/portal/customers/121/delete/
Exception Value: ORA-00942: table or view does not exist
out almost all of the issues except one.
You can now update, and add new records through the admin panel, but after
that you can't delete them.
The Models file was generated by djangos inspect Db. I'm not sure why but I
can't delete.
MODELS.PY
# This is an auto-generated Django model module.
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# * Remove `managed = False` lines if you wish to allow Django to create
and delete the table
# Feel free to rename the models, but don't rename db_table values or
field names.
#
# Also note: You'll have to insert the output of 'django-admin.py
sqlcustom [appname]'
# into your database.
from __future__ import unicode_literals
from django.db import models
from django.core.exceptions import ValidationError
from django.contrib.auth.models import User
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(unique=True, max_length=160, blank=True)
managed = False
db_table = 'auth_group'
id = models.IntegerField(primary_key=True, editable=False)
group = models.ForeignKey(AuthGroup)
permission = models.ForeignKey('AuthPermission')
managed = False
db_table = 'auth_group_permissions'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=100, blank=True)
content_type = models.ForeignKey('DjangoContentType')
codename = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'auth_permission'
id = models.IntegerField(primary_key=True, editable=False)
password = models.CharField(max_length=256, blank=True)
last_login = models.DateTimeField()
is_superuser = models.BooleanField()
username = models.CharField(unique=True, max_length=60, blank=True)
first_name = models.CharField(max_length=60, blank=True)
last_name = models.CharField(max_length=60, blank=True)
email = models.CharField(max_length=150, blank=True)
is_staff = models.BooleanField()
is_active = models.BooleanField()
date_joined = models.DateTimeField()
managed = False
db_table = 'auth_user'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
group = models.ForeignKey(AuthGroup)
managed = False
db_table = 'auth_user_groups'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
permission = models.ForeignKey(AuthPermission)
managed = False
db_table = 'auth_user_user_permissions'
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
sal = models.FloatField(blank=True, null=True)
comm = models.FloatField(blank=True, null=True)
managed = False
db_table = 'bonus'
cidr_allocation_id = models.BigIntegerField(primary_key=True,
editable=False)
cidr = models.CharField(max_length=40)
allocation_name = models.CharField(max_length=30)
allocation_date = models.DateField()
deallocation_date = models.DateField(blank=True, null=True)
allocation_source = models.CharField(max_length=30)
public_address = models.CharField(max_length=1)
managed = False
db_table = 'cidr_allocations'
raise ValidationError('Please enter a Y or N')
return self.allocation_name
customer_id = models.BigIntegerField(primary_key=True, editable=False)
customer_name = models.CharField(max_length=30)
inactive = models.CharField(max_length=1)
managed = False
db_table = 'customers'
return self.customer_name
raise ValidationError('Please enter a Y or N')
datacenter_id = models.BigIntegerField(primary_key=True,
editable=False)
vcenter = models.ForeignKey('Vcenters')
datacenter_mor = models.CharField(max_length=20)
datacenter_name = models.CharField(max_length=30)
managed = False
db_table = 'datacenters'
datastore_id = models.BigIntegerField(primary_key=True, editable=False)
datastore_mor = models.CharField(max_length=20)
storage_tier = models.ForeignKey('StorageTiers')
datastore_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
type = models.CharField(max_length=10)
managed = False
db_table = 'datastores'
deptno = models.IntegerField(blank=True, null=True)
dname = models.CharField(max_length=14, blank=True)
loc = models.CharField(max_length=13, blank=True)
managed = False
db_table = 'dept'
id = models.IntegerField(primary_key=True, editable=False)
action_time = models.DateTimeField()
user = models.ForeignKey(AuthUser)
content_type = models.ForeignKey('DjangoContentType', blank=True,
null=True)
object_id = models.TextField(blank=True)
object_repr = models.CharField(max_length=400, blank=True)
action_flag = models.IntegerField()
change_message = models.TextField(blank=True)
managed = False
db_table = 'django_admin_log'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=200, blank=True)
app_label = models.CharField(max_length=200, blank=True)
model = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'django_content_type'
session_key = models.CharField(primary_key=True, max_length=80)
session_data = models.TextField(blank=True)
expire_date = models.DateTimeField()
managed = False
db_table = 'django_session'
empno = models.IntegerField()
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
mgr = models.IntegerField(blank=True, null=True)
hiredate = models.DateField(blank=True, null=True)
sal = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
comm = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
deptno = models.IntegerField(blank=True, null=True)
managed = False
db_table = 'emp'
esxi_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license_type = models.CharField(max_length=40)
managed = False
db_table = 'esxi_licenses'
guest_os_id = models.FloatField(primary_key=True, editable=False)
guest_os = models.CharField(unique=True, max_length=60)
managed = False
db_table = 'guest_os'
host_id = models.BigIntegerField(primary_key=True, editable=False)
host_mor = models.CharField(unique=True, max_length=20)
esxi_license = models.ForeignKey(EsxiLicenses)
datacenter = models.ForeignKey(Datacenters)
host_ip_address = models.TextField(unique=True) # This field type is a
guess.
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)
managed = False
db_table = 'hosts'
vcenter_uuid = models.CharField(max_length=50)
vm_mor = models.CharField(max_length=20)
datastore_mor = models.CharField(max_length=20)
datetime = models.DateTimeField()
riops = models.FloatField()
wiops = models.FloatField()
managed = False
db_table = 'iops'
datetime = models.DateTimeField()
bytes_sent = models.BigIntegerField()
bytes_received = models.BigIntegerField()
ip_address = models.ForeignKey('IpAddresses')
load_sequence = models.BigIntegerField()
managed = False
db_table = 'ip_address_usage_histories'
ip_address_id = models.BigIntegerField(primary_key=True,
editable=False)
ip_address = models.TextField(unique=True, blank=True) # This field
type is a guess.
cidr_allocation = models.ForeignKey(CidrAllocations)
managed = False
db_table = 'ip_addresses'
id = models.IntegerField(primary_key=True, editable=False)
license = models.ForeignKey('Licenses')
vm_license = models.ForeignKey('VmLicenses')
managed = False
db_table = 'license_assignments'
license_authority_id = models.FloatField(primary_key=True,
editable=False)
licensing_authority = models.CharField(max_length=30)
managed = False
db_table = 'license_authorities'
return self.licensing_authority
license_id = models.FloatField(primary_key=True, editable=False)
license_authority_id = models.FloatField()
product = models.CharField(max_length=30)
managed = False
db_table = 'licenses'
return self.product
managed_entity_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=80)
managed_entity_mor = models.CharField(max_length=20)
vcenter = models.ForeignKey('Vcenters')
parent_mor = models.CharField(max_length=20, blank=True)
vm = models.ForeignKey('Vms', blank=True, null=True)
type = models.CharField(max_length=30)
managed = False
db_table = 'managed_entities'
nas_device_id = models.BigIntegerField(primary_key=True,
editable=False)
device_name = models.CharField(max_length=20)
ip_address = models.TextField() # This field type is a guess.
storage_tier = models.ForeignKey('StorageTiers')
managed = False
db_table = 'nas_devices'
return self.device_name
vm_nas_usage_history_id = models.BigIntegerField()
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device_id = models.BigIntegerField()
customer_id = models.BigIntegerField()
managed = False
db_table = 'nas_usage'
datetime = models.DateTimeField()
ip_address = models.CharField(max_length=39)
sbytes = models.FloatField()
rbytes = models.FloatField()
managed = False
db_table = 'netflows'
network_device = models.ForeignKey('NetworkDevices')
ip_address = models.ForeignKey(IpAddresses, unique=True)
managed = False
db_table = 'network_device_ip_addresses'
network_device = models.ForeignKey('NetworkDevices')
mac_address = models.CharField(max_length=17)
datacenter = models.ForeignKey(Datacenters)
managed = False
db_table = 'network_device_mac_addresses'
return self.mac_address
network_device_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=20)
management_ip_address = models.BinaryField() # This field type is a
guess.
snmp_version = models.BooleanField()
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, blank=True)
snmp_auth_protocol = models.CharField(max_length=3, blank=True)
snmp_priv_protocol = models.CharField(max_length=3, blank=True)
managed = False
db_table = 'network_devices'
return self.name
snmp_security = set(['AuthPriv', 'NoAuthNoPriv', 'AuthNoPriv'])
auth_protocols = set(['MD5', 'SHA'])
priv_protocols = set(['AES', 'DES'])
raise ValidationError('Please enter a 1, 2 or 3')
raise ValidationError('Please enter AuthPriv, NoAuthNoPriv or
AuthNoPriv')
raise ValidationError('Please enter MD5 or SHA')
raise ValidationError('Please enter AES or DES')
id = models.IntegerField(primary_key=True, editable=False)
poll = models.ForeignKey('PollsPoll')
choice_text = models.CharField(max_length=400, blank=True)
votes = models.IntegerField()
managed = False
db_table = 'polls_choice'
id = models.IntegerField(primary_key=True, editable=False)
question = models.CharField(max_length=400, blank=True)
pub_date = models.DateTimeField()
managed = False
db_table = 'polls_poll'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser, unique=True)
website = models.CharField(max_length=400, blank=True)
picture = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'portal_userprofile'
id = models.IntegerField(primary_key=True, editable=False)
vm_license = models.ForeignKey('VmLicenses')
license = models.ForeignKey(Licenses)
managed = False
db_table = 'portal_vm_assignments'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'report_compute'
resource_pool_id = models.BigIntegerField(primary_key=True,
editable=False)
resource_pool_mor = models.CharField(unique=True, max_length=20)
resource_pool_name = models.CharField(max_length=30)
cpu_ghz_reservation = models.DecimalField(max_digits=8,
decimal_places=5, blank=True, null=True)
cpu_ghz_limit = models.DecimalField(max_digits=8, decimal_places=5,
blank=True, null=True)
cpu_reservation_expandable = models.CharField(max_length=1)
ram_gb_reservation = models.DecimalField(max_digits=9,
decimal_places=5, blank=True, null=True)
ram_gb_limit = models.DecimalField(max_digits=9, decimal_places=5,
blank=True, null=True)
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.BigIntegerField()
managed = False
db_table = 'resource_pools'
grade = models.FloatField(blank=True, null=True)
losal = models.FloatField(blank=True, null=True)
hisal = models.FloatField(blank=True, null=True)
managed = False
db_table = 'salgrade'
storage_tier_id = models.BigIntegerField(primary_key=True,
editable=False)
tier_name = models.CharField(max_length=20)
reserved_iops = models.BigIntegerField()
price_per_gb = models.DecimalField(max_digits=7, decimal_places=4,
blank=True, null=True)
managed = False
db_table = 'storage_tiers'
return self.tier_name
ip_address = models.CharField(max_length=17, blank=True)
gigabytes_sent = models.FloatField(blank=True, null=True)
gigabytes_received = models.FloatField(blank=True, null=True)
managed = False
db_table = 'unallocated_ips'
vcenter_id = models.BigIntegerField(primary_key=True, editable=False)
vcenter_ip_address = models.TextField() # This field type is a guess.
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)
managed = False
db_table = 'vcenters'
return self.name
vm_backup_storage_id = models.BigIntegerField(primary_key=True,
editable=False)
customer = models.ForeignKey(Customers)
datetime = models.DateField()
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_backup_storage'
vm_compute_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
power_state = models.BooleanField()
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()
host = models.ForeignKey(Hosts)
esxi_license = models.ForeignKey(EsxiLicenses)
resource_pool = models.ForeignKey(ResourcePools, blank=True, null=True)
fault_tolerance = models.CharField(max_length=1)
guest_os = models.ForeignKey(GuestOs)
managed = False
db_table = 'vm_compute_histories'
vm = models.ForeignKey('Vms')
datetime = models.DateField()
cpu_ghz_hours = models.DecimalField(max_digits=13, decimal_places=5)
ram_gb_hours = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_compute_usage_histories'
vm_group_id = models.BigIntegerField(primary_key=True, editable=False)
customer = models.ForeignKey(Customers)
vm_group_name = models.CharField(max_length=30)
managed = False
db_table = 'vm_groups'
return self.vm_group_name
vm_ip_address_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
ip_address = models.ForeignKey(IpAddresses)
allocation_date = models.DateTimeField()
deallocation_date = models.DateTimeField(blank=True, null=True)
managed = False
db_table = 'vm_ip_address_histories'
vm_license_history_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
vm = models.ForeignKey('Vms')
assignment_date = models.DateField()
deassignment_date = models.DateField(blank=True, null=True)
managed = False
db_table = 'vm_license_histories'
vm_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
#license = models.ManyToManyField(Licenses)
vm = models.ForeignKey('Vms')
managed = False
db_table = 'vm_licenses'
vm_mac_address_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
mac_address = models.CharField(max_length=20)
datetime = models.DateTimeField()
datacenter_id = models.BigIntegerField()
managed = False
db_table = 'vm_mac_addresses'
vm_nas_usage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device = models.ForeignKey(NasDevices)
customer = models.ForeignKey(Customers)
managed = False
db_table = 'vm_nas_usage_histories'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'vm_paths'
vm_storage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
datastore = models.ForeignKey(Datastores)
datetime = models.DateTimeField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_storage_histories'
vm_storage_perf_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datastore_id = models.BigIntegerField()
vm_id = models.BigIntegerField()
datetime = models.DateField()
average_reads_per_sec = models.FloatField()
average_writes_per_sec = models.FloatField()
max_read_requests = models.FloatField()
max_write_requests = models.FloatField()
sum_read_requests = models.FloatField()
sum_write_requests = models.FloatField()
managed = False
db_table = 'vm_storage_perf_histories'
vm_id = models.BigIntegerField(primary_key=True, editable=False)
vm_mor = models.CharField(max_length=20)
vm_name = models.CharField(max_length=4000)
vm_group = models.ForeignKey(VmGroups)
vm_display_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
vcd_managed = models.CharField(max_length=1)
managed = False
db_table = 'vms'
return self.vm_name
user = models.OneToOneField(User)
website = models.URLField(blank=True)
picture = models.ImageField(upload_to='profile_images', blank=True)
return self.user.username
* Whenever I try to delete and entry i made it gives me the following# * Make sure each model has one field with primary_key=True
# * Remove `managed = False` lines if you wish to allow Django to create
and delete the table
# Feel free to rename the models, but don't rename db_table values or
field names.
#
# Also note: You'll have to insert the output of 'django-admin.py
sqlcustom [appname]'
# into your database.
from __future__ import unicode_literals
from django.db import models
from django.core.exceptions import ValidationError
from django.contrib.auth.models import User
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(unique=True, max_length=160, blank=True)
managed = False
db_table = 'auth_group'
id = models.IntegerField(primary_key=True, editable=False)
group = models.ForeignKey(AuthGroup)
permission = models.ForeignKey('AuthPermission')
managed = False
db_table = 'auth_group_permissions'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=100, blank=True)
content_type = models.ForeignKey('DjangoContentType')
codename = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'auth_permission'
id = models.IntegerField(primary_key=True, editable=False)
password = models.CharField(max_length=256, blank=True)
last_login = models.DateTimeField()
is_superuser = models.BooleanField()
username = models.CharField(unique=True, max_length=60, blank=True)
first_name = models.CharField(max_length=60, blank=True)
last_name = models.CharField(max_length=60, blank=True)
email = models.CharField(max_length=150, blank=True)
is_staff = models.BooleanField()
is_active = models.BooleanField()
date_joined = models.DateTimeField()
managed = False
db_table = 'auth_user'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
group = models.ForeignKey(AuthGroup)
managed = False
db_table = 'auth_user_groups'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser)
permission = models.ForeignKey(AuthPermission)
managed = False
db_table = 'auth_user_user_permissions'
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
sal = models.FloatField(blank=True, null=True)
comm = models.FloatField(blank=True, null=True)
managed = False
db_table = 'bonus'
cidr_allocation_id = models.BigIntegerField(primary_key=True,
editable=False)
cidr = models.CharField(max_length=40)
allocation_name = models.CharField(max_length=30)
allocation_date = models.DateField()
deallocation_date = models.DateField(blank=True, null=True)
allocation_source = models.CharField(max_length=30)
public_address = models.CharField(max_length=1)
managed = False
db_table = 'cidr_allocations'
raise ValidationError('Please enter a Y or N')
return self.allocation_name
customer_id = models.BigIntegerField(primary_key=True, editable=False)
customer_name = models.CharField(max_length=30)
inactive = models.CharField(max_length=1)
managed = False
db_table = 'customers'
return self.customer_name
raise ValidationError('Please enter a Y or N')
datacenter_id = models.BigIntegerField(primary_key=True,
editable=False)
vcenter = models.ForeignKey('Vcenters')
datacenter_mor = models.CharField(max_length=20)
datacenter_name = models.CharField(max_length=30)
managed = False
db_table = 'datacenters'
datastore_id = models.BigIntegerField(primary_key=True, editable=False)
datastore_mor = models.CharField(max_length=20)
storage_tier = models.ForeignKey('StorageTiers')
datastore_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
type = models.CharField(max_length=10)
managed = False
db_table = 'datastores'
deptno = models.IntegerField(blank=True, null=True)
dname = models.CharField(max_length=14, blank=True)
loc = models.CharField(max_length=13, blank=True)
managed = False
db_table = 'dept'
id = models.IntegerField(primary_key=True, editable=False)
action_time = models.DateTimeField()
user = models.ForeignKey(AuthUser)
content_type = models.ForeignKey('DjangoContentType', blank=True,
null=True)
object_id = models.TextField(blank=True)
object_repr = models.CharField(max_length=400, blank=True)
action_flag = models.IntegerField()
change_message = models.TextField(blank=True)
managed = False
db_table = 'django_admin_log'
id = models.IntegerField(primary_key=True, editable=False)
name = models.CharField(max_length=200, blank=True)
app_label = models.CharField(max_length=200, blank=True)
model = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'django_content_type'
session_key = models.CharField(primary_key=True, max_length=80)
session_data = models.TextField(blank=True)
expire_date = models.DateTimeField()
managed = False
db_table = 'django_session'
empno = models.IntegerField()
ename = models.CharField(max_length=10, blank=True)
job = models.CharField(max_length=9, blank=True)
mgr = models.IntegerField(blank=True, null=True)
hiredate = models.DateField(blank=True, null=True)
sal = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
comm = models.DecimalField(max_digits=7, decimal_places=2, blank=True,
null=True)
deptno = models.IntegerField(blank=True, null=True)
managed = False
db_table = 'emp'
esxi_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license_type = models.CharField(max_length=40)
managed = False
db_table = 'esxi_licenses'
guest_os_id = models.FloatField(primary_key=True, editable=False)
guest_os = models.CharField(unique=True, max_length=60)
managed = False
db_table = 'guest_os'
host_id = models.BigIntegerField(primary_key=True, editable=False)
host_mor = models.CharField(unique=True, max_length=20)
esxi_license = models.ForeignKey(EsxiLicenses)
datacenter = models.ForeignKey(Datacenters)
host_ip_address = models.TextField(unique=True) # This field type is a
guess.
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)
managed = False
db_table = 'hosts'
vcenter_uuid = models.CharField(max_length=50)
vm_mor = models.CharField(max_length=20)
datastore_mor = models.CharField(max_length=20)
datetime = models.DateTimeField()
riops = models.FloatField()
wiops = models.FloatField()
managed = False
db_table = 'iops'
datetime = models.DateTimeField()
bytes_sent = models.BigIntegerField()
bytes_received = models.BigIntegerField()
ip_address = models.ForeignKey('IpAddresses')
load_sequence = models.BigIntegerField()
managed = False
db_table = 'ip_address_usage_histories'
ip_address_id = models.BigIntegerField(primary_key=True,
editable=False)
ip_address = models.TextField(unique=True, blank=True) # This field
type is a guess.
cidr_allocation = models.ForeignKey(CidrAllocations)
managed = False
db_table = 'ip_addresses'
id = models.IntegerField(primary_key=True, editable=False)
license = models.ForeignKey('Licenses')
vm_license = models.ForeignKey('VmLicenses')
managed = False
db_table = 'license_assignments'
license_authority_id = models.FloatField(primary_key=True,
editable=False)
licensing_authority = models.CharField(max_length=30)
managed = False
db_table = 'license_authorities'
return self.licensing_authority
license_id = models.FloatField(primary_key=True, editable=False)
license_authority_id = models.FloatField()
product = models.CharField(max_length=30)
managed = False
db_table = 'licenses'
return self.product
managed_entity_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=80)
managed_entity_mor = models.CharField(max_length=20)
vcenter = models.ForeignKey('Vcenters')
parent_mor = models.CharField(max_length=20, blank=True)
vm = models.ForeignKey('Vms', blank=True, null=True)
type = models.CharField(max_length=30)
managed = False
db_table = 'managed_entities'
nas_device_id = models.BigIntegerField(primary_key=True,
editable=False)
device_name = models.CharField(max_length=20)
ip_address = models.TextField() # This field type is a guess.
storage_tier = models.ForeignKey('StorageTiers')
managed = False
db_table = 'nas_devices'
return self.device_name
vm_nas_usage_history_id = models.BigIntegerField()
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device_id = models.BigIntegerField()
customer_id = models.BigIntegerField()
managed = False
db_table = 'nas_usage'
datetime = models.DateTimeField()
ip_address = models.CharField(max_length=39)
sbytes = models.FloatField()
rbytes = models.FloatField()
managed = False
db_table = 'netflows'
network_device = models.ForeignKey('NetworkDevices')
ip_address = models.ForeignKey(IpAddresses, unique=True)
managed = False
db_table = 'network_device_ip_addresses'
network_device = models.ForeignKey('NetworkDevices')
mac_address = models.CharField(max_length=17)
datacenter = models.ForeignKey(Datacenters)
managed = False
db_table = 'network_device_mac_addresses'
return self.mac_address
network_device_id = models.BigIntegerField(primary_key=True,
editable=False)
name = models.CharField(max_length=20)
management_ip_address = models.BinaryField() # This field type is a
guess.
snmp_version = models.BooleanField()
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, blank=True)
snmp_auth_protocol = models.CharField(max_length=3, blank=True)
snmp_priv_protocol = models.CharField(max_length=3, blank=True)
managed = False
db_table = 'network_devices'
return self.name
snmp_security = set(['AuthPriv', 'NoAuthNoPriv', 'AuthNoPriv'])
auth_protocols = set(['MD5', 'SHA'])
priv_protocols = set(['AES', 'DES'])
raise ValidationError('Please enter a 1, 2 or 3')
raise ValidationError('Please enter AuthPriv, NoAuthNoPriv or
AuthNoPriv')
raise ValidationError('Please enter MD5 or SHA')
raise ValidationError('Please enter AES or DES')
id = models.IntegerField(primary_key=True, editable=False)
poll = models.ForeignKey('PollsPoll')
choice_text = models.CharField(max_length=400, blank=True)
votes = models.IntegerField()
managed = False
db_table = 'polls_choice'
id = models.IntegerField(primary_key=True, editable=False)
question = models.CharField(max_length=400, blank=True)
pub_date = models.DateTimeField()
managed = False
db_table = 'polls_poll'
id = models.IntegerField(primary_key=True, editable=False)
user = models.ForeignKey(AuthUser, unique=True)
website = models.CharField(max_length=400, blank=True)
picture = models.CharField(max_length=200, blank=True)
managed = False
db_table = 'portal_userprofile'
id = models.IntegerField(primary_key=True, editable=False)
vm_license = models.ForeignKey('VmLicenses')
license = models.ForeignKey(Licenses)
managed = False
db_table = 'portal_vm_assignments'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'report_compute'
resource_pool_id = models.BigIntegerField(primary_key=True,
editable=False)
resource_pool_mor = models.CharField(unique=True, max_length=20)
resource_pool_name = models.CharField(max_length=30)
cpu_ghz_reservation = models.DecimalField(max_digits=8,
decimal_places=5, blank=True, null=True)
cpu_ghz_limit = models.DecimalField(max_digits=8, decimal_places=5,
blank=True, null=True)
cpu_reservation_expandable = models.CharField(max_length=1)
ram_gb_reservation = models.DecimalField(max_digits=9,
decimal_places=5, blank=True, null=True)
ram_gb_limit = models.DecimalField(max_digits=9, decimal_places=5,
blank=True, null=True)
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.BigIntegerField()
managed = False
db_table = 'resource_pools'
grade = models.FloatField(blank=True, null=True)
losal = models.FloatField(blank=True, null=True)
hisal = models.FloatField(blank=True, null=True)
managed = False
db_table = 'salgrade'
storage_tier_id = models.BigIntegerField(primary_key=True,
editable=False)
tier_name = models.CharField(max_length=20)
reserved_iops = models.BigIntegerField()
price_per_gb = models.DecimalField(max_digits=7, decimal_places=4,
blank=True, null=True)
managed = False
db_table = 'storage_tiers'
return self.tier_name
ip_address = models.CharField(max_length=17, blank=True)
gigabytes_sent = models.FloatField(blank=True, null=True)
gigabytes_received = models.FloatField(blank=True, null=True)
managed = False
db_table = 'unallocated_ips'
vcenter_id = models.BigIntegerField(primary_key=True, editable=False)
vcenter_ip_address = models.TextField() # This field type is a guess.
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)
managed = False
db_table = 'vcenters'
return self.name
vm_backup_storage_id = models.BigIntegerField(primary_key=True,
editable=False)
customer = models.ForeignKey(Customers)
datetime = models.DateField()
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_backup_storage'
vm_compute_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
power_state = models.BooleanField()
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()
host = models.ForeignKey(Hosts)
esxi_license = models.ForeignKey(EsxiLicenses)
resource_pool = models.ForeignKey(ResourcePools, blank=True, null=True)
fault_tolerance = models.CharField(max_length=1)
guest_os = models.ForeignKey(GuestOs)
managed = False
db_table = 'vm_compute_histories'
vm = models.ForeignKey('Vms')
datetime = models.DateField()
cpu_ghz_hours = models.DecimalField(max_digits=13, decimal_places=5)
ram_gb_hours = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_compute_usage_histories'
vm_group_id = models.BigIntegerField(primary_key=True, editable=False)
customer = models.ForeignKey(Customers)
vm_group_name = models.CharField(max_length=30)
managed = False
db_table = 'vm_groups'
return self.vm_group_name
vm_ip_address_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
ip_address = models.ForeignKey(IpAddresses)
allocation_date = models.DateTimeField()
deallocation_date = models.DateTimeField(blank=True, null=True)
managed = False
db_table = 'vm_ip_address_histories'
vm_license_history_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
vm = models.ForeignKey('Vms')
assignment_date = models.DateField()
deassignment_date = models.DateField(blank=True, null=True)
managed = False
db_table = 'vm_license_histories'
vm_license_id = models.BigIntegerField(primary_key=True,
editable=False)
license = models.ForeignKey(Licenses)
#license = models.ManyToManyField(Licenses)
vm = models.ForeignKey('Vms')
managed = False
db_table = 'vm_licenses'
vm_mac_address_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
mac_address = models.CharField(max_length=20)
datetime = models.DateTimeField()
datacenter_id = models.BigIntegerField()
managed = False
db_table = 'vm_mac_addresses'
vm_nas_usage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datetime = models.DateField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
nas_device = models.ForeignKey(NasDevices)
customer = models.ForeignKey(Customers)
managed = False
db_table = 'vm_nas_usage_histories'
vm_id = models.FloatField(blank=True, null=True)
vm_path = models.CharField(max_length=3972, blank=True)
managed = False
db_table = 'vm_paths'
vm_storage_history_id = models.BigIntegerField(primary_key=True,
editable=False)
vm = models.ForeignKey('Vms')
datastore = models.ForeignKey(Datastores)
datetime = models.DateTimeField()
provisioned_gb = models.DecimalField(max_digits=13, decimal_places=5)
consumed_gb = models.DecimalField(max_digits=13, decimal_places=5)
managed = False
db_table = 'vm_storage_histories'
vm_storage_perf_history_id = models.BigIntegerField(primary_key=True,
editable=False)
datastore_id = models.BigIntegerField()
vm_id = models.BigIntegerField()
datetime = models.DateField()
average_reads_per_sec = models.FloatField()
average_writes_per_sec = models.FloatField()
max_read_requests = models.FloatField()
max_write_requests = models.FloatField()
sum_read_requests = models.FloatField()
sum_write_requests = models.FloatField()
managed = False
db_table = 'vm_storage_perf_histories'
vm_id = models.BigIntegerField(primary_key=True, editable=False)
vm_mor = models.CharField(max_length=20)
vm_name = models.CharField(max_length=4000)
vm_group = models.ForeignKey(VmGroups)
vm_display_name = models.CharField(max_length=30)
datacenter = models.ForeignKey(Datacenters)
vcd_managed = models.CharField(max_length=1)
managed = False
db_table = 'vms'
return self.vm_name
user = models.OneToOneField(User)
website = models.URLField(blank=True)
picture = models.ImageField(upload_to='profile_images', blank=True)
return self.user.username
error:*
Exception Type:DatabaseErrorException Value:
ORA-00942: table or view does not exist
Environment:
Request Method: GET
Request URL: http://127.0.0.1:8000/admin/portal/customers/121/delete/
Django Version: 1.6.5
Python Version: 2.7.5
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'portal')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware')
Traceback:
File "/usr/local/lib/python2.7/dist-packages/django/core/handlers/base.py"
in get_response
112. response = wrapped_callback(request,
*callback_args, **callback_kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
wrapper
432. return self.admin_site.admin_view(view)(*args,
**kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/views/decorators/cache.py"
in _wrapped_view_func
52. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/sites.py"
in inner
198. return view(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapper
29. return bound_func(*args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
_wrapped_view
99. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/utils/decorators.py" in
bound_func
25. return func(self, *args2, **kwargs2)
File "/usr/local/lib/python2.7/dist-packages/django/db/transaction.py" in
inner
371. return func(*args, **kwargs)
File
"/usr/local/lib/python2.7/dist-packages/django/contrib/admin/options.py" in
delete_view
1457. [obj], opts, request.user, self.admin_site, using)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in get_deleted_objects
109. collector.collect(objs)
File "/usr/local/lib/python2.7/dist-packages/django/contrib/admin/util.py"
in collect
160. return super(NestedObjects, self).collect(objs,
source_attr=source_attr, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/django/db/models/deletion.py"
in collect
196. elif sub_objs:
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
__nonzero__
100. self._fetch_all()
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
_fetch_all
857. self._result_cache = list(self.iterator())
File "/usr/local/lib/python2.7/dist-packages/django/db/models/query.py" in
iterator
220. for row in compiler.results_iter():
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in results_iter
713. for rows in self.execute_sql(MULTI):
File
"/usr/local/lib/python2.7/dist-packages/django/db/models/sql/compiler.py"
in execute_sql
786. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
69. return super(CursorDebugWrapper, self).execute(sql,
params)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File "/usr/local/lib/python2.7/dist-packages/django/db/utils.py" in __exit__
99. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/usr/local/lib/python2.7/dist-packages/django/db/backends/util.py" in
execute
53. return self.cursor.execute(sql, params)
File
"/usr/local/lib/python2.7/dist-packages/django/db/backends/oracle/base.py"
in execute
816. return self.cursor.execute(query,
self._param_generator(params))
Exception Type: DatabaseError at /admin/portal/customers/121/delete/
Exception Value: ORA-00942: table or view does not exist
--
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/49598d10-ce53-43a3-bae3-e09d383f4cce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
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/49598d10-ce53-43a3-bae3-e09d383f4cce%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.