class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) # id = Column(Integer, ForeignKey('cart.id')) name = Column(Unicode(255), unique=True, nullable=False) password = Column(Unicode(255), nullable=False) last_logged = Column(DateTime, default=datetime.datetime.utcnow) user_banned = Column(Boolean()) user_banned_reason = Column(UnicodeText, default=u'') active = Column(Boolean, default=False) contacts = relationship('Contact')
@classmethod def by_name(cls, name): return DBSession.query(User).filter(User.name == name).first() def verify_password(self, password): return self.password == password class Blog_Entry(Base): __tablename__ = 'entries' id = Column(Integer, primary_key=True) title = Column(Unicode(255), unique=True, nullable=False) body = Column(UnicodeText, default=u'') created = Column(DateTime, default=datetime.datetime.utcnow) edited = Column(DateTime, default=datetime.datetime.utcnow) class Contact(Base): __tablename__ = 'contacts' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('users.id')) name = Column(Unicode(255), unique=True, nullable=False) email = Column(Unicode(255), nullable=False) body = Column(UnicodeText, default=u'') created = Column(DateTime, default=datetime.datetime.utcnow) class Song(Base): __tablename__ = 'song' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('album.id')) id = Column(Integer, ForeignKey('genre.id')) #id = Column(Integer, ForeignKey('artist.id')) title = Column(Unicode(255), nullable=False) url = Column(Unicode(255), nullable=False) artist = Column(Unicode(255), nullable=False) year = Column(Unicode(255), nullable=False) price = Column(Unicode(255), nullable=False) class Genre(Base): __tablename__ = 'genre' id = Column(Integer, primary_key=True) #id = Column(Integer, ForeignKey=('song.id')) genre = Column(Unicode(255), nullable=False) active = Column(Boolean, default=False) songs = relationship("Song") class Artist(Base): __tablename__ = 'artist' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('users.id')) #id = Column(Integer, ForeignKey('album.id')) artist = Column(Unicode(255), nullable=False) bio = Column(UnicodeText, default=u'') active = Column(Boolean, default=False) song = relation('Song') class Album(Base): __tablename__ = 'album' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('artist.id')) #id = Column(Integer, ForeignKey('song.id')) album_name = Column(Unicode(255), nullable=False) ReleaseDate = Column(DateTime) picture = Column(Unicode(255), nullable=False) active = Column(Boolean, default=False) artist = relation('Artist', backref=backref('album', order_by=id)) def __repr__(self): return "<artist('%')>" % self.name ''' class Cart(Base): __tablename__ = 'cart' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('users.id') id = Column(Integer, ForeignKey('song.id')) order_date = Column(DateTime, default=datetime.datetime.utcnow) price = Column(Unicode(255), nullable=False) user = relation('User') def __repr__(self): return "<User('%')" % self.name ''' class SongReview(Base): __tablename__ = 'review' id = Column(Integer, primary_key=True) id = Column(Integer, ForeignKey('song.id')) rating = Column(Unicode(255), nullable = True) body = Column(UnicodeText, default=u'') created = Column(DateTime, default=datetime.datetime.utcnow) is_approved = Column(Boolean, default=True) -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.