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 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 )