creating a table within python code

[Souvik Dutta]

There will be quotes when doing FLASK_APP="<your_app_name>" I think that
should solve the problem.

On Fri, 22 May, 2020, 5:35 pm Buddy Peacock, <buddy.peacock at gmail.com>
wrote:

> I'm working on my first python project in CS50W  and I am trying to create
> 2 tables.
> I am getting the following error when trying to run it:  I have included my
> code below the error message.
>
> flask.cli.NoAppException: Failed to find Flask application or factory in
> module "create_db". Use "FLASK_APP=create_db:name to specify one.
> Traceback (most recent call last)
> File
>
> "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\_compat.py",
> line 39, in reraise
> raise value
> File
>
> "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py",
> line 97, in find_best_app
> raise NoAppException(
> flask.cli.NoAppException: Failed to find Flask application or factory in
> module "create_db". Use "FLASK_APP=create_db:name to specify one.
>
> I used:
> FLASK_APP=create_db.py   at the command line
>
> and this is my code:
>
> import os
> from flask import Flask, session
> from flask_session import Session
> from sqlalchemy import create_engine
> from sqlalchemy.orm import scoped_session, sessionmaker
> engine = create_engine(os.getenv("DATABASE_URL"))
> db = scoped_session(sessionmaker(bind=engine))
> def main():
>     db.execute("CREATE TABLE books (id SERIAL PRIMARY KEY, isbn VARCHAR NOT
> NULL, title VARCHAR NOT NULL, author INTEGER NOT NULL, year INTEGER NOT
> NULL,)")
>     db.execute("CREATE TABLE authors (id SERIAL PRIMARY KEY, name VARCHAR
> NOT NULL,)")
>     db.commit()
> if __name__ == "__main__":
>     main()
>
> Does anyone have any ideas?
>
> Al (Buddy) Peacock, PMP, MCCT,  ITILv3, SMC, CSM, SPOC
> (920) 740-3411
> linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
> --
> https://mail.python.org/mailman/listinfo/python-list
>