Dealing with duplicate primary keys on insert in SQLAlchemy (declarative style)

If you use session.merge(bike) instead of session.add(bike), then you will not generate primary key errors. The bike will be retrieved and updated or created as needed.