def write_to_db(lesson_name, description, section_name, url, slug="", modified_date="Empty", url_description="Empty", type="text"): if "добро" in section_name.lower(): check_columns_list = [lesson_name, description] if "Windows" in check_columns_list or "Mac OS" in check_columns_list or "Linux" in check_columns_list: return False url_exist = Content.query.filter(Content.url == url).count() if type == "text": url_description_exist = Content.query.filter( Content.url_description == url_description).count() print(f"description exist is {bool(url_description_exist)}") print(f"url_exist is {bool(url_exist)}") if not url_description_exist and not url_exist: content = Content(lesson_name=lesson_name, description=description, section_name=section_name, type=type, url_description=url_description, url=url, modified_date=modified_date, slug=slug) db.session.add(content) db.session.commit() else: print(f"url_exist is {bool(url_exist)}") if not url_exist: content = Content(lesson_name=lesson_name, description=description, section_name=section_name, type=type, url_description=url_description, url=url, modified_date=modified_date, slug=slug) db.session.add(content) db.session.commit() else: print(lesson_name + " | " + slug + " | " + url)
def common(page_slug): get_user_id = current_user.get_id() user_by_id = Users.query.filter_by(id=get_user_id).first() g.username = user_by_id.username g.role = user_by_id.role g.avatar = user_by_id.avatar page_content = Content.query.with_entities( Content.description, Content.type, Content.url, Content.lesson_name, Content.url_description).filter(Content.slug != "").filter( (or_(Content.section_name.ilike('%первой%'), Content.section_name.ilike('%2 недели%'), Content.section_name.ilike('%окружение%')))).filter( Content.slug == page_slug).distinct() page = Content.query.with_entities( Content.slug).filter(Content.slug == page_slug).first() if not page: return 'Not found', 404 return render_template(f'/common/{page.slug}.html', page_content=page_content, username=g.username, role=g.role, common_menu=Content.common_menu(), web_menu=Content.web_menu(), ds_menu=Content.ds_menu(), bot_menu=Content.bot_menu(), deploy_menu=Content.deploy_menu(), add_menu=Content.add_menu())
def start(): get_user_id = current_user.get_id() user_by_id = Users.query.filter_by(id=get_user_id).first() g.username = user_by_id.username g.role = user_by_id.role g.avatar = user_by_id.avatar return render_template('start.html', username=g.username, role=g.role, common_menu=Content.common_menu(), web_menu=Content.web_menu(), ds_menu=Content.ds_menu(), bot_menu=Content.bot_menu(), deploy_menu=Content.deploy_menu(), add_menu=Content.add_menu())
def add(page_slug): get_user_id = current_user.get_id() user_by_id = Users.query.filter_by(id=get_user_id).first() g.username = user_by_id.username g.role = user_by_id.role g.avatar = user_by_id.avatar page = Content.query.with_entities( Content.slug).filter(Content.slug == page_slug).first() if not page: return 'Not found', 404 return render_template(f'/add/{page.slug}.html', username=g.username, role=g.role, page_content=Content.page_content(page_slug), common_menu=Content.common_menu(), web_menu=Content.web_menu(), ds_menu=Content.ds_menu(), bot_menu=Content.bot_menu(), deploy_menu=Content.deploy_menu(), add_menu=Content.add_menu())
def index(): get_user_id = current_user.get_id() user_by_id = Users.query.filter_by(id=get_user_id).first() g.username = user_by_id.username g.role = user_by_id.role g.avatar = user_by_id.avatar news_list = News.query.order_by(News.published.desc()).all() habr_list = Articles.query.filter_by(source="habr").all() tproger_list = Articles.query.filter_by(source="tproger").all() return render_template('index.html', news_list=news_list, habr_list=habr_list, tproger_list=tproger_list, username=g.username, role=g.role, common_menu=Content.common_menu(), web_menu=Content.web_menu(), ds_menu=Content.ds_menu(), bot_menu=Content.bot_menu(), deploy_menu=Content.deploy_menu(), add_menu=Content.add_menu())