自定义Django二进制字段& SQL Server 2008 [英] Custom Django binary field & SQL Server 2008

问题描述

我有一个表：

CREATE TABLE [organization_division] (
[id] int IDENTITY (1, 1) NOT NULL PRIMARY KEY,
[uuid] binary(16) NOT NULL
)

我可以使用SQL查询插入一条记录：

I can insert a record with SQL query:

INSERT INTO [organization_division] ([uuid]) VALUES (0x244c71c6c9444f38b67ab1dcfbb5fc32)

该表的Django模型是：

The Django model for this table is:

from apps.lib.fields import GUIDField

class Division(models.Model):
    uuid = GUIDField() 

GUIDField是我尝试创建自定义字段的：

GUIDField is my attempt to create a custom field:

class GUIDField(models.Field):    
    description = "GUID binary field"
    __metaclass__ = models.SubfieldBase

    def __init__(self, *args, **kwargs):
        kwargs['max_length'] = 16
        super(GUIDField, self).__init__(*args, **kwargs)

    def db_type(self, connection):
        return 'binary(16)'

我需要传递16位二进制从ORM实例到数据库的数据。最有可能我得到一个无条件的字符串，紧跟着SQL Server端的 0x ...但是如何？

I need to pass 16 byte binary data from ORM instance to the database. Most likely I have to get an unquoted string followed by 0x on the SQL Server side... But how?

m使用unixodbc，pyodbc，django-odbc。

I'm using unixodbc, pyodbc, django-odbc.

推荐答案

from django.db import models
import pyodbc

class GUIDField(models.Field):    
    description = "GUID binary field"
    __metaclass__ = models.SubfieldBase

    def __init__(self, *args, **kwargs):
        kwargs['max_length'] = 16
        super(GUIDField, self).__init__(*args, **kwargs)

    def db_type(self, connection):
        return 'binary(16)'

    def get_db_prep_value(self, value):
        if value is None:
            return None
        return pyodbc.BINARY(value)

这篇关于自定义Django二进制字段& SQL Server 2008的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！