Peewee: UnsignedIntegerField?

[nilp0inter]

Hi,

I'm trying to create a model with an unsigned integer field but I can't find how to do it with peewee.

Is this possible?

[coleifer]

http://docs.peewee-orm.com/en/latest/peewee/models.html#creating-a-custom-field

[sooslaca]

if you got here through google - like me - here is a quick solution which worked for my use case
uid = SmallIntegerField(null=True, constraints=[SQL("UNSIGNED")])

[coleifer]

:+1: thanks for sharing @sooslaca

[binderclip]

got this one worked:

class UnsignedIntegerField(IntegerField):
    field_type = 'int unsigned'

(peewee 3.3.4)

[kent-cheung]

@sooslaca
it doesn't work as you said.

[coleifer]

You can use @binderclip snippet, which works for Peewee 3.x and newer.