webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Not be able to delete child tables in SQLAlchemy using in Fast api

  • 1.  Not be able to delete child tables in SQLAlchemy using in Fast api

    Posted Sat July 27, 2024 04:24 AM

    Below i have three tables which have many to many relationship between them, the problem is i am not be able to delete user table the database say: “constraint imagesmetadata_user_id_fkey on table imagesmetadata depends on table users constraint tokens_user_id_fkey on table tokens depends on table userscannot drop table users because other objects depend on it”

    The only way i can delete user table after deleting token and images meta data table

    Although i already have put this cascade="all, delete-orphan" in my code but still it doesn’t work can some body please help ??

    here is my model code:

    User file:
    [postgresql]


    #API-Management
    #webMethods
    #Developer-Portal


  • 2.  RE: Not be able to delete child tables in SQLAlchemy using in Fast api

    Posted Sat July 27, 2024 09:37 AM

    Hm, not sure how this is related to webMethods. Can you elaborate?


    #API-Management
    #webMethods
    #Developer-Portal