On Thu, Aug 28, 2014 at 10:38 AM, Maurice J Elagu <mjose...@gmail.com> wrote:
>
>
> 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)
>
Could you provide a bit more information, such as the exact error
message and stack trace?
Thanks,
Simon
--
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.
