def get_selected_notes(title): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT notes FROM msd_notes WHERE title=:title""", {'title': encrypt_value(title.strip())}) all_notes = cur.fetchone() cur.close() con.close() return decrypt_value(all_notes[0]) else: showerror("Error", "Error while retreiving notes")
def read_appointment_title_from_db(name): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT name FROM msd_appointments WHERE name=:name""", {'name': encrypt_value(name)}) got_name = cur.fetchone() cur.close() con.close() if got_name == None: return None else: return decrypt_value(got_name[0])
def get_selected_passwords(web_desc): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT * FROM msd_passwords WHERE web_desc=:name""", {'name': encrypt_value(web_desc)}) got_data = cur.fetchone() cur.close() con.close() if got_data == None: return None else: return decrypt_value(got_data[0]), decrypt_value(got_data[1]), decrypt_value(got_data[2])
def read_password_desc_from_db(web_desc): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT web_desc FROM msd_passwords WHERE web_desc=:web_desc""", {'web_desc': encrypt_value(web_desc)}) got_web_desc = cur.fetchone() cur.close() con.close() if got_web_desc == None: return None else: return decrypt_value(got_web_desc[0])
def get_selected_appointments(name): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT * FROM msd_appointments WHERE name=:name""", {'name': encrypt_value(name)}) got_name = cur.fetchone() cur.close() con.close() if got_name == None: return None else: return decrypt_value(got_name[0]), decrypt_value(got_name[3]), decrypt_value(got_name[1]), decrypt_value(got_name[4]), decrypt_value(got_name[2])
def read_passwords_from_db(): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("SELECT * FROM msd_passwords") all_passwords = cur.fetchall() i = 0 for row in all_passwords: tab_3_treeview.insert(parent='', index='end', iid=i, text=decrypt_value(row[0]), values=(decrypt_value(row[1]), decrypt_value(row[2]))) i += 1 tab_3_treeview.pack() cur.close() con.close()
def create_tables(): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("CREATE TABLE IF NOT EXISTS msd_notes (title TEXT, date TEXT, time TEXT, notes TEXT)") cur.execute("CREATE TABLE IF NOT EXISTS msd_appointments (name TEXT, date TEXT, time TEXT, description TEXT, status TEXT)") cur.execute("CREATE TABLE IF NOT EXISTS msd_passwords (web_desc TEXT, username TEXT, password TEXT)") cur.execute("CREATE TABLE IF NOT EXISTS msd_login (password TEXT)") cur.close() con.close() else: showerror("Error", "Error while creating the tables") root.destroy() exit()
def read_notes_only_from_db(title): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("""SELECT title FROM msd_notes WHERE title=:title""", {'title': encrypt_value(title)}) got_title = cur.fetchone() cur.close() con.close() if got_title == None: return None else: return decrypt_value(got_title[0]) else: showerror("Error", "Error while retreiving notes")
def delete_password(): global tab_3_button_message if tab_3_treeview.focus() == '': tab_3_button_message.set("Please select a password") else: p = get_db_path() if p is not None: tab_3_button_message.set("") delete_password = tab_3_treeview.item(tab_3_treeview.focus())['text'].strip() con = connect(p) cur = con.cursor() cur.execute("""DELETE FROM msd_passwords WHERE web_desc=:name""", {'name': encrypt_value(delete_password)}) con.commit() cur.close() con.close() update_tab_3_treeview()
def update_password(web_desc, username, password): p = get_db_path() if p is not None: add_passwords_button["state"] = "normal" open_passwords_button["state"] = "normal" delete_passwords_button["state"] = "normal" tabs_window.tab(0, state="normal") tabs_window.tab(1, state="normal") con = connect(p) cur = con.cursor() cur.execute("""UPDATE msd_passwords SET username=:username, password=:password WHERE web_desc=:web_desc""", {'web_desc': encrypt_value(web_desc), 'username': encrypt_value(username), 'password': encrypt_value(password)}) con.commit() cur.close() con.close() update_tab_3_treeview() window.destroy()
def create_login(user_pass): p = get_db_path() if p is not None: con = connect(p) cur = con.cursor() cur.execute("INSERT INTO msd_login (password) VALUES (?)", (encrypt_value(user_pass), )) con.commit() cur.close() con.close() showinfo("Thank you!", "Please login again") root.destroy() exit() else: showerror("Error", "Error while creating login") root.destroy() exit()
def delete_notes(): global tab_1_button_message if tab_1_treeview.focus() == '': tab_1_button_message.set("Please select a notes") else: p = get_db_path() if p is not None: tab_1_button_message.set("") delete_title = tab_1_treeview.item(tab_1_treeview.focus())['text'].strip() con = connect(p) cur = con.cursor() cur.execute("""DELETE FROM msd_notes WHERE title=:title""", {'title': encrypt_value(delete_title)}) con.commit() cur.close() con.close() update_tab_1_treeview()
def delete_appointment(): global tab_2_button_message if tab_2_treeview.focus() == '': tab_2_button_message.set("Please select an appointment") else: p = get_db_path() if p is not None: tab_2_button_message.set("") delete_name = tab_2_treeview.item(tab_2_treeview.focus())['text'].strip() con = connect(p) cur = con.cursor() cur.execute("""DELETE FROM msd_appointments WHERE name=:name""", {'name': encrypt_value(delete_name)}) con.commit() cur.close() con.close() update_tab_2_treeview()
def update_appointment(name, new_date, description, new_time, status): p = get_db_path() if p is not None: add_appointments_button["state"] = "normal" open_appointments_button["state"] = "normal" delete_appointments_button["state"] = "normal" tabs_window.tab(0, state="normal") tabs_window.tab(2, state="normal") con = connect(p) cur = con.cursor() cur.execute("""UPDATE msd_appointments SET date=:new_date, time=:new_time, description=:description, status=:status WHERE name=:name""", {'name': encrypt_value(name), 'new_date': encrypt_value(new_date), 'new_time': encrypt_value(new_time), 'description': encrypt_value(description), 'status': encrypt_value(status)}) con.commit() cur.close() con.close() update_tab_2_treeview() window.destroy()
def save_password(): p = get_db_path() if not check_password_web_desc_redundancy(web_desc_entry.get().strip()) and p is not None: add_passwords_button["state"] = "normal" open_passwords_button["state"] = "normal" delete_passwords_button["state"] = "normal" tabs_window.tab(0, state="normal") tabs_window.tab(1, state="normal") s_web_desc, s_username, s_password = encrypt_value(web_desc_entry.get().strip()), encrypt_value(username_entry.get().strip()), encrypt_value(password_entry.get().strip()) con = connect(p) cur = con.cursor() cur.execute("INSERT INTO msd_passwords (web_desc, username, password) VALUES (?, ?, ?)", (encrypt_value(web_desc_entry.get().strip()), encrypt_value(username_entry.get().strip()), encrypt_value(password_entry.get().strip()))) con.commit() cur.close() con.close() update_tab_3_treeview() window.destroy()
def check_is_login_available(): p = get_db_path() got_pass = None if p is not None: con = connect(p) cur = con.cursor() cur.execute("SELECT password FROM msd_login") got_pass = cur.fetchone() cur.close() con.close() else: showerror("Error", "Error while checking login") root.destroy() exit() if got_pass == None: return None else: return decrypt_value(got_pass[0])
def save_notes(): p = get_db_path() if p is not None and not check_notes_title_redundancy(title_entry.get().strip()): add_notes_button["state"] = "normal" open_notes_button["state"] = "normal" delete_notes_button["state"] = "normal" tabs_window.tab(1, state="normal") tabs_window.tab(2, state="normal") now_date = str(localtime().tm_year) + '-' + str(localtime().tm_mon) + '-' + str(localtime().tm_mday) now_time = str(localtime().tm_hour) + ':' + str(localtime().tm_min) + ':' + str(localtime().tm_sec) con = connect(p) cur = con.cursor() cur.execute("INSERT INTO msd_notes (title, date, time, notes) VALUES (?, ?, ?, ?)", (encrypt_value(title_entry.get().strip()), encrypt_value(now_date), encrypt_value(now_time), encrypt_value(textarea.get("1.0", 'end').strip()))) con.commit() cur.close() con.close() update_tab_1_treeview() window.destroy()
def update_notes(title, notes): p = get_db_path() if p is not None: add_notes_button["state"] = "normal" open_notes_button["state"] = "normal" delete_notes_button["state"] = "normal" tabs_window.tab(1, state="normal") tabs_window.tab(2, state="normal") now_date = str(localtime().tm_year) + '-' + str(localtime().tm_mon) + '-' + str(localtime().tm_mday) now_time = str(localtime().tm_hour) + ':' + str(localtime().tm_min) + ':' + str(localtime().tm_sec) con = connect(p) cur = con.cursor() cur.execute("""UPDATE msd_notes SET date=:now_date, time=:now_time, notes=:notes WHERE title=:title""", {'title': encrypt_value(title), 'now_date': encrypt_value(now_date), 'now_time': encrypt_value(now_time), 'notes': encrypt_value(notes)}) con.commit() cur.close() con.close() update_tab_1_treeview() window.destroy()
def save_appointment(): p = get_db_path() if not check_apointment_name_redundancy(appointment_name_entry.get().strip()) and p is not None: add_appointments_button["state"] = "normal" open_appointments_button["state"] = "normal" delete_appointments_button["state"] = "normal" tabs_window.tab(0, state="normal") tabs_window.tab(2, state="normal") appointment_date = cal.selection_get() appointment_time = appointment_time_entry.get().strip() con = connect(p) cur = con.cursor() cur.execute("INSERT INTO msd_appointments (name, date, time, description, status) VALUES (?, ?, ?, ?, ?)", (encrypt_value(appointment_name_entry.get().strip()), encrypt_value(str(appointment_date)), encrypt_value(appointment_time), encrypt_value(appointment_textarea.get("1.0", 'end').strip()), encrypt_value(appointment_status_spinbox.get()))) con.commit() cur.close() con.close() update_tab_2_treeview() window.destroy()