webMethods

 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