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(String(50), unique=True, nullable = False)
    email = Column(String(120), unique=True, nullable = False)
    pwd = email = Column(String(120), unique=True, nullable = False)
    tabs = relationship("tabs", backref="user")


class Tab(base):
  __tablename__ = 'tabs'
  id = Column(Integer, primary_key=True)
  text = Column(Text, unique=True, nullable=False)
  user_id = Column(Integer, ForeignKey('users.id'))
  song_id = Column(Integer, ForeignKey('songs.id'))


class Song(base):
  __tablename__ = 'tabs'
  id = Column(Integer, primary_key=True)
  title = Column(Text, unique=True, nullable=False)
  artist_id = Column(Integer, ForeignKey('artists.id'))


 class Artist(base):
  __tablename__ = 'tabs'
  id = Column(Integer, primary_key=True)
  name = Column(Text, unique=True, nullable=False)
  songs = relationship("artists", backref="artist")