def entries(mode, page_number):
try:
mode = get_specific_item(config.modes, "route", mode)
except ValueError:
return "invalid page"
if not mode.get('enabled'):
return "This mode is disabled"
pagination = None
mode_entries = None
# todo: Choose if ajax_enabled and infinite_scroll_enabled configs are for each separate modes or globals
ajax_enabled = config.ajax_enabled
infinite_scroll_enabled = config.infinite_scroll_enabled
if ajax_enabled and page_number is None:
no_layout = False
else:
if ajax_enabled:
no_layout = True
else: # AJAX is disabled
no_layout = False
infinite_scroll_enabled = False
if page_number is None:
page_number = 1
db = get_db()
cur = db.cursor()
cur.execute('select count(id) from ' + mode.get("route"))
count = cur.fetchone()[0]
pagination = Pagination(page_number, config.pagination_entry_per_page,
count)
cur = db.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
cur.execute(
'select id, title, text from %s order by id desc limit %d offset %d' %
(mode.get('route'), config.pagination_entry_per_page,
(pagination.page - 1) * config.pagination_entry_per_page))
mode_entries = cur.fetchall()
if not mode_entries and page_number != 1:
abort(404)
print(mode_entries)
return render_template('modes/' + mode.get('route') + '.html',
pagination=pagination,
entries=mode_entries,
title=mode.get('name'),
mode=mode.get('route'),
config=config,
ajaxOn=ajax_enabled,
infiniteScrollOn=infinite_scroll_enabled,
noLayout=no_layout)
def entries_add(mode):
if not session.get('logged_in'):
abort(401)
db = get_db()
db.execute('insert into ' + mode + ' (title, text) values (?, ?)',
[request.form['title'], request.form['text']])
db.commit()
flash('New ' + mode + ' entry was successfully posted')
return "OK"
def clear_entries(mode):
with app.app_context():
db = get_db()
database_request = "drop table if exists " + mode + ";"
db.cursor().execute(database_request)
db.commit()
init_db()
flash('All ' + mode + ' entries were successfully cleared')
return "OK"
def get_mode(mode):
db = get_db()
for tmp_mode in config.modes:
cur = db.cursor()
cur.execute('select count(*) from ' + tmp_mode.get("route"))
count = cur.fetchone()[0]
tmp_mode.__setitem__('count', count)
mode = get_specific_item(config.modes, "route", mode)
return render_template("admin/modes.html", mode=mode, in_admin=True)
def entries_add(mode):
if not session.get('logged_in'):
abort(401)
db = get_db()
db.cursor().execute("insert into " + mode + " (title, text) values ('" +
str(request.form['title']) + "', '" +
str(request.form['text']) + "')")
db.commit()
flash('New ' + mode + ' entry was successfully posted')
return "OK"
def clear_entries(mode):
with app.app_context():
db = get_db()
database_request = "drop table if exists " + mode + ";"
db.cursor().execute(database_request)
db.commit()
init_db()
flash('All ' + mode + ' entries were successfully cleared')
return "OK"
def admin():
db = get_db()
for mode in config.modes:
cur = db.cursor()
cur.execute('select count(id) from ' + mode.get("route"))
count = cur.fetchone()[0]
mode.__setitem__('count', count)
return render_template("admin/admin.html",
modes=config.modes,
title='Admin',
in_admin=True)
def admin():
db = get_db()
for mode in config.modes:
cur = db.execute('select count(id) from ' + mode.get("route"))
count = cur.fetchone()
mode.__setitem__('count', count[0])
return render_template(
"admin/admin.html",
modes=config.modes,
title='Admin',
in_admin=True
)
def entries_add_auto(mode, num):
if not session.get('logged_in'):
abort(401)
db = get_db()
for i in range(0, num):
db.cursor().execute("insert into " + mode +
" (title, text) values ('" +
str(get_sentences(1, False)[0].replace(".", "")) +
"', '" + str(get_paragraphs(1, False)[0]) + "')")
db.commit()
flash('New ' + mode + ' automatic %d %s entrie%s successfully posted' %
(num, mode, 's were' if (num > 1) else ' was'))
return "OK"
def entries_add(mode):
if not session.get('logged_in'):
abort(401)
db = get_db()
db.cursor().execute(
"insert into " + mode +
" (title, text) values ('" +
str(request.form['title']) + "', '" +
str(request.form['text']) + "')"
)
db.commit()
flash('New ' + mode + ' entry was successfully posted')
return "OK"
def get_mode(mode):
db = get_db()
for tmp_mode in config.modes:
cur = db.execute('select count(id) from ' + tmp_mode.get("route"))
count = cur.fetchone()
tmp_mode.__setitem__('count', count[0])
mode = get_specific_item(config.modes, "route", mode)
return render_template(
"admin/modes.html",
mode=mode,
in_admin=True
)
def entries_add_auto(mode, num):
if not session.get('logged_in'):
abort(401)
db = get_db()
for i in range(0, num):
db.execute(
'insert into ' + mode +
' (title, text) values (?, ?)',
[get_sentences(1, False)[0].replace(".", ""), get_paragraphs(1, False)[0]]
)
db.commit()
flash('New ' + mode + ' automatic %d %s entrie%s successfully posted' %
(num, mode, 's were' if (num > 1) else ' was'))
return "OK"
def entry(mode, mode_id):
try:
mode = get_specific_item(config.modes, "route", mode)
except ValueError:
return "invalid page"
if not mode.get('enabled'):
return "This mode is disabled"
db = get_db()
cur = db.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute('select id, title, text from ' + mode.get('route') +
' where id = ' + str(mode_id))
mode_entry = cur.fetchall()
if not mode_entry:
abort(404)
return render_template('modes/' + mode.get('route') + '.html',
entries=mode_entry,
title=mode.get('name'))
def entry(mode, mode_id):
try:
mode = get_specific_item(config.modes, "route", mode)
except ValueError:
return "invalid page"
if not mode.get('enabled'):
return "This mode is disabled"
db = get_db()
cur = db.execute('select id, title, text from ' + mode.get('route') + ' where id = ' + str(mode_id))
mode_entry = cur.fetchall()
if not mode_entry:
abort(404)
return render_template(
'modes/' + mode.get('route') + '.html',
entries=mode_entry,
title=mode.get('name')
)
def entries(mode, page_number):
try:
mode = get_specific_item(config.modes, "route", mode)
except ValueError:
return "invalid page"
if not mode.get('enabled'):
return "This mode is disabled"
pagination = None
mode_entries = None
# todo: Choose if ajax_enabled and infinite_scroll_enabled configs are for each separate modes or globals
ajax_enabled = config.ajax_enabled
infinite_scroll_enabled = config.infinite_scroll_enabled
if ajax_enabled and page_number is None:
no_layout = False
else:
if ajax_enabled:
no_layout = True
else: # AJAX is disabled
no_layout = False
infinite_scroll_enabled = False
if page_number is None:
page_number = 1
db = get_db()
cur = db.cursor()
cur.execute('select count(id) from ' + mode.get("route"))
count = cur.fetchone()[0]
pagination = Pagination(
page_number,
config.pagination_entry_per_page,
count
)
cur = db.cursor(cursor_factory=psycopg2.extras.RealDictCursor)
cur.execute(
'select id, title, text from %s order by id desc limit %d offset %d' % (
mode.get('route'),
config.pagination_entry_per_page,
(pagination.page - 1) * config.pagination_entry_per_page
)
)
mode_entries = cur.fetchall()
if not mode_entries and page_number != 1:
abort(404)
print (mode_entries)
return render_template(
'modes/' + mode.get('route') + '.html',
pagination=pagination,
entries=mode_entries,
title=mode.get('name'),
mode=mode.get('route'),
config=config,
ajaxOn=ajax_enabled,
infiniteScrollOn=infinite_scroll_enabled,
noLayout=no_layout
)
