Thank you Souvik, but still having issues. I have pasted the command line interaction this time. My prior message is what appeared in the browser. ================================================================================================================ c:\Harvard\project1>SET FLASK_APP="create_db.py"
c:\Harvard\project1>set DATABASE_URL=postgres:// guaqyugfujbudc:79ae65a6d8966991694906e4b96f20ebcfde5b80fb334e99d79d9300dd6ef...@ec2-34-200-72-77.compute-1.amazonaws.com:5432/dep18tfh5g2eme c:\Harvard\project1>flask run * Serving Flask app ""create_db.py"" (lazy loading) * Environment: development * Debug mode: on * Restarting with stat * Debugger is active! * Debugger PIN: 124-607-194 * Running on http://127.0.0.1:5000/ (Press CTRL+C to quit) 127.0.0.1 - - [22/May/2020 10:16:46] " [35m [1mGET / HTTP/1.1 [0m" 500 - Traceback (most recent call last): File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 240, in locate_app __import__(module_name) ModuleNotFoundError: No module named '"create_db' During handling of the above exception, another exception occurred: Traceback (most recent call last): File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 338, in __call__ self._flush_bg_loading_exception() File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 326, in _flush_bg_loading_exception reraise(*exc_info) 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 314, in _load_app self._load_unlocked() File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 330, in _load_unlocked self._app = rv = self.loader() File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 388, in load_app app = locate_app(self, import_name, name) File "C:\Users\buddy\AppData\Local\Programs\Python\Python38\Lib\site-packages\flask\cli.py", line 250, in locate_app raise NoAppException('Could not import "{name}".'.format(name=module_name)) flask.cli.NoAppException: Could not import ""create_db.py"". 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=style.css HTTP/1.1 [0m" 200 - 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=debugger.js HTTP/1.1 [0m" 200 - 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=jquery.js HTTP/1.1 [0m" 200 - 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1 [0m" 200 - 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=ubuntu.ttf HTTP/1.1 [0m" 200 - 127.0.0.1 - - [22/May/2020 10:16:46] " [37mGET /?__debugger__=yes&cmd=resource&f=console.png HTTP/1.1 [0m" 200 - Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC (920) 740-3411 linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/> On Fri, May 22, 2020 at 9:42 AM Souvik Dutta <souvik.vik...@gmail.com> wrote: > 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.peac...@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 >> > -- https://mail.python.org/mailman/listinfo/python-list