from tenjin.html import *
from tenjin.helpers import *
import tornado.web
import tornado.gen
from tornado.httpclient import AsyncHTTPClient
import functools
from urllib import parse
from hashlib import md5
from web_server.model import sqlite_query
from CDS_Auto_Import_tools import parameters_parse
root_myapp = logging.getLogger('web_server')
pj_dict = parameters_parse.get_para_dict()
if pj_dict is None:
root_myapp.error(
'get parameters error, please check log file and parameters_parse.py')
sys.exit()
EPG_MEDIA_INFO_URL = \
'http://{ip}:{port}/epgs/{template}/media/detail?&columnid={columnid}&id={m_id}'
engine = tenjin.Engine(path=[
os.path.join('web_server', 'template'),
],
cache=tenjin.MemoryCacheStorage(),
preprocess=True)
idx = PrimaryKey(int, auto=True) # primary key
media_id = Required(Media, index='media_id', reverse='url') # index
url = Required(str, 2048)
serial = Optional(int, size=64, default=0)
isfinal = Optional(int, size=8, default=1)
provider_id = Optional(int, size=32, default=100)
quality_id = Optional(int, size=32, default=1)
thumbnail_url = Optional(str, 255)
image_url = Optional(str, 255)
title = Optional(str, 255, default='')
description = Optional(str, 4096, default='')
time_len = Optional(int, size=16, default=0)
bitrate = Optional(str, 64, default='')
if parameters_parse.get_para_dict() is None:
r_log.error('get parameters error, please check log file and parameters_parse.py')
sys.exit()
db.bind('mysql', user=parameters_parse.para_dict['mysql']['user'],
password=parameters_parse.para_dict['mysql']['passwd'],
host=parameters_parse.para_dict['mysql']['host'],
database=parameters_parse.para_dict['mysql']['database'])
db.generate_mapping()
@db_session
def mysql_read_url():
print(select(p for p in Url)[:2])
