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