Is there anyway to use the DAL with a database that used UUIDs as the
primary key in a few tables?  The setup below just gives errors
because registered_user.UserId (the id field) isn't an integer as
expected (ValueError: invalid literal for int() with base 10:
'6BBC2607-1B6A-4C8A-BBD4-8566754CFA20')

#Table: registered_user
#Stores user profiles
#Yeah I know this isn't web2py's Auth table - I'm integrating with
a .NET app.
db.define_table("registered_user",
    Field("UserId","id", length=64, default=uuid.uuid4()),
    Field("first_name",  "string", notnull=True),
    Field("last_name", "string", notnull=True),
    Field("street", "string", notnull=True),
    Field("city", "string", notnull=True),
    Field("state", "string", notnull=True),
    Field("zip", "string", notnull=True),
    Field("lastUpdatedDate", "datetime", default=datetime.now(),
notnull=False),
    migrate = do_migration
    )

#Table: group_leader
#Stores the leader(s) of each group
db.define_table("group_leader",
    Field("group_leader_id", "id"),
    Field("group_id",db.volunteer_group),
    Field("UserId",db.registered_user),
    migrate = do_migration
    )

Thanks in advance.
~Brian

Reply via email to