Column of type UUID fails to insert default

[hectorcanto]

Column of type UUID fails to insert default

[ernests]

I got it working.

Here is my approach:

from sqlalchemy import (
    Boolean,
    Column,
    DateTime,
    ForeignKey,
    Integer,
    String,
    Text
)

import sqlalchemy.dialects.postgresql as postgresql
import uuid
from sqlalchemy.sql import func

Base = declarative_base()

class Column(Base):
    _id = Column(postgresql.UUID(as_uuid=True),
        primary_key=True,
        default=uuid.uuid4,
        unique=True
    )
    _created = Column(DateTime,
                      default=func.now())
    _updated = Column(DateTime,
                      default=func.now(),
                      onupdate=func.now())
    _etag = Column(Text)

I had to set type of _id for each column to be "uuid - DOMAIN["tasks"]["schema"]["_id"]["type"] = "uuid"

Implemented UUIDValidator and UUIDEncoder from here - https://docs.python-eve.org/en/latest/tutorials/custom_idfields.html#custom-jsonencoder

and passed it to Eve app:

app = Eve(validator= UUIDValidator,
              json_encoder= UUIDEncoder,
              data=SQL)

One key aspect is that you have to generate _id yourself - uuid.uuid4().hex - and pass it as part of POST. It is not needed when you add straight to db.

Hope it helps someone :)