Multiple SQL Queries with python & flask

Question

I have a SQLite3 table that collects data from a gym booking form; all the data goes into one table - Name, Email, Day, Exercise Class, Class Time.

If it is possible, I would like to find a way to get all from Name if Day, Exercise Class & Class Time are equal to a selected value.

I am using Flask so once I can do this the data would then be used to generate a new HTML page (which would be the registration checklist page for the gym tutor).

I am pretty sure this is incorrect, but this is the general idea of what I would like to achieve..

db.execute("SELECT * FROM GymTable WHERE (Day == "Monday", Ex_Class == "BoxFit", Ex_Time == "0745-0845"))

. . You need to learn basic SQL syntax. There are many resources online and offline to help with that. — Gordon Linoff
– Gordon Linoff, Commented Apr 29, 2019 at 11:13

Kartik Narang · Accepted Answer · 2019-04-29 10:34:40Z

1

the correct query in this case would be:

db.execute("SELECT * FROM GymTable WHERE Day = 'Monday' and Ex_Class = 'BoxFit' and Ex_Time = '0745-0845'")

answered Apr 29, 2019 at 10:34

Kartik Narang

2011 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

iJustin254 Over a year ago

SELECT Name FROM since Sinclair only wants to get names from Name column

DinoCoderSaurus · Accepted Answer · 2019-04-29 11:32:27Z

1

You may find these two tutorials on the SQL WHERE clause and SQL AND, OR, NOT Operators helpful. Notice first that the equal operator is = instead of ==. This query needs AND between column filters. The WHERE clause should not be enclosed in (). You may find the python sqlite3 doc useful as well.

edited Apr 29, 2019 at 11:32

answered Apr 29, 2019 at 10:28

DinoCoderSaurus

6,5502 gold badges13 silver badges17 bronze badges

Comments

Gabe · Accepted Answer · 2019-04-30 02:05:59Z

1

To better illustrate:

db.execute( "
    SELECT name 
    FROM   gymtable 
    WHERE  day = 'Monday' 
        AND ex_class = 'BoxFit' 
        AND ex_time = '0745-0845' 
");

answered Apr 30, 2019 at 2:05

Gabe

9937 silver badges9 bronze badges

Collectives™ on Stack Overflow

Multiple SQL Queries with python & flask

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related