How to set unique string primary key in flask-sqlalchemy for API endpoint

Question

I am building a Rest API using Flask dan Flask-SQLAlchemy. Just wonder, are there any ways to generate a unique ID string primary key? this key will be used for identity API endpoint, like:

POST v0.2/users/4q2VolejRejNmGQB/messages

Instead of

POST v0.2/users/123/messages

I am playing with http://hashids.org/, but seems like had a problem because the primary key will be generated automatically after I save the data while hashids need to generate given integer

got it, I am using uuid and base64 to generate friendly unique url. Thanks! — rizkiaditya24
– rizkiaditya24, Commented Apr 2, 2017 at 15:22

rizkiaditya24 · Accepted Answer · 2017-04-02 15:28:50Z

1

I just got the solution. I am using uuid for generating unique primary key and base64 to make it friendly.

import re
import uuid
import base64

def uuid_url64():
    rv = base64.b64encode(uuid.uuid4().bytes).decode('utf-8')
    return re.sub(r'[\=\+\/]', lambda m: {'+': '-', '/': '_', '=': ''}[m.group(0)], rv)

here is example of the implementation

user1 = UserModel(user_id=str(uuid_url64()), name='rizkiaditya')

answered Apr 2, 2017 at 15:28

rizkiaditya24

353 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

André Heringer Over a year ago

But are you still seting the primary_key proprery to True in the UserModel declaration?

rizkiaditya24 Over a year ago

yes, since primary_key should be unique, UUID can handle that.

Andrew E Over a year ago

If you use sqlalchemy_utils dedicated type UUIDType, you can declare the primary key like this: uuid = Column(UUIDType, primary_key=True)

Javier Seixas Over a year ago

sqlalchemy_utils works, but if you are using Flask-Migrate, it doesn't generate the migration version properly. I had to change manually the parameters passed to the UUIDType.

Collectives™ on Stack Overflow

How to set unique string primary key in flask-sqlalchemy for API endpoint

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related