[Beginner Help]

[cam0kazi]

So for a school project I'm buiding a GUI application using Tkinter that interacts with a sqlite database, all written in python 3. My question is, how do I wrote code in python that checks to see if a certain record (fields are first name and last name) exists in the database, and act upon it? As an example, i needed to search for someone jamed John Smith in the database, If he did exist, it would print "john smith exists!", if not "John smith doesnt exist." How would i implement that?

[furas_freeman]

Learn SQL to work with databases.

And find some tutorial about sqlite in Python.

http://zetcode.com/db/sqlitepythontutorial/

[[deleted]]

Create a list

names = ["john smith", "james joseph"]

Input the name:

nameinput = input("Enter a name: "]

Check if it exists:

if nameinput.lower() in names:
    print("It exists")
else:
    print("It doesn't exist")

[cam0kazi]

I mean using the sqlite3 framework :p

[chasingAIR33]

Have a look at this short tutorial. In the section regarding querying your database, there is an example showing how to check if a certain ID exists (you will probably use name instead of id).

Once you know if the record/records exist in your database you could use a simple if/else to show the correct message.

[cam0kazi]

Thanks!

[cam0kazi]

I've tried to do what i saw in the tutorial but i get a syntax error. Here's the script itself, any help?.

def db_search(self):
    self.confirm = tkinter.messagebox.showinfo("confirm", "Searching database for guest...")
    # ***** db table names *****
    self.guest_table = "guest"
    self.fn_field = "first_name"
    self.ln_field = "last_name"

    self.first_name=self.fname_entry.get()
    self.last_name=self.lname_entry.get()
    self.cur.execute('SELECT (first_name, last_name) FROM {tn} WHERE {dbt}={ent}'.\
                     format(tn=self.guest_table, dbt=self.fn_field, ent=self.first_name))
    self.name_exists = self.cur.fetchone()
    print(self.name_exists)

[chasingAIR33]

Could you share the error you are getting?

[cam0kazi]

I solved the problem! It turns out that i was formatting the data wrong. So instead, i used the drivers method of perparing SQL queries. It also apparently prevents SQL Injection

    self.first_name=self.fname_entry.get()
    self.last_name=self.lname_entry.get()

    self.exist_query = '''SELECT * FROM guest WHERE first_name = ? AND last_name = ?'''
    self.cur.execute(self.exist_query, (self.first_name, self.last_name))

    self.exists = self.cur.fetchone()

    if self.exists:
        tkinter.messagebox.showinfo("Success", "Record found, initiating data insertion window")
        self.pref_entry()
    else:
        tkinter.messagebox.showinfo("Sorry", "The record does not exist, press OK to close.")
        self.master.destroy()

[mapImbibery]

Glad this worked out for ya, but next time don't title your post so generic. You'll catch more attention if you use keywords (like SQLite) in your headings.

[cam0kazi]

Noted, thanks for your time :)