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-R

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/buddypeaco

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

SQLAlchemy & Postgresql

ror: (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: creating a table within python code

t() 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 w

Re: creating a table within python code

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 HTT

creating a table within python code

: 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__ == "

Help Problem with python : python-3.8.3rc1-amd64

quot; 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