def __init__(self, arguments):
# Configure Session class with desired options
Session = sessionmaker()
# Import credentials
db_name = credentials.get_db_name()
db_user_name = credentials.get_db_user_name()
db_host = credentials.get_db_host()
db_password = credentials.get_db_password()
db_backend = credentials.get_db_backend()
# Later, we create the engine
engine = create_engine('{backend}://{user}:{password}@{host}/{name}?charset=utf8'
.format(backend=db_backend,
user=db_user_name,
password=db_password,
host=db_host,
name=db_name),
# echo=True
)
# Associate it with our custom Session class
Session.configure(bind=engine)
# API Credentials
API_KEY = credentials.get_lastfm_api_key()
API_SECRET = credentials.get_lastfm_api_secret()
DB_NAME = credentials.get_db_name()
network = pylast.LastFMNetwork(api_key=API_KEY,
api_secret=API_SECRET,)
variables = Variables(arguments, Session, network)
#TODO: evaluate listdir for artists_dir lazily
for artist in os.listdir(variables.dirs.artists):
print '[+]>>>> Adding ' + artist
self.add_band(variables, artist)
def __init__(self, arguments):
# Configure Session class with desired options
Session = sessionmaker()
# Import credentials
db_name = credentials.get_db_name()
db_user_name = credentials.get_db_user_name()
db_host = credentials.get_db_host()
db_password = credentials.get_db_password()
db_backend = credentials.get_db_backend()
# Later, we create the engine
engine = create_engine(
'{backend}://{user}:{password}@{host}/{name}?charset=utf8'.format(
backend=db_backend,
user=db_user_name,
password=db_password,
host=db_host,
name=db_name),
# echo=True
)
# Associate it with our custom Session class
Session.configure(bind=engine)
# API Credentials
API_KEY = credentials.get_lastfm_api_key()
API_SECRET = credentials.get_lastfm_api_secret()
DB_NAME = credentials.get_db_name()
network = pylast.LastFMNetwork(
api_key=API_KEY,
api_secret=API_SECRET,
)
variables = Variables(arguments, Session, network)
self.download_missing_images(variables)
def __init__(self, arguments):
# Configure Session class with desired options
Session = sessionmaker()
# Import credentials
db_name = credentials.get_db_name()
db_user_name = credentials.get_db_user_name()
db_host = credentials.get_db_host()
db_password = credentials.get_db_password()
db_backend = credentials.get_db_backend()
# Later, we create the engine
engine = create_engine('{backend}://{user}:{password}@{host}/{name}?charset=utf8'
.format(backend=db_backend,
user=db_user_name,
password=db_password,
host=db_host,
name=db_name),
# echo=True
)
# Associate it with our custom Session class
Session.configure(bind=engine)
# API Credentials
API_KEY = credentials.get_lastfm_api_key()
API_SECRET = credentials.get_lastfm_api_secret()
DB_NAME = credentials.get_db_name()
network = pylast.LastFMNetwork(api_key=API_KEY,
api_secret=API_SECRET,)
variables = Variables(arguments, Session, network)
self.download_missing_images(variables)
'templates')
app = Flask(__name__, template_folder=tmpl_dir)
# XXX: The Database URI should be in the format of:
#
# postgresql://USER:PASSWORD@<IP_OF_POSTGRE_SQL_SERVER>/<DB_NAME>
#
# For example, if you had username ewu2493, password foobar, then the following line would be:
#
# DATABASEURI = "postgresql://*****:*****@<IP_OF_POSTGRE_SQL_SERVER>/postgres"
#
# For your convenience, we already set it to the class database
# Use the DB credentials you received by e-mail
DB_USER = credentials.get_db_user()
DB_PASSWORD = credentials.get_db_password()
DB_SERVER = "w4111.cisxo09blonu.us-east-1.rds.amazonaws.com"
DATABASEURI = "postgresql://" + DB_USER + ":" + DB_PASSWORD + "@" + DB_SERVER + "/w4111"
#
# This line creates a database engine that knows how to connect to the URI above
#
engine = create_engine(DATABASEURI)
# Here we create a test table and insert some values in it
engine.execute("""DROP TABLE IF EXISTS test;""")
engine.execute("""CREATE TABLE IF NOT EXISTS test (
id serial,
name text
from schema import Base
from sqlalchemy import create_engine
from sqlalchemy_utils import database_exists, create_database, drop_database
import credentials
db_name = credentials.get_db_name()
db_user_name = credentials.get_db_user_name()
db_host = credentials.get_db_host()
db_password = credentials.get_db_password()
db_backend = credentials.get_db_backend()
# later, we create the engine
engine = create_engine('{backend}://{user}:{password}@{host}/{name}'.format(
backend=db_backend,
user=db_user_name,
password=db_password,
host=db_host,
name=db_name))
if __name__ == '__main__':
# create db if it doesn't exist
if database_exists(engine.url):
print 'Database already exists.'
exit()
try:
create_database(engine.url)
Base.metadata.create_all(engine)
print "Database created."
except Exception as e:
print str(e)
from schema import Base
from sqlalchemy import create_engine
from sqlalchemy_utils import database_exists, create_database, drop_database
import credentials
db_name = credentials.get_db_name()
db_user_name = credentials.get_db_user_name()
db_host = credentials.get_db_host()
db_password = credentials.get_db_password()
db_backend = credentials.get_db_backend()
# later, we create the engine
engine = create_engine('{backend}://{user}:{password}@{host}/{name}'.format(backend=db_backend,
user=db_user_name,
password=db_password,
host=db_host,
name=db_name))
if __name__ == '__main__':
# create db if it doesn't exist
if database_exists(engine.url):
print 'Database already exists.'
exit()
try:
create_database(engine.url)
Base.metadata.create_all(engine)
print "Database created."
except Exception as e:
print str(e)
