Flask SQLite Common Question

python-mysql-typeerror-nonetype-object-is-not-subscriptable

from flaskr.db import get_db
db = get_db()
cursor = db.cursor()
cursor.execute(
    'SELECT occupancy_status'
    ' FROM parking_log'
    ' WHERE parking_space_no =?',
    (parking_space_no,)
)
row = cursor.fetchone()
while row:
    do_stuff()
    row = cursor.fetchone()

Get distinct values

SELECT DISTINCT column_name,column_name
FROM table_name;

Order by example

SELECT CompanyName, ContactName, City, Country
  FROM Supplier
 ORDER BY CompanyName

Count having example

Reference SQL COUNT() with HAVING.

SELECT commission,COUNT(*)
FROM agents
GROUP BY commission
HAVING COUNT(*)>3;