from sqlalchemy import * from sqlalchemy.orm import * from tonal import settings settings.ensure_app_dirs_exists() uri = 'sqlite:///%s/tonal-music.db' % \ settings.get_user_app_data_dir() engine = create_engine(uri) metadata = MetaData(engine) session = create_session() artists = Table('artists', metadata, Column('id', Integer, primary_key=True), Column('name', String, unique=True) ) albums = Table('albums', metadata, Column('id', Integer, primary_key=True), Column('artist_id', Integer, ForeignKey('artists.id')), Column('name', String, unique=True), Column('image', Binary) ) genres = Table('genres', metadata, Column('id', Integer, primary_key=True), Column('name', String, unique=True) )
def _get_user_app_data_dir(): return settings.get_user_app_data_dir()