Database_GUI_address_book.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "832884db",
   "metadata": {},
   "outputs": [],
   "source": [
    "from tkinter import *\n",
    "import sqlite3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ba95c0eb",
   "metadata": {},
   "outputs": [],
   "source": [
    "root =Tk()  # returns the location of the particular file we have chosen\n",
    "root.title(\"Checkboxes\")\n",
    "root.geometry(\"400x400\")\n",
    "\n",
    "# Database\n",
    "\n",
    "\n",
    "#Create a database or connect to one \n",
    "conn = sqlite3.connect(\"address_book.db\")\n",
    "#Create a cursor\n",
    "c=conn.cursor()\n",
    "\n",
    "#Create table\n",
    "\n",
    "\n",
    "def submit():\n",
    "    #Create a database or connect to one \n",
    "    conn = sqlite3.connect(\"address_book.db\")\n",
    "    #Create a cursor\n",
    "    c=conn.cursor() \n",
    "    \n",
    "    # Insert into table\n",
    "    \n",
    "    c.execute(\"INSERT INTO addresses VALUES (:f_name, :l_name, :address, :city, :state, :zipcode)\",\n",
    "             {\n",
    "                 'f_name': f_name.get(),\n",
    "                 'l_name':l_name.get(),\n",
    "                 'address':address.get(),\n",
    "                 'city':city.get(),\n",
    "                 'state':state.get(),\n",
    "                 'zipcode':zipcode.get()\n",
    "                 \n",
    "             })\n",
    "\n",
    "    conn.commit()\n",
    "    conn.close()\n",
    "    \n",
    "\n",
    "    f_name.delete(0,END)\n",
    "    l_name.delete(0,END)\n",
    "    address.delete(0,END)\n",
    "    city.delete(0,END)\n",
    "    state.delete(0,END)\n",
    "    zipcode.delete(0,END)\n",
    "    \n",
    "    return\n",
    "\n",
    "def query():\n",
    "    \n",
    "    #Create a database or connect to one \n",
    "    conn = sqlite3.connect(\"address_book.db\")\n",
    "    #Create a cursor\n",
    "    c=conn.cursor() \n",
    "    \n",
    "    # query the database\n",
    "    \n",
    "    c.execute(\"SELECT *,oid FROM addresses\")\n",
    "    records=c.fetchall()\n",
    "    #print(records)\n",
    "    print_record=\"\"\n",
    "    for record in records:\n",
    "        print_record += str(record) + \"\\n\"\n",
    "        \n",
    "    query_label=Label(root, text=print_record)\n",
    "    query_label.grid(row=11,column=0,columnspan=2)\n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    conn.commit()\n",
    "    conn.close()\n",
    "\n",
    "def delete1():\n",
    "    #Create a database or connect to one \n",
    "    conn = sqlite3.connect(\"address_book.db\")\n",
    "    #Create a cursor\n",
    "    c=conn.cursor() \n",
    "\n",
    "    c.execute(\"DELETE from addresses WHERE oid ={}\".format(delete_box.get()))\n",
    "    \n",
    "    \n",
    "    delete_box.delete(0,END)\n",
    "    conn.commit()\n",
    "    conn.close()\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "# Create text boxes\n",
    "f_name = Entry(root,width=30)\n",
    "f_name.grid(row=0,column=1,padx=20,pady=(10,0))\n",
    "\n",
    "\n",
    "l_name = Entry(root,width=30)\n",
    "l_name.grid(row=1,column=1,padx=20)\n",
    "\n",
    "address = Entry(root,width=30)\n",
    "address.grid(row=2,column=1,padx=20)\n",
    "\n",
    "city = Entry(root,width=30)\n",
    "city.grid(row=3,column=1,padx=20)\n",
    "\n",
    "state = Entry(root,width=30)\n",
    "state.grid(row=4,column=1,padx=20)\n",
    "\n",
    "zipcode = Entry(root,width=30)\n",
    "zipcode.grid(row=5,column=1,padx=20)\n",
    "\n",
    "delete_box=Entry(root,width=30)\n",
    "delete_box.grid(row=9,column=1,padx=20,pady=5)\n",
    "\n",
    "\n",
    "# Text box labels\n",
    "f_name_label = Label(root,text=\"first name\")\n",
    "f_name_label.grid(row=0,column=0)\n",
    "l_name_label = Label(root,text=\"last name\")\n",
    "l_name_label.grid(row=1,column=0)\n",
    "a_name_label = Label(root,text=\"address\")\n",
    "a_name_label.grid(row=2,column=0)\n",
    "c_name_label = Label(root,text=\"city\")\n",
    "c_name_label.grid(row=3,column=0)\n",
    "s_name_label = Label(root,text=\"state\")\n",
    "s_name_label.grid(row=4,column=0)\n",
    "z_name_label = Label(root,text=\"zipcode\")\n",
    "z_name_label.grid(row=5,column=0)\n",
    "delete_label=Label(root,text=\"Delete ID Number\")\n",
    "delete_label.grid(row=9,column=0,pady=5)\n",
    "# Create submit button\n",
    "\n",
    "submit_btn = Button(root, text=\"Add record to data base\",command=submit)\n",
    "submit_btn.grid(row=6,column=0,columnspan=2,pady=10,padx=10,ipadx=107)\n",
    "# create query button\n",
    "\n",
    "query_btn = Button(root, text=\"show records\",command=query)\n",
    "query_btn.grid(row=7,column=0,columnspan=2,pady=10,padx=10,ipadx=137)\n",
    "\n",
    "# Delete button\n",
    "delete_btn = Button(root,text=\"Delete Records\",command=delete1)\n",
    "delete_btn.grid(row=10,column=0,columnspan=2,pady=10,padx=10,ipadx=134)\n",
    "\n",
    "\n",
    "#Commit changes\n",
    "conn.commit()\n",
    "#conn.close\n",
    "conn.close()\n",
    "root.mainloop()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4ef1f87d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}