creating a table within python code
Buddy Peacock
buddy.peacock at gmail.com
Fri May 22 10:22:40 EDT 2020
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:79ae65a6d8966991694906e4b96f20ebcfde5b80fb334e99d79d9300dd6ef95f at 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.viksou at 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.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
>>
>
More information about the Python-list
mailing list