def db_connect(cls):
settings = Config.get('database')
cls._db = web.database(dbn=settings['dbn'],
user=settings['user'],
pw=settings['password'],
db=settings['db'],
host=settings['host'])
log.info("Connected to db: %s" % cls._db)
def sessionDB():
"""
Gets the session database object. Database object is based from
web.py's database handling. This utilizes values found in the
config.yaml file.
"""
config = Config.get('database')
return web.database(dbn=config['dbn'], user=config['user'], pw=config['password'], db=config['db'], host=config['host'])
def sessionDB():
"""
Gets the session database object. Database object is based from
web.py's database handling. This utilizes values found in the
config.yaml file.
"""
config = Config.get('database')
return web.database(dbn=config['dbn'], user=config['user'], pw=config['password'], db=config['db'], host=config['host'])
import lib.web as web
import datetime
db = web.database(dbn='sqlite', db='anorak.db')
def get_animes():
return db.select('animes', order='title ASC')
def get_anime(id):
try:
return db.select('animes', where='id=$id', vars=locals())[0]
except IndexError:
return None
def get_anime_by_title(title):
# Custom query to make sure the where is case-insensitive
try:
return db.query("SELECT * FROM animes WHERE LOWER(title)=LOWER(\'%s\')" % title)[0]
except IndexError:
# Don't give up, try the alternative title
try:
return db.query("SELECT * FROM animes WHERE LOWER(alternativeTitle)=LOWER(\'%s\')" % title)[0]
except IndexError:
return None
def new_anime(id, title, subber, location, quality=0):
db.insert('animes', id=id, title=title, subber=subber, location=location, quality=quality)
def remove_anime(id):
db.delete('animes', where='id=$id', vars=locals())
db.delete('episodes', where='id=$id', vars=locals())
def connectDB(self, dbParams):
self.DBHandle = web.database(dbn=dbParams.get('dbn'),user=dbParams.get('user'), pw=dbParams.get('password'), db=dbParams.get('db'), host=dbParams.get('host'))
def db_connect(cls):
settings = Config.get('database')
cls._db = web.database(dbn=settings['dbn'], user=settings['user'], pw=settings['password'], db=settings['db'], host=settings['host'])
log.info("Connected to db: %s" % cls._db)
def connectDB(self, dbParams):
self.DBHandle = web.database(dbn=dbParams.get('dbn'),
user=dbParams.get('user'),
pw=dbParams.get('password'),
db=dbParams.get('db'),
host=dbParams.get('host'))
import lib.web as web
import datetime
db = web.database(dbn='sqlite', db='anorak.db')
def get_animes():
return db.select('animes', order='title ASC')
def get_anime(id):
try:
return db.select('animes', where='id=$id', vars=locals())[0]
except IndexError:
return None
def get_anime_by_title(title):
# Custom query to make sure the where is case-insensitive
try:
return db.query(
"SELECT * FROM animes WHERE LOWER(title)=LOWER(\'%s\')" % title)[0]
except IndexError:
# Don't give up, try the alternative title
try:
return db.query(
"SELECT * FROM animes WHERE LOWER(alternativeTitle)=LOWER(\'%s\')"
% title)[0]
except IndexError:
# Don't give up, try the official title
try:
