def data_list():
#console.log("data start")
#name=request.args.get('type')
name = request.args.get('type')
c_data = []
#return render_template('showdata.html',entries=entries)
search = False
q = request.args.get('q')
if q:
search = True
try:
page = int(request.args.get('page', 1))
except ValueError:
page = 1
per_page = 10
logging.info(name)
if search == True:
# console.log("search==True")
data = db.findQuery(name, q)
else:
data = db.findAll(name)
index = (page - 1) * per_page
delta = per_page
if (len(data) - index) / per_page == 0:
delta = len(data) - index
for i in range(index, index + delta):
c_data.append(data[i])
if search == True:
pagination = Pagination(
page=page,
total=len(data),
search=search,
record_name='Id',
found=len(data),
search_msg=q,
)
else:
pagination = Pagination(
page=page,
total=len(data),
search=search,
record_name='Id',
)
keys = []
if len(c_data) > 0:
keys = c_data[0].keys()
return render_template(
'list.html',
c_data=c_data,
keys=keys,
page=page,
per_page=per_page,
total=len(data),
pagination=pagination,
name=name,
)
def show_script():
name = 'script'
c_data = []
#return render_template('showdata.html',entries=entries)
search = False
q = request.args.get('q')
if q:
search = True
try:
page = int(request.args.get('page', 1))
except ValueError:
page = 1
per_page = 10
if search == True:
# console.log("search==True")
data = db.findQuery(name, q)
else:
data = db.findAll(name)
index = (page - 1) * per_page
delta = per_page
if (len(data) - index) / per_page == 0:
delta = len(data) - index
for i in range(index, index + delta):
c_data.append(data[i])
if search == True:
pagination = Pagination(
page=page,
total=len(data),
search=search,
record_name='script',
found=len(data),
search_msg=q,
)
else:
pagination = Pagination(
page=page,
total=len(data),
search=search,
record_name='script',
)
return render_template(
'script_data.html',
c_data=c_data,
page=page,
per_page=per_page,
total=len(data),
pagination=pagination,
name=name,
)
def list():
search = False
q = request.args.get('q')
if q:
search = True
try:
page = int(request.args.get('page', 1))
except ValueError:
page = 1
users = [
'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'a', 'b', 'b',
'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b', 'b'
]
print users
pagination = Pagination(
page=page,
total=len(users),
search=search,
record_name='users',
)
return render_template(
'hello.html',
users=users,
page=page,
pagination=pagination,
)
def manufacturer_page(category, manufacturer):
if not request.headers.getlist("X-Forwarded-For"):
ip = request.remote_addr
else:
ip = request.headers.getlist("X-Forwarded-For")[0]
log_ip("/cat_man %s : %s %s\n" %
(str(datetime.now().time()), ip, request.headers.get('User-Agent')))
if db.stoves.find_one({
"category": category,
"manufacturer": manufacturer
}) == None:
abort(404)
temp = db.stoves.find({"category": category, "manufacturer": manufacturer})
page = int(request.args.get('page', 1))
per_page = 9
offset = (page - 1) * per_page
pagination_users = get_users(temp, offset=offset, per_page=per_page)
pagination = Pagination(page=page,
per_page=per_page,
offset=offset,
total=temp.count(),
css_framework='bootstrap4')
return render_template('product.html',
category=category,
manufacturer=manufacturer,
stoves=temp,
goods=pagination_users,
pagination=pagination)
def hero_matches(name, page=1):
hero_name_query = Hero.query.filter(Hero.name == HERO_PREFIX + name).all()
if len(hero_name_query) != 1:
abort(404)
else:
hero_name = hero_name_query[0].localized_name
hero_id = hero_name_query[0].id
all_heroes = Hero.query.order_by(Hero.localized_name.asc()).all()
matches_query = Match.query.join(Player).\
filter(Player.hero_id==hero_id,
Match.is_significant_p==True).\
order_by(Match.starttime.desc())
display_msg = '''Matches <b>{start} - {end}</b> of <b>{total}</b>'''
matches_pagination = Pagination(per_page=MATCHES_PER_PAGE,
total=matches_query.count(),
display_msg=display_msg,
page=page)
matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False)
(matches, players_for_match) = matches_and_players(matches_query.items)
title = hero_name
return render_template("hero-matches.html",
matches=matches_query,
pagination=matches_pagination,
players_for_match=players_for_match,
hero_name=hero_name,
fields=prepare_match_preview(),
all_heroes=all_heroes,
title=title)
def player(name, page=1):
if str(name) in NAME_ID.keys():
player_name = name
player_id = NAME_ID[str(name)]
else:
abort(404)
matches_query = Match.query.join(Player).\
filter(Player.account_id==player_id,
Match.is_significant_p==True).\
order_by(Match.starttime.desc())
display_msg = '''Matches <b>{start} - {end}</b> of <b>{total}</b>'''
matches_pagination = Pagination(per_page=MATCHES_PER_PAGE,
total=matches_query.count(),
display_msg=display_msg,
page=page)
matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False)
(matches, players_for_match) = matches_and_players(matches_query.items)
title = player_name
return render_template("player.html",
matches=matches_query,
pagination=matches_pagination,
players_for_match=players_for_match,
player_name=player_name,
fields=prepare_match_preview(),
title=title)
def index(page=1):
matches_query = Match.query.filter(
Match.is_significant_p == True).order_by(Match.starttime.desc())
display_msg = '''Matches <b>{start} - {end}</b> of
<b>{total}</b>'''
matches_pagination = Pagination(page=page,
per_page=MATCHES_PER_PAGE,
total=matches_query.count(),
display_msg=display_msg)
matches_query = matches_query.paginate(page, MATCHES_PER_PAGE, False)
(matches, players_for_match) = matches_and_players(matches_query.items)
sorted_players = sorted(NAME_ID.iteritems(), key=operator.itemgetter(0))
sorted_players = sorted(sorted_players, key=lambda s: s[0].lower())
start = 1 + (matches_pagination.page - 1) * matches_pagination.per_page
end = start + matches_pagination.per_page - 1
title = "Matches " + str(start) + " - " + str(end) + " of " + str(
matches_pagination.total)
return render_template("index.html",
matches=matches_query,
pagination=matches_pagination,
players_for_match=players_for_match,
player_pages=sorted_players,
fields=prepare_match_preview(),
title=title)
def manufacturer_page(category, manufacturer):
temp = db.stoves.find({"category": category, "manufacturer": manufacturer})
page = int(request.args.get('page', 1))
per_page = 9
offset = (page - 1) * per_page
pagination_users = get_users(temp, offset=offset, per_page=per_page)
pagination = Pagination(page=page,
per_page=per_page,
offset=offset,
total=temp.count(),
css_framework='bootstrap4')
return render_template('product.html',
category=category,
manufacturer=manufacturer,
stoves=temp,
goods=pagination_users,
pagination=pagination)
def topics():
page, per_page, offset = get_page_args(page_parameter='page',
per_page_parameter='per_page')
order = request.args.get('order') or "time"
database = db.Database()
subjects = database.get_topics(order, offset=offset, per_page=per_page)
pagination = Pagination(
css_framework='bootstrap4',
link_size='sm',
show_single_page=False,
page=page,
per_page=per_page,
total=database.get_num_topics(),
record_name='Topics',
format_total=True,
format_number=True,
)
context = {'subjects': subjects, 'pagination': pagination}
return render_template('topics.html', **context)