def edit_tags(request): if request.method == 'POST': if request.POST.get('tagName'): tg = request.POST.get('tagName') conn = sqlite3.connect('db.sqlite3') c = conn.cursor() c.execute("SELECT * FROM bookmarks_tag_list") result = c.fetchall() tgs = [r[1] for r in result] if tg not in tgs: newTag = Tag_list(tags = tg) newTag.save() elif request.POST.get('deleteTag'): tggs = request.POST.get('delete_tag') conn = sqlite3.connect('db.sqlite3') o = conn.cursor() mydata = o.execute("DELETE FROM bookmarks_tag_list WHERE tags = ?", (tggs,)) conn.commit() conn = sqlite3.connect('db.sqlite3') b = conn.cursor() b.execute("SELECT * FROM bookmarks_tag_list") resultt = b.fetchall() context = {'list': resultt} return render(request, 'edit_tags.html', context)
def bookmarks(request): if request.method == 'POST': if request.POST.get('deleteUrl'): urls = request.POST.get('delete_url') conn = sqlite3.connect('db.sqlite3') o = conn.cursor() o.execute("DELETE FROM bookmarks_bookmark WHERE task = ?", (urls,)) conn.commit() o.close() conn = sqlite3.connect('db.sqlite3') c = conn.cursor() c.execute("SELECT * FROM bookmarks_bookmark") result = c.fetchall() ids = [r[0] for r in result] tags = [r[1] for r in result] urls = [r[2] for r in result] j = ",".join(tags) #Converting list into string i.e. from ['abc, xyz'] to 'abc, xyz' k = j.split(',') # 'abc, xyz' to ['abc', 'xyz'] s_tags = unique(k) s = conn.cursor() #Filling Tag_list Table if for some additional tags s.execute("SELECT * FROM bookmarks_tag_list") res = s.fetchall() tg_ids = [f[0] for f in res] tg_list = [f[1] for f in res] inter = intersect(s_tags, tg_list) new_tags = [x for x in s_tags if x not in inter] i = [idx for idx,t in enumerate(new_tags)] for y in i: tagInstance = Tag_list(tags = new_tags[y]) tagInstance.save() list = zip(ids, urls) context = {'list': list, 'all_tags': s_tags} return render(request, 'bookmark.html', context)