SQLAlchemy

من مكتبة SQLAlchemy استورد *، ومن مكتبة SQLAlchemy.ext.declarative استورد declarative_base، ومن مكتبة SQLAlchemy.orm استورد relation و sessionmakerالأساس = قاعدة تعريفية ()class Movie ( Base ): __tablename__ = "movies"id = Column ( Integer , primary_key = True ) title = Column ( String ( 255 ), nullable = False ) year = Column ( Integer ) directed_by = Column ( Integer , ForeignKey ( "directors.id" ))director = relation ( "Director" , backref = "movies" , lazy = False )def __init __ ( self , title = None , year = None ) : self.title = title self.year = year​​def __repr__ ( self ): return f "Movie( { self . title } , { self . year } , { self . director } )"class Director ( Base ): __tablename__ = "directors"id = Column ( Integer , primary_key = True ) name = Column ( String ( 50 ), nullable = False , unique = True )def __init __ ( self , name = None ) : self.name = namedef __repr__ ( self ): return f "Director( { self . name } )"engine = create_engine ( "dbms://user:pwd@ host / dbname " ) Base.metadata.create_all ( engine )

Session = sessionmaker ( bind = engine ) session = Session ()m1 = Movie ( "Robocop" , 1987 ) m1 . director = Director ( "Paul Verhoeven" )d2 = Director ( "George Lucas" ) d2 . movies = [ Movie ( "Star Wars" , 1977 ), Movie ( "THX 1138" , 1971 )]حاول : session.add ( m1 ) session.add ( d2 ) session.commit ( ) باستثناء : session.rollback ( )​​​​​​

alldata = session.query ( Movie ) .all ( ) for somedata in alldata : print ( somedata )​​

فيلم ( روبوكوب ، 1987 ، إخراج بول فيرهوفن ) فيلم ( حرب النجوم ، 1977 ، إخراج جورج لوكاس ) فيلم ( THX 1138 ، 1971 ، إخراج جورج لوكاس )​