Python Forum
SQLALCHEMY - Column doesn't exist
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQLALCHEMY - Column doesn't exist
#4
(Nov-01-2021, 12:45 PM)ndc85430 Wrote: You also shouldn't be concatenating strings to build SQL statements, as that's vulnerable to SQL injection. Bobby Tables can educate you on this.

Hi there,

I understand. My workaround (on flask) is to pull the data from sql, use that to build an html string, close the connection and then return the html string.

That way nothing on the user's end relates directly to the db.
while dad_has_cigs == True:
    happiness = True
    if dad_has_cigs == False:
    print("Dad come home!")
    happiness = not happiness
    break
Reply


Messages In This Thread
SQLALCHEMY - Column doesn't exist - by jamesaarr - Nov-01-2021, 10:35 AM
RE: SQLALCHEMY - Column doesn't exist - by ndc85430 - Nov-01-2021, 12:45 PM
RE: SQLALCHEMY - Column doesn't exist - by jamesaarr - Nov-01-2021, 12:59 PM
RE: SQLALCHEMY - Column doesn't exist - by buran - Nov-01-2021, 02:00 PM
RE: SQLALCHEMY - Column doesn't exist - by ndc85430 - Nov-02-2021, 08:49 AM
RE: SQLALCHEMY - Column doesn't exist - by buran - Nov-02-2021, 11:20 AM
RE: SQLALCHEMY - Column doesn't exist - by ndc85430 - Nov-04-2021, 09:20 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  UndefinedEnvironmentName: 'extra' does not exist in evaluation environment EarthAndMoon 3 1,849 Oct-09-2023, 05:38 PM
Last Post: snippsat
  check if a file exist on the internet and get the size kucingkembar 6 1,906 Apr-16-2022, 05:09 PM
Last Post: kucingkembar
  pathlib destpath.exists() true even file does not exist NaN 9 4,797 Dec-01-2020, 12:43 PM
Last Post: NaN
  SQLAlchemy Flask ERROR: no such column XXX marcello86 0 2,940 Aug-31-2020, 09:21 AM
Last Post: marcello86
  Syntax not exist noorpy 1 2,085 Nov-14-2019, 09:23 AM
Last Post: perfringo
  Shutil attempts to copy directories that don't exist ConsoleGeek 5 4,683 Oct-29-2019, 09:26 PM
Last Post: Gribouillis
  get value if it's exist [python] senait 1 1,829 Aug-21-2019, 06:47 AM
Last Post: buran
  Python says module doesn't exist... I say it does! EricMichel 2 3,184 May-14-2019, 03:26 AM
Last Post: EricMichel
  pathlib: resolving a path that does not exist Skaperen 6 5,673 Sep-08-2018, 12:25 AM
Last Post: Skaperen
  Does stack overflow exist in python ? sylas 3 3,900 Jul-23-2017, 09:21 AM
Last Post: sylas

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020