creating a table within python code

Fri May 22 11:03:53 EDT 2020

And also you might have to add after the import statements app=
Flask(__name__)
and app.run() inside the main function

On Fri, 22 May, 2020, 8:31 pm Souvik Dutta, <souvik.viksou at gmail.com> wrote:

>  You might have to add @app.route("/") before the main method.
>
> On Fri, 22 May, 2020, 7:53 pm Buddy Peacock, <buddy.peacock at gmail.com>
> wrote:
>
>> 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
>>>>
>>>