How to Start Primary key with a particular number in sqlalchemy?

Asked Jul 01 '20 at 05:46

Active Jul 01 '20 at 05:46

Viewed 326 times

I have a Sqlite Database and created a model using Sqlalchemy with below code :

class Patient(db.Model):
    __tablename__ = 'patient'
    id = db.Column(db.Integer, Sequence('pat_id_seq',start=123450001,increment=1), primary_key=True)
    ssn_id = db.Column(db.String(45), nullable=False, unique=True)
    name = db.Column(db.String(45), nullable=False)
    age = db.Column(db.Integer, nullable=False)

I want the id to start with 123450001, but it always starts with "1", is there a possible way to do this ?

asked Jul 01 '20 at 05:46

Ajay Kumar Chowdary

Does [this](https://stackoverflow.com/questions/10494033/setting-sqlalchemy-autoincrement-start-value/10495449) answer your question? – Dwij Mehta Jul 01 '20 at 06:18
1

i tried that, it says integer takes no argument and i included sequence in my code which is not working. – Ajay Kumar Chowdary Jul 01 '20 at 06:20

How to Start Primary key with a particular number in sqlalchemy?

0 Answers0