Derek,
I have manually merged the trunk into my local working copy of the
schema-evolution branch and started playing with it. I wanted to
question the SQL "sqlevolve" is outputting. I have this model in an
application called "asset":
class Interface(models.Model):
name = models.CharField(maxlength=64, core=True, db_index=True,
help_text='The name of the interface as given by the asset.')
interfacetype = models.ForeignKey(InterfaceType)
ipaddress = models.ForeignKey(IPAddress, verbose_name='IP Address',
raw_id_admin=True)
# allow for EUI-48 and EUI-64 addresses
mac_address = models.CharField(maxlength=24, blank=True,
help_text='The EUI-48 or EUI-64 physical address of the interface.')
domain = models.CharField(maxlength=255, blank=True,
help_text='The DNS domain this host resides in.')
asset = models.ForeignKey(Asset, edit_inline=models.TABULAR,
num_in_admin=10, num_extra_on_change=5)
objects = InterfaceManager()
def _get_meta(self):
return self._meta
meta = property(_get_meta)
def __str__(self):
return "%s:%s" % (self.asset, self.name)
def get_absolute_url(self):
return self.asset.get_absolute_url()
class Meta:
ordering = ['name']
unique_together = (('asset', 'name'),)
class Admin:
pass
and the schema from "./manage.py sql asset":
CREATE TABLE "asset_interface" (
"id" serial NOT NULL PRIMARY KEY,
"name" varchar(64) NOT NULL,
"interfacetype_id" integer NOT NULL,
"ipaddress_id" integer NOT NULL REFERENCES "ip_ipaddress" ("id"),
"mac_address" varchar(24) NOT NULL,
"domain" varchar(255) NOT NULL,
"asset_id" integer NOT NULL REFERENCES "asset_asset" ("id"),
UNIQUE ("asset_id", "name")
);
when I run "./manage.py sqlevolve asset" with absolutely no changes to
my models it outputs:
BEGIN;
ALTER TABLE "asset_interface" ADD COLUMN "name_tmp" varchar(64);
UPDATE "asset_interface" SET "name_tmp" = "name";
ALTER TABLE "asset_interface" DROP COLUMN "name";
ALTER TABLE "asset_interface" RENAME COLUMN "name_tmp" TO "name";
ALTER TABLE "asset_interface" ALTER COLUMN "name" SET NOT NULL;
COMMIT;
Any ideas why it is doing this?
regards
matthew
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-developers
-~----------~----~----~----~------~----~------~--~---
