Sqlite - Python - refer to table column in a loop

Question

I’m doing a script in Python accessing Sqlite database. I made a loop for but don’t know how to get the value of a column in the table.

Take the example:

cursor2 = cnx.cursor()
cursor2.execute("select * from despesas")
cursor2.moveToFirst()
cont = 0
lista = []
for (despesa) in cursor2:
    if permanente="S":
    elif:

I need to verify that the value of the "permanent" column of the "expenses" table is "S" or "N". The "permanent" column is varchar(1). Then I’m switching to Boolean. How do I do?

Answer 1

When you write select * from despesas you are selecting all the columns of the expenses table. To select only a specific column, change the * by the name of the desired column.

So your loop for can stay like this:

//Selecionando apenas a coluna "permanente" da tabela "despesas"
query = cursor2.execute("SELECT permanente FROM despesas")

for row in query:
    if row == 'S':
        código
    else:
        código