Extracting accounts from sqlite3 database with python

Question

I am making an approval system to my account management system. Upon registering the user has an entry in the database as Approved which is set to false, but when an admin logs in, I want him to be returned a list of accounts with the approved row as False. I have tried with this SQL statement but am only getting the first not all of them.

c.execute("SELECT * FROM accounts WHERE approved=?", (False,))
ifapproved=c.fetchone()
print (ifapproved)

I have tried using a for loop but it just repeats the first account which is unapproved. How can I fix this?

i suppose remove , after false and try

sundar nataraj
– sundar nataraj

2014-04-23 10:16:10 +00:00
Commented Apr 23, 2014 at 10:16 — sundar nataraj
– sundar nataraj, Commented Apr 23, 2014 at 10:16

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

You have wrong syntx in your execute method.

For example:

cur.execute("SELECT Name, Price FROM Cars WHERE Id=:Id", {"Id": uId})

c.execute("SELECT * FROM accounts WHERE approved=:approved", {"approved":'false'}) 
//with or without the single quite to false.
rows = c.fetchall()

for row in rows:
    print (row)  //check all list of returned results

or

c.execute("SELECT * FROM accounts WHERE approved = 'False'")

c.execute("SELECT * FROM accounts WHERE approved = 'false'")

c.execute("SELECT * FROM accounts WHERE approved = '0'")

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Apr 23, 2014 at 10:18

Daniel Wondyifraw

7,7338 gold badges62 silver badges82 bronze badges

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

9 Comments

sundar nataraj Over a year ago

wt is difference between ur answer and Below one

Coder77 Over a year ago

Does not work, still getting the first account only.

Daniel Wondyifraw Over a year ago

syntax it is? have u tried without the quetos on False

Coder77 Over a year ago

I removed the quotes and kept it as False, because approved is equal to the boolean False or True, not the string 'False' or 'True'

Daniel Wondyifraw Over a year ago

try now , you have used fetchOne ...with a select * query so fetch all as above and play with the row in the for loop ..cheers!

|

sundar nataraj · Accepted Answer · 2014-04-23 10:15:44Z

0

Try in this way

stmt="""SELECT * FROM accounts WHERE approved=:APPROVAL"""
d["APPROVAL"]=False

 c.execute(unicode(stmt), d)
ifapproved=c.fetchone()
print (ifapproved)

answered Apr 23, 2014 at 10:15

sundar nataraj

8,7202 gold badges36 silver badges48 bronze badges

1 Comment

Coder77 Over a year ago

I get an error, d is not globally defined. I am using Python3 btw.

Collectives™ on Stack Overflow

Extracting accounts from sqlite3 database with python

2 Answers 2

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related