Support for custom primary keys?

[chthor]

I have an application that requires string primary id keys. Standalone PyDAL would be a perfect solution for me otherwise, but it seems like it assumes an integer autoincrement primary key and won't let me define my own. I.e., I can define my table like so:

db.define_table('pizzas', Field('id', type='string'), Field('radius', type='integer'))

and pydal does not object, but an insert statement with a string id fails:

db.pizzas.insert(id='chicago', radius=12)
ValueError: invalid literal for int() with base 10: 'chicago'

Is there any way around this restriction that would allow me to configure my own id field?

Update: looks like maybe this is a WIP in PR 443. Any update on that?

[valq7711]

Hi! Try this:

db.define_table('pizzas', 
       Field('id', type='string'), 
       Field('radius', type='integer'),
       primarykey = ['id'] # this does the trick
)

It works just fine for me!