- Author:
- Lacour
- Posted:
- August 15, 2011
- Language:
- Python
- Version:
- 1.3
- Tags:
- model db 8-bit-integer MySQL IntegerField tiny-integer
- Score:
- 0 (after 0 ratings)
Django lacks support of MySQL's "tinyint" 8-bit-integer datatype. This snippet gives you a TinyIntegerField and a PositiveTinyIntegerField. Falls back Django's SmallIntegerField if a different database-engine is used
1 2 3 4 5 6 7 8 9 10 11 12 13 | class TinyIntegerField(models.SmallIntegerField):
def db_type(self, connection):
if connection.settings_dict['ENGINE'] == 'django.db.backends.mysql':
return "tinyint"
else:
return super(TinyIntegerField, self).db_type(connection)
class PositiveTinyIntegerField(models.PositiveSmallIntegerField):
def db_type(self, connection):
if connection.settings_dict['ENGINE'] == 'django.db.backends.mysql':
return "tinyint unsigned"
else:
return super(PositiveTinyIntegerField, self).db_type(connection)
|
Comments
Please login first before commenting.