Untitled

#1 create database engine

from sqlalchemy import Column, Integer, String
from arabtabs.db import Base

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    alias = Column(Unicode(50), unique=True, nullable = False)
    email = Column(Unicode(120), unique=True, nullable = False)
    pwd =  Column(Unicode(120), unique=True, nullable = False)

class Artist(base):
  __tablename__ = 'artists'
  id = Column(Integer, primary_key=True)
  name = Column(UnicodeText, unique=True, nullable=False)

class Song(base):
  __tablename__ = 'songs'
  id = Column(Integer, primary_key=True)
  title = Column(Unicode(50), unique=True, nullable=False)
  artist_id = Column(Integer, ForeignKey('artists.id'))
  artist = relationship(Artist, backref="songs")


class Tab(base):
  __tablename__ = 'tabs'
  id = Column(Integer, primary_key=True)
  text = Column(UnicodeText, unique=True, nullable=False)
  user_id = Column(Integer, ForeignKey('users.id'))
  song_id = Column(Integer, ForeignKey('songs.id'))
  user = relationship(User, backref="tabs")
  song = relationship(Song, backref="tabs")