sqlalchemy操作

from sqlalchemy import create_engine


engine = create_engine('mysql://neutron:b80a9c053c4d47f0@mysql.cloud.vt/test', echo=True)




from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base


from sqlalchemy import ForeignKey
from sqlalchemy.orm import relationship, backref




Base = declarative_base()
class User(Base):
    __tablename__ = 'users';
    id = Column(Integer, primary_key=True);
    name = Column(String(36));
    fullname = Column(String(36));
    password = Column(String(36));   
    addresses = relationship("Address", order_by="Address.id", backref="user") 
    def __repr__(self):
        return "<User(name='%s', fullname='%s', password='%s')>" % (
                            self.name, self.fullname, self.password);






                          
from sqlalchemy.orm import sessionmaker
Session = sessionmaker(bind=engine)


session = Session()


# ed_user = User(name='ed', fullname='Ed Jones', password='edspassword')
# session.add(ed_user)








class Address(Base):
    __tablename__ = 'addresses'
    id = Column(Integer, primary_key=True)
    email_address = Column(String(36), nullable=False)
    user_id = Column(Integer, ForeignKey('users.id'))  
    #user = relationship("User", backref=backref('addresses', order_by=id))
    def __repr__(self):
        return "<Address(email_address='%s')>" % self.email_address
 
 
 
Base.metadata.create_all(engine)   
    
    
jack = User(name='jack', fullname='Jack Bean', password='gjffdd')


jack.addresses = [ Address(email_address='jack@google.com'), Address(email_address='j25@yahoo.com')]