Help Problem with python : python-3.8.3rc1-amd64
I am trying to install python on my surface with windows 10, version 1903, build 18362.778. The installer seems to think everything worked. But there is no Python folder anywhere on the system. I looked in the root directory as well as "Program Files" and "Program Files (x86)" and not in any users folders either. I have uninstalled and re-installed twice. Once after shutting down and restarting. Your help would be appreciated as I am taking an on-line programming class. 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
creating a table within python code
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
Re: creating a table within python code
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
wrote:
> There will be quotes when doing FLASK_APP="" I think that
> should solve the problem.
>
> On Fri, 22 May, 2020, 5:35 pm Buddy Peacock,
> 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_engin
Re: creating a table within python code
Still no go. I even tried using the entire path of the py ap in the SET
FLASK_APP command
This is my code now after trying your suggestions.
===
import os
from flask import Flask, session
from flask_session import Session
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
app= Flask(__name__)
engine = create_engine(os.getenv("DATABASE_URL"))
db = scoped_session(sessionmaker(bind=engine))
@app.route("/")
def main():
app.run()
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()
=========
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 11:04 AM Souvik Dutta
wrote:
> 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,
> wrote:
>
>> You might have to add @app.route("/") before the main method.
>>
>> On Fri, 22 May, 2020, 7:53 pm Buddy Peacock,
>> 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: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=resourc
SQLAlchemy & Postgresql
Hello group,
I have a pretty good background in MySQL & MSSQL as well as VB & Php, but I
am new to Python and Postgresql.
I am taking a class and working on a project to insert authors and books
into a table. My code for this is:
===
import csv
import os
from flask import Flask
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
app = Flask(__name__)
# Configure session to use filesystem
app.config["SESSION_PERMANENT"] = False
app.config["SESSION_TYPE"] = "filesystem"
# Session(app)
# Set up database
engine = create_engine(os.getenv("DATABASE_URL"))
db = scoped_session(sessionmaker(bind=engine))
print (os.getenv("DATABASE_URL"))
def main():
f = open("books.csv")
reader = csv.reader(f)
for isbn, title, author, year in reader:
if db.execute("SELECT * FROM authors WHERE name = :author",
{"name": author}).rowcount == 0:
db.execute("INSERT INTO authors (name) VALUES (author)")
print(f" {author} was read.")
db.commit()
if __name__ == "__main__":
main()
If I comment out the "if" statement then the authors all print on screen.
But when I run this with the if statement I am getting a message that says:
ssqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A
value is required for bind parameter 'author'
[SQL: SELECT * FROM authors WHERE name = %(author)s]
[parameters: [{'name': 'author'}]]
What am I missing?
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
Re: SQLAlchemy & Postgresql
I'm not sure what you mean by models? Am I missing something in my
environment perhaps?
Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
(920) 740-3411
linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
On Thu, May 28, 2020 at 2:26 PM Abdur-Rahmaan Janhangeer <
arj.pyt...@gmail.com> wrote:
> Greetings,
>
>
> where did you define your models?
>
> Kind Regards,
>
>
> Abdur-Rahmaan Janhangeer
>
> https://www.github.com/Abdur-RahmaanJ
>
> Mauritius
>
> sent from gmail client on Android, that's why the signature is so ugly.
>
> On Thu, 28 May 2020, 22:22 Buddy Peacock, wrote:
>
>> Hello group,
>> I have a pretty good background in MySQL & MSSQL as well as VB & Php, but
>> I
>> am new to Python and Postgresql.
>>
>> I am taking a class and working on a project to insert authors and books
>> into a table. My code for this is:
>> ===
>> import csv
>> import os
>>
>> from flask import Flask
>> from sqlalchemy import create_engine
>> from sqlalchemy.orm import scoped_session, sessionmaker
>>
>> app = Flask(__name__)
>>
>> # Configure session to use filesystem
>> app.config["SESSION_PERMANENT"] = False
>> app.config["SESSION_TYPE"] = "filesystem"
>> # Session(app)
>>
>> # Set up database
>> engine = create_engine(os.getenv("DATABASE_URL"))
>> db = scoped_session(sessionmaker(bind=engine))
>>
>> print (os.getenv("DATABASE_URL"))
>>
>> def main():
>> f = open("books.csv")
>> reader = csv.reader(f)
>> for isbn, title, author, year in reader:
>> if db.execute("SELECT * FROM authors WHERE name = :author",
>> {"name": author}).rowcount == 0:
>> db.execute("INSERT INTO authors (name) VALUES (author)")
>>
>> print(f" {author} was read.")
>> db.commit()
>>
>> if __name__ == "__main__":
>> main()
>> ========
>> If I comment out the "if" statement then the authors all print on screen.
>> But when I run this with the if statement I am getting a message that
>> says:
>> ssqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A
>> value is required for bind parameter 'author'
>> [SQL: SELECT * FROM authors WHERE name = %(author)s]
>> [parameters: [{'name': 'author'}]]
>>
>> What am I missing?
>>
>>
>> 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
Re: SQLAlchemy & Postgresql
Thanks for your response Abdur-Rahmaan,
The tables already exist and I have tried both "name = author" and "name =
:author"
Regards,
Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
(920) 740-3411
linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
On Thu, May 28, 2020 at 2:44 PM Abdur-Rahmaan Janhangeer <
arj.pyt...@gmail.com> wrote:
> Well,
>
>
> See
>
> for isbn, title, author, year in reader:
> if db.execute("SELECT * FROM authors WHERE name = :author",
> {"name": author}).rowcount == 0:
> db.execute("INSERT INTO authors (name) VALUES (author)")
>
> but i don't see any code for creating the authors table
>
> also did you mean "name = author" instead of "name = :author"
>
> 3rd thing is that since you are using SQLALchemy, you should not be using
> pure SQL
>
> What i mean by models is something like this:
> https://github.com/Abdur-rahmaanJ/shopyo/blob/dev/shopyo/modules/product/models.py
>
> where you define code and your table is created the link uses
> flask-sqlalchemy but pure sqlalchemy should
> be somewhat similar
>
> 4th thing: when using
>
> for isbn, title, author, year in reader:
>
> without flask, do you actually see a value for author?
>
> Kind Regards,
>
> Abdur-Rahmaan Janhangeer
> compileralchemy <https://compileralchemy.github.io/> | blog
> <https://abdur-rahmaanj.github.io/>
> github <https://github.com/Abdur-RahmaanJ>
> Mauritius
>
>
> On Thu, May 28, 2020 at 10:31 PM Buddy Peacock
> wrote:
>
>> I'm not sure what you mean by models? Am I missing something in my
>> environment perhaps?
>>
>> Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
>> (920) 740-3411
>> linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
>>
>>
>>
>>
>> On Thu, May 28, 2020 at 2:26 PM Abdur-Rahmaan Janhangeer <
>> arj.pyt...@gmail.com> wrote:
>>
>>> Greetings,
>>>
>>>
>>> where did you define your models?
>>>
>>> Kind Regards,
>>>
>>>
>>> Abdur-Rahmaan Janhangeer
>>>
>>> https://www.github.com/Abdur-RahmaanJ
>>>
>>> Mauritius
>>>
>>> sent from gmail client on Android, that's why the signature is so ugly.
>>>
>>> On Thu, 28 May 2020, 22:22 Buddy Peacock,
>>> wrote:
>>>
>>>> Hello group,
>>>> I have a pretty good background in MySQL & MSSQL as well as VB & Php,
>>>> but I
>>>> am new to Python and Postgresql.
>>>>
>>>> I am taking a class and working on a project to insert authors and books
>>>> into a table. My code for this is:
>>>> ===
>>>> import csv
>>>> import os
>>>>
>>>> from flask import Flask
>>>> from sqlalchemy import create_engine
>>>> from sqlalchemy.orm import scoped_session, sessionmaker
>>>>
>>>> app = Flask(__name__)
>>>>
>>>> # Configure session to use filesystem
>>>> app.config["SESSION_PERMANENT"] = False
>>>> app.config["SESSION_TYPE"] = "filesystem"
>>>> # Session(app)
>>>>
>>>> # Set up database
>>>> engine = create_engine(os.getenv("DATABASE_URL"))
>>>> db = scoped_session(sessionmaker(bind=engine))
>>>>
>>>> print (os.getenv("DATABASE_URL"))
>>>>
>>>> def main():
>>>> f = open("books.csv")
>>>> reader = csv.reader(f)
>>>> for isbn, title, author, year in reader:
>>>> if db.execute("SELECT * FROM authors WHERE name = :author",
>>>> {"name": author}).rowcount == 0:
>>>> db.execute("INSERT INTO authors (name) VALUES (author)")
>>>>
>>>> print(f" {author} was read.")
>>>> db.commit()
>>>>
>>>> if __name__ == "__main__":
>>>> main()
>>>>
>>>> If I comment out the "if" statement then the authors all print on
>>>> screen.
>>>> But when I run this with the if statement I am getting a message that
>>>> says:
>>>> ssqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) A
>>>> value is required for bind parameter 'author'
>>>> [SQL: SELECT * FROM authors WHERE name = %(author)s]
>>>> [parameters: [{'name': 'author'}]]
>>>>
>>>> What am I missing?
>>>>
>>>>
>>>> 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
Re: SQLAlchemy & Postgresql
Yes, after commenting out all flask related lines and then running the
print, I do see all the authors.
Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
(920) 740-3411
linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
On Thu, May 28, 2020 at 3:48 PM Abdur-Rahmaan Janhangeer <
arj.pyt...@gmail.com> wrote:
> You tried
>
> for isbn, title, author, year in reader:
>
> without flask, do you actually see a value for author?
>
>
>
> Like using a normal print
>
> Kind Regards,
>
>
> Abdur-Rahmaan Janhangeer
>
> https://www.github.com/Abdur-RahmaanJ
>
> Mauritius
>
> sent from gmail client on Android, that's why the signature is so ugly.
>
> On Thu, 28 May 2020, 23:31 Buddy Peacock, wrote:
>
>> Thanks for your response Abdur-Rahmaan,
>>
>> The tables already exist and I have tried both "name = author" and "name
>> = :author"
>>
>> Regards,
>>
>> Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
>> (920) 740-3411
>> linkedin.com/in/buddypeacock <https://www.linkedin.com/in/buddypeacock/>
>>
>>
>>
>>
>> On Thu, May 28, 2020 at 2:44 PM Abdur-Rahmaan Janhangeer <
>> arj.pyt...@gmail.com> wrote:
>>
>>> Well,
>>>
>>>
>>> See
>>>
>>> for isbn, title, author, year in reader:
>>> if db.execute("SELECT * FROM authors WHERE name = :author",
>>> {"name": author}).rowcount == 0:
>>> db.execute("INSERT INTO authors (name) VALUES (author)")
>>>
>>> but i don't see any code for creating the authors table
>>>
>>> also did you mean "name = author" instead of "name = :author"
>>>
>>> 3rd thing is that since you are using SQLALchemy, you should not be
>>> using
>>> pure SQL
>>>
>>> What i mean by models is something like this:
>>> https://github.com/Abdur-rahmaanJ/shopyo/blob/dev/shopyo/modules/product/models.py
>>>
>>> where you define code and your table is created the link uses
>>> flask-sqlalchemy but pure sqlalchemy should
>>> be somewhat similar
>>>
>>> 4th thing: when using
>>>
>>> for isbn, title, author, year in reader:
>>>
>>> without flask, do you actually see a value for author?
>>>
>>> Kind Regards,
>>>
>>> Abdur-Rahmaan Janhangeer
>>> compileralchemy <https://compileralchemy.github.io/> | blog
>>> <https://abdur-rahmaanj.github.io/>
>>> github <https://github.com/Abdur-RahmaanJ>
>>> Mauritius
>>>
>>>
>>> On Thu, May 28, 2020 at 10:31 PM Buddy Peacock
>>> wrote:
>>>
>>>> I'm not sure what you mean by models? Am I missing something in my
>>>> environment perhaps?
>>>>
>>>> Al (Buddy) Peacock, PMP, MCCT, ITILv3, SMC, CSM, SPOC
>>>> (920) 740-3411
>>>> linkedin.com/in/buddypeacock
>>>> <https://www.linkedin.com/in/buddypeacock/>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, May 28, 2020 at 2:26 PM Abdur-Rahmaan Janhangeer <
>>>> arj.pyt...@gmail.com> wrote:
>>>>
>>>>> Greetings,
>>>>>
>>>>>
>>>>> where did you define your models?
>>>>>
>>>>> Kind Regards,
>>>>>
>>>>>
>>>>> Abdur-Rahmaan Janhangeer
>>>>>
>>>>> https://www.github.com/Abdur-RahmaanJ
>>>>>
>>>>> Mauritius
>>>>>
>>>>> sent from gmail client on Android, that's why the signature is so ugly.
>>>>>
>>>>> On Thu, 28 May 2020, 22:22 Buddy Peacock,
>>>>> wrote:
>>>>>
>>>>>> Hello group,
>>>>>> I have a pretty good background in MySQL & MSSQL as well as VB & Php,
>>>>>> but I
>>>>>> am new to Python and Postgresql.
>>>>>>
>>>>>> I am taking a class and working on a project to insert authors and
>>>>>> books
>>>>>> into a table. My code for this is:
>>>>>> ===
>>>>>> import csv
>>>>>> import os
>>>>>>
>>>>>> from flask import Flask
>>>>>> from sqlalchemy import c
