Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there any way to use GUIDs in django?

I have a couple of tables that are joined by GUIDs in SQL Server. Now, I've found a few custom fields to add support for GUIDs in django, but I tend to shy away from using code in blog posts if at all possible. I'm not going to do anything with the GUID other than join on it and maybe assign a GUID on new entries (although this is optional). Is there any way to allow this using django's built-in types? Like can I use some kind of char field or binary field and "trick" django into joining using it?

If it's any help, I'm using django-pyodbc.

like image 872
Jason Baker Avatar asked May 21 '09 19:05

Jason Baker


3 Answers

I'd create a basic GUID Model in order to reuse it's properties for any other models in my projects. Model inheritance is working nicely since several versions prior to Django 1.0 and is quite stable with Django 1.0.

Create something like project/common/models.py and place there this class:

import hashlib
import random
from django.db import models

class GUIDModel(models.Model):

    guid = models.CharField(primary_key=True, max_length=40)

    def save(self, *args, **kwargs):

      if not self.guid:
        self.guid = hashlib.sha1(str(random.random())).hexdigest()

      super(GUIDModel, self).save(*args, **kwargs)

Then create your other models as usual:

from common.models import GUIDModel

class Customer(GUIDModel):
  name = models.CharField(max_length=64)

class Product(GUIDModel):
  name = models.CharField(max_length=64)

class Sale(GUIDModel):
  customer = models.ForeignKey(Customer)
  product = models.ForeignKey(Product)
  items = models.PositiveIntegerField()

And everything should work nicely with GUIDs as primary keys instead of autoincremental integers.

like image 139
gnrfan Avatar answered Oct 01 '22 09:10

gnrfan


Take a look at Django-extensions UUID Field

like image 40
Jj. Avatar answered Oct 01 '22 11:10

Jj.


Old question, but for anybody using Django 1.8+ the built in UUIDField could come in handy.

like image 28
akotian Avatar answered Oct 01 '22 10:10

akotian