am a newbie .. encountered a small problem any help will be appreciated class Stock(declarative_base): __tablename__ = 'tbl_stock' .... .... books = relation("Book", order_by="Book.id", backref="tbl_stock") .... pass
class Book(declarative_base): __tablename__ = 'tbl_books' .... .... stock = relation('Stock', backref=backref('tbl_books', order_by=id)) ## created a stock and added 3 books to the stock ins_stock = Stock() ins_book_1 = Book('Book1') ins_book_2 = Book('Book2') ins_book_3 = Book('Book3') ins_stock.books = [ins_book_1,ins_book_2,ins_book_3] # saving ....... session.add(ins_stock) flush() # Later when i update the stock like removing book1 and adding book4 # book1 exists in the db ins_stock.books.remove(ins_book_1) ins_book_4 = Book('Book4') ins_stock.books.add(ins_book_4) flush() in the table the row corresponding to the book1 remains there what should i do to tell sqlalchemy to automatically remove orphan books i have tried giving cascade = 'a'',delete-orphan' but errors comes thanks and regards [EMAIL PROTECTED] Calicut,India --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---