Matching user's input with query from sqlite3 db in python

Question

I'm writing a script where by a user registers his/her username, but a function checks whether this username is already in the db or not. But I'm stuck on how to match my query with the input. Here is the code:

def checker(self, insane):                                                  
        t = (insane,)                                                           
    cmd = "SELECT admin_user FROM admin_db where admin_user = \"%s\";" %t
    self.cursor.execute(cmd)
    namer = self.cursor.fetchone()
    print namer
    if namer == insane:                                                     
        print("Username is already chosen!")
        exit(1)
    else:
        pass

Since

namer

returns as

(u'maverick',)

It doesn't match with the input. How should I go about implementing that?

Daniel Roseman · Accepted Answer · 2011-12-23 16:58:56Z

1

The DB fetch models return a tuple for each row. Since you've only selected a single field, you can simply access namer[0] to get the actual value.

edited Dec 23, 2011 at 16:58

answered Dec 23, 2011 at 15:42

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Maverick Over a year ago

aha, didn't know that. Got what I wanted. Thanks! [answer accepted] ;)

Collectives™ on Stack Overflow

Matching user's input with query from sqlite3 db in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related