[MonetDB-users] Django Backend: SQL column types

4 May 2008

      Hi guys,

I am jumping straight into the deep end with Monet.
My first task is to implement a backend for Django written in Django.

I need to map the field types to SQL column types, and that is for the
most part easy, yet a few questions:

1) Is 'integer' accepted, or do I have to use 'int'
2) How do I specify a floating point with specified max_digits and
decimal_places? I didn't see support for numeric in the docs.
3) How do I specify unsigned integers? unsigned or check expression?
Is there a text field, or should I use varchar/clob ?

These are my definitions as they stand so far:

DATA_TYPES = {
    'AutoField':                    'serial',
    'BooleanField':                 'boolean',
    'CharField':                    'varchar(%(maxlength)s)',
    'CommaSeparatedIntegerField':   'varchar(%(maxlength)s)',
    'DateField':                    'date',
    'DateTimeField':                'timestamp',
    'FileField':                    'varchar(100)',
    'FilePathField':                'varchar(100)',
    'FloatField':                   'numeric(%(max_digits)s,
%(decimal_places)s)',
    'ImageField':                   'varchar(100)',
    'IntegerField':                 'int',
    'IPAddressField':               'char(15)',
    'ManyToManyField':              None,
    'NullBooleanField':             'bool',
    'OneToOneField':                'int',
    'PhoneNumberField':             'varchar(20)',
    'PositiveIntegerField':         'integer unsigned', # TODO how
should this be handled???
    'PositiveSmallIntegerField':    'smallint unsigned', # TODO how
should this be handled???
    'SlugField':                    'varchar(%(maxlength)s)',
    'SmallIntegerField':            'smallint',
    'TextField':                    'text',
    'TimeField':                    'time',
    'USStateField':                 'varchar(2)',
}

Thanks,

Henrik

[MonetDB-users] Django Backend: SQL column types

Henrik Vendelbo