i only ever made two commits into django's repo:
changeset 3646 - the meat and potatoes
changeset 3647 - test code
can someone who knows svn better than i help me out as to how i would
refresh the branch with the latest from the trunk, and then remerge
these changes back into it?
thanks,
derek
Victor Ng wrote:
> Any luck with schema evolution lately?
>
> 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
>>>>
>>>
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
