How to clone a SQLAlchemy object with new primary key

by

This should work:

product_obj = products.all()[0]

db.session.expunge(product_obj)  # expunge the object from session
make_transient(product_obj)  # http://docs.sqlalchemy.org/en/rel_1_1/orm/session_api.html#sqlalchemy.orm.session.make_transient

product_obj.product_uid = 'something'
db.session.add(product_obj)

make_transient

Related Contents:

  1. How to execute raw SQL in Flask-SQLAlchemy app
  2. How to update SQLAlchemy row entry?
  3. How to delete a record by id in Flask-SQLAlchemy
  4. Flask SQLAlchemy query, specify column names
  5. How do I know if I can disable SQLALCHEMY_TRACK_MODIFICATIONS?
  6. sqlalchemy.exc.NoSuchModuleError: Can’t load plugin: sqlalchemy.dialects:postgres
  7. SQLAlchemy ORM conversion to pandas DataFrame
  8. jsonify a SQLAlchemy result set in Flask [duplicate]
  9. Case Insensitive Flask-SQLAlchemy Query
  10. Flask-SQLAlchemy how to delete all rows in a single table
  11. flask-sqlalchemy or sqlalchemy
  12. SQLAlchemy create_all() does not create tables
  13. Flask sqlalchemy many-to-many insert data
  14. What is the difference between the declarative_base() and db.Model?
  15. Flask-SQLalchemy update a row’s information
  16. Getting first row from sqlalchemy
  17. How to build a flask application around an already existing database?
  18. ImportError: No module named sqlalchemy
  19. Could not assemble any primary key columns for mapped table
  20. unable to create autoincrementing primary key with flask-sqlalchemy
  21. Flask-SQLAlchemy check if row exists in table
  22. AttributeError: ‘int’ object has no attribute ‘_sa_instance_state’
  23. Flask SQLAlchemy querying a column with “not equals”
  24. Inserting new records with one-to-many relationship in sqlalchemy
  25. scoped_session(sessionmaker()) or plain sessionmaker() in sqlalchemy?
  26. Pylint can’t find SQLAlchemy query member
  27. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  28. SQLAlchemy ManyToMany secondary table with additional fields
  29. Updates to JSON field don’t persist to DB
  30. What is the difference between .one() and .first()
  31. Separate SQLAlchemy models by file in Flask [duplicate]
  32. sqlalchemy : executing raw sql with parameter bindings
  33. sqlalchemy foreign key relationship attributes
  34. How to use avg and sum in SQLAlchemy query
  35. SQLAlchemy delete doesn’t cascade
  36. SQLAlchemy: Hybrid expression with relationship
  37. Defining SQLAlchemy enum column with Python enum raises “ValueError: not a valid enum”
  38. Using OR in SQLAlchemy
  39. sqlalchemy IS NOT NULL select
  40. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  41. SQLAlchemy versioning cares about class import order
  42. Switching from SQLite to MySQL with Flask SQLAlchemy
  43. Alembic: IntegrityError: “column contains null values” when adding non-nullable column
  44. Writing to MySQL database with pandas using SQLAlchemy, to_sql
  45. Bulk insert a Pandas DataFrame using SQLAlchemy
  46. How do I catch a psycopg2.errors.UniqueViolation error in a Python (Flask) app?
  47. Doing DateTime Comparisons in Filter SQLAlchemy
  48. How to use Flask-SQLAlchemy in a Celery task
  49. SQLAlchemy: a better way for update with declarative?
  50. Can I avoid circular imports in Flask and SQLAlchemy

Leave a Comment