Vic,
On 26/10/06, Victor Ng <[EMAIL PROTECTED]> wrote:
>
> Any luck with schema evolution lately?
>
I haven't done anything further with it since my last email in this
thread. Nor have I had any response from the developer regarding the
issue I previously highlighted.
Other django users would be more likely to test this branch out if it
were up to date with the latest trunk.
regards
matthew
> I'm starting to look at seeing if i can merge this back to trunk as
> well, but wanted to know if you've made any progress.
>
> I'm using the postgresql_psycopg2 backend.
>
> vic
>
> On 9/14/06, Matthew Flanagan <[EMAIL PROTECTED]> wrote:
> >
> > postgresql
> >
> > On 14/09/06, Derek Anderson <[EMAIL PROTECTED]> wrote:
> > >
> > > which backend are you using?
> > >
> > > Matthew Flanagan wrote:
> > > > 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
> > > >
> > > > >
> > > >
> > >
> > >
> > > >
> > >
> >
> > >
> >
>
>
> --
> "Never attribute to malice that which can be adequately explained by
> stupidity." - Hanlon's Razor
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
