Hi there!
Not really a question about PythonAnywhere. However, seeing as this forum is filled with users who do use SQLAlchemy, figured I'd try my show at seeing if I could get some help.
SO I'm getting started with SQLAlchemy for Flask, and the ORM is a bit different than what I'm use to. Use to just write the sql querys to get the results I wanted.
Bascially, I have two tables in my database. "categories" and "tools". In the tools table i have a column called "categories" which will have the category ID in it that it belongs to.
In my flask template I have the following:
{% for category in categories %}
<a href="/category/{{ category.name|slug }}.{{ category.id }}">
{{ category.name }} <span> {{ category_count }}</span>
</a>
{% endfor %}
I want the {{ category_count }} to associate/count how many tools have the category ID in it's categories column.
For example
Category Name - #
Category Two - #
Category Three - #
Replace the '#' with the number of how many tools have that category id in it's category column.
My current route:
@app.route('/')
def index():
featured = Tools.query.filter(Tools.status == 2).order_by(Tools.id.asc()).limit(5).all()
tools = Tools.query.order_by(Tools.id.desc())
tool_count = Tools.query.count()
categories = Categories.query
return render_template('index.html', featured=featured, tools=tools, tool_count=tool_count, categories=categories)
I'm not sure about how to use SQLAlchemy to have the two tables match/associate with each other.