Пример #1
0
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)
        )
Пример #2
0
 def _get_user_app_data_dir():
     return settings.get_user_app_data_dir()